PDA

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


Elrach
11-10-2004, 04:32 AM
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:
[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.

[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]

Muuss
11-10-2004, 04:52 AM
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)

Elrach
11-10-2004, 06:02 AM
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! :)

wize_one
11-10-2004, 08:47 AM
hmm what about doing a symlink

Elrach
11-12-2004, 08:03 AM
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