[bug #382] LDAP Authentifikation Setup failed at all

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

Changes by: Dave Hall <dave.hall@xxxxxxxxxxx>
Date: Thu 10/30/03 at 17:46 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
           Bug Group | 0.9.14 RC3                | 0.9.16RC1
          Resolution | None                      | Fixed
         Assigned to | jarg                      | skwashd
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
I can confirm this is fix in 16 cvs



=================== BUG #382: FULL BUG SNAPSHOT ===================


Submitted by: None                    Project: phpGroupWare                 
Submitted on: Sun 05/12/02 at 17:55
Category:  API - Setup                Bug Group:  0.9.16RC1                 
Severity:  4                          Priority:  Normal                     
Resolution:  Fixed                    Assigned to:  skwashd                 
Status:  Closed                       Component Version:  None              
Platform Version:  Linux - Mandrake   Reproducibility:  Every Time          

Summary:  LDAP Authentifikation Setup failed at all

Original Submission:  1.Creating demo accounts and one admin failes with the 
following error after pressing the submit button:


"Warning: LDAP: add operation could not be completed. in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
688
Database error: Invalid SQL: INSERT INTO phpgw_acl (acl_appname, acl_location, 
acl_account, acl_rights) VALUES ('preferences', 'changepassword', , 0)

Session halted.
Fatal error: Call to undefined function: parse_navbar_end() in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/footer.inc.php on line 62
"

Summary:
1.1 LDAP works no problem testet with several clients.
1.2 SQL authentification ok.
1.3 Inserted ou=groups,dc==example,dc=de
          ou=users,dc=example,dc=de
into LDAP tree.
1.4 schemas included.
1.5 phpgwc creates groups cn=admins (isn`t that wrong, shouldn`t it be dn: 
ou=admins,ou=groups,dc=...,dc=dc...) 

2. Export from Mysql to ldap failes
2.1 starting point  /setup/ldap.php
2.2 choice Export ...SQL ...LDAP  >>>> /setup/ldapexport.php
2.3. choice all user (=admin ++ demo users), choice admin and default group
2.4. submit = export
2.5. Error
Error: Can't connect to LDAP server !

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
405

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
406

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
413

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
415

accountid: 1
accountlid: Default
exists: 
Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
405

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
406

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
413

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
415

accountid: 2
accountlid: Admins
exists: 
Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
405

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
406

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
413

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
415

Adding3
Warning: LDAP: add operation could not be completed. in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
688

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
405

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
406

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
413

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
415

Adding4
Warning: LDAP: add operation could not be completed. in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
688

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
405

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
406

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
413

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
415

Adding5
Warning: LDAP: add operation could not be completed. in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
688

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
405

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
406

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
413

Warning: Supplied argument is not a valid ldap link resource in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
415

Adding6
Warning: LDAP: add operation could not be completed. in 
/usr/local/httpd/htdocs/phpgw/phpgwapi/inc/class.accounts_ldap.inc.php on line 
688

Attention: "Can`t connect to LDAP -SeRVER"  is not true due to a in general 
working parameters insertet in th Configuration and verified with several 
clients.

I checked this error for 5 times now !
And got no idea !
Is it a bug?
Thanks for any hint !

Wolfgang Buech
buech@xxxxxxxxxxxxxx

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

-------------------------------------------------------
Date: Thu 10/30/03 at 17:46         By: skwashd
I can confirm this is fix in 16 cvs

-------------------------------------------------------
Date: Thu 10/30/03 at 08:31         By: pooh_
Is this still a problem?

-------------------------------------------------------
Date: Mon 08/19/02 at 09:36         By: milosch
Thanks, I guess we need to make those have a default value, and by default 
enable their usage.

-------------------------------------------------------
Date: Sat 06/01/02 at 18:19         By: None
Probably solution!

slapd logs:

"...posixAccount needs attribut homedirectory..."





If you fill in homedirectory and shell for the users in step two of the setup 
process,  it works.







-------------------------------------------------------
Date: Sun 05/19/02 at 02:48         By: milosch
OK, really need to see some logs from the LDAP server to

know why this is failing.  I will commit a change to

not try the acl inserts if it does, but there is some other reason here.



-------------------------------------------------------
Date: Sat 05/18/02 at 16:44         By: None
Yes i did  enter host rootdn.rootpw, accounts ou groups and ou accounts into 
setup/config.php.

And adding new groups etc works with other clients like java ldapbrowser.

There are two different error messages depending on how you setup the ldap ou .

1. Export from sql:

"Database error:..... invalid SQL statement..."

Hint: There have been 3 posting in the user mailing lists with the same error. 



2. Directly creating the ldap ous from the initial setup:

See the above error messages.

As far as i know this means that the id for the connection between the 
ldapserver and the client passed by to verify the connection is not correct or 
identical.



system: openldap  2.0.23-53, Mysql-3.23.48-19, php 4.1.0



-------------------------------------------------------
Date: Sat 05/18/02 at 16:44         By: None
Yes i did  enter host rootdn.rootpw, accounts ou groups and ou accounts into 
setup/config.php.

And adding new groups etc works with other clients like java ldapbrowser.

There are two different error messages depending on how you setup the ldap ou .

1. Export from sql:

"Database error:..... invalid SQL statement..."

Hint: There have been 3 posting in the user mailing lists with the same error. 



2. Directly creating the ldap ous from the initial setup:

See the above error messages.

As far as i know this means that the id for the connection between the 
ldapserver and the client passed by to verify the connection is not correct or 
identical.



system: openldap  2.0.23-53, Mysql-3.23.48-19, php 4.1.0



-------------------------------------------------------
Date: Fri 05/17/02 at 22:08         By: milosch
cn=admins is correct



you have a basic ldap connection problem.  Did you enter

the host, rootdn, rootpw, accounts ou and groups ou in setup/config.php ?




CC list is empty


No files currently attached


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

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