You are not logged in.


 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2019-06-12 03:31:45

Registered: 2010-06-17
Posts: 20

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/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()

GLPI 9.4.2 ( => /var/www/html/glpi) Installation mode: TARBALL

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


Board footer

Powered by FluxBB