Clear Open User Sessions for $login

Clear Open User Sessions for $login Could not include SQL library functions. Aborting EOM; exit(); } echo << Clear Open User Sessions for $login

EOM; include("../html/user_toolbar.html.php3"); $open_sessions = 0; $sql_extra_query = ''; if ($config[sql_accounting_extra_query] != ''){ $sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); $sql_extra_query = da_sql_escape_string($sql_extra_query); } print <<

Clear open sessions for $login

EOM; if ($drop_conns == 1){ $method = 'snmp'; $nastype = 'cisco'; if ($config[general_sessionclear_method] != '') $method = $config[general_sessionclear_method]; if ($config[general_nas_type] != '') $nastype = $config[general_nas_type]; if ($config[general_ld_library_path] != '') putenv("LD_LIBRARY_PATH=$config[general_ld_library_path]"); $nas_by_ip = array(); $meth_by_ip = array(); $nastype_by_ip = array(); foreach ($nas_list as $nas){ if ($nas[ip] != ''){ $ip = $nas[ip]; $nas_by_ip[$ip] = $nas[community]; $meth_by_ip[$ip] = $nas[sessionclear_method]; $nastype_by_ip[$ip] = $nas[nas_type]; } } $link = @da_sql_pconnect($config); if ($link){ $search = @da_sql_query($link,$config, "SELECT nasipaddress,acctsessionid FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstoptime IS NULL;"); if ($search){ while($row = @da_sql_fetch_array($search,$config)){ $sessionid = $row[acctsessionid]; $sessionid = hexdec($sessionid); $nas = $row[nasipaddress]; $port = $row[nasportid]; $meth = $meth_by_ip[$nas]; $nastype = ($nastype_by_ip[$nas] != '') ? $nastype_by_ip[$nas] : $nastype; $comm = $nas_by_ip[$nas]; if ($meth == '') $meth = $method; if ($meth == 'snmp' && $comm != '') exec("$config[general_sessionclear_bin] $nas snmp $nastype $login $sessionid $comm"); if ($meth == 'telnet') exec("$config[general_sessionclear_bin] $nas telnet $nastype $login $sessionid $port"); } } else echo "Database query failed: " . da_sql_error($link,$config) . "
\n"; } else echo "Could not connect to SQL database
\n"; } if ($clear_sessions == 1){ $sql_servers = array(); if ($config[sql_extra_servers] != '') $sql_servers = explode(' ',$config[sql_extra_servers]); $quer = '= 0'; if ($config[sql_type] == 'pg') $quer = 'IS NULL'; $sql_servers[] = $config[sql_server]; foreach ($sql_servers as $server){ $link = @da_sql_host_connect($server,$config); if ($link){ $res = @da_sql_query($link,$config, "DELETE FROM $config[sql_accounting_table] WHERE username='$login' AND acctstoptime $quer $sql_extra_query;"); if ($res) echo "Deleted open sessions from accounting table on server $server
\n"; else echo "Error deleting open sessions for user" . da_sql_error($link,$config) . "
\n"; } else echo "Could not connect to SQL database
\n"; } echo <<

EOM; exit(); } else{ $link = @da_sql_pconnect($config); if ($link){ $search = @da_sql_query($link,$config, "SELECT COUNT(*) AS counter FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstoptime IS NULL $sql_extra_query;"); if ($search){ if ($row = @da_sql_fetch_array($search,$config)) $open_sessions = $row[counter]; } else echo "Database query failed: " . da_sql_error($link,$config) . "
\n"; } else echo "Could not connect to SQL database
\n"; } ?>