Defining a ldap server using postgresql gave the following error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "ldapdata_rwattrs" violates not-null constraint in /home/johnp/drupal-6.13/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO ldapauth (name, status, server, port, tls, encrypted, basedn, user_attr, mail_attr, binddn, bindpw) VALUES ('xxx', '1', 'xxx', '10389', '0', '0', 'dc=ndff-ecogrid,dc=nl', 'uid', 'email', 'uid=gan,ou=users,ou=system', 'xxxx') in /home/johnp/drupal.sites/all/modules/ldap_integration/ldapauth.admin.inc on line 355.

The insert statement did work when these fields were added with empty strings as values: ldapdata_rwattrs, ldapdata_roattrs, ldapdata_mappings.

If you want I can provide a patch, just let me know (and for which release).

Thanks,
John

Comments

miglius’s picture

Issue tags: +PostgreSQL

Please try the dev version first, and if there is a problems with PostgreSQL, please provide a patch against dev version.

jpulles’s picture

The dev version doesn't give this error since the database fields added by the ldapdata module have 'not null' => FALSE here. So no need for a patch against dev.

miglius’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)
Issue tags: -PostgreSQL

Automatically closed -- issue fixed for 2 weeks with no activity.