EQEmulator Forums - Error: #2002 - my.cnf causing my head to ache.

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)

- - Error: #2002 - my.cnf causing my head to ache. (https://www.eqemulator.org/forums/showthread.php?t=16914)

Error: #2002 - my.cnf causing my head to ache.

Ok, I'm back to Emu after an absence of about 1 year. I'm still on Linux, running FC2. I compiled, setup my db, my world is almost perfect.

Here is /etc/my.cnf:

Code:

[client]

port=3306

socket=/var/lib/mysql/mysql.sock



[mysqld]

port=3306

socket=/var/lib/mysql/mysql.sock

key_buffer_size=16M

max_allowed_packet=8M

log-error=/var/log/mysql.log



[mysqldump]

quick

For some strange reason, world uses the right location for socket, but zone doesn't. I have no ~/.my.cnf so it's not fetching elsewhere. I can't find any other cnf files on my system for mysql.

Here is what zone gives me on startup.

Code:

[Error] Failed to connect to database: Error: #2002: Can't connect to local MySQ

L server through socket '/tmp/mysql.sock' (2)

[Status] Starting Log: logs/eqemu_zone.log

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR1

[Status] Loading Variables

Any tidbit of info to at least give me a hint would be appreciated.[/b]

in your my.cnf, replace /var/lib/mysql/mysql.sock by /tmp/mysql.sock
for the client and the mysqld options. /var/lib is the default option when you compile/install it yourself. it's easier to have it in /tmp since most softwares using mysql search it in /tmp .

Once you modified your my.cnf, don't forget to kill and spawn again mysqld (mysql_safe... etc)

I did try this. However, the result gets reversed. world becomes the one that complains about /var/lib/mysql/mysql.sock missing.

I know it's gotta be something stupid I'm overlooking.

P.S. Wow, I've not seen Calimero since I was a kid...many moons ago! :)

hmm what about doing a symlink

I was hoping to avoid doing a symlink, cause I wanted to figure out why it wasn't working right. But in the meantime, symlink does the job.

Thanks