modsecparse.pl / mysql issues

[katmai]

hi,

i moved mysql to another drive, and i am getting these errors

/etc/cron.hourly/modsecparse.pl:

DBI connect('modsec:localhost','modsec',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /etc/cron.hourly/modsecparse.pl line 19
Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 19.

[root@viper ~]# ls -la /var/lib/mysql/mysql.sock
lrwxrwxrwx 1 root root 23 Jan 6 20:11 /var/lib/mysql/mysql.sock -> /home3/mysql/mysql.sock


the socket exists.

in cpanel - service manager mysql looks as down, and eximstats the same.

any idea where is the config for modsec and chkserv so that i could set the new mysql.sock location? maybe that will work.

[katmai]

already did that in the first place.

as you already know the socket gets created once you start mysql. so it would be impossible for me to create a symlink to an inexistent socket.

[katmai]

lol i wrote in advance)

[chirpy]

One thing, make sure you have set the datadir and socket directives in /etc/my.cnf to the real locations (not the symlink) and restart mysql.

[katmai]

bumping the thread.

[cpanelkenneth]

Does command line mysql still work?

Try logging into MySQL as different users. Log in as the mod sec user.

[Solokron]

We see this from time to time where modsec works fine but access to the logging db for the whm plugin is missing.

vi /etc/cron.hourly/modsecparse.pl

#Copy the password. Close out.

mysql
create database modsec;
grant all privileges on modsec.* to modsec@localhost identified by 'thepassword';
quit