Catch binary puid misconfiguration if incorrectly set by user

Created on 30 June 2017, almost 7 years ago
Updated 20 October 2023, 8 months ago

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 →

📌 Task
Status

Closed: outdated

Version

4.0

Component

User interface

Created by

🇩🇪Germany bahuma20 Germany

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024