[bug #5996] Problem with authentification in LDAP ( in mysql :)

=================== BUG #5996: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5996&group_id=509

Changes by: Caeies <benoit.hamet@xxxxxxxxxxx>
Date: Thu 10/30/03 at 12:52 (GMT)

------------------ Additional Follow-up Comments ----------------------------
It seems that now this works,

But there still some problems.



I don't know, if this is correlated to this bug or not.

But, When I try to create an admin user from a Fresh install,

It don't set the password that I give. (so the userPassword is empty).



So I use ldappasswd to set it, all is ok, I can now loggin as admin (youpi !)



But When I try to add a Group Account, MySQL failed :

Database error: Invalid SQL: insert into phpgw_log (log_date, log_app, 
log_account_id, log_account_lid, log_severity, log_file, log_line, log_msg) 
values ('2003-10-30 13:11:16','admin',6,'admin','s','',0,'s')

MySQL Error: 1100 (Table 'phpgw_log' was not locked with LOCK TABLES)



File: phpgwapi/inc/class.log.inc.php

Line: 192



Session halted.



Looking at the mysql logs, it seems that a lock table is done, then released, 
but I guess that 2 apps try to do the same in the same time, and that's why it 
failed ...





=================== BUG #5996: FULL BUG SNAPSHOT ===================


Submitted by: Caeies                  Project: phpGroupWare                 
Submitted on: Thu 10/16/03 at 14:29
Category:  addressbook                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  jarg                    
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - Debian     Reproducibility:  Every Time          

Summary:  Problem with authentification in LDAP ( in mysql :)

Original Submission:  This is the result :

Warning: Missing argument 2 for equal() in 
phpgroupware/phpgroupware/phpgwapi/inc/class.sql.inc.php on line 56

Database error: Invalid SQL: SELECT contact_person.person_id AS person_id, 
contact_person.first_name AS per_first_name, contact_person.last_name AS 
per_last_name, contact_person.initials AS per_initials, contact_person.title AS 
per_title, contact_person.department AS per_department, contact_person.pubkey 
AS per_pubkey FROM phpgw_contact_person AS contact_person INNER JOIN 
phpgw_contact AS contact_central ON contact_central.contact_id = 
contact_person.person_id WHERE (contact_central.contact_type_id = AND 
contact_central.contact_id = 5)

MySQL 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 'AND 
contact_central.contact_id = 5)' at line 1)



File:    phpgroupware/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php

Line: 990



Session halted.



After looking at the line 990, it seems that the LDAP use the ->get_persons 
function, which don't provided one argument ( don't know why 
contact_central.contact_type_id is empty !)



I'll will try to investigate where is the problem.

To reproduce the bug :

>From a fresh install, configure your application and choose LDAP has protocol 
>to authentification.

Fill in the right values into the context/rootdn/...

save.

Then choose to create a new admin account (4th option in the next screen) fill 
in the fields and submit.

The error occurs here.



Hope this help.

Please fill free to contact me.

Follow-up Comments
*******************

-------------------------------------------------------
Date: Thu 10/30/03 at 12:52         By: Caeies
It seems that now this works,

But there still some problems.



I don't know, if this is correlated to this bug or not.

But, When I try to create an admin user from a Fresh install,

It don't set the password that I give. (so the userPassword is empty).



So I use ldappasswd to set it, all is ok, I can now loggin as admin (youpi !)



But When I try to add a Group Account, MySQL failed :

Database error: Invalid SQL: insert into phpgw_log (log_date, log_app, 
log_account_id, log_account_lid, log_severity, log_file, log_line, log_msg) 
values ('2003-10-30 13:11:16','admin',6,'admin','s','',0,'s')

MySQL Error: 1100 (Table 'phpgw_log' was not locked with LOCK TABLES)



File: phpgwapi/inc/class.log.inc.php

Line: 192



Session halted.



Looking at the mysql logs, it seems that a lock table is done, then released, 
but I guess that 2 apps try to do the same in the same time, and that's why it 
failed ...



-------------------------------------------------------
Date: Thu 10/30/03 at 05:57         By: eald
Is this still a problem?

-------------------------------------------------------
Date: Tue 10/28/03 at 00:00         By: pooh_
eald: is this something you are able to handle ?



pooh_

-------------------------------------------------------
Date: Fri 10/17/03 at 10:52         By: Caeies
So let's try a workaround (for me) to go back in MySQL connections, after an 
LDAP authentication.

Go on the setup page, choose the MySQL type of authentification, and erase 
<b>ALL</b> the informations in the LDAP entries (rootdn, host,...). Then 
recreate the admin user into MySQL, And It should work again.



Hope this Help.


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5996&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/