[Phpgroupware-tracker] [bugs #9687] Can not login after setup run with register_globals turned off with LDAP Authentication

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #9687] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Wed 07/28/2004 at 08:48 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
            Severity | 3 - Ordinary              | 7 - Major
         Assigned to | None                      | fipsfuchs


------------------ Additional Follow-up Comments ----------------------------
My dev install is register_globals = off.  Setup is register_globals = off 
safe.  I spent a fair bit of time making sure they would work with 
register_globals = off in 16.

login with SQL accounts in 16 works with register_globals = off

Side note, I fixed ldapmodify to work with the new schema in 001, ldap 
import/export need to be checked.






/**************************************************************************/
[bugs #9687] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=9687>
Project: phpGroupWare
Submitted by: 0
On: Mon 07/19/2004 at 01:36

Category:  API - Setup
Item Group:  0.9.16.001
Severity:  7 - Major
Priority:  7 - High
Resolution:  None
Assigned to:  fipsfuchs
Status:  Open
Component Version:  BZIP2
Platform Version:  GNU/Linux - RedHat/Fedora
Reproducibility:  None
Planned Release:  None
Fixed Release:  


Summary:  Can not login after setup run with register_globals turned off with 
LDAP Authentication

Original Submission:  With register_globals turned off, after going through the 
setup process, choosing LDAP as the authentication type, and adding LDAP users 
and groups to the MySQL database, users receive the following error when 
logging in:

Database error: Invalid SQL: LIMIT 15
MySQL Error: 1064 (You have an error in your SQL syntax near 'LIMIT 15' at line 
1)
File: /var/www/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 862
Session halted.

Dropping all the tables from the database, turning on register_globals and 
going through setup again fixed the problem.

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


-------------------------------------------------------
Date: Wed 07/28/2004 at 08:48       By: skwashd
My dev install is register_globals = off.  Setup is register_globals = off 
safe.  I spent a fair bit of time making sure they would work with 
register_globals = off in 16.

login with SQL accounts in 16 works with register_globals = off

Side note, I fixed ldapmodify to work with the new schema in 001, ldap 
import/export need to be checked.

-------------------------------------------------------
Date: Wed 07/28/2004 at 08:39       By: fipsfuchs
I'm pretty sure that the setup scripts won't work with
register_globals = off. These scripts are very poor. I'm not sure if it is 
worth to debug errors like this one in theses scripts. If somebody provides a 
patch - I'm happy to apply it.



-------------------------------------------------------
Date: Tue 07/27/2004 at 14:36       By: Caeies
I will try with register_globals turned off ASAP to confirm this.

Btw the error is very strange LIMIT 15 is only a part of a request, so ... some 
values are dropped I guess.

Not sure if this is a LDAP error though, so I assinged to fipsfuch, but we need 
more info I think.

Hope I'm clear :)

Caeies












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=9687>

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