Open-AudIT
http://www.open-audit.org/phpBB3/

SQL error on user table.
http://www.open-audit.org/phpBB3/viewtopic.php?f=10&t=3839
Page 1 of 1

Author:  larry [ Wed Nov 03, 2010 7:45 am ]
Post subject:  SQL error on user table.

I am a nob using OA. Installed on XP with xampp. When I run the audit the domain (AD) I get an error

Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '20101102172757','20101102172757','1') ON DUPLICATE KEY UPDATE ldap_users_cn='Ins' at line 1 Auditing computer accounts in: DC=CG,DC=local

I don't have 2 users with the same name. I tried to set the base to a ou with just two users and I get the same error. I imported 100 users and only get one error but always get the error.

Not sure how to tell the version, I downloaded from SF openauditrelease-09.12.23-SVN1233.zip and did no patches.

I deleted the data base and reinstalled but same issue.

Mostly the install was easy, my only issue was enabling ldap in the php config. Which the ldap setup told me about. So far looks real nice, running a bigger test tonigt. :D

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/