Hi,
in my scenario, I use ldaps to authnticate users.
If a user login using not lowercase username, for example Name.Surname@mydomain.net, he is able to login, but, if he tries to save user preferences, he obtains an error.
In the syslog I see:
SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint “idx_icingaweb_user_preference”
DETAIL: Key (lower(username::text), lower(section::text), lower(name::text))=(name.surname@mydomain.net, icingaweb, language) already exists., query was: INSERT INTO icingaweb_user_preference (username, “section”, “name”, value, ctime, mtime) VALUES (?, ?, ?, ?, NOW(), NOW()) ← PDOException in /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php:228 with message: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint “idx_icingaweb_user_preference”
Infact, I see the entry in the table: icingaweb_user_preference
with username= name.surname@mydomain.net
Instead, if the user login using lowercase username name.surname@mydomain.net, everything works well, and he is able to save user preferences and so on.
Probably, is it a bug?
Thanks
Mario
- Icinga DB Web version (1.1.0): 1.1.0
- Icinga Web 2 version (2.11.4):2.11.4
- Web browser:
- Icinga 2 version (
icinga2 --version):r2.14.0-1 - Icinga DB version (
icingadb --version): v1.1.1 - PHP version used (
php --version): PHP 7.4.3-4ubuntu2.19 - Server operating system and version:
Platform: Ubuntu
Platform version: 20.04.6 LTS (Focal Fossa)