dialup_admin failed login doesnt show any report
----------------------------------------------
sql debug
---------------------------------------------
# login time server terminate cause callerid
DEBUG(SQL,MYSQL DRIVER): Query: SELECT
AcctStopTime,UserName,NASIPAddress,NASPortId,AcctTerminateCause,CallingStationId
FROM radacct WHERE AcctStopTime <= '2003-11-14
20:20:24' AND AcctStopTime >= '2003-11-14 19:50:24'
AND (AcctTerminateCause LIKE 'Login-Incorrect%' OR
AcctTerminateCause LIKE 'Invalid-User%' OR
AcctTerminateCause LIKE 'Multiple-Logins%') ORDER BY
AcctStopTime desc LIMIT 10;
DEBUG(SQL,MYSQL DRIVER): Query Result:
-------------------------------------------------
radacct table
------------------------------------------------
mysql> select * from radacct;
+-----------+---------------+----------------------------------+----------+-------+----------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+----------------------------------+-------------+----------------+-----------------+----------------+---------------+
| RadAcctId | AcctSessionId | AcctUniqueId
| UserName | Realm | NASIPAddress |
NASPortId | NASPortType | AcctStartTime |
AcctStopTime | AcctSessionTime | AcctAuthentic
| ConnectInfo_start | ConnectInfo_stop |
AcctInputOctets | AcctOutputOctets | CalledStationId |
CallingStationId | AcctTerminateCause |
ServiceType | FramedProtocol | FramedIPAddress |
AcctStartDelay | AcctStopDelay |
+-----------+---------------+----------------------------------+----------+-------+----------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+----------------------------------+-------------+----------------+-----------------+----------------+---------------+
| 1 | |
235cd91b0ffaca7b433075696d487b93 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:02:03 | 2003-11-13 22:02:03 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Login-Incorrect |
NULL | NULL | |
NULL | NULL |
| 2 | |
2f1a4527f658172f1be13fb44f7f0589 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:03:06 | 2003-11-13 22:03:06 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Invalid-User (rlm_counter: Maxim |
NULL | NULL | |
NULL | NULL |
| 3 | |
70f79c55f8ecac877d7e68ca72c9c871 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:05:18 | 2003-11-13 22:05:18 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 4 | |
f123f3b60856f7247c8faa92c1c771ab | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:19:25 | 2003-11-13 22:19:25 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 5 | 00000316 |
| cache | | 203.177.29.204 |
6 | Async | 2003-11-14 00:00:53 | 2003-11-14
00:11:54 | 661 | | 33600
V42bis | 33600 V42bis | 8352 |
5246 | | |
| Framed-User | PPP
| 203.177.29.211 | 0 |
0 |
| 6 | 00000317 |
| cache | | 203.177.29.204 |
6 | Async | 2003-11-14 00:14:23 | 2003-11-14
00:38:28 | 0 | | 33600
V42bis | | 0 |
0 | | |
| Framed-User | PPP
| 203.177.29.211 | 0 |
0 |
| 7 | 00000318 |
| cache | | 203.177.29.204 |
6 | Async | 2003-11-14 00:41:22 | 2003-11-14
00:51:23 | 601 | | 33600
V42bis | 33600 V42bis | 8235 |
5692 | | |
| Framed-User | PPP
| 203.177.29.211 | 0 |
0 |
| 8 | 00000319 |
| cache | | 203.177.29.204 |
6 | Async | 2003-11-14 00:53:49 | 2003-11-14
01:01:50 | 481 | | 33600
V42bis | 33600 V42bis | 8412 |
5986 | | |
| Framed-User | PPP
| 203.177.29.211 | 0 |
0 |
| 9 | |
f123f3b60856f7247c8faa92c1c771ab | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:19:25 | 2003-11-13 22:19:25 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 10 | |
e64ecebb9e08eedb89a1bd155508307f | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
20:30:52 | 2003-11-13 20:30:52 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Login-Incorrect |
NULL | NULL | |
NULL | NULL |
| 11 | |
fab2e628f952f796c23b48cae23591c9 | cach | |
127.0.0.1 | 1645 | NULL | 2003-11-13
20:31:11 | 2003-11-13 20:31:11 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Login-Incorrect |
NULL | NULL | |
NULL | NULL |
| 12 | |
b16f81f8e470138146bb2289ae8bf87c | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
20:32:00 | 2003-11-13 20:32:00 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Invalid-User (rlm_counter: Maxim |
NULL | NULL | |
NULL | NULL |
| 13 | |
235cd91b0ffaca7b433075696d487b93 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:02:03 | 2003-11-13 22:02:03 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Login-Incorrect |
NULL | NULL | |
NULL | NULL |
| 14 | |
2f1a4527f658172f1be13fb44f7f0589 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:03:06 | 2003-11-13 22:03:06 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Invalid-User (rlm_counter: Maxim |
NULL | NULL | |
NULL | NULL |
| 15 | |
70f79c55f8ecac877d7e68ca72c9c871 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:05:18 | 2003-11-13 22:05:18 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 16 | |
f123f3b60856f7247c8faa92c1c771ab | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:19:25 | 2003-11-13 22:19:25 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 17 | |
b1696ef22d9ce69a7093b8068bf4c400 | cache | |
203.177.29.204 | 6 | NULL | 2003-11-13
23:59:23 | 2003-11-13 23:59:23 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 18 | |
5e388800b6a91d00aeaf88f27b6c18ac | cache | |
203.177.29.204 | 6 | NULL | 2003-11-14
00:38:28 | 2003-11-14 00:38:28 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 19 | |
a0254b11738e5f8f5727b0bb644c583a | cache | |
203.177.29.204 | 6 | NULL | 2003-11-14
00:40:14 | 2003-11-14 00:40:14 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 20 | |
a0254b11738e5f8f5727b0bb644c583a | cache | |
203.177.29.204 | 6 | NULL | 2003-11-14
00:40:14 | 2003-11-14 00:40:14 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 21 | |
e64ecebb9e08eedb89a1bd155508307f | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
20:30:52 | 2003-11-13 20:30:52 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Login-Incorrect |
NULL | NULL | |
NULL | NULL |
| 22 | |
fab2e628f952f796c23b48cae23591c9 | cach | |
127.0.0.1 | 1645 | NULL | 2003-11-13
20:31:11 | 2003-11-13 20:31:11 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Login-Incorrect |
NULL | NULL | |
NULL | NULL |
| 23 | |
b16f81f8e470138146bb2289ae8bf87c | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
20:32:00 | 2003-11-13 20:32:00 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Invalid-User (rlm_counter: Maxim |
NULL | NULL | |
NULL | NULL |
| 24 | |
235cd91b0ffaca7b433075696d487b93 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:02:03 | 2003-11-13 22:02:03 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Login-Incorrect |
NULL | NULL | |
NULL | NULL |
| 25 | |
2f1a4527f658172f1be13fb44f7f0589 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:03:06 | 2003-11-13 22:03:06 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Invalid-User (rlm_counter: Maxim |
NULL | NULL | |
NULL | NULL |
| 26 | |
70f79c55f8ecac877d7e68ca72c9c871 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:05:18 | 2003-11-13 22:05:18 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 27 | |
f123f3b60856f7247c8faa92c1c771ab | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-13
22:19:25 | 2003-11-13 22:19:25 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 28 | |
b1696ef22d9ce69a7093b8068bf4c400 | cache | |
203.177.29.204 | 6 | NULL | 2003-11-13
23:59:23 | 2003-11-13 23:59:23 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 29 | |
5e388800b6a91d00aeaf88f27b6c18ac | cache | |
203.177.29.204 | 6 | NULL | 2003-11-14
00:38:28 | 2003-11-14 00:38:28 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 30 | |
a0254b11738e5f8f5727b0bb644c583a | cache | |
203.177.29.204 | 6 | NULL | 2003-11-14
00:40:14 | 2003-11-14 00:40:14 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 31 | |
db07b80db4e3d8fe85d9d1042a9e240e | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-14
19:47:00 | 2003-11-14 19:47:00 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
| 32 | |
e174f7d60b113d034c0fbd7af0c7fb78 | cache | |
127.0.0.1 | 1645 | NULL | 2003-11-14
20:09:18 | 2003-11-14 20:09:18 | 0 |
NULL | NULL | NULL |
0 | 0 | |
| Outside allowed timespan (time a |
NULL | NULL | |
NULL | NULL |
+-----------+---------------+----------------------------------+----------+-------+----------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+----------------------------------+-------------+----------------+-----------------+----------------+---------------+
32 rows in set (0.01 sec)
------------------------------------------------
part of log_badlogins script
------------------------------------------------
use Date::Manip qw(ParseDate UnixDate);
use Digest::MD5;
$|=1;
$file=shift||'/var/log/radius/radius.log';
$conf=shift||'/usr/local/www/data/dialup_admin/conf/admin.conf';
$all_file=shift||'none';
#
#
# CHANGE THESE TO MATCH YOUR SETUP
#
$domain='mactan.ph';
$mysql='/usr/local/bin/mysql';
$tmpfile='/var/tmp/mysql.input';
#
#
-----------------------------------------------------
when i tried to run log_badlogins, it take so long to
end. any suggestion, comment? thanks
=====
wilfredo pahilanga apellido jr.
technical support
mactan online
bacolod city, philippines
+63 34 4348311
If you can't hear me, it's because i'm in parentheses.
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
