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
Comment #1
Alpha5 commentedMe 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.
Comment #2
Alpha5 commentedI 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
Comment #3
miglius commentedThe fields can be NULL in the dev version.
Comment #4
Alpha5 commentedSuccess to logon by AD account. Now I study to map group by memberOf to exist role.
Comment #5
JLelie commented@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.
Comment #6
miglius commentedComment #8
ccaajj commentedI 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!