Tickets :: [#1097] Sessions with MySQL gives "not a valid link resource" on logout

6.0.0-beta1

7/7/25

Summary	Sessions with MySQL gives "not a valid link resource" on logout
Queue	Horde Base
Queue Version	3.0.1
Type	Bug
State	Resolved
Priority	1. Low
Owners	chuck (at) horde (dot) org
Requester	dustin (at) ywlcs (dot) org
Created	01/06/2005 (7487 days ago)
Due
Updated	02/01/2005 (7461 days ago)
Assigned	01/11/2005 (7482 days ago)
Resolved	02/01/2005 (7461 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

02/01/2005 07:02:12 PM	Chuck Hagenbuch	Comment #9 State ⇒ Resolved	Reply to this comment
Found it. Fixed in HEAD, and will be in Horde 3.0.3.

02/01/2005 06:04:52 PM	jigermano (at) uolsinectis (dot) com (dot) ar	Comment #8	Reply to this comment
I'm having the same problem, using php4. The complete message is PHP Warning: mysql_query(): 21 is not a valid MySQL-Link resource in /usr/local/lib/php/Horde/SessionHandler/mysql.php on line 136 Although this bug was first reported on January 6, I first saw it January 31 and I update to HEAD almost daily.

01/11/2005 10:38:41 PM	dustin (at) ywlcs (dot) org	Comment #7	Reply to this comment
This is also causing Apache to segfault on user logouts, just FYI I hate it when PHP causes segfaults :(

01/11/2005 06:22:18 PM	Jan Schneider	Comment #6 Assigned to Chuck Hagenbuch State ⇒ Assigned	Reply to this comment
I don't have a PHP5 install handy, do you still have one, Chuck?

01/07/2005 01:38:32 AM	dustin (at) ywlcs (dot) org	Comment #5	Reply to this comment
One other thing that might contribute -- I'm using PHP5. Are there any variations I can try that might give more info? We're going production on Sunday, so I can play all you want until then :)

01/07/2005 01:34:43 AM	Jan Schneider	Comment #4	Reply to this comment
Exactly my setup. Does anyone else see this?

01/07/2005 01:31:28 AM	dustin (at) ywlcs (dot) org	Comment #3	Reply to this comment
Through an app -- IMP, which is connected to Cyrus IMAP.

01/07/2005 01:04:02 AM	Jan Schneider	Comment #2 State ⇒ Feedback	Reply to this comment
I can't reproduce this. What authentication type do you use?

01/06/2005 10:01:00 PM	dustin (at) ywlcs (dot) org	Comment #1 Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ Sessions with MySQL gives "not a valid link resource" on logout Queue ⇒ Horde Base State ⇒ Unconfirmed	Reply to this comment
We're using the MySQL backend for sessions, and on logout the logout succeeds, but at the bottom of the page we get "not a valid link resource" in lib/Horde/SessionHandler/mysql.php on linke 136. Adding an '@' to the mysql_query call there makes the warning go away, but I don't know the code well enough to discern whether there's actually something wrong here, so I'll leave that to those who know the codebase better.