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.

errors in /usr/local/cpanel/scripts/upcp --cron logfile

Discussion in 'General Discussion' started by trucmuche, Apr 20, 2017.

  1. trucmuche

    trucmuche Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    69
    Likes Received:
    3
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Hello,

    Every day, a cron job is ran on my dns servers and I get some warnings/errors since 5-6 days. Apparently, everything is ok on the dns but I'm worrying whether or not those error messages are important to fix. Could you tell me if I have something to do to ensure stability of my dns servers ? Here are the lines :
    Code:
    [2017-04-20 04:54:43 +0200]   68% complete
    [2017-04-20 04:54:43 +0200]    - Processing command `/usr/local/cpanel/scripts/checkbashshell`
    [2017-04-20 04:54:43 +0200]   70% complete
    [2017-04-20 04:54:43 +0200]    - Processing command `/usr/local/cpanel/scripts/purge_modsec_log`
    [2017-04-20 04:54:43 +0200]      [23358] Cpanel::Exception::Database::Error/(XID 6v7wtw) Database /var/cpanel/modsec/modsec.sqlite Error: no such table: hits
    [2017-04-20 04:54:43 +0200]      [23358]  at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 77.
    [2017-04-20 04:54:43 +0200]      [23358]     Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x114b468), HASH(0x110bb38)) called at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 94
    [2017-04-20 04:54:43 +0200]      [23358]     Cpanel::Exception::create_raw("Database::Error", "Database /var/cpanel/modsec/modsec.sqlite Error: no such tabl"..., HASH(0x110bb38)) called at /usr/local/cpanel/Cpanel/Exception.pm line 30
    [2017-04-20 04:54:43 +0200]      [23358]     Cpanel::Exception::__ANON__(__CPANEL_HIDDEN__, __CPANEL_HIDDEN__..., HASH(0x110bb38)) called at /usr/local/cpanel/Cpanel/DBI.pm line 193
    [2017-04-20 04:54:43 +0200]      [23358]     Cpanel::DBI::_create_exception(Cpanel::DBI::SQLite::db=HASH(0x110b700), "DBD::SQLite::db do failed: no such table: hits", undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 178
    [2017-04-20 04:54:43 +0200]      [23358]     Cpanel::DBI::_error_handler("DBD::SQLite::db do failed: no such table: hits", Cpanel::DBI::SQLite::db=HASH(0x110b700), undef) called at /usr/local/cpanel/Cpanel/ModSecurity/DB.pm line 312
    [2017-04-20 04:54:43 +0200]      [23358]     Cpanel::ModSecurity::DB::purge_stale_records_from_database(7) called at /usr/local/cpanel/scripts/purge_modsec_log line 41
    [2017-04-20 04:54:43 +0200]      [23358]     scripts::purge_modsec_log::run() called at /usr/local/cpanel/scripts/purge_modsec_log line 27
    [2017-04-20 04:54:43 +0200]   72% complete
    [2017-04-20 04:54:43 +0200]   74% complete
    [2017-04-20 04:54:44 +0200]   Setting up cronjobs
    Many thanks in advance !
    T.
     
  2. cPanelChrisI

    cPanelChrisI Technical Analyst II
    Staff Member

    Joined:
    Mar 24, 2014
    Messages:
    67
    Likes Received:
    11
    Trophy Points:
    83
    cPanel Access Level:
    Root Administrator
    Hello!

    The main error I see there is this:

    [2017-04-20 04:54:43 +0200] [23358] Cpanel::Exception::Database::Error/(XID 6v7wtw) Database /var/cpanel/modsec/modsec.sqlite Error: no such table: hits

    If the hits table is missing from that database, running this command will readd it.

    /scripts/setup_modsec_db

    Thanks!
     
  3. trucmuche

    trucmuche Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    69
    Likes Received:
    3
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Ok I ran this command and it shows me one line of output : "info [setup_modsec_db] : Initialized ModSecurity database."
    I will see tomorrow if the problem is solved...
    Thanks !
     
    cPanelMichael likes this.
Loading...

Share This Page