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

* Your Email Address
* Spam protection	Enter the letters below: .___.__.. ..__ .__ [__ [__]\|_/ [__)[__) \| \| \|\| \\| \|
Comment	> 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.
Attachment
Watch this ticket

Saved Queries