Bug#577828: marked as done (Cannot login, getting "ERROR: Session terminated, please re-login!")

Wed, 01 Sep 2010 14:57:23 -0700 

Your message dated Wed, 01 Sep 2010 23:48:59 +0200
with message-id <[email protected]>
and subject line Re: Bug#577828: SOLVED
has caused the Debian Bug report #577828,
regarding Cannot login, getting "ERROR: Session terminated, please re-login!"
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
577828: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=577828
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message --- 
Package: zabbix-frontend-php
Version: 1:1.8.1-1~bpo50+1
Severity: normal
Tags:

I have a current lenny installation with these packages from backports:

$ dpkg -l | grep bpo50 | awk '{print $2 " " $3}'
libjs-prototype 1.6.1-1~bpo50+1
libjs-scriptaculous 1.8.3-1~bpo50+1
libpq5 8.4.2-1~bpo50+1
postgresql 8.4.3-1~bpo50+1
postgresql-8.4 8.4.2-1~bpo50+1
postgresql-client-8.4 8.4.2-1~bpo50+1
postgresql-client-common 105~bpo50+1
postgresql-common 105~bpo50+1
zabbix-frontend-php 1:1.8.1-1~bpo50+1
zabbix-server-pgsql 1:1.8.1-1~bpo50+1

