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
