[support] Drupal-Postgres-LDAP-FreeBSD

[David King]

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