[support] Drupal-Postgres-LDAP-FreeBSD

[David King]

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