[Tickets #7618] Re: Logout failed with mysql session handler

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7618
------------------------------------------------------------------------------
  Ticket             | 7618
  Updated By         | emeric.jhelil at univ-lemans.fr
  Summary            | Logout failed with mysql session handler
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Assigned
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Horde Developers
------------------------------------------------------------------------------


emeric.jhelil at univ-lemans.fr (2009-01-23 13:53) wrote:

Installation infos : horde-webmail-1.2.1 ; php-5.2.6 ; debian etch
DB : mysql-4.1.11 (tables using default engine MyISAM)

I think I meet the same pb. It works perfectly with file-based  
sessions but it rocks much more for me with Mysql-based sessions.
I'll add that :

1. If I try to delete a message, it fails too with the same message  
"We cannot verify that this request was..." without error in logs :
Jan 23 18:43:37 HORDE [debug] [horde] SQL Query by  
essionHandler_mysql::_read(): query = "SELECT session_data FROM  
horde_sessionhandler WHERE session_id = 'l4itih4bh7aj2qof1l2mr9br37'  
FOR UPDATE" [pid 17265 on line 139 of  
"/var/www/horde/lib/Horde/SessionHandler/mysql.php"]
Jan 23 18:43:37 HORDE [debug] [imp] We cannot verify that this request  
was really sent by you. It could be a malicious request. If you  
intended to perform this action, you can retry it now. [pid 17265 on  
line 176 of "/var/www/horde/lib/Horde/Notification.php"]

2. I can't logout when app=imp (it is shown in the url), but I can  
logout properly when app=horde.

3. It works if I use a distinct database for horde_sessionhandler  
(InnoDB and MyISAM too).
For instance the logs when I delete a message :
Jan 23 18:54:31 HORDE [debug] [horde] SQL Query by  
essionHandler_mysql::_read(): query = "SELECT session_data FROM  
horde_sessionhandler WHERE session_id = 'vej5n9hm0q2lt68tud8q26ajr1'  
FOR UPDATE" [pid 17423 on line 139 of  
"/var/www/horde/lib/Horde/SessionHandler/mysql.php"]
Jan 23 18:54:31 HORDE [debug] [horde] Session data unchanged (id =  
vej5n9hm0q2lt68tud8q26ajr1) [pid 17423 on line 253 of  
"/var/www/horde/lib/Horde/SessionHandler.php"]

4. Using separate databases allows me to use the persistent  
connections with the global database but not with the database  
dedicated for the horde_sessionhandler table (cannot connect anymore  
with error in logs :
Jan 23 12:29:53 HORDE [error] [horde] Error retrieving session data  
(id = fh5kqpdsi4gihmodguds5rdl03): Lock wait timeout exceeded; try  
restarting transaction [pid 15201 on line 144 of  
"/var/www/horde/lib/Horde/SessionHandler/mysql.php"]

I don't know what parameters I missed in horde ? php ? mysql ?

Hope it helps.