Hi, I know this has been a topic that has been discussed in detail but I cannot find
my answer.
I am using Apache-Session 1.53.
If make test this archive I get this error message:
---
t/99mysqllock....... (in cleanup) DBD::mysql::st execute failed: MySQL server has
gone away at blib/lib/Apache/Session/Lock/MySQL.pm line 70.
t/99mysqllock.......ok
t/99mysqlstore......ok
t/99mysql........... (in cleanup) DBD::mysql::st execute failed: MySQL server has
gone away at blib/lib/Apache/Session/Lock/MySQL.pm line 70.
t/99mysql...........ok
---
In I look in the Mysql log it looks fine:
----
011001 14:01:27 149 Connect test@localhost as anonymous on test
150 Connect test@localhost as anonymous on test
150 Query SELECT
GET_LOCK('Apache-Session-09876543210987654321098765432109', 3600)
149 Query SELECT
GET_LOCK('Apache-Session-09876543210987654321098765432109', 0)
150 Query SELECT
RELEASE_LOCK('Apache-Session-09876543210987654321098765432109')
149 Query SELECT
GET_LOCK('Apache-Session-09876543210987654321098765432109', 0)
149 Query SELECT
RELEASE_LOCK('Apache-Session-09876543210987654321098765432109')
149 Query SELECT
GET_LOCK('Apache-Session-09876543210987654321098765432109', 3600)
150 Quit
149 Query SELECT
GET_LOCK('Apache-Session-09876543210987654321098765432109', 0)
149 Quit
151 Connect test@localhost as anonymous on sessions
151 Query SELECT
GET_LOCK('Apache-Session-ec8bb133ee472c1ef2b6f09238d88f8c', 3600)
152 Connect test@localhost as anonymous on sessions
152 Query INSERT INTO sessions (id, a_session) VALUES
('ec8bb133ee472c1ef2b6f09238d88f8c','\0\0\0
ec8bb133ee472c1ef2b6f09238d88f8c\0\0\0
_session_id')
152 Query UPDATE sessions SET a_session = '\0\0\0
bar\0\0\0foo\0\0\0
tom
dick
harry\0\0\0baz
ec8bb133ee472c1ef2b6f09238d88f8c\0\0\0
_session_id' WHERE id =
'ec8bb133ee472c1ef2b6f09238d88f8c'
151 Query SELECT
RELEASE_LOCK('Apache-Session-ec8bb133ee472c1ef2b6f09238d88f8c')
151 Quit
152 Quit
153 Connect test@localhost as anonymous on sessions
153 Query SELECT
GET_LOCK('Apache-Session-ec8bb133ee472c1ef2b6f09238d88f8c', 3600)
154 Connect test@localhost as anonymous on sessions
154 Query SELECT a_session FROM sessions WHERE id =
'ec8bb133ee472c1ef2b6f09238d88f8c'
153 Query SELECT
RELEASE_LOCK('Apache-Session-ec8bb133ee472c1ef2b6f09238d88f8c')
153 Quit
154 Quit
155 Connect test@localhost as anonymous on sessions
155 Query SELECT
GET_LOCK('Apache-Session-ec8bb133ee472c1ef2b6f09238d88f8c', 3600)
155 Query SELECT a_session FROM sessions WHERE id =
'ec8bb133ee472c1ef2b6f09238d88f8c'
155 Query DELETE FROM sessions WHERE id =
'ec8bb133ee472c1ef2b6f09238d88f8c'
155 Quit
---------
So it seens talkting to mysql is not the problem.
In the Embperl log I get this when I trie to access a page that just set
$udat{test}='test'
----
[32092]ERR: 24: Line 1: Error in Perl code: Permission denied at
/usr/lib/perl5/site_perl/5.6.0/Apache/Session/Lock/Semaphore.pm line 92.
-----
I have read about the semaphores and that you can delete them (some of them) and
something about different users but this is above my knowlege.
Could anyone explain in more detail which semaphore to delete and how to delete them
and WHERE TO FIND THEM :-) and if it's something to do with user rights, how to change
them to the right ones and for which programs?
I am running emb perl for some time now and it's great, I run it on RH6.0, 6.1, 6.2
and 7.0 (the 7.0 also took me ages to get up and running but somehow I managed)
but the RH 7.1 is really a mistery to me. It allready costs me 4 days of fiddling :-(
and still nothing closer.
Thank you.
Hans de Groot
------
Hans de Groot
Interspective Internet Services B.V.
Tel: +31 (0) 30 6001180
Fax +31 (0) 30 6044204
www: http://www.interspective.nl
email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
