Login

11-06-2012, 10:01 AM

[eluser]davidinchi[/eluser]
Hi,

I'm working with codeigniter 2.1.3 and flexi-auth with this configuration:
Linux
PHP: 5.2.11
MySQL : 5.1.38-log

As you can see in http://www.flyinglow.es/flyinglow_es-PRO...-CI_2.1.3/
if a user logs in, just with a page refresh (F5) the user is log out.

It only happens with Chrome!!

Debuging the code, I see that in Sessions.sess_write() and Update is executed over ci_sessions table and it works fine, because I execute a Select and shows correct data in ci_sessions table.

But, when log in process finish and page is showed, data in DataBase is incorrect!!

Session.php sess_write()

Code:
// Run the update query

                $this->CI->db->where('session_id', $this->userdata['session_id']);

  $this->CI->db->update($this->sess_table_name, array('last_activity' => $this->userdata['last_activity'], 'user_data' => $custom_userdata));

                log_message('debug', '**Session sess_write() $custom_data : '.serialize($custom_userdata).' table '.$this->sess_table_name);

                //select for debug

  $sql_select = array('user_data');

  $query = $this->CI->db->select($sql_select)

   ->where('session_id', $this->userdata['session_id'])

   ->limit(1)

   ->get($this->sess_table_name);

                $result = $query->row();

                if ($query->num_rows() !== 1)

                {

       return FALSE;

                }

  $db_user_data = $result->{'user_data'};

                log_message('debug', '**Session sess_write() SELECT $db_user_data : '.$db_user_data);

log file:

Code:

DEBUG - 2012-11-06 17:48:18 --&gt; **mysql_driver _UPDATE(...) sql = UPDATE `ci_sessions` SET `last_activity` = 1352220251, `user_data` = 'a:4:{s:14:\"prevent_update\";i:0;s:9:\"user_data\";s:0:\"\";s:10:\"flexi_auth\";a:7:{s:15:\"user_identifier\";s:20:\"[email protected]\";s:7:\"user_id\";s:1:\"7\";s:5:\"admin\";b:0;s:5:\"group\";a:1:{i:1;s:6:\"Public\";}s:10:\"privileges\";a:0:{}s:22:\"logged_in_via_password\";b:1;s:19:\"login_session_token\";s:40:\"67206e1d4a25978017afd36cf1cc935768ab3d7e\";}s:17:\"flash:old:message\";s:61:\"<p class=\"status_msg\">Has iniciado sesiÃ³n correctamente.</p>\";}' WHERE `session_id` =  'e0330de0379f5e4e981780c3328b60b4'

DEBUG - 2012-11-06 17:48:18 --&gt; **mysql_driver _EXECUTE(...) sql = UPDATE `ci_sessions` SET `last_activity` = 1352220251, `user_data` = 'a:4:{s:14:\"prevent_update\";i:0;s:9:\"user_data\";s:0:\"\";s:10:\"flexi_auth\";a:7:{s:15:\"user_identifier\";s:20:\"[email protected]\";s:7:\"user_id\";s:1:\"7\";s:5:\"admin\";b:0;s:5:\"group\";a:1:{i:1;s:6:\"Public\";}s:10:\"privileges\";a:0:{}s:22:\"logged_in_via_password\";b:1;s:19:\"login_session_token\";s:40:\"67206e1d4a25978017afd36cf1cc935768ab3d7e\";}s:17:\"flash:old:message\";s:61:\"<p class=\"status_msg\">Has iniciado sesiÃ³n correctamente.</p>\";}' WHERE `session_id` =  'e0330de0379f5e4e981780c3328b60b4'

DEBUG - 2012-11-06 17:48:18 --&gt; **Session sess_write() $custom_data : s:430:"a:4:{s:14:"prevent_update";i:0;s:9:"user_data";s:0:"";s:10:"flexi_auth";a:7:{s:15:"user_identifier";s:20:"[email protected]";s:7:"user_id";s:1:"7";s:5:"admin";b:0;s:5:"group";a:1:{i:1;s:6:"Public";}s:10:"privileges";a:0:{}s:22:"logged_in_via_password";b:1;s:19:"login_session_token";s:40:"67206e1d4a25978017afd36cf1cc935768ab3d7e";}s:17:"flash:old:message";s:61:"<p class="status_msg">Has iniciado sesiÃ³n correctamente.</p>";}"; table ci_sessions

DEBUG - 2012-11-06 17:48:18 --&gt; **mysql_driver _EXECUTE(...) sql = SELECT `user_data`

FROM (`ci_sessions`)

WHERE `session_id` =  'e0330de0379f5e4e981780c3328b60b4'

LIMIT 1

DEBUG - 2012-11-06 17:48:18 --&gt; **Session sess_write() SELECT $db_user_data : a:4:{s:14:"prevent_update";i:0;s:9:"user_data";s:0:"";s:10:"flexi_auth";a:7:{s:15:"user_identifier";s:20:"[email protected]";s:7:"user_id";s:1:"7";s:5:"admin";b:0;s:5:"group";a:1:{i:1;s:6:"Public";}s:10:"privileges";a:0:{}s:22:"logged_in_via_password";b:1;s:19:"login_session_token";s:40:"67206e1d4a25978017afd36cf1cc935768ab3d7e";}s:17:"flash:old:message";s:61:"<p class="status_msg">Has iniciado sesiÃ³n correctamente.</p>";}

Data in DataBase, ci_sessions table:

Code:
'e0330de0379f5e4e981780c3328b60b4', '87.223.230.193', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4', '1352220251', 'a:2:{s:14:"prevent_update";i:0;s:9:"user_data";s:0:"";}', '0'