Getting cron.hourly errors now about modsec.modec missing

fizz

Well-Known Member
Jan 25, 2002
202
0
316
/etc/cron.hourly/modsecparse.pl:

DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 11.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 28.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 45.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 60.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 76.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 92.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 107.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 121.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 136.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 150.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 165.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 182.
DBD::mysql::st execute failed: Table 'modsec.modsec' doesn't exist at /etc/cron.hourly/modsecparse.pl line 69, <FILE> line 200.

Im not sure what this relates to, but looks like mod_security, however I dont remember there being this perl script for it. I looked at the DB info inside, and connected to the DB, and that database is empty which is why im getting these errors. Anyone else encountered this?

mysql> use modsec
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql>
 

PanelGuy

Well-Known Member
Oct 13, 2004
106
0
166
Modsec Failed

I get this:
/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 18

Hourly. No Idea why.
 

PanelGuy

Well-Known Member
Oct 13, 2004
106
0
166
Creating 40 byte hash

Ok I just figured something out.

When this was installed on the original server, it had a 15 byte hashed password. The new server uses the NEW method of 40 byte hash. So, how to I turn something into a hash so I change the password on teh db and in the script that logs mod_security in?