#15 MySQL on UNIX domain sockets

[Niels Martin Hansen]

Newserv doesn't seem to be able to connect to MySQL
servers not listening on a TCP socket. (Ie. only
listening on a UNIX domain socket.)
Usually it should be possible by using NULL as
server-address, but that apparently doesn't work.
I am using 0.6-p2.
Temporary workaround: Make MySQL listen on a TCP
socket. (Potentially less secure.)

[Julian Huppertz]

Logged In: YES
user_id=796727

I have the same error.
Can you tell me how to create that socket?

Thanks for your help!

Regards,
eiSi

[cry0]

Logged In: YES
user_id=474843

This is completely true. It has never been my intention to use
UNIX sockets (as I run sql and services on two diffrent
machines) but it seems like many people want this to be
implemented so I will try to work on the implementation of
unix sockets.

Best Regards
Linus Kimselius

[Niels Martin Hansen]

Logged In: YES
user_id=141468

The default-setup of the mysql-server package on Debian
Linux is to listen only on a UNIX socket.
The setup of MySQL can be changed in /etc/mysql/my.cnf .
Look for the line "skip-networking", and comment it out.
Then restart the mysql server.

[Julian Huppertz]

Logged In: YES
user_id=796727

thanks, but it is:

...
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-networking
...

The error I get:
---------------------------------------
-- NewService by Cryo starting up... --
---------------------------------------
-- Version: NewService v.0.6-beta-p2

Connecting to mysql database newserv (newserv@127.0.0.1)
Couldn't connect to MySQL server!
Can't connect to MySQL server on '127.0.0.1' (111)

Transport endpoint is not connected
Couldn't connect to MySQL server! Can't connect to MySQL
server on '127.0.0.1' (111)

same with localhost. any suggestions? (the config IS
correct... :))