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

trucmuche

Well-Known Member
Nov 20, 2014
85
3
58
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.
 

ChrisI

Technical Analyst II
Mar 24, 2014
67
12
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!
 

trucmuche

Well-Known Member
Nov 20, 2014
85
3
58
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 !
 
  • Like
Reactions: cPanelMichael