On Fri, 14 Nov 2003, apellido jr., wilfredo p wrote:
> 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'
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Isn't it clear?
The failed logins page will by default only show the last 30 minutes (or as many
as you configure it through the general_most_recent_fl configuration directive
as IS described in admin.conf)
> 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:
>
> -----------------------------------------------------
>
> when i tried to run log_badlogins, it take so long to
> end. any suggestion, comment? thanks
That's what it is supposed to do. It does the equivalent of a
tail -f radius.log and logs the failed logins in the database.
It should run all the time.
>
>
> =====
> 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
>
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
