Failed Logins

Failed logins Could not include SQL library functions. Aborting EOM; exit(); } $now = time(); if (!isset($last)) $last = ($config[general_most_recent_fl]) ? $config[general_most_recent_fl] : 5; if (!is_numeric($last)) $last = 5; $start = $now - ($last*60); $now_str = date($config[sql_full_date_format],$now); $prev_str = date($config[sql_full_date_format],$start); $now_str = da_sql_escape_string($now_str); $prev_str = da_sql_escape_string($prev_str); $pagesize = ($pagesize) ? $pagesize : 10; if (!is_numeric($pagesize) && $pagesize != 'all') $pagesize = 10; $limit = ($pagesize == 'all') ? '' : "$pagesize"; $selected[$pagesize] = 'selected'; $order = ($order != '') ? $order : $config[general_accounting_info_order]; if ($order != 'desc' && $order != 'asc') $order = 'desc'; $selected[$order] = 'selected'; if ($callerid != ''){ $callerid = da_sql_escape_string($callerid); $callerid_str = "AND callingstationid = '$callerid'"; } if ($server != '' && $server != 'all'){ $server = da_sql_escape_string($server); $server_str = "AND nasipaddress = '$server'"; } unset($da_name_cache); if (isset($_SESSION['da_name_cache'])) $da_name_cache = $_SESSION['da_name_cache']; ?> Failed Logins

Failed Logins

$prev_str up to $now_str EOM; ?>

" . $acct_attrs['fl'][2] . "\n"; if ($acct_attrs['fl'][7] != '') echo "\n"; if ($acct_attrs['fl'][8] != '') echo "\n"; if ($acct_attrs['fl'][9] != '') echo "\n"; unset($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); } ?> = '$prev_str' AND (acctterminatecause LIKE 'Login-Incorrect%' OR acctterminatecause LIKE 'Invalid-User%' OR acctterminatecause LIKE 'Multiple-Logins%') $callerid_str $server_str $sql_extra_query " . da_sql_limit($limit,1,$config) . " ORDER BY acctstoptime $order " . da_sql_limit($limit,2,$config) . " ;"); if ($search){ while( $row = @da_sql_fetch_array($search,$config) ){ $num++; $acct_login = $row[username]; if ($acct_login == '') $acct_login = '-'; else $acct_login = "$acct_login"; $acct_time = $row[acctstoptime]; $acct_server = $row[nasipaddress]; if ($acct_server != ''){ $acct_server = $da_name_cache[$acct_server]; if (!isset($acct_server)){ $acct_server = $row[nasipaddress]; $acct_server = @gethostbyaddr($acct_server); if (!isset($da_name_cache) && $config[general_use_session] == 'yes'){ $da_name_cache[$row[nasipaddress]] = $acct_server; session_register('da_name_cache'); } else $da_name_cache[$row[nasipaddress]] = $acct_server; } } else $acct_server = '-'; $acct_server = "$acct_server:$row[nasportid]"; $acct_terminate_cause = "$row[acctterminatecause]"; if ($acct_terminate_cause == '') $acct_terminate_cause = '-'; $acct_callerid = "$row[callingstationid]"; if ($acct_callerid == '') $acct_callerid = '-'; echo << EOM; if ($acct_attrs['fl'][2] != '') echo "\n"; if ($acct_attrs['fl'][2] != '') echo "\n"; if ($acct_attrs['fl'][2] != '') echo "\n"; if ($acct_attrs['fl'][2] != '') echo "\n"; echo "\n"; } } else echo "Database query failed: " . da_sql_error($link,$config) . "
\n"; } else echo "Could not connect to SQL database
\n"; echo <<

# login " . $acct_attrs['fl'][7] . " " . $acct_attrs['fl'][8] . " " . $acct_attrs['fl'][9] . "

$num $acct_login $acct_time $acct_server $acct_terminate_cause $acct_callerid

EOM; ?>

time back (mins) pagesize caller id order

On Access Server: