After a new Zabbix server+Frontend installation, I reimport zabbix mysql database to the new installation.

Login is permit but failed with :

Session terminated, re-login

I finally find the error (I follow sessionId...) :

• the commit on login request is not done because of a SQL error

  INSERT INTO auditlog (userid,clock,ip,action,resourcetype,resourceid,resourcename,auditid) VALUES ('1','1487930776','127.0.0.1, 192.168.101.104','3','0','1','','173')] Duplicate entry '173' for key 'PRIMARY'
  

• error is stored to ZBX_MESSAGES but never shown on the screen nor trace into log
• revert is done and a guest session is created

As mentionned in ZBX-10471 (last comment after close), an error on auditlog table prevent the user to login silently.

Solve the issue with :

delete from auditlog;