MySQL error 1267 when adding a linux system
Page 1 of 1

Author:  aylnews [ Wed Jun 15, 2011 6:54 pm ]
Post subject:  MySQL error 1267 when adding a linux system

I have installed beta 1.1 on a windows 7 machine and successfully audited my domain, brilliant. However when I try to audit a linux machine it does not appear. When I manually copy the audit_linux generated xml .txt file into the add system form I come up with a 1267 collation error; see attached for system information and a screen shot of the error.

the sql statement is:-

SELECT sys_hw_bios.bios_id FROM sys_hw_bios, system WHERE sys_hw_bios.system_id = system.system_id AND '1042' = system.system_id AND system.man_status = 'production' AND 'VirtualBox' = bios_description AND 'innotek GmbH' = bios_manufacturer AND '0' = bios_serial AND '1.2' = bios_smversion AND 'VirtualBox' = bios_version AND ( '0000-00-00 00:00:00' = sys_hw_bios.timestamp OR '' = sys_hw_bios.timestamp) LIMIT 1

It appears to be falling over on the empty datetime string at the end of the sql statement. If I manually run the query and change round the last statement e.g. sys_hw_bios.timestamp = '' or alternatively change it to be _latin1'' = sys_hw_bios.timestamp the query then works. I have tried changing the collation on the table but does not seem to make a difference.

I am running Windows 7 SP1 using IIS and PHP 5.3.6 and MySQL 5.5.13.

Any help would be greatly appreciated.

open-audit-error.png [ 28.1 KiB | Viewed 1845 times ] [5.55 KiB]
Downloaded 248 times

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group