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-PRODUCCION-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()
// 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:
DEBUG - 2012-11-06 17:48:18 --> **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:\"fltest@gmail.com\";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 --> **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:\"fltest@gmail.com\";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 --> **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:"fltest@gmail.com";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 --> **mysql_driver _EXECUTE(...) sql = SELECT `user_data`
FROM (`ci_sessions`)
WHERE `session_id` = 'e0330de0379f5e4e981780c3328b60b4'
LIMIT 1
DEBUG - 2012-11-06 17:48:18 --> **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:"fltest@gmail.com";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:
'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'
