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

[nobody]

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

Changes by: Hsing-Foo Wang <address@hidden>
Date: Tue 10/28/2003 at 00:00 (GMT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
            Category | API - phpGWapi            | addressbook
         Assigned to | None                      | eald


------------------ Additional Follow-up Comments ----------------------------
eald: is this something you are able to handle ?



pooh_



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


Submitted by: Caeies                  Project: phpGroupWare                 
Submitted on: Thu 10/16/2003 at 14:29
Category:  addressbook                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  eald                    
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: Tue 10/28/2003 at 00:00       By: pooh_
eald: is this something you are able to handle ?



pooh_

-------------------------------------------------------
Date: Fri 10/17/2003 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/