[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bug #5996] Problem with authentification in LDAP
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [bug #5996] Problem with authentification in LDAP ( in mysql :) |
Date: |
Mon, 27 Oct 2003 19:00:01 -0500 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5a) Gecko/20031010 Mozilla Firebird/0.6.1 |
=================== 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/