You are not logged in.
Pages: 1
Hi, I have configured two different LDAP authentication servers (A and B). Both works ok. I could do a succesful login using A or B user accounts.
The problem is when i try to change the authentication method for a user. It gives me a red failure popup.
I watched GLPI sql-errors.log and saw this:
[2019-06-11 22:26:27] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 177
*** MySQL query error:
SQL: UPDATE `glpi_users` SET `authtype` = '3', `auths_id` = '4', `password` = '', `is_deleted_ldap` = '0' WHERE `id` IN ('468')
Error: Duplicate entry 'tlombardini-3-4' for key 'unicityloginauth'
Backtrace :
inc/dbmysql.class.php:937
inc/user.class.php:3941 DBmysql->update()
inc/user.class.php:2856 User::changeAuthMethod()
inc/massiveaction.class.php:991 User::processMassiveActionsForOneItemtype()
inc/massiveaction.class.php:970 MassiveAction->processForSeveralItemtypes()
front/massiveaction.php:59 MassiveAction->process()
{"user":"32@glpi"}
GLPI 9.4.2 ( => /var/www/html/glpi) Installation mode: TARBALL
Server:
Operating system: Linux glpi 3.16.0-7-686-pae #1 SMP Debian 3.16.59-1 (2018-10-03) i686
PHP 5.6.39-0+deb8u1 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu,
bcmath, bz2, calendar, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, json,
ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, openssl, pcre, pdo_mysql, posix, readline, session, shmop, soap, sockets,
standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, zlib)
Setup: max_execution_time="300" memory_limit="1024M" post_max_size="80M" safe_mode="" session.save_handler="files" upload_max_filesize="60M"
Software: Apache () Mozilla/5.0 (Windows NT 10.0; WOW64; rv:67.0) Gecko/20100101 Firefox/67.0
Server Software: MySQL Community Server (GPL) Server Version: 5.6.42
Offline
Same was happening to me when trying to change to internal GLPI authentication. I finally traced it back to two users having the same username. I don't know how this happened but this was it. Once I modified one of the repeated usernames I could change authentication. etc.
This was also giving me a "User not authorized to connect in GLPI" error.
Last edited by Atom (2020-06-09 09:28:56)
Offline
Hi
Exactly, please just make sure You're not having another account already defined with exactly the same username - as GLPI would then complain about violating unicity (uniqueness) criteria...
Offline
Pages: 1