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?

[AFlachat]

the my.cnf that all

[PEMapModder]

No. I meant ServerAuth Config.

[AFlachat]

no

[PEMapModder]

That's the problem.

[AFlachat]

With my IDE which got the same error i've put 0.0.0.0 and it work, i've change a little the plugin to work with phpbb

[YaBoiBalAnce]

im getting this too... But im using a seperate server for mySql database

[Flavius12]

Change host setting in ServerAuth configuration and put your database server IP/domain there. Make sure also that your MySQL database is configured to receive remote connections

[thelucyclub]

Im getting this error too but i'm using a MySQL provider.

[Flavius12]

@thelucyclub is your MySQL server on the same computer of your PM server?

[PEMapModder]

Just use your server's IP address. That's simpler.

[thelucyclub]

Ok.

[KennFatt]

did you was try to grant all permission on ur mysql's database?

[kkekof]

In mysql config find "bind" and change ip to your ip

[iDirtniverse]

My ServerAuth connected but it doesnt sync together passwords? Any help?

[TheDiamondYT1]

@PEMapModder

Did you, like, defined the MySQL socket?

Define*

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

Everyone on the pmmp forums says that sending lmgtfy links is rude, but http://lmgtfy.com/?q=what+do+they+know