Thu 30 Oct 2003 12:52:14 PM UTC, comment #3:
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 ...
|
Fri 17 Oct 2003 10:52:34 AM UTC, comment #1:
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.
|
Thu 16 Oct 2003 02:29:57 PM UTC, 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.
|