Forum GLPI-Project

tlombardini

Member

Registered: 2010-06-17

Posts: 29

Authentication method change failure

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

Atom

Member

Registered: 2009-03-18

Posts: 6

Re: Authentication method change failure

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)

mklimasz

Member

Registered: 2017-12-14

Posts: 82

Re: Authentication method change failure

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...