• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Linux cannot connect to mysql o.O?

Wiw3K

New Member
Joined
Apr 16, 2008
Messages
371
Reaction score
3
Gesior ACC gives this error on STEP 2/3/4
Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database. Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: /usr/zeromskiots/config.lua .
3. MySQL user, password, database or host is wrong.

thats my sql options in config.lua
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "user1"
sqlPass = "pass1"
sqlDatabase = "testots"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
passwordType = "plain"
i have deleted every --info in config.lua but still gives error =(

btw. i can go to http://ip/phpmyadmin and it works so wtf?
 
OH man dont write your pass and user here, seriously remove it asap

edit: Oh maybe you changed it with user1 and password1, what do I know.


And for the error, make sure you put MYSQL and not SQLITE.
 
I see you are on linux

I had the same problem, I changed permission of the config.lua and it worked ;P

sudo chmod 777 /usr/zeromskiots/config.lua
 
OH man dont write your pass and user here, seriously remove it asap

edit: Oh maybe you changed it with user1 and password1, what do I know.


And for the error, make sure you put MYSQL and not SQLITE.
yeah i changed them to user1/pass1 :D
and i have sqlType = "mysql"

I see you are on linux

I had the same problem, I changed permission of the config.lua and it worked ;P

sudo chmod 777 /usr/zeromskiots/config.lua
i already did it, nothing happen... still error

info:
i am on Debian Lenny 5.0 and i am using Xampp (/opt/lampp/)
 
Last edited:
xampp/lampp FAIL
r30240:~# /var/lampp/lampp start
cat: /opt/lampp/lib/VERSION: Nie ma takiego pliku ani katalogu
/var/lampp/lampp: line 115: /opt/lampp/share/lampp/selinux: Nie ma takiego pliku ani katalogu
Starting XAMPP for Linux ...
/var/lampp/lampp: line 122: /opt/lampp/share/lampp/nogroupcheck: Nie ma takiego pliku ani katalogu
cat: /opt/lampp/lib/VERSION: Nie ma takiego pliku ani katalogu
/var/lampp/lampp: line 115: /opt/lampp/share/lampp/selinux: Nie ma takiego pliku ani katalogu
cat: /opt/lampp/lib/VERSION: Nie ma takiego pliku ani katalogu
/var/lampp/lampp: line 115: /opt/lampp/share/lampp/selinux: Nie ma takiego pliku ani katalogu
/var/lampp/lampp: line 489: /opt/lampp/share/lampp/phpstatus: Nie ma takiego pliku ani katalogu
XAMPP: Starting Apache...
/var/lampp/lampp: line 215: /opt/lampp/logs/apachestart.log: Nie ma takiego pliku ani katalogu
XAMPP: Error 1! Couldn't start Apache!
/var/lampp/lampp: line 222: /opt/lampp/share/lampp/diagnose: Nie ma takiego pliku ani katalogu
cat: /opt/lampp/lib/VERSION: Nie ma takiego pliku ani katalogu
/var/lampp/lampp: line 115: /opt/lampp/share/lampp/selinux: Nie ma takiego pliku ani katalogu
XAMPP: Another MySQL daemon is already running.
cat: /opt/lampp/lib/VERSION: Nie ma takiego pliku ani katalogu
/var/lampp/lampp: line 115: /opt/lampp/share/lampp/selinux: Nie ma takiego pliku ani katalogu
/var/lampp/lampp: line 129: /opt/lampp/share/lampp/alladdons: Nie ma takiego pliku ani katalogu
XAMPP for Linux started.
r30240:~#
 
Back
Top