I can't get authentication working.
I configured ldap_user to create drupal users when logging in.
When i try to login using a wrong password it says password incorrect.
When i try to login unsing the correct password i get the following error message:
Drupal\Core\Entity\EntityStorageException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xB5)\x95A\x8D\x02...' for column 'ldap_user_puid' at row 1: INSERT INTO {users_field_data} (uid, langcode, preferred_langcode, preferred_admin_langcode, name, pass, mail, timezone, status, created, changed, access, login, init, default_langcode, ldap_user_puid_sid, ldap_user_puid, ldap_user_puid_property, ldap_user_current_dn, ldap_user_last_checked, ldap_user_ldap_exclude) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20); Array ( [:db_insert_placeholder_0] => 99 [:db_insert_placeholder_1] => de [:db_insert_placeholder_2] => de [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => bachhubermax [:db_insert_placeholder_5] => $S$EpB8VV2rOjHyuj.ctX2HVo4AheOQKjT4HV8y/i1v0.pQ0U1xR0ju [:db_insert_placeholder_6] => user@example.com [:db_insert_placeholder_7] => Europe/Berlin [:db_insert_placeholder_8] => 1 [:db_insert_placeholder_9] => 1498828185 [:db_insert_placeholder_10] => 1498828185 [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => user@example.com [:db_insert_placeholder_14] => 1 [:db_insert_placeholder_15] => ad [:db_insert_placeholder_16] => X51�)�A�!�>,+B [:db_insert_placeholder_17] => objectGUID [:db_insert_placeholder_18] => CN=Maximilian Bachhuber,OU=showroomuser,DC=showroom,DC=local [:db_insert_placeholder_19] => 1498828186 [:db_insert_placeholder_20] => ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 777 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Seems like the guid mapping (which was automatically set by ldap_authentication module) is binary and cannot be saved to the database.
I can't toggle on conversion from binary in the ldap_user configuration because it is locked by ldap_authentication module.
The active directory field i am using for puid, configured in ldap_server, is "objectGUID".
A similar issue existed in Drupal 7 version of this module: https://www.drupal.org/node/1870630 →
Closed: outdated
4.0
User interface
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.