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.
| Attachments: |
|
open-audit-error.png [ 28.1 KiB | Viewed 5231 times ] |
nagios.aylnews.com.txt [5.55 KiB]
Downloaded 641 times |