When I try to add an LDAP server, I get the following message and the server is never added:

user warning: Field 'ldapdata_roattrs' doesn't have a default value query: INSERT INTO CECC_ldapauth (name, status, server, port, tls, encrypted, basedn, user_attr, mail_attr, binddn, bindpw) VALUES ('LDAP1', '1', 'nki', '389', '0', '0', '', 'uid', 'mail', '', '') in D:\TestWeb\drupal-6.5\sites\all\Modules\ldap_integration\ldapauth.admin.inc on line 355.

Any ideas?
Thanks

Comments

Alpha5’s picture

Me too, anyone can help me??? I can't add server. I use IIS to install Drupal and I want to authen with active directory.

user warning: Field 'ldapdata_rwattrs' doesn't have a default value query: INSERT INTO ldapauth (name, status, server, port, tls, encrypted, basedn, user_attr, mail_attr, binddn, bindpw) VALUES ('TEST', '1', 'server1.test.org.vn', '636', '1', '0', 'CN=Users,DC=test,DC=org,DC=vn', 'sAMAccountName', 'mail', 'CN=mcafee,CN=Users,DC=test,DC=org,DC=vn', 'mcafee') in D:\Drupal\sites\all\modules\ldap_integration\ldapauth.admin.inc on line 355.

Alpha5’s picture

I searched this site and found a way to fix this

______________________
I had this error:

'ldapdata_rwattrs' doesn't have a default value

With MySQL manager I found that the default value for some fields in the corresponding table were NULL, while there was also a checkmark at "NOT NULL".
So I unchecked "NOT NULL", and the error was gone.
______________________

Althought, I still not log in by AD account. Have to study more

miglius’s picture

The fields can be NULL in the dev version.

Alpha5’s picture

Success to logon by AD account. Now I study to map group by memberOf to exist role.

JLelie’s picture

@Alpha5: Your suggestion regarding the NULL / Not NULL was a golden one, thanks for that! I did the same and unchecked the Not NULL option in 3 fields, where it said NULL as data.

Errors were GONE. I was now also fully able to populate my AD groups.

miglius’s picture

Version: 6.x-1.0-alpha2 » master
Status: Active » Fixed

Status: Fixed » Closed (fixed)

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

ccaajj’s picture

I had the same problem where ldapdata_rwattrs, ldapdata_roattrs and ldapdata_mappings had Default values of NULL and Null values of NO. Changes all 3 NOs to YES and it worked!

Was able to add our AD server to the LDAP Authentication list.

Thanks alpha5!