UnrealIRCd Forums

Hello

i am trying to use mysql for my anope but i have this problem

is there anyone out there that can help me

Cant connect to MySQL: Host 'localhost.localdomain' is not allowed to connect to this MySQL server

Hello

i forgot to say i that the first error was from 127.0.01

this is from Localhost


Cant connect to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
: No such file or directory

Hi there.

The first error you posted boils down to MySQL Permission errors.

If you have root access to the MySQL Server, I suggest reading the MySQL Documentation at http://www.mysql.com about the GRANT command.

If you access MySQL via phpMyAdmin, look on the main page after login for the "Permissions" link, and add your hostname "localhost.localdomain" to the list of allowed hosts for that user.

The second error is refering to there not being a MySQL Unix Sock at the path located. You can try using 'locate mysql.sock' on your system, and, if it finds it, changing the MysqlSock directive in the services.conf file, to the path it finds.

I hope this information is of use to you.

Hello

Thx i have the link wrong to the mysql.sock

why does the anope still make the files .db in the services folder should it not onlye put it in mysql here is what the log says now


[Sep 18 17:22:43 2004] Anope 1.7.5 (325) (compiled for UnrealIRCd 3.1.1+) starting up
[Sep 18 17:22:43 2004] MySQL has been enabled.
[Sep 18 17:22:43 2004] Databases loaded
[Sep 18 17:22:43 2004] Info: Reflecting database records.
[Sep 18 17:22:44 2004] Connected to Server 1 (localhost:xxxx)

I answered that question here.