witam, wdrazam aplikacje egroupware (http://www.egroupware.org/), musialem troche zmodyfikowac kod, aby wspolpracowal z AD w mojej firmie, w miejscu gdzie system loguje uzytkownika (pobiera dane z bazy) ja autoryzuje usera przez AD i jesli to nowy user, dodaje go do bazy, jednak raz na jakis czas, w chwili dodawania dostaje blad 1062 Duplicate Entry, query log z mysql'a wyglada tak
10 Query SELECT *
FROM phpgw_config WHERE config_app='phpgwapi'
11 Query DELETE
FROM phpgw_app_sessions WHERE sessionid = '0' AND loginid = '0' AND app = 'phpgwapi' AND location = 'config'
10 Query DELETE
FROM phpgw_app_sessions WHERE sessionid = '0' AND loginid = '0' AND app = 'phpgwapi' AND location = 'config'
11 Query SELECT account_id
FROM phpgw_accounts WHERE account_lid='pawela'
10 Query SELECT account_id
FROM phpgw_accounts WHERE account_lid='pawela'
11 Query SELECT account_id
FROM phpgw_accounts WHERE account_lid='pawela'
11 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND ip='172.26.25.79' AND li > 1123597019
11 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND (loginid='pawela' OR loginid LIKE 'pawela@%') AND li > 1123597019
10 Query SELECT account_id
FROM phpgw_accounts WHERE account_lid='pawela'
10 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND ip='172.26.25.79' AND li > 1123597019
10 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND (loginid='pawela' OR loginid LIKE 'pawela@%') AND li > 1123597019
11 Query SELECT *
FROM phpgw_accounts WHERE account_lid = 'pawela' AND account_type='u' AND account_pwd='1e47d2e1b9bc29523c2f3e8fb9bf11ab' AND account_status ='A'
11 Query SELECT *
FROM phpgw_accounts WHERE account_lid = 'pawela' AND account_type='u'
11 Query SELECT account_id
FROM phpgw_accounts WHERE account_lid = 'IT' AND account_type='g' AND account_status ='A'
11 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND ip='172.26.25.79' AND li > 1123597019
10 Query SELECT *
FROM phpgw_accounts WHERE account_lid = 'pawela' AND account_type='u' AND account_pwd='1e47d2e1b9bc29523c2f3e8fb9bf11ab' AND account_status ='A'
11 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND (loginid='' OR loginid LIKE '@%') AND li > 1123597019
10 Query SELECT *
FROM phpgw_accounts WHERE account_lid = 'pawela' AND account_type='u'
10 Query SELECT account_id
FROM phpgw_accounts WHERE account_lid = 'IT' AND account_type='g' AND account_status ='A'
11 Query SELECT *
FROM phpgw_accounts WHERE account_lid = '' AND account_type='u' AND account_pwd='1e47d2e1b9bc29523c2f3e8fb9bf11ab' AND account_status ='A'
10 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND ip='172.26.25.79' AND li > 1123597019
10 Query SELECT count(*)
FROM phpgw_access_log WHERE account_id=0 AND (loginid='' OR loginid LIKE '@%') AND li > 1123597019
11 Query UPDATE phpgw_access_log SET lo=1123598819 WHERE sessionid='bad login or password'
10 Query SELECT *
FROM phpgw_accounts WHERE account_lid = '' AND account_type='u' AND account_pwd='1e47d2e1b9bc29523c2f3e8fb9bf11ab' AND account_status ='A'
10 Query UPDATE phpgw_access_log SET lo=1123598819 WHERE sessionid='bad login or password'
11 Query DELETE
FROM phpgw_access_log WHERE li < 1115822819
10 Query DELETE
FROM phpgw_access_log WHERE li < 1115822819
11 Query INSERT
INTO phpgw_accounts (account_lid,account_pwd,account_firstname,account_lastname,account_status,account_expires,account_type,person_id,account_primary_group,account_email) VALUES ('pawela','1e47d2e1b9bc29523c2f3e8fb9bf11ab','Paweł','Antczak','A',-1,'u',0,9,'pawela@lge.com')
10 Query INSERT
INTO phpgw_accounts (account_lid,account_pwd,account_firstname,account_lastname,account_status,account_expires,account_type,person_id,account_primary_group,account_email) VALUES ('pawela','1e47d2e1b9bc29523c2f3e8fb9bf11ab','Paweł','Antczak','A',-1,'u',0,9,'pawela@lge.com')
11 Query SELECT account_id
FROM phpgw_accounts WHERE account_lid = 'pawela' AND account_type='u' AND account_status ='A'
11 Query INSERT
INTO phpgw_acl VALUES ('preferences','changepassword','113',1)
11 Query INSERT
INTO phpgw_acl VALUES ('phpgw_group','9','113',1)
widacy wyraznie, ze sa dwa procesy? kotry robia to samo, jesli macie pomysly zapraszam. dodam, ze korzystam z xampp'a, ale na czystym A+MySQL+php tez mam ten blad. pzdr i czekam na pomysly