Incorrect daytime MySQL odbc logging
Romachy
Hello,
I tried to use ODBC logging of MySQL.
But I encountered following errors on debug mode:
-----------------------------------------------------------
C:Program FilesServersCheck_Monitoring>monitoring_manager.exe > debug5.txt
DBD::ODBC::db do failed: [MySQL][ODBC 3.51 Driver][mysqld-5.0.84-community-nt]In
correct datetime value: '8/21/109 15:24:28' for column 'TimeStamps' at row 1 (SQ
L-HY000) at monitoring_thread2.pl line 10826.
DBD::ODBC::db do failed: [MySQL][ODBC 3.51 Driver][mysqld-5.0.84-community-nt]In
correct datetime value: '8/21/109 15:25:50' for column 'TimeStamps' at row 1 (SQ
L-HY000) at monitoring_thread2.pl line 10826.
-----------------------------------------------------------
On the above messages, "8/21/109" seems incorrect.
Actually "mysql> select current_timestamp;" shows correct date("2009-08-21").
ServersCheck :7.15.10.
MySQL :5.0.84 win32
MySQL ODBC driver
.51.27.00
Tables were created as follows:
-----------------------------------------------------------
mysql> source C:Program FilesServersCheck_Monitoringadd-onsMySQL.sql
-----------------------------------------------------------
I would like to know what is wrong.
I hope your kind advise.
I tried to use ODBC logging of MySQL.
But I encountered following errors on debug mode:
-----------------------------------------------------------
C:Program FilesServersCheck_Monitoring>monitoring_manager.exe > debug5.txt
DBD::ODBC::db do failed: [MySQL][ODBC 3.51 Driver][mysqld-5.0.84-community-nt]In
correct datetime value: '8/21/109 15:24:28' for column 'TimeStamps' at row 1 (SQ
L-HY000) at monitoring_thread2.pl line 10826.
DBD::ODBC::db do failed: [MySQL][ODBC 3.51 Driver][mysqld-5.0.84-community-nt]In
correct datetime value: '8/21/109 15:25:50' for column 'TimeStamps' at row 1 (SQ
L-HY000) at monitoring_thread2.pl line 10826.
-----------------------------------------------------------
On the above messages, "8/21/109" seems incorrect.
Actually "mysql> select current_timestamp;" shows correct date("2009-08-21").
ServersCheck :7.15.10.
MySQL :5.0.84 win32
MySQL ODBC driver
.51.27.00Tables were created as follows:
-----------------------------------------------------------
mysql> source C:Program FilesServersCheck_Monitoringadd-onsMySQL.sql
-----------------------------------------------------------
I would like to know what is wrong.
I hope your kind advise.
This discussion has been closed.
Comments
http://files.serverscheck.net/fixes/monitoring_thread2.zip
The ODBC logging seems to be fine.
Thank you !!