Those of you that use mysql with freeradius, can anyone recommend some
software for linux to process mysql radacct table logs?
Do you just roll your own scripts to query the logs and make reports?
Seems simple enough, but "what are others doing?" is always a good
question :-)
Tha
duh! I didn't know it was there. Thanks.
Ken A
Milver S. Nisay wrote:
Those of you that use mysql with freeradius, can anyone recommend some
software for linux to process mysql radacct table logs?
Do you just roll your own scripts to query the logs and make reports?
Seems simple enough
OP records in the radacct table, so I
also put a unique index on (sessionid,username,nasipaddress) and changed
the INSERT STOP record in sql.conf to a "REPLACE INTO" instead of
"INSERT INTO" and that seems to have resolved the problem.
Ken A
Ken A wrote:
Those of you that
ecs = (time()-($back_days*86400));
$date = POSIX::strftime("%Y-%m-%d %T",localtime($secs));
print "Removing sessions with Stop Time < $date\n";
Ken A
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Kostas Kalevras wrote:
On Wed, 28 Jul 2004, Ken A wrote:
In dialup admin's perl goodies, 'clean_radacct' and 'truncate_radacct'
subtract a $days_back value of 35 or 90 from the current day of the
month (say 28). This results in negative values for the day of the
mon
Kostas Kalevras wrote:
On Wed, 28 Jul 2004, Ken A wrote:
Edgars wrote:
i am writing my own program to get them in human-readable form:)
Edgars
Yep. I made some changes that make it easier for me to start from
scratch with a language I'm more familiar with (perl) than to modify
dialupadmin
We've added framed routes with freeradius like so:
Framed-IP-Address = x.x.x.1,
Framed-Route += "x.x.x.2/32 x.x.x.1 1",
Framed-Route += "x.x.x.2/32 x.x.x.1 2",
Framed-Route += "x.x.x.2/32 x.x.x.1 3",
or
Framed-IP-Address = x.x.x.1,
Framed-Route = "x.x.x.x/30 x.x.x.1 1"
This is using pppoe, but with
Try the environment variable REMOTE_USER
#!/usr/bin/perl
print "Content-type: text/html\n\n";
foreach $key (keys %ENV) {
print "$key --> $ENV{$key}";
}
Ken
Alan DeKok wrote:
"Ayres G.J." <[EMAIL PROTECTED]> wrote:
I am developing a web system that auth
or even easier, if apache is setup for SSI, you can just plunk this into
your web page where you want the authenticated username:
Ken
Alan DeKok wrote:
"Ayres G.J." <[EMAIL PROTECTED]> wrote:
I am developing a web system that authenticates users to a web site
through free radius
9 matches
Mail list logo