freeradius sql accounting/simultaeneous use

2003-12-22 Thread Devin Atencio
once. I have attached a few lines from my configuration and make sure it is correct.   session {     sql }   accounting {    acct_unique     sql }      Would having the above sections in my radiusd.conf be what I am looking for to make this happen? I currently have my

RE: Sending accounting info to Oracle

2003-12-17 Thread Dourty, Brian R. \(IATS\)
I've found a way to test the accounting portion and just wanted to post it here. echo "User-name= , NAS-Port-Id = 1, Acct-Session-Id = 1, Acct-Status-Type = 1, Password = xx" | radclient hostname acct sharedsecret Acct-Status-Type = 1 starts the accounting. Na

RE: Sending accounting info to Oracle

2003-12-17 Thread Dourty, Brian R. \(IATS\)
Oliver, Thanks for your reply. That makes sense now. Since I'm using the radtest utility to do my testing and not our actual NAS I won't see any accounting info. Duh... I used the radclient utility to send an acct request and I see in interacting with the accounting module now. Guess i

Re: Sending accounting info to Oracle

2003-12-17 Thread Oliver Graf
On Wed, Dec 17, 2003 at 01:45:55PM -0600, Dourty, Brian R. (IATS) wrote: > Shouldn't I see a call to the accounting module that tries to dump > accounting info to oracle? Why? You only show us Access-Requests in your debug output. Where are the Accounting-Requests radiusd should l

Sending accounting info to Oracle

2003-12-17 Thread Dourty, Brian R. \(IATS\)
I've got freeradius-0.9.3 up and running under RHEL 3.0. I'm having some problems getting it to log accounting info to oracle though. I've started radiusd with the -X option and watched a simple test using radtest. Here are the relevant portions of the debug info with usernames/

Re: SOLVED?! ( was Re: BUG?! (was Re: date type attribute not added to accounting request using attr_rewrite)

2003-12-07 Thread Paul Sijben
Ah, I see what you mean. Ok that will work as well ;-) Paul Kostas Kalevras wrote: > On Sun, 7 Dec 2003, Alan DeKok wrote: > > >>Paul Sijben <[EMAIL PROTECTED]> wrote: >> >>>I found now WHY a change in attr_rewrite when used in pre-Proxy does not >>>work. It operates on request->packet rather

