[Tickets #12041] Re: Authentication does not work any longer

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12041
------------------------------------------------------------------------------
  Ticket             | 12041
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | Authentication does not work any longer
  Queue              | Horde Base
  Version            | 5.0.4
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2013-02-14 16:25) wrote:

>> With an empty table, this error couldn't happen, because with an
>> empty table there's no duplicate key. Which session handler backend
>> exactly do you use, and did you try a different driver if using SQL
>> (mysqli vs. mysql/pdo if using mysql)?
>
>
> Ok. I emptied the table again, and I am using the mysqli-driver now  
> (before mysql/PDO) Here is the result (in the end nothing changes;  
> log again in DEBUG).
>
> Here sessionhandler before the login:
> MariaDB [horde]> select * from horde_sessionhandler;
> Empty set (0.00 sec)
>
> and after:
> MariaDB [horde]> select session_id from horde_sessionhandler;
> +----------------------------------+
> | session_id                       |
> +----------------------------------+
> | dbobdsjjhiidd6cq54al4g56i5cv6tfr |
> +----------------------------------+
> 1 row in set (0.00 sec)
>
> Perhaps there is some "INSERT" instead of an "UPDATE"-Statement somewhere?

We explicitly check whether the session ID exists before deciding  
whether to make an INSERT or UPDATE query. You have to track this down  
yourself in Horde/SessionHandler/Storage/Sql.php in the write() method.