mysql accounting

2004-07-27 Thread Ken A
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

Re: mysql accounting

2004-07-27 Thread Ken A
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

Re: mysql accounting

2004-07-28 Thread Ken A
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

dialup admin perl scripts clean_radacct and truncate_radacct

2004-07-28 Thread Ken A
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

Re: dialup admin perl scripts clean_radacct and truncate_radacct

2004-07-28 Thread Ken A
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

Re: mysql accounting

2004-07-29 Thread Ken A
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

Re: pppoe-server and Framed-Route

2005-04-06 Thread Ken A
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

Re: mod_auth_radius values

2005-08-18 Thread Ken A
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

Re: mod_auth_radius values

2005-08-18 Thread Ken A
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