Re: SOLVED?! ( was Re: BUG?! (was Re: date type attribute not added to accounting request using attr_rewrite)

2003-12-07 Thread Paul Sijben
Alan DeKok wrote: > Paul Sijben <[EMAIL PROTECTED]> wrote: > >>I found now WHY a change in attr_rewrite when used in pre-Proxy does not >>work. It operates on request->packet rather than request->proxy. > > > That should be fixed. > > >>Now the question is which ought to be fixed; the call

Re: SOLVED?! ( was Re: BUG?! (was Re: date type attribute not added to accounting request using attr_rewrite)

2003-12-07 Thread Kostas Kalevras
On Sun, 7 Dec 2003, Alan DeKok wrote: > Paul Sijben <[EMAIL PROTECTED]> wrote: > > I found now WHY a change in attr_rewrite when used in pre-Proxy does not > > work. It operates on request->packet rather than request->proxy. > > That should be fixed. > > > Now the question is which ought to be f

Re: SOLVED?! ( was Re: BUG?! (was Re: date type attribute not added to accounting request using attr_rewrite)

2003-12-07 Thread Alan DeKok
Paul Sijben <[EMAIL PROTECTED]> wrote: > I found now WHY a change in attr_rewrite when used in pre-Proxy does not > work. It operates on request->packet rather than request->proxy. That should be fixed. > Now the question is which ought to be fixed; the call to pre-proxy in > procy.c Absolu

SOLVED?! ( was Re: BUG?! (was Re: date type attribute not added to accounting request using attr_rewrite)

2003-12-07 Thread Paul Sijben
I found now WHY a change in attr_rewrite when used in pre-Proxy does not work. It operates on request->packet rather than request->proxy. Now the question is which ought to be fixed; the call to pre-proxy in procy.c or the pre-proxy chain that uses standard calls to operate on the request? I am n

Re: Maximum Simultaneous accounting sessions ??

2003-12-05 Thread Alan DeKok
asured the server running at hundreds of requests per second, when logging to SQL. If you're not using SQL, that may go up even more. > What is the limit of a freeRadius server for accounting voip calls etc.. CPU and memory. The server can record as many simultaneous calls as you can sto

Maximum Simultaneous accounting sessions ??

2003-12-05 Thread Arda Açıl
Hi,   I wonder about the capacity of freeRadius server.. Like If I want to log like 1000+ calls same time, can  a freeRadius server handle such a load ? What is the limit of a freeRadius server for accounting voip calls etc..   Thanks in advance..   Arda Acil

Re: Accounting redirection?

2003-12-03 Thread Graeme Hinchliffe
sponded or not? > > I think you'd be better off *always* logging locally. You can then > use 'radrelay' to copy those logs to another system. Wed decided this was a good idea too. But would like to have the server send back a relivant OK response to the accounting pack

Re: framedaddress accounting

2003-12-02 Thread Tony Axtell
It works! Thanks a lot guys! The "aaa accounting delay-start" is not understood on our AS5200 running IOS 12.1.18, Receiving an extra packet shouldn't be an issue for us. Thanks Again! Tony Axtell On Tue, 2003-12-02 at 14:07, Guy Fraser wrote: > This is a cisco issue.

Re: framedaddress accounting

2003-12-02 Thread Kostas Kalevras
On Tue, 2 Dec 2003, Guy Fraser wrote: > This is a cisco issue. > > Add something like {This is what I use on my 5200's}: > aaa accounting update newinfo Or better yet enable delayed accounting start packets That will save you an extra radius packet for each connection whic

Re: framedaddress accounting

2003-12-02 Thread Guy Fraser
This is a cisco issue. Add something like {This is what I use on my 5200's}: aaa accounting update newinfo Go to Cisco's site for more information, and the specific commands for your version of IOS. This is most of the AAA config on one of my 5200's : aaa new-model aaa authe

framedaddress accounting

2003-12-02 Thread Tony Axtell
Greetings! I'm new to freeradius, I have a freeradius-0.9.1 install with mysql support (for accounting only) on a freebsd 5.1 box. I'm experiencing some issues with logging of accounting where the Framed-IP-Address only shows at the stop of a user session, not at start, so I cannot

Re: Accounting redirection?

2003-12-02 Thread Alan DeKok
it's own local format (which I have set to flat > file), then when eventually it gives up it doesn't send back a > response to the client. I'm a little suprised. How have you configured the server to do that? The proxy retry code is handled independently of the accountin

Re: Accounting-Start packet question

2003-12-02 Thread Brian Clarkson
here are 2 specific problems i'm trying to solve. 1. it seems the NAS i'm using ( a Buffalo AirStation Pro http://www.buffalotech.com/wireless/products/airstationpro/WLMRL11G.html ) doesn't support the accounting side of the RADIUS suite. i never saw any Accounting-Start packets f

Re: Accounting redirection?

2003-12-02 Thread Alan DeKok
Graeme Hinchliffe <[EMAIL PROTECTED]> wrote: > Would it be possible in a future revision to attempt to deliver them > and then fail back to local storage? Sure, if someone supplies patches. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Accounting-Start packet question

2003-12-02 Thread Chris Parker
At 12:46 PM 12/2/2003, Brian Clarkson wrote: Chris Parker wrote: At 12:27 PM 12/2/2003, Brian Clarkson wrote: Accounting-Start packets are sent by the client ( which could be either the NAS or the end-user in the case of wireless auth, which is what i'm doing ). No, it will be the NAS, it

Re: Accounting-Start packet question

2003-12-02 Thread Brian Clarkson
Chris Parker wrote: At 12:27 PM 12/2/2003, Brian Clarkson wrote: Accounting-Start packets are sent by the client ( which could be either the NAS or the end-user in the case of wireless auth, which is what i'm doing ). No, it will be the NAS, it will not be the end-user. that's what

Re: Accounting-Start packet question

2003-12-02 Thread Chris Parker
At 12:27 PM 12/2/2003, Brian Clarkson wrote: so i've read through the O'Reilly _Radius_ book, the FAQ for FreeRADIUS, and browsed the list's archive, but i still i have a relatively basic question that just needs some clarification. Accounting-Start packets are sent by the clien

Accounting-Start packet question

2003-12-02 Thread Brian Clarkson
so i've read through the O'Reilly _Radius_ book, the FAQ for FreeRADIUS, and browsed the list's archive, but i still i have a relatively basic question that just needs some clarification. Accounting-Start packets are sent by the client ( which could be either the NAS or the

Re: Accounting redirection?

2003-12-02 Thread Graeme Hinchliffe
> > My idea is to have a central radacct server which holds all > > radacct data from all RADIUS connections (makes it easy to search). > > I know this can be done by simply directing the accounting packets > > to this single server, but I was hoping to use the

Re: Accounting redirection?

2003-12-02 Thread Graeme Hinchliffe
On Fri, 28 Nov 2003 11:56:04 -0500 "Alan DeKok" <[EMAIL PROTECTED]> wrote: > Graeme Hinchliffe <[EMAIL PROTECTED]> wrote: > > Is it possible to redirect accounting packets recieved by one > > radius server to another? > > Yes. See '

Re: BUG?! (was Re: date type attribute not added to accounting request using attr_rewrite)

2003-12-01 Thread Alan DeKok
> I am happy to help fix it as I need this to work soon. However I would > appreciate some pointers where to look. src/lib/valuepair.c, function paircreate() Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

BUG?! (was Re: date type attribute not added to accounting request using attr_rewrite)

2003-12-01 Thread Paul Sijben
James, this looks like the same thing I am seeing in both attr_rewrite and with rlm_perl. I am afraid this is a bug. I am happy to help fix it as I need this to work soon. However I would appreciate some pointers where to look. Paul James Nedila wrote: > freeradius-0.9.3 > > First, my rewrite

date type attribute not added to accounting request using attr_rewrite

2003-11-29 Thread James Nedila
freeradius-0.9.3 First, my rewrite config: attr_rewrite addEventTimestamp attribute = Event-Timestamp searchfor = NULL searchin = packet replacewith = "%l" new_attribute = yes max_

Re: Postgresql Traffic Accounting Update

2003-11-29 Thread Peter Nixon
Didi Rieder wrote: --On Friday, November 28, 2003 06:13:30 PM +0200 Peter Nixon <[EMAIL PROTECTED]> wrote: In any case I have added your suggested changes to sql.conf in the mainline cvs. However can you please double check your suggestions and compare with Arthur's patch for postgres. His patch

Re: Postgresql Traffic Accounting Update

2003-11-28 Thread Didi Rieder
--On Friday, November 28, 2003 06:13:30 PM +0200 Peter Nixon <[EMAIL PROTECTED]> wrote: In any case I have added your suggested changes to sql.conf in the mainline cvs. However can you please double check your suggestions and compare with Arthur's patch for postgres. His patch does some checks th

Re: Accounting redirection?

2003-11-28 Thread Alan DeKok
Graeme Hinchliffe <[EMAIL PROTECTED]> wrote: > Is it possible to redirect accounting packets recieved by one > radius server to another? Yes. See 'acct_users'. You can set Proxy-To-Realm for all accounting packets. > My idea is to have a central radac

Re: Postgresql Traffic Accounting Update

2003-11-28 Thread Peter Nixon
%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' \ AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime IS NULL" And your accounting will be updated with the interval set with Acct-Interim-Interval. Commited. thanks After thinking about

Accounting redirection?

2003-11-28 Thread Graeme Hinchliffe
Hiya Is it possible to redirect accounting packets recieved by one radius server to another? My idea is to have a central radacct server which holds all radacct data from all RADIUS connections (makes it easy to search). I know this can be done by simply directing the

Re: Postgresql Traffic Accounting Update

2003-11-28 Thread Peter Nixon
'::bigint << 32) + '%{Acct-Input-Octets:-0}'::bigint), \ AcctOutputOctets = (('%{Acct-Output-Gigawords:-0}'::bigint << 32) + '%{Acct-Output-Octets:-0}'::bigint) \ WHERE AcctSessionId = '%{Acct-Session-Id}

Re: Postgresql Traffic Accounting Update

2003-11-28 Thread Peter Nixon
Didi Rieder wrote: --On Wednesday, November 26, 2003 01:13:48 AM +0200 Peter Nixon <[EMAIL PROTECTED]> wrote: Thanks. I will check this into CVS tomorrow. I asked this list about this issue some week ago: http://www.mail-archive.com/[EMAIL PROTECTED]/msg21337.html http://www.mail-archive.com

Re: Freeradius-Proxied-To not showing up in sql accounting

2003-11-27 Thread Alan DeKok
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > OK, but the attribute is getting written to the accouting detail file, > so if it is getting into the accounting detail file (which is just a text > file) then why can I not write it to MySQL. I don't know. See the

Re: Freeradius-Proxied-To not showing up in sql accounting

2003-11-26 Thread [EMAIL PROTECTED]
> > The request is logged to the accounting detail file, and THEN the > FreeRADIUS-Proxied-To is generated, and the packet is proxied. > > Order is important. Since the packet was logged before it was > proxied, there is no FreeRADIUS-Proxied-To attribute to log. > OK,

Re: Freeradius-Proxied-To not showing up in sql accounting

2003-11-26 Thread Alan DeKok
; request to FreeRADIUS and then FreeRADIUS decides to proxy the > request to another radius, that FreeRADIUS-Proxied-To is generated > internally and written to the accouting detail file. No. The request is logged to the accounting detail file, and THEN the FreeRADIUS-Proxied-To is gener

Re: Freeradius-Proxied-To not showing up in sql accounting

2003-11-26 Thread [EMAIL PROTECTED]
> > 2. But when I use something like NTRadping to test the accounting start > > and accounting stop and send the additional attributes > > "Freeradius-Proxied-To" > > it gets written to both the master detail file and my radacct table. > > Find out what&

Re: Freeradius-Proxied-To not showing up in sql accounting

2003-11-26 Thread Alan DeKok
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I am currently in the process of setting up MySQL to handle the > accounting records. Just about everything seems to working except I > cannot get the attribute "Freeradius-Proxied-To" to write to my > radacct

Freeradius-Proxied-To not showing up in sql accounting

2003-11-26 Thread [EMAIL PROTECTED]
re proxied reliably and all the necessary accounting detail is getting written to my master detail file, etc. I am currently in the process of setting up MySQL to handle the accounting records. Just about everything seems to working except I cannot get the attribute "Freeradius-Proxied-To" to

RE: Postgresql Traffic Accounting Update

2003-11-26 Thread David
7:20 AM To: [EMAIL PROTECTED] Subject: Re: Postgresql Traffic Accounting Update --On Wednesday, November 26, 2003 01:13:48 AM +0200 Peter Nixon <[EMAIL PROTECTED]> wrote: > Thanks. > > I will check this into CVS tomorrow. I asked this list about this issue some week ago:

Re: Postgresql Traffic Accounting Update

2003-11-26 Thread Didi Rieder
--On Wednesday, November 26, 2003 01:13:48 AM +0200 Peter Nixon <[EMAIL PROTECTED]> wrote: Thanks. I will check this into CVS tomorrow. I asked this list about this issue some week ago: http://www.mail-archive.com/[EMAIL PROTECTED]/msg21337.html http://www.mail-archive.com/[EMAIL PROTECTED]/msg

Re: Postgresql Traffic Accounting Update

2003-11-26 Thread Peter Nixon
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Peter Nixon Sent: Tuesday, November 25, 2003 4:14 PM To: [EMAIL PROTECTED] Subject: Re: Postgresql Traffic Accounting Update Arthur B Olsen wrote: The Acct-Interim-Interval does not update the acctinputoctets and acctoutputoctets in

RE: Postgresql Traffic Accounting Update

2003-11-25 Thread David
SpeedyQuick Networks, Inc Boise, Id www.speedyquick.net 208.284.5505 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Peter Nixon Sent: Tuesday, November 25, 2003 4:14 PM To: [EMAIL PROTECTED] Subject: Re: Postgresql Traffic Accounting Update Arthur B Olsen wrote

Re: Postgresql Traffic Accounting Update

2003-11-25 Thread Peter Nixon
'::bigint << 32) + '%{Acct-Input-Octets:-0}'::bigint), \ AcctOutputOctets = (('%{Acct-Output-Gigawords:-0}'::bigint << 32) + '%{Acct-Output-Octets:-0}'::bigint) \ WHERE AcctSessionId = '%{Acct-Session-Id}

Postgresql Traffic Accounting Update

2003-11-25 Thread Arthur B Olsen
< 32) + '%{Acct-Input-Octets:-0}'::bigint), \ AcctOutputOctets = (('%{Acct-Output-Gigawords:-0}'::bigint << 32) + '%{Acct-Output-Octets:-0}'::bigint) \ WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{

Re: accounting

2003-11-20 Thread Chris Parker
At 02:34 PM 11/20/2003, Rob Genovesi wrote: This is close to what I'm playing with ... IN radiusd.conf : -- modules { exec session_lookup wait = yes program = "/your/program %{User-Name}"

RE: accounting

2003-11-20 Thread Anson Rinesmith
   1800 :=   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tech Strategy Sent: Thursday, November 20, 2003 2:13 PM To: [EMAIL PROTECTED] Subject: accounting   Hello!   How will I make use of the 'se

Re: accounting

2003-11-20 Thread Rob Genovesi
This is close to what I'm playing with ... IN radiusd.conf : -- modules { exec session_lookup wait = yes program = "/your/program %{User-Name}" input_pairs = request output_p

accounting

2003-11-20 Thread Tech Strategy
Hello!   How will I make use of the 'session-timeout' attribute (No- 27) in freeradius. Every time I get a login request, I want to query this value associated with that particular user from a sql db and send it back with the request. Would this require additional coding. Also, can the Idle-timeout

Re: Interim accounting update +mysql

2003-11-19 Thread Dustin Doris
On Wed, 19 Nov 2003, David Blood wrote: > For some reason mysql is not being update with the interim accouting > updates. Below is one of the accounting requests sent to free radius and > you can see that it does not send the bytes and up time information to > mysql. >

Interim accounting update +mysql

2003-11-19 Thread David Blood
For some reason mysql is not being update with the interim accouting updates. Below is one of the accounting requests sent to free radius and you can see that it does not send the bytes and up time information to mysql. Anyone know why? rad_recv: Accounting-Request packet from host

Timing out user after missed accounting updates

2003-11-14 Thread Alex French
Hi all, In brief, I'm looking for a way to assume users are logged out if their NAS missed x accounting updates (or alternatively, no update for y seconds). The use case is as follows: We have a number of wireless hotspots at the end of unreliable links. We use RADIUS accounting to bill

Re: accounting updates

2003-11-10 Thread Didi Rieder
Quoting Didi Rieder <[EMAIL PROTECTED]>: > Hi, > > the default accounting_update_query in sql.conf makes no update for input and > output octets and session-time. Is this correct, or shoud the query look more > like the following: > > accounting_update_query = "UPDATE ${acct_table1} > SET > Fr

accounting updates

2003-11-07 Thread Didi Rieder
Hi, the default accounting_update_query in sql.conf makes no update for input and output octets and session-time. Is this correct, or shoud the query look more like the following: accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime

accounting updates

2003-11-06 Thread Didi Rieder
Hi, the default accounting_update_query in sql.conf makes no update for input and output octets and session-time. Is this correct, or shoud the query look like the following: accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{

Scripts for radius accounting (flat files)

2003-11-04 Thread [EMAIL PROTECTED]
cript that can report the total number of unique users that have logged in by realm. I just want to run the script once a night to get a rough snap. I have looked at a number of the available accounting scripts/tools out there but they do not seem to have this ability. Does anyone have a simple s

VoIP Accounting with Cisco

2003-11-03 Thread Eusebio Silva
Hello there,   I'm currently working on VoIP accounting from cisco gateways.   For the time being freeradius is storing CDRs on a postgreSql database.   Nevertheless, I'm facing a problem with certain Cisco-AVPairs. I can't get FreeRadius to store "Cisco-AVPair = redirected-s

Re: collect accounting + acct port

2003-11-03 Thread marek cervenka
> are there some standard way(scripts) how collect accounting data from > myssql/radacct to central accounting server? > > one way is add "Stamp timestamp" to radacct > (alter table radacct add Stamp timestamp;) does freeradius support "event-timestamp"? (

collect accounting + acct port

2003-11-03 Thread marek cervenka
hi, are there some standard way(scripts) how collect accounting data from myssql/radacct to central accounting server? one way is add "Stamp timestamp" to radacct (alter table radacct add Stamp timestamp;) and now i can select * from radacct where stamp<'timestamp_when_run

Re: Differnent database for authentication and accounting

2003-11-01 Thread Alan DeKok
"Deepak Singhal" <[EMAIL PROTECTED]> wrote: > I tried editing postgresql.conf and specified sql1 and sql2 and used these > in radius.conf but it gives error : > > Failed to link to module 'rlm_sql1': file not found > > What should i specify in radiusd.conf. See doc/configurable_failover. It

Re: Problem with Accounting-On packet

2003-11-01 Thread Gustavo A. Lozano
I know that but after I commented the radzap entry in rlm_unix the thing is working good... On Fri, 2003-10-31 at 20:52, Kostas Kalevras wrote: > On Thu, 30 Oct 2003, Gustavo A. Lozano wrote: > > > Hello. > > > > I have a very big problem with one NAS. The machine is s

Differnent database for authentication and accounting

2003-11-01 Thread Deepak Singhal
How can i use differnet databases for authentication and accounting. Both are postgresql databases. I tried editing postgresql.conf and specified sql1 and sql2 and used these in radius.conf but it gives error : Failed to link to module 'rlm_sql1': file not found What should i

Re: Problem with Accounting-On packet

2003-10-31 Thread Kostas Kalevras
On Thu, 30 Oct 2003, Gustavo A. Lozano wrote: > Hello. > > I have a very big problem with one NAS. The machine is sending > accounting-on packets every 2 seconds, so the wtmp and rlm_ippool > modules are not working. Every time the packet is received by the > radius, the wtmp a

Re: Accounting and Realms (Solved)

2003-10-31 Thread Jefferson Dümes
file The acct_users file allows you to specify what to do with a specific users accounting packets. In my case I'm doing wildcard proxying, so I have DEFAULT User-Name =~ "@*.olie1", Proxy-To-Realm := "bt-radius" in my users file. However the accounting re

Re: Accounting and Realms

2003-10-31 Thread Alan DeKok
=?ISO-8859-1?Q?Jefferson_D=FCmes?= <[EMAIL PROTECTED]> wrote: > But I think I need to refer this file (acct_user) on radiusd.conf or other. > > I don't need to have in radiusd.conf a "files {}" section refering to > this file ??? Or something else ??? Yes. $ grep acct_users freeradius-0.9.2/r

Re: Accounting and Realms

2003-10-31 Thread Jefferson Dümes
t you mean with "...miss the acct_users file". What is the acct_users file The acct_users file allows you to specify what to do with a specific users accounting packets. In my case I'm doing wildcard proxying, so I have DEFAULT User-Name =~ "@*.olie1", Proxy-To

Re: Accounting and Realms

2003-10-31 Thread Dave Hickey
> I have the same problem. But I did not understand what you mean with > "...miss the acct_users file". > > What is the acct_users file The acct_users file allows you to specify what to do with a specific users accounting packets. In my case I'm doing w

Re: Problem with Accounting-On packet

2003-10-31 Thread Gustavo A. Lozano
Well, I think I got it, I am going to comment out the radzap line in rlm_utmp.c and see if it works :) Any comment from anybody? On Thu, 2003-10-30 at 16:22, Gustavo A. Lozano wrote: > Hello. > > I have a very big problem with one NAS. The machine is sending > accounting-on pac

Re: Accounting and Realms

2003-10-31 Thread Jefferson Dümes
r a little help from the list. I have since got the accounting proxying working, I had managed to miss the acct_users file... Doh! Cheers, Dave. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Accounting and Realms

2003-10-31 Thread Dave Hickey
Hello All, > I'm having a little trouble with FreeRadius 0.9.2 and realms and I'm looking > for a little help from the list. I have since got the accounting proxying working, I had managed to miss the acct_users file... Doh! Cheers, Dave. -- Dave Hickey [EMAIL

Accounting and Realms

2003-10-31 Thread Dave Hickey
t = ** nostrip } realm bt-radius { type= radius authhost= 208.159.238.242:1645 accthost= 208.159.238.243:1646 secret = ** nostrip } >> The problem is that the user is authenticated corr

Problem with Accounting-On packet

2003-10-30 Thread Gustavo A. Lozano
Hello. I have a very big problem with one NAS. The machine is sending accounting-on packets every 2 seconds, so the wtmp and rlm_ippool modules are not working. Every time the packet is received by the radius, the wtmp and ip_pool dbs are reset. The radius.log file shows the next every 2-3

Re: Interim Accounting

2003-10-28 Thread Alan DeKok
"Das, Anindya Kishore" <[EMAIL PROTECTED]> wrote: > How can I enable Interim-Accounting in freeradius? You don't. It's up to the NAS to send the packets. > I have a Mikrotik > RouterOS set up to send interim requests at every minute but according > acco

Re: accounting alive packet

2003-10-28 Thread Matthew Schumacher
Marek, What I did is provision the NAS to send the update every 30 minutes, then I put the start, update, and stop messages on seperate rows in the database then run a query that looks for the min and max transfer bytes within the month gouped by user and session. Then I subtract the min from

Re: accounting alive packet

2003-10-28 Thread Alan DeKok
marek cervenka <[EMAIL PROTECTED]> wrote: > i have adsl users(dynamic ip) which are connected to NAS longer than month > i need info about bytes transfered > in so far that i cannot sumarize this from start-time, stop-time packets ... > can i do this with freeradius? Yes. Alan DeKok. - Li

Interim Accounting

2003-10-28 Thread Das, Anindya Kishore
Hi All, How can I enable Interim-Accounting in freeradius? I have a Mikrotik RouterOS set up to send interim requests at every minute but according according to the documentation at Mikrotik the radius server needs to send an Acct-Interim-Interval = 0 A/V pair back to the NAS so as to take effect

accounting alive packet

2003-10-27 Thread marek cervenka
hi, i have adsl users(dynamic ip) which are connected to NAS longer than month i need info about bytes transfered in so far that i cannot sumarize this from start-time, stop-time packets i'm sending alive packet (Acct-Status-Type = Alive), but i cannot see this packets in mysql "usertime" tabl

Re: ldap authentication + mysql accounting

2003-10-27 Thread Kostas Kalevras
On Sun, 26 Oct 2003, Ruslan Spivak wrote: > Hello. > > For now i use authentication(authtype PAP) and accounting in mysql(also > rlm_sqlcounter). > I saw in config option for authentication using ldap. Is it possible to > use ldap authentication and mysql accounting and will rlm

ldap authentication + mysql accounting

2003-10-25 Thread Ruslan Spivak
Hello. For now i use authentication(authtype PAP) and accounting in mysql(also rlm_sqlcounter). I saw in config option for authentication using ldap. Is it possible to use ldap authentication and mysql accounting and will rlm_sqlcounter work in such combination? Thanks in advance. Your help

Clean Accounting Logs

2003-10-16 Thread Matt
Does anyone know of a script to clean out the old log files every night? I have tried: "radiusd.cron.daily" but it keeps giving me: "savelog: command not found". Also, how long should one keep logs? Matt - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Accounting trouble + proxy

2003-10-08 Thread Thomas MARCHESSEAU
Hi Chris, Chris Parker wrote: At 08:18 AM 10/8/2003, Thomas MARCHESSEAU wrote: Hi all, I would like to know if there is a special tricks to have "accthost" working on freeradius 0.9.1 in proxy mode : My accounting request are not forwarded by the proxy to my radius server . What

Re: Accounting trouble + proxy

2003-10-08 Thread Chris Parker
At 08:18 AM 10/8/2003, Thomas MARCHESSEAU wrote: Hi all, I would like to know if there is a special tricks to have "accthost" working on freeradius 0.9.1 in proxy mode : My accounting request are not forwarded by the proxy to my radius server . What modules do you have enabled in th

Accounting trouble + proxy

2003-10-08 Thread Thomas MARCHESSEAU
Hi all, I would like to know if there is a special tricks to have "accthost" working on freeradius 0.9.1 in proxy mode : My accounting request are not forwarded by the proxy to my radius server . --- proxy.conf (working fine on 0.8.1) realm myrealm.net {

Re: FreeRadius 0.9.1, Accounting, SQL & Total Control

2003-09-30 Thread Bill
I re-read the example you had below and used it. That worked perfectly. Thanks! Bill - Original Message - From: Alan DeKok To: [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 3:20 PM Subject: Re: FreeRadius 0.9.1, Accounting, SQL & Total Control "Bill

Re: FreeRadius 0.9.1, Accounting, SQL & Total Control

2003-09-30 Thread Bill
ll - Original Message - From: Alan DeKok To: [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 3:20 PM Subject: Re: FreeRadius 0.9.1, Accounting, SQL & Total Control "Bill" <[EMAIL PROTECTED]> wrote: > I just started using FreeRadius with SQL for ac

Re: FreeRadius 0.9.1, Accounting, SQL & Total Control

2003-09-30 Thread Alan DeKok
"Bill" <[EMAIL PROTECTED]> wrote: > I just started using FreeRadius with SQL for accounting today and > noticed that the Total Control's connection speed values are not being > recorded into the ConnectInfo_start or stop fields of the mySQL database. I > trie

FreeRadius 0.9.1, Accounting, SQL & Total Control

2003-09-30 Thread Bill
I just started using FreeRadius with SQL for accounting today and noticed that the Total Control's connection speed values are not being recorded into the ConnectInfo_start or stop fields of the mySQL database. I tried changing all the dictionary.usr attributes from "USR-Connect

Re: Re: Mysql Optimize Table without losing accounting-data???

2003-09-26 Thread m . prenger
Alan wrote: >Huh? Logging to the 'detail' file takes nearly zero time. > >Let me guess: You're running MySQL on the same machine as FreeRADIUS. > >The solution is simple: Don't do that. Hi Alan, thanks for replying. Yes, we're running mysqld on the same machine as radiusd, but we're not able to

Re: TTLS/Radius Accounting

2003-09-20 Thread Alan DeKok
lutely. > The only way I can see to get around this problem easily is to, after > the fact, correlate the authentication logs with another attribute in > the accounting requests. CallingStationID is the best one that comes to > mind right off the bat, since this should be unique to the

Re: TTLS/Radius Accounting

2003-09-20 Thread Michael Griego
st is sent inside the tunnel, to which the AP (by design) has no way to decrypt. Therefore, for accounting requests originating from the AP, the username attribute will *always* be anonymous (or whatever dummy identity the TTLS client sends). Also, you will alway see the same UserID show up in the

TTLS/Radius Accounting

2003-09-20 Thread Phil Flores
Title: TTLS/Radius Accounting Kudos to the FreeRadius team for their commitment to improving an already solid package! I have recently implemented TTLS on my test network using the CVS Snapshot from 9/19.  TTLS is enabled along with MySQL.  Connected to the radius is a Colubris CN3000 with

Re: module failure with multiple accounting methods

2003-09-16 Thread Alan DeKok
Dave Mason <[EMAIL PROTECTED]> wrote: > I have a Freeradius server (v0.8.1) where I may configure multiple > accounting methods in radiusd.conf. These could be any of the ones > supplied with Freeradius, like detail, radutmp, etc, or a new one that I > wrote. My new one may

Re: Freeradius+MySql+Cisco (Accounting)

2003-09-15 Thread Kiran
t the second one. --- Ulrich Walcher <[EMAIL PROTECTED]> wrote: > I didn't test it but did you try to add a semicolon > and the next > statement? > I don't know if the accounting part is coded in > another way than the > authorization part, but in authorization it

Re: Freeradius+MySql+Cisco (Accounting)

2003-09-15 Thread Ulrich Walcher
I didn't test it but did you try to add a semicolon and the next statement? I don't know if the accounting part is coded in another way than the authorization part, but in authorization it works... Am Mon, 2003-09-15 um 16.00 schrieb Kiran: > Hi, > > I am using freeradius-0

Proxy (accounting) based on any attribute!!

2003-09-15 Thread Pavlos Demosthenous
I read in the freradius specification that it is capable of doing proxy authentication and/or accounting forwarding based on any attribute. Traditionally, Proxy was only applicable through Realms/Suffixes.   Suppose I want to do accounting forwarding based on NAS-IP address, how I would do

Freeradius+MySql+Cisco (Accounting)

2003-09-15 Thread Kiran
Hi, I am using freeradius-0.9.1, MySql 4.0 and using TCL 2.0 in Cisco AS5400. How can I have more than one SQL statements to be executed in sql.conf whenever there is an accounting request. Basically, I want to insert into one table and update the second table once the call is finished. How can

Accounting problems

2003-09-12 Thread Marcus Grando
Hi List, How insert user ID of radcheck in accounting table? Need change in "SQL-User-Name"? Any idea? Best Regards. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

  1   2   3   4   5   6   7   8   9   >