Alec, after modifications improved. There are currently 10% active sessions expire in 1 hour.
thank you 2012/4/26 Claudio Kuenzler <[email protected]>: > Hi Thiago > > Even if this works with direct connection, the issue with proxied > connections remains. > > @ALEC: Any idea why the session is deleted from the session table and then > reinserted again? > > > On Wed, Apr 25, 2012 at 1:51 PM, Thiago Cavalcante <[email protected]> > wrote: >> >> Claudio, i checked the Roundcube works with the client IP in session >> table, solved adding firewall exception, allowing direct connection to >> server Roundcube. >> >> Alec, I just make the changes suggested. Throughout the day observe >> the application. Thank you for great help. >> >> 2012/4/25 Claudio Kuenzler <[email protected]>: >> > Hello, >> > >> > As written in my mail from yesterday, I took a close look this time. >> > It just happened to me again 10mins ago, while yesterday I kept >> > connected >> > during several hours without a logout or session kill. >> > >> > Difference: Yesterday I was at home when I wrote the message, direct >> > internet access. Now I'm at work behind a proxy. Maybe this fact changes >> > the >> > browser session behaviour. >> > >> > Logs from my session: >> > >> > SQL: >> > [25-Apr-2012 10:41:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:42:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:43:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:43:02 +0200]: query(1): UPDATE session SET >> > changed='2012-04-25 10:43:02' WHERE >> > sess_id='fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:44:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:45:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:45:13 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:46:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:47:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:48:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:49:02 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:49:59 +0200]: query(1): DELETE FROM session WHERE >> > sess_id = >> > 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:49:59 +0200]: query(1): INSERT INTO session (sess_id, >> > vars, >> > ip, created, changed) VALUES ('fq0m0vp31sqip858te5mnu1e67', >> > 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7', 'xxx.xxx.xxx.xxx', >> > '2012-04-25 >> > 10:49:59', '2012-04-25 10:49:59'); >> > [25-Apr-2012 10:50:01 +0200]: query(1): SELECT vars, ip, changed FROM >> > session WHERE sess_id = 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:50:01 +0200]: query(1): UPDATE session SET >> > vars='bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7dGFza3xzOjU6ImxvZ2luIjs=', >> > changed='2012-04-25 10:50:01' WHERE >> > sess_id='fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:50:02 +0200]: query(1): DELETE FROM session WHERE >> > sess_id = >> > 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:50:02 +0200]: query(1): INSERT INTO session (sess_id, >> > vars, >> > ip, created, changed) VALUES ('fq0m0vp31sqip858te5mnu1e67', >> > 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7', 'xxx.xxx.xxx.xxx', >> > '2012-04-25 >> > 10:50:02', '2012-04-25 10:50:02'); >> > [25-Apr-2012 10:50:02 +0200]: query(1): DELETE FROM session WHERE >> > sess_id = >> > 'fq0m0vp31sqip858te5mnu1e67'; >> > [25-Apr-2012 10:50:02 +0200]: query(1): INSERT INTO session (sess_id, >> > vars, >> > ip, created, changed) VALUES ('fq0m0vp31sqip858te5mnu1e67', >> > 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7', 'xxx.xxx.xxx.xxx', >> > '2012-04-25 >> > 10:50:02', '2012-04-25 10:50:02'); >> > >> > session log: >> > [25-Apr-2012 10:50:01 +0200]: Aborted session >> > fq0m0vp31sqip858te5mnu1e67; no >> > valid session data found >> > >> > no entries in errors log. >> > >> > http access log: >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:41:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343261913 >> > HTTP/1.1" 200 77 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:42:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343321928 >> > HTTP/1.1" 200 77 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:43:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343382109 >> > HTTP/1.1" 200 77 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:44:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343441933 >> > HTTP/1.1" 200 77 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:45:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343501932 >> > HTTP/1.1" 200 77 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:46:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343561932 >> > HTTP/1.1" 200 77 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:47:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343621959 >> > HTTP/1.1" 200 171 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:48:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343681963 >> > HTTP/1.1" 200 171 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:49:02 +0200] "GET >> > >> > /?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_remote=1&_unlock=0&_=1335343741962 >> > HTTP/1.1" 200 171 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:50:01 +0200] "GET /?_task=mail >> > HTTP/1.1" >> > 200 8110 >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:50:01 +0200] "GET >> > /skins/default/common.css?s=1330947632 HTTP/1.1" 304 - >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:50:01 +0200] "GET >> > /program/js/common.js?s=1331483103 HTTP/1.1" 304 - >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:50:01 +0200] "GET >> > /plugins/persistent_login/persistent_login.css?s=1321094906 HTTP/1.1" >> > 304 - >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:50:01 +0200] "GET >> > /plugins/persistent_login/persistent_login.js?s=1321129484 HTTP/1.1" 304 >> > - >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:50:01 +0200] "GET >> > /program/js/jquery.min.js?s=1315898178 HTTP/1.1" 304 - >> > xxx.xxx.xxx.xxx - - [25/Apr/2012:10:50:01 +0200] "GET >> > /program/js/app.js?s=1331483100 HTTP/1.1" 304 - >> > >> > >> > Again, as mentioned yesterday, the session was DELETEd and then >> > immediately >> > reinserted in the session table. But why? >> > >> > Thiago, are you/your users also using a proxy by any chance? >> > >> > >> > >> > On Wed, Apr 25, 2012 at 8:50 AM, A.L.E.C <[email protected]> wrote: >> >> >> >> On 24.04.2012 19:42, Thiago Cavalcante wrote: >> >> > Apache log, only this: >> >> > [Tue Apr 24 13:49:52 2012] [error] [client 192.168.21.42] File does >> >> > not exist: >> >> > >> >> > /var/www/correio/?_task=mail&_action=get&_uid=5997&_mbox=INBOX&_part=2 >> >> > [Tue Apr 24 13:49:56 2012] [error] [client 192.168.21.42] File does >> >> > not exist: >> >> > >> >> > /var/www/correio/?_task=mail&_action=get&_uid=5997&_mbox=INBOX&_part=2 >> >> >> >> Strange. >> >> >> >> > Has no entry in mysql error log on the database Roundcube. >> >> > A friend of another institution reported a similar problem in Apache, >> >> > I am studying Lighttpd or Nginx, you think may be related?! >> >> >> >> Another idea, edit program/js/editor.js and add >> >> ie7_compat: false >> >> in TinyMCE configuration (c.a. line 30 of this file). >> >> >> >> -- >> >> Aleksander 'A.L.E.C' Machniak >> >> LAN Management System Developer [http://lms.org.pl] >> >> Roundcube Webmail Developer [http://roundcube.net] >> >> --------------------------------------------------- >> >> PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec.pl >> >> _______________________________________________ >> >> Roundcube Users mailing list >> >> [email protected] >> >> http://lists.roundcube.net/mailman/listinfo/users >> > >> > >> > >> > _______________________________________________ >> > Roundcube Users mailing list >> > [email protected] >> > http://lists.roundcube.net/mailman/listinfo/users >> _______________________________________________ >> Roundcube Users mailing list >> [email protected] >> http://lists.roundcube.net/mailman/listinfo/users > > > > _______________________________________________ > Roundcube Users mailing list > [email protected] > http://lists.roundcube.net/mailman/listinfo/users _______________________________________________ Roundcube Users mailing list [email protected] http://lists.roundcube.net/mailman/listinfo/users
