[Phpgroupware-tracker] [bug #5996] Problem with contacts with LDAP auth

[nobody]

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

Changes by: Dave Hall <address@hidden>
Date: Mon 11/03/03 at 18:10 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
            Category | addressbook               | API - phpGWapi
           Bug Group | 0.9.16RC1                 | 0.9.14.003 release
          Resolution | None                      | Fixed
              Status | Open                      | Closed
             Summary | Problem with authentification in LDAP ( in mysql :) | 
Problem with contacts with LDAP auth


------------------ Additional Follow-up Comments ----------------------------
Can you please log the new error as a seperate bug report - as the primary bug 
is now fixed in cvs.



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


Submitted by: Caeies                  Project: phpGroupWare                 
Submitted on: Fri 10/17/03 at 00:29
Category:  API - phpGWapi             Bug Group:  0.9.14.003 release        
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  Fixed                    Assigned to:  jarg                    
Status:  Closed                       Component Version:  CVS               
Platform Version:  Linux - Debian     Reproducibility:  Every Time          

Summary:  Problem with contacts with LDAP auth

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: Mon 11/03/03 at 18:10         By: skwashd
Can you please log the new error as a seperate bug report - as the primary bug 
is now fixed in cvs.

-------------------------------------------------------
Date: Thu 10/30/03 at 23: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 16:57         By: eald
Is this still a problem?

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



pooh_

-------------------------------------------------------
Date: Fri 10/17/03 at 20: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/