modsecparse.pl issue

[Serverji]

I have a VPS with cPanel 11.25.0-R43252 - WHM 11.25.0 - X 3.9
CENTOS 5 i686

every hour i am getting a cron error

/etc/cron.hourly/modsecparse.pl:

DBI connect('modsec:localhost','modsec',...) failed: Access denied for user 'modsec'@'localhost' (using password: YES) at /etc/cron.hourly/modsecparse.pl line 19
Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 19.

I checked MySQL database and there is no db with the name of modsec.

So, how to fix this issue ?

Thanks to anyone who can help me here.

[zacharooni]

Hello,

Look in the modsecparse.pl file for the credentials, then as root in SSH:

mysqladmin create modsec
mysql
mysql> GRANT ALL PRIVILEGES ON modsec.* TO 'modsec'@'localhost' IDENTIFIED BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
mysql> quit
/etc/init.d/mysql restart
/usr/local/cpanel/startup

Replace PASSWORD with the password in modsecparse.pl

[cPanelDon]

I have a VPS with cPanel 11.25.0-R43252 - WHM 11.25.0 - X 3.9
CENTOS 5 i686

every hour i am getting a cron error

/etc/cron.hourly/modsecparse.pl:

DBI connect('modsec:localhost','modsec',...) failed: Access denied for user 'modsec'@'localhost' (using password: YES) at /etc/cron.hourly/modsecparse.pl line 19
Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 19.

I checked MySQL database and there is no db with the name of modsec.

So, how to fix this issue ?

Thanks to anyone who can help me here.

Are both mod_security and mod_unique_id installed in the Apache configuration?

The following commands may be used to help verify the installation status and confirm if they are loading:

# find /usr/local/apache -regex ".*modsec.*\|.*mod_security.*" | sort
# /usr/local/apache/bin/httpd -l | grep "unique_id"
# /usr/local/apache/bin/httpd -M | egrep "sec|unique_id"

I recommend to try correcting the issue by running EasyApache while ensuring to enable mod_security in the build profile, at the very least it should ensure there is a working mod_security installation. If this alone does not fully alleviate the reported symptom please consider submitting a support request so that we can examine the system and determine why the issue is occurring; if submitting a ticket please send me a PM referencing this thread and the ID number of your support request so that I may follow-up internally.