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 <tlcavalcante@gmail.com> 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 <ck@claudiokuenzler.com>:
> 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 <alec@alec.pl> 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
>> users@lists.roundcube.net
>> http://lists.roundcube.net/mailman/listinfo/users
>
>
>
> _______________________________________________
> Roundcube Users mailing list
> users@lists.roundcube.net
> http://lists.roundcube.net/mailman/listinfo/users
_______________________________________________
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users