The database is correctly set up as far as I can tell. When I browse to
the login page (http://server/zabbix/index.php) and try to login using
the default username and password, it returns to the login page with the
error message: "ERROR: Session terminated, please re-login!"

I can verify that I'm logging in using the correct username and password
in the database:

 SELECT * FROM auditlog;

I have enabled logging in PostgreSQL and this is the queries that the
frontend passes to it:


2010-04-14 23:28:12 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
2010-04-14 23:28:12 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT u.*,s.*  FROM sessions s,users u WHERE
s.sessionid='f955213d7ecf5869c68181d3661f0a51' AND s.status=0 AND
s.userid=u.userid AND ((s.lastaccess+u.autologout>1271280492) OR
(u.autologout=0)) AND ((u.userid  BETWEEN 000000000000000 AND
099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT u.*  FROM users u  WHERE u.alias='guest' AND
((u.userid  BETWEEN 000000000000000 AND 099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: INSERT INTO sessions (sessionid,userid,lastaccess,status)
VALUES ('a0495103966aa5ea35fe02534e860d66',2,1271280493,0)
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT MAX(g.gui_access) as gui_access  FROM usrgrp g,
users_groups ug  WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT g.usrgrpid  FROM usrgrp g, users_groups ug  WHERE
ug.userid = 2 AND g.usrgrpid = ug.usrgrpid  AND g.users_status = 1 LIMIT
1 OFFSET 0
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: UPDATE sessions SET status=1 WHERE
sessionid='a0495103966aa5ea35fe02534e860d66'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT g.usrgrpid  FROM usrgrp g, users_groups ug  WHERE
ug.userid = 2 AND g.usrgrpid = ug.usrgrpid  AND g.debug_mode = 1 LIMIT 1
OFFSET 0
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT DISTINCT n.nodeid,n.name,n.masterid  FROM nodes n,
groups hg,rights r, users_groups g  WHERE r.id=hg.groupid  AND
r.groupid=g.usrgrpid  AND g.userid=2 AND
n.nodeid=(hg.groupid/100000000000000)
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT n.nodeid as nodeid,n.name as
node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid
FROM groups hg  LEFT JOIN rights r ON r.id=hg.groupid  LEFT JOIN
users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n
ON (hg.groupid/100000000000000)=n.nodeid  WHERE ((hg.groupid  BETWEEN
000000000000000 AND 099999999999999)) GROUP BY n.nodeid, n.name,
hg.groupid, hg.name, g.userid, g.userid  ORDER BY node_name, hg.name,
permission
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT * FROM config WHERE ((configid  BETWEEN
000000000000000 AND 099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT n.nodeid as nodeid,n.name as
node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid
FROM groups hg  LEFT JOIN rights r ON r.id=hg.groupid  LEFT JOIN
users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n
ON (hg.groupid/100000000000000)=n.nodeid  WHERE ((hg.groupid  BETWEEN
000000000000000 AND 099999999999999)) GROUP BY n.nodeid, n.name,
hg.groupid, hg.name, g.userid, g.userid  ORDER BY node_name, hg.name,
permission
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT value_id FROM profiles WHERE userid=2 AND
idx='web.nodes.selected'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT *  FROM profiles  WHERE userid=2 AND ((profileid
BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC,
profileid ASC
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT masterid FROM nodes WHERE nodeid=0
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: DELETE FROM profiles WHERE userid=2 AND idx='web.nodes.selected'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT * FROM config WHERE ((configid  BETWEEN
000000000000000 AND 099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT u.userid,u.attempt_failed, u.attempt_clock,
u.attempt_ip  FROM users u  WHERE u.alias='Admin'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: UPDATE users SET attempt_clock=1271280493 WHERE alias='Admin'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT MAX(g.gui_access) as gui_access  FROM usrgrp g,
users_groups ug  WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT
u.userid,u.alias,u.name,u.surname,u.url,u.refresh,u.passwd  FROM users
u, users_groups ug, usrgrp g  WHERE u.alias='Admin' AND
u.passwd='5fce1b3e34b520afeffb37ce08c7cd66' AND ((u.userid  BETWEEN
000000000000000 AND 099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT MAX(g.gui_access) as gui_access  FROM usrgrp g,
users_groups ug  WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT g.usrgrpid  FROM usrgrp g, users_groups ug  WHERE
ug.userid = 1 AND g.usrgrpid = ug.usrgrpid  AND g.users_status = 1 LIMIT
1 OFFSET 0
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: INSERT INTO sessions (sessionid,userid,lastaccess,status)
VALUES ('a65905591a6bc25aa6dbf7079c33ea04',1,1271280493,0)
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT nextid FROM ids WHERE nodeid=0 AND
table_name='auditlog' AND field_name='auditid'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: UPDATE ids SET nextid=nextid+1 WHERE nodeid=0 AND
table_name='auditlog' AND field_name='auditid'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: SELECT nextid FROM ids WHERE nodeid=0 AND
table_name='auditlog' AND field_name='auditid'
2010-04-14 23:28:13 CEST s:4bc6336c.3443 u:zabbix d:zabbix LOG:
statement: INSERT INTO auditlog
(auditid,userid,clock,action,resourcetype,details,ip)  VALUES
(36,2,1271280493,3,0,'Correct login [Admin]','111.111.111.111')
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT u.*,s.*  FROM sessions s,users u WHERE
s.sessionid='a0495103966aa5ea35fe02534e860d66' AND s.status=0 AND
s.userid=u.userid AND ((s.lastaccess+u.autologout>1271280493) OR
(u.autologout=0)) AND ((u.userid  BETWEEN 000000000000000 AND
099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT u.*  FROM users u  WHERE u.alias='guest' AND
((u.userid  BETWEEN 000000000000000 AND 099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: INSERT INTO sessions (sessionid,userid,lastaccess,status)
VALUES ('a5a8be14e95e553b4546f12309f43326',2,1271280493,0)
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT MAX(g.gui_access) as gui_access  FROM usrgrp g,
users_groups ug  WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT g.usrgrpid  FROM usrgrp g, users_groups ug  WHERE
ug.userid = 2 AND g.usrgrpid = ug.usrgrpid  AND g.users_status = 1 LIMIT
1 OFFSET 0
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: UPDATE sessions SET status=1 WHERE
sessionid='a5a8be14e95e553b4546f12309f43326'
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT g.usrgrpid  FROM usrgrp g, users_groups ug  WHERE
ug.userid = 2 AND g.usrgrpid = ug.usrgrpid  AND g.debug_mode = 1 LIMIT 1
OFFSET 0
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT DISTINCT n.nodeid,n.name,n.masterid  FROM nodes n,
groups hg,rights r, users_groups g  WHERE r.id=hg.groupid  AND
r.groupid=g.usrgrpid  AND g.userid=2 AND
n.nodeid=(hg.groupid/100000000000000)
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT n.nodeid as nodeid,n.name as
node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid
FROM groups hg  LEFT JOIN rights r ON r.id=hg.groupid  LEFT JOIN
users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n
ON (hg.groupid/100000000000000)=n.nodeid  WHERE ((hg.groupid  BETWEEN
000000000000000 AND 099999999999999)) GROUP BY n.nodeid, n.name,
hg.groupid, hg.name, g.userid, g.userid  ORDER BY node_name, hg.name,
permission
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT * FROM config WHERE ((configid  BETWEEN
000000000000000 AND 099999999999999))
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT n.nodeid as nodeid,n.name as
node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid
FROM groups hg  LEFT JOIN rights r ON r.id=hg.groupid  LEFT JOIN
users_groups g ON r.groupid=g.usrgrpid AND g.userid=2 LEFT JOIN nodes n
ON (hg.groupid/100000000000000)=n.nodeid  WHERE ((hg.groupid  BETWEEN
000000000000000 AND 099999999999999)) GROUP BY n.nodeid, n.name,
hg.groupid, hg.name, g.userid, g.userid  ORDER BY node_name, hg.name,
permission
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT value_id FROM profiles WHERE userid=2 AND
idx='web.nodes.selected'
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT *  FROM profiles  WHERE userid=2 AND ((profileid
BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC,
profileid ASC
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT masterid FROM nodes WHERE nodeid=0
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: DELETE FROM profiles WHERE userid=2 AND idx='web.nodes.selected'
2010-04-14 23:28:13 CEST s:4bc6336d.3444 u:zabbix d:zabbix LOG:
statement: SELECT * FROM config WHERE ((configid  BETWEEN
000000000000000 AND 099999999999999))


What could be wrong here? I didn't manage to enable logging as described
in bug #519708.

Regards,
Henrik

-- 
Henrik Holmboe, Stockholm, Sweden
<http://henrik.holmboe.se/contact/>

--- End Message ---
--- Begin Message --- 
I believe I can consider your bug report fixed by yourself. :)
Let us know if the problem persists.

Regards
 Christoph

Am 15.04.2010 00:52, schrieb Henrik Holmboe:
> I have been troubleshooting this for some time now, before even sending
> in the bugreport. And after the fact I started thinking "out of the box"
> and tried another webbrowser and it worked!
> 
> It is probably one of the addons I have in Firefox on my main computer.
> Will try to narrow it down further in the morning.
> 
> Cheers!
>

--- End Message ---

Reply via email to