46 global $dolibarr_main_db_type, $dolibarr_main_db_host;
47 global $dolibarr_main_db_user, $dolibarr_main_db_pass, $dolibarr_main_db_name, $dolibarr_main_db_port;
49 global $dolibarr_session_db_type, $dolibarr_session_db_host;
50 global $dolibarr_session_db_user, $dolibarr_session_db_pass, $dolibarr_session_db_name, $dolibarr_session_db_port;
52 if (empty($dolibarr_session_db_type)) {
53 $dolibarr_session_db_type = $dolibarr_main_db_type;
55 if (empty($dolibarr_session_db_host)) {
56 $dolibarr_session_db_host = $dolibarr_main_db_host;
58 if (empty($dolibarr_session_db_user)) {
59 $dolibarr_session_db_user = $dolibarr_main_db_user;
61 if (empty($dolibarr_session_db_pass)) {
62 $dolibarr_session_db_pass = $dolibarr_main_db_pass;
64 if (empty($dolibarr_session_db_name)) {
65 $dolibarr_session_db_name = $dolibarr_main_db_name;
67 if (empty($dolibarr_session_db_port)) {
68 $dolibarr_session_db_port = $dolibarr_main_db_port;
74 $dbsession =
getDoliDBInstance($dolibarr_session_db_type, $dolibarr_session_db_host, $dolibarr_session_db_user, $dolibarr_session_db_pass, $dolibarr_session_db_name, (
int) $dolibarr_session_db_port,
true);
88 global $sessionlastvalueread;
89 global $sessionidfound;
91 $sql =
"SELECT session_id, session_variable, last_accessed FROM ".MAIN_DB_PREFIX.
"session";
92 $sql .=
" WHERE session_id = '".$dbsession->escape($sess_id).
"'";
95 $resql = $dbsession->query($sql);
96 $num_rows = $dbsession->num_rows($resql);
99 $sessionlastvalueread =
'';
100 $sessionidfound =
'';
104 $obj = $dbsession->fetch_object($resql);
111 $max_lifetime = min(3600 * 24, (
int) ini_get(
'session.gc_maxlifetime'));
112 if ($max_lifetime > 0 && $dbsession->jdate($obj->last_accessed) < (
dol_now() - $max_lifetime)) {
115 $delete_query =
"DELETE FROM ".MAIN_DB_PREFIX.
"session";
116 $delete_query .=
" WHERE session_id = '".$dbsession->escape($sess_id).
"'";
117 $dbsession->query($delete_query);
119 $sessionlastvalueread =
'';
120 $sessionidfound =
'';
125 $sessionlastvalueread = $obj->session_variable;
126 $sessionidfound = $obj->session_id;
127 return $obj->session_variable;
140 global $dbsession, $user;
141 global $sessionlastvalueread;
142 global $sessionidfound;
149 if ($sessionlastvalueread != $val) {
152 if (empty($sessionidfound)) {
154 $insert_query =
"INSERT INTO ".MAIN_DB_PREFIX.
"session";
155 $insert_query .=
"(session_id, session_variable, date_creation, last_accessed, fk_user, remote_ip, user_agent)";
156 $insert_query .=
" VALUES ('".$dbsession->escape($sess_id).
"', '".$dbsession->escape($val).
"', '".$dbsession->idate($time_stamp).
"', '".$dbsession->idate($time_stamp).
"', 0, '".$dbsession->escape(
getUserRemoteIP()).
"', '".$dbsession->escape(substr($_SERVER[
'HTTP_USER_AGENT'] ??
'', 0, 255)).
"')";
158 $result = $dbsession->query($insert_query);
160 dol_print_error($dbsession);
164 if ($sessionidfound != $sess_id) {
166 dol_print_error($dbsession,
'Oops sess_id received in dolSessionWrite differs from the cache value $sessionidfound. How can this happen ?');
188 $update_query =
"UPDATE ".MAIN_DB_PREFIX.
"session";
189 $update_query .=
" SET session_variable = '".$dbsession->escape($val).
"',";
190 $update_query .=
" last_accessed = '".$dbsession->idate($time_stamp).
"',";
191 $update_query .=
" fk_user = ".(int) (!empty($user->id) ? $user->id : 0).
",";
192 $update_query .=
" remote_ip = '".$dbsession->escape(
getUserRemoteIP()).
"',";
193 $update_query .=
" user_agent = '".$dbsession->escape($_SERVER[
'HTTP_USER_AGENT'] ??
'').
"'";
194 $update_query .=
" WHERE session_id = '".$dbsession->escape($sess_id).
"'";
196 $result = $dbsession->query($update_query);
198 dol_print_error($dbsession);
210 if ((
int) ini_get(
'session.gc_probability') == 0) {
211 $gc_divisor = max(1, (
int) ini_get(
'session.gc_divisor'));
212 if (mt_rand(1, $gc_divisor) == 1) {
213 $max_lifetime = min(3600 * 24, max(
getDolGlobalInt(
'MAIN_SESSION_TIMEOUT'), (
int) ini_get(
'session.gc_maxlifetime')));
250 $delete_query =
"DELETE FROM ".MAIN_DB_PREFIX.
"session";
251 $delete_query .=
" WHERE session_id = '".$dbsession->escape($sess_id).
"'";
252 $dbsession->query($delete_query);
270 $delete_query =
"DELETE FROM ".MAIN_DB_PREFIX.
"session";
271 $delete_query .=
" WHERE last_accessed < '".$dbsession->idate($time_stamp - $max_lifetime).
"'";
273 $resql = $dbsession->query($delete_query);
277 dol_syslog(
"dolSessionGC failed to purge expired sessions: ".$dbsession->lasterror(), LOG_WARNING);
300 $fk_user = (int) $fk_user;
301 $keepcount = (int) $keepcount;
302 if ($fk_user <= 0 || $keepcount <= 0) {
307 $sql =
"SELECT session_id FROM ".MAIN_DB_PREFIX.
"session";
308 $sql .=
" WHERE fk_user = ".((int) $fk_user);
309 $sql .=
" AND session_id <> '".$dbsession->escape($currentsessionid).
"'";
310 $sql .=
" ORDER BY last_accessed DESC, session_id DESC";
312 $resql = $dbsession->query($sql);
314 dol_syslog(
"dolSessionsLimitForUser failed to list sessions: ".$dbsession->lasterror(), LOG_WARNING);
318 $idstodelete = array();
320 while ($obj = $dbsession->fetch_object($resql)) {
322 if ($rank >= $keepcount) {
323 $idstodelete[] = $obj->session_id;
327 if (empty($idstodelete)) {
331 $sqldel =
"DELETE FROM ".MAIN_DB_PREFIX.
"session WHERE session_id IN (";
333 foreach ($idstodelete as $idtodelete) {
334 $sqldel .= ($i > 0 ?
", " :
"").
"'".$dbsession->escape($idtodelete).
"'";
339 $resqldel = $dbsession->query($sqldel);
341 dol_syslog(
"dolSessionsLimitForUser failed to purge sessions: ".$dbsession->lasterror(), LOG_WARNING);
345 dol_syslog(
"dolSessionsLimitForUser evicted ".count($idstodelete).
" session(s) for fk_user=".$fk_user.
" to enforce a limit of ".$keepcount, LOG_NOTICE);
347 return count($idstodelete);
351session_set_save_handler(
"dolSessionOpen",
"dolSessionClose",
"dolSessionRead",
"dolSessionWrite",
"dolSessionDestroy",
"dolSessionGC");
362 $arrayofsessions = [];
363 $sql =
"SELECT s.session_id, s.session_variable, s.fk_user, s.date_creation, s.last_accessed, s.remote_ip, s.user_agent";
365 $sql .=
" FROM ".MAIN_DB_PREFIX.
"session as s";
366 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u ON u.rowid=s.fk_user";
367 $sql .=
" LIMIT 500";
368 $resql = $dbsession->query($sql);
369 while ($resql && $obj = $dbsession->fetch_object($resql)) {
370 $arrayofsessions[$obj->session_id] = [
371 "login" => (string) $obj->login,
372 "age" =>
dol_now() - (int) $dbsession->jdate($obj->date_creation),
373 "creation" => $dbsession->idate($obj->date_creation),
374 "modification" => $dbsession->idate($obj->last_accessed),
375 "remote_ip" => $obj->remote_ip,
376 "user_agent" => $obj->user_agent,
381 return $arrayofsessions;
dol_now($mode='gmt')
Return date for now.
getDoliDBInstance($type, $host, $user, $pass, $name, $port, $forcenew=false)
Return a DoliDB instance (database handler).
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getUserRemoteIP($trusted=0)
Return the real IP of remote user.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dolSessionOpen($save_path, $session_name)
The session open handler called by PHP whenever a session is initialized.
dolSessionWrite($sess_id, $val)
This function is called when a session is initialized with a session_start( ) call,...
dolSessionDestroy($sess_id)
This is called whenever the session_destroy() function call is made.
dolSessionsLimitForUser($fk_user, $keepcount, $currentsessionid)
Enforce a maximum number of concurrent database sessions for a given user.
dolListSessions()
List sessions in db.
dolSessionClose()
This function is executed on shutdown of the session.
dolSessionGC($max_lifetime)
This function is called on a session's start up with the probability specified in session....
dolSessionRead($sess_id)
This function is called whenever a session_start() call is made and reads the session variables.