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

tableprefix: "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

[PEMapModder]

@TheDiamondYT1 mind stop troubling the dead? It's disrespectful to the ancestors to step on their tomb.

[TheDiamondYT1]

@PEMapModder I do not mind