My name is David King, I am having trouble with LDAP users logging on
I have a very vanilla Drupal (v4.6.6) install, except that it is installed on Postgres, I have the LDAP authentication module installed, and it is installed on FreeBSD (all three are installed via the FreeBSD Ports system).
When I try to have an LDAP user log in, the user is created in the database, and looks like this:
$ psql drupal drupal=# select uid,name,data from users; uid | name | data -----+------- +----------------------------------------------------------------------- -------------------------------------------------------- 0 | | 1 | admin | a:1:{s:5:"roles";a:1:{i:0;s:1:"2";}} 2 | dking | a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=DN>";} (3 rows)
But the user is presented with a blank page after several seconds. In the log are dumped many (a hundred or so) Postgres errors of the following forms:
pg_query(): Query failed: ERROR: multiple assignments to same column "changed" in /usr/local/www/drupal/includes/database.pgsql.inc on line 45.
query: UPDATE users SET uid = '2', name = 'dking', pass = '47c6b15aca93873f58522f26300d181d', mail = 'dking@<censored=domain>', mode = '0', sort = '0', threshold = '0', theme = '', signature = '', created = '1150424378', changed = '1150424378', status = '1', timezone = '', language = '', picture = '', init = '', data = 'a:3:{s: 5:"roles";a:1:{i:0;s:1:"2";}s:17:"ldap_authentified";b:1;s: 7:"ldap_dn";s:38:"<censored=dn>";}', data = 'a:3:{s:5:"roles";a:1:{i: 0;s:1:"2";}s:17:"ldap_authentified";b:1;s:7:"ldap_dn";s: 38:"<censored=dn>";}', changed = 1150424379 WHERE uid = 2 in /usr/ local/www/drupal/includes/database.pgsql.inc on line 62.
The errors seem to alternate between those two.
I can't delete the user in the database, because if I go to Administer > Users > dking (the username) > Edit, I get the browser error that the server has closed the connection.
How can I go about troubleshooting/debugging this? Does anyone have any ideas?
Some more potentially useful information:
~% uname -a FreeBSD <> 5.3-RELEASE-p20 FreeBSD 5.3-RELEASE-p20 #2: Fri Sep 9 14:11:12 PDT 2005 root@<>:/usr/obj/usr/src/sys/ROUTERKERNEL i386
~% pkg_info | grep drupal drupal-4.6.6_2006031700 CMS that supports pgsql and mysql drupal-ldap_integration-4.6.0_20060117 LDAP user authentication for the Drupal CMS
~% psql --version psql (PostgreSQL) 8.0.8
I tried upgrading to postgres 8.1 instead of 8.0 to no avail. Does anyone have any ideas? I can do additional debugging
On 15 Jun 2006, at 19:27, David King wrote:
My name is David King, I am having trouble with LDAP users logging on
I have a very vanilla Drupal (v4.6.6) install, except that it is installed on Postgres, I have the LDAP authentication module installed, and it is installed on FreeBSD (all three are installed via the FreeBSD Ports system).
When I try to have an LDAP user log in, the user is created in the database, and looks like this:
$ psql drupal drupal=# select uid,name,data from users; uid | name | data -----+-------
+---------------------------------------------------------------------
0 | | 1 | admin | a:1:{s:5:"roles";a:1:{i:0;s:1:"2";}} 2 | dking | a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=DN>";} (3 rows)
But the user is presented with a blank page after several seconds. In the log are dumped many (a hundred or so) Postgres errors of the following forms:
pg_query(): Query failed: ERROR: multiple assignments to same column "changed" in /usr/local/www/drupal/includes/ database.pgsql.inc on line 45.
query: UPDATE users SET uid = '2', name = 'dking', pass = '47c6b15aca93873f58522f26300d181d', mail = 'dking@<censored=domain>', mode = '0', sort = '0', threshold = '0', theme = '', signature = '', created = '1150424378', changed = '1150424378', status = '1', timezone = '', language = '', picture = '', init = '', data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}', data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}', changed = 1150424379 WHERE uid = 2 in /usr/local/www/drupal/ includes/database.pgsql.inc on line 62.
The errors seem to alternate between those two.
I can't delete the user in the database, because if I go to Administer > Users > dking (the username) > Edit, I get the browser error that the server has closed the connection.
How can I go about troubleshooting/debugging this? Does anyone have any ideas?
Some more potentially useful information:
~% uname -a FreeBSD <> 5.3-RELEASE-p20 FreeBSD 5.3-RELEASE-p20 #2: Fri Sep 9 14:11:12 PDT 2005 root@<>:/usr/obj/usr/src/sys/ROUTERKERNEL i386
~% pkg_info | grep drupal drupal-4.6.6_2006031700 CMS that supports pgsql and mysql drupal-ldap_integration-4.6.0_20060117 LDAP user authentication for the Drupal CMS
~% psql --version psql (PostgreSQL) 8.0.8
-- [ Drupal support list | http://lists.drupal.org/ ]
-- David King Computer Programmer Ketralnis Systems
On 6/22/06, David King dking@ketralnis.com wrote:
I tried upgrading to postgres 8.1 instead of 8.0 to no avail. Does anyone have any ideas? I can do additional debugging
I´m just guess here, but it appears to me that the query it is executing is malformed in some way. Were I you, I´d redo the installation on a test site and try executing this query that has the problem. The DB may give you a more explicit explanation (maybe not) and then you can just try deleting sections of the query until it works and then dive into the section that you removed last (i.e. the offending bit) until you see the syntax error.
query: UPDATE users SET uid = '2', name = 'dking', pass = '47c6b15aca93873f58522f26300d181d', mail = 'dking@<censored=domain>', mode = '0', sort = '0', threshold = '0', theme = '', signature = '', created = '1150424378', changed = '1150424378', status = '1', timezone = '', language = '', picture = '', init = '', data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}', data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}', changed = 1150424379 WHERE uid = 2 in /usr/local/www/drupal/ includes/database.pgsql.inc on line 62.
The errors seem to alternate between those two.
If you are still having trouble after that exercise, you may have better luck asking a pgsql expert or on a pgsql list because drupal users are mostly mysql folks so it´s hard to find a pgsql debugger around these parts...
Best luck, Greg