Hi Hans (and all others that experience this issue),
Can you log into your MySQL server (preferably with the same credentials as cacti) and run the following command and report the outcome here:
mysql> SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode;
On my system, this returns:
mysql> SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode;
+-------------------+--------------------+------------+
| @@global.sql_mode | @@session.sql_mode | @@sql_mode |
+-------------------+--------------------+------------+
| | | |
+-------------------+--------------------+------------+
1 row in set (0.06 sec)
I suspect that you have somewhere sql_mode NO_ZERO_DATE defined. If that is true, I think what I need to request from upstream is that they are robust against that option by clearing that mode in their connection.
Also, I like to know if this was a fresh install (because I expect this issue would cause the install to fail on your system).
And just so we have all the required info, please run:
apport-collect 1578144
Hi Hans (and all others that experience this issue),
Can you log into your MySQL server (preferably with the same credentials as cacti) and run the following command and report the outcome here:
mysql> SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode;
On my system, this returns: ------- ------+ ------- ------- ------+ ------- -----+ ------- ------+ ------- ------- ------+ ------- -----+ ------- ------+ ------- ------- ------+ ------- -----+
mysql> SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode;
+------
| @@global.sql_mode | @@session.sql_mode | @@sql_mode |
+------
| | | |
+------
1 row in set (0.06 sec)
I suspect that you have somewhere sql_mode NO_ZERO_DATE defined. If that is true, I think what I need to request from upstream is that they are robust against that option by clearing that mode in their connection.
Also, I like to know if this was a fresh install (because I expect this issue would cause the install to fail on your system).
And just so we have all the required info, please run:
apport-collect 1578144
Paul