The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Getting cron.hourly errors now about modsec.modec missing

Discussion in 'Security' started by fizz, Mar 1, 2005.

  1. fizz

    fizz Well-Known Member

    Joined:
    Jan 25, 2002
    Messages:
    202
    Likes Received:
    0
    Trophy Points:
    16
    /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>
     
  2. PanelGuy

    PanelGuy Well-Known Member

    Joined:
    Oct 13, 2004
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  3. PanelGuy

    PanelGuy Well-Known Member

    Joined:
    Oct 13, 2004
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    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?
     
Loading...

Share This Page