mysql-db-usage.json missing

[daveboulter42]

Hi,

When cron runs:
/usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache

we get errors like:

Cpanel::Exception::IO::ChownError/(XID rj6pnv) The system failed to set the user ID to “0” and the group ID to “508” on “/var/cpanel/datastore/xxxxxx/mysql-db-usage.json” because of an error: No such file or directory  at /usr/local/cpanel/Cpanel/Exception.pm line 183.
    Cpanel::Exception::new("Cpanel::Exception::IO::ChownError", HASH(0x298f0d8)) called at /usr/local/cpanel/Cpanel/Exception.pm line 75
    Cpanel::Exception::__create("IO::ChownError", HASH(0x298f0d8)) called at /usr/local/cpanel/Cpanel/Autodie.pm line 473
    Cpanel::Autodie::chown(0, 508, "/var/cpanel/datastore/xxxxxx/mysql-db-usage.json") called at /usr/local/cpanel/Cpanel/CacheFile.pm line 232
    Cpanel::CacheFile::_chown_path(__CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/CacheFile.pm line 130
    Cpanel::CacheFile::save("Cpanel::Mysql::DiskUsage", HASH(0x2a355c8), "xxxxxx") called at bin/update_db_cache.pl line 115
    Script::Update::DB::Cache::__ANON__() called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80
    eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71
    Try::Tiny::try(CODE(0x2a3e490), Try::Tiny::Catch=REF(0x2a05980)) called at bin/update_db_cache.pl line 122
    Script::Update::DB::Cache::script("Script::Update::DB::Cache") called at bin/update_db_cache.pl line 35

 

[James-L]

I also get this error, however I get:

Cpanel::Exception::IO::ChownError/(XID 53ecvg) The system failed to set the user ID to “0† and the group ID to “502† on “/var/cpanel/datastore/*domain*/mysql-db-usage.json† because of an error: No such file or directory

 

[cPanelMichael]

Hello

I've seen this happen on systems with multiple UID 0 users. Could you browse to "WHM >> Service Manager" and disable "Name Service Cache Daemon" to see if the issue persists? You can test this by manually running the following command:

/usr/local/cpanel/scripts/update_db_cache

Thank you.

 

[daveboulter42]

Hello

I've seen this happen on systems with multiple UID 0 users. Could you browse to "WHM >> Service Manager" and disable "Name Service Cache Daemon" to see if the issue persists? You can test this by manually running the following command:

/usr/local/cpanel/scripts/update_db_cache

Thank you.

Thanks
Yes when run by hand works fine.
yes I have two UID 0 users. I wanted a backdoor login just in case. I should implement that better.

 

[cPanelMichael]

yes I have two UID 0 users. I wanted a backdoor login just in case. I should implement that better.

I suggest removing that configuration. You can configure other methods of backup access, or follow the steps at:

[Tutorial] Interested in increasing the security of your server? Read this. (sshd hardening)

Thank you.