100-monitor_database_size.inc.php reports 0 used space

When did you install the ISPConfig git-stable version? If it was not installed in the past few days, try to make an update to the current git-stable version to see if that solves the issue.

 

That is the latest stable-3.1.

Is this a single server or multi-server install? If multi-server, make sure all your servers are on that same version.

Check that the password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf works (run 'mysql -u root -p -h localhost mysql' and paste that password).

 

The archive you downloaded is the latest git-stable version, as @Jesse Norell pointed out already in post #4.

 

It is a development version of the stable-3.1 branch, a git branch of the current stable version, 3.1. At some point in the future that branch will become the next stable release (3.1.14). Not to be confused with the master branch, which is development branch for the next version of ispconfig, eg. 3.2. Not many features make it into 3.1, it's mostly for bugfixes, and the particular ispconfig3-stable-3.1-e2465bd7a2d324259c3c1dae00dfca8c2535edcc which you installed is a few bugfixes/changes ahead of the most recent stable release, 3.1.13.

 

I'm using the same version on debian 9 and database quotas are working there; I don't have ubuntu 14.04 to test offhand. Maybe do a quick checksum and make sure you see the same:

Code:

# md5sum /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_database_size.inc.php 
5ccae058c2273791dcd0d382c410968b  /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php
f0515547b8b650221ba09fb70c7555a8  /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_database_size.inc.php

Beyond that, it sounds like getDatabaseSize() is returning 0, so I'd try adding some debugging lines to the getDatabaseSize() function in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php and see what you might find, eg. start with:

Code:

        public function getDatabaseSize($database_name) {
                global $app;

                require_once 'lib/mysql_clientdb.conf';

$app->log("getDatabaseSize(): running query: " .
    "SELECT SUM(data_length+index_length) FROM information_schema.TABLES WHERE table_schema='".$this->escape($database_name)."'");
                $result = $this->_query("SELECT SUM(data_length+index_length) FROM information_schema.TABLES WHERE table_schema='".$this->escape($database_name)."'"); 
                if(!$result) { 
                        $this->_sqlerror('Unable to determine the size of database ' . $database_name); 
                        return; 
                } 
$app->log("getDatabaseSize(): got result"); 
                $database_size = $result->getAsRow(); 
                $result->free(); 
$app->log("getDatabaseSize(): \$database_size[0] is: " . $database_size[0]);
        return $database_size[0] ? $database_size[0] : 0;
        }

You may have to similarly debug db_result::getAsResult() (same file), or 100-monitor_database_size.inc.php .. something must be different in your setup, though I don't know what offhand.

 

Yes, that's normal when no errors occurred.

 

IIRC the log messages would end up in cron.log, not ispconfig.log, and not on the cli. Also make sure you edited /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php, not the identical file under /usr/local/ispconfig/interface/....

My mistake, it is getAsRow().

 

As for debug messages, it looks like from the cron you have to use "print", it seems $app is not setup the same when running a cronjob. As for the issue, I actually can reproduce it (I verified the system where I thought it was working had a different db_mysql.inc.php, and the one with the right version wasn't working anymore); try this:

Code:

        public function getDatabaseSize($database_name) {
                global $app, $conf;
                static $db=null;

                if ( ! $db ) {
                        $clientdb_host     = ($conf['db_host']) ? $conf['db_host'] : NULL;
                        $clientdb_user     = ($conf['db_user']) ? $conf['db_user'] : NULL;
                        $clientdb_password = ($conf['db_password']) ? $conf['db_password'] : NULL;
                        $clientdb_port     = ((int)$conf['db_port']) ? (int)$conf['db_port'] : NULL;
                        $clientdb_flags    = ($conf['db_flags'] !== NULL) ? $conf['db_flags'] : NULL;

                        require_once 'lib/mysql_clientdb.conf';

                        $db = new db($clientdb_host, $clientdb_user, $clientdb_password, NULL, $clientdb_port, $clientdb_flags);
                }

                $result = $db->_query("SELECT SUM(data_length+index_length) FROM information_schema.TABLES WHERE table_schema='".$db->escape($database_name)."'");
                if(!$result) {
                        $db->_sqlerror('Unable to determine the size of database ' . $database_name);
                        return;
                }
                $database_size = $result->getAsRow();
                $result->free();
                return $database_size[0] ? $database_size[0] : 0;
        }