MySQL Bug

[AFlachat]

Hi i've a little bug with mysql support i got this error :
[ServerAuth] ServerAuth can't connect to the MySQL database. Data will be saved locally. Error: No such file or directory
But every informations on config.yml are true.
Any idea ?

[PEMapModder]

Are you using localhost as IP?
Did you, like, defined the MySQL socket?

[AFlachat]

Yes i use localhost, and yes

[AFlachat]

#Use MySQL (set this to false if you want to save data in local files) use-mysql: true #MySQL settings mysql: #MySQL host host: "localhost" #MySQL port (default 3306) port: 3306 #MySQL username username: "root" #MySQL password (you can leave it blank if your database doesn't need password) password: "************" #MySQL ServerAuth database database: "auth" #ServerAuth table prefix table_prefix: "auth_"

[PEMapModder]

On some setups, you also need to define the socket location like /var/lib/mysql.sock or whatever, something like that.

[AFlachat]

Ok , how ?

[AFlachat]

Hmm i've do ln -s /data/mysql_datadir/mysql.sock /var/lib/mysql/mysql.sock but same error

[AFlachat]

looking my my.cnf , every files are where they need to be ....

[AFlachat]

hmmm mysql.sock seems to be missing, look with filezilla i've see that it's a corrupted file, how to replace it ?

[PEMapModder]

Why do you think it is a corrupted file?

[AFlachat]

The server don't detect it as file/directory

[PEMapModder]

http://lmgtfy.com/?q=mysql+socket+file+location

[Flavius12]

You configured mysql or ServerAuth wrongly

[AFlachat]

Hmmm i like the error of no file /var/run/mysqld/mysqld.sock not found when it exist and with good permissions access and mysql owner....

[PEMapModder]

What about trying 127.0.0.1?

[PEMapModder]

Wait, is there even an option that lets you define the socket?