Re: Accounting redirection?

2003-12-03 Thread Graeme Hinchliffe
> Of course, you may mean that the *NAS* sends retry packets, and > those are logged. There isn't much that can be done about that... AH! hadn't thought of it that way, sounds most logical.. I am using radclient to sent the auth packets, and it just sits waiting for a response, so I guess it i

Re: Accounting redirection?

2003-12-02 Thread Alan DeKok
Graeme Hinchliffe <[EMAIL PROTECTED]> wrote: > It's 80% perfect for what I want, my issue is that if the radacct > system that acct is proxied to fails and doesn't respond the local > system retries, which is fine, however it logs locally each one of > these retries in it's own local format (which

Re: Accounting-Start packet question

2003-12-02 Thread Brian Clarkson
Chris Parker wrote: Is there a particular problem you are trying to solve? It might be better to spell out your problem, and listen to the proposed solutions than trying to jump straight to a solution as the one you see may not be perhaps the 'best' for your particular problem. there are 2 spec

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 will

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 i thought

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 client ( which could b

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 redundant feature > > of freeradi

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 'acct_users'. You can set Proxy-To-Realm for all > account

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 radacct server which holds all > ra

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
I use ascend MAX’s with the freeradius/mysql setup. So, I’ll give you what use and what I would assume you would use. Max Time of 6hours, Idle of 30minutes.   In the radgroupreply table you would add a row with: GroupName   Attribute        Value 

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

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

Re: Accounting and Realms (Solved)

2003-10-31 Thread Jefferson Dümes
Great, that works. But I changed your example to: DEFAULT Realm == "domain.com.br", Proxy-To-Realm := "domain.com.br" and the unique adding to radiusd.conf is: files { acctusersfile = ${confdir}/acct_users compat = no } I can't beleave that. It sending acc

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
Ok 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 ??? Dave Hickey em 31-10-2003 15:23 disse: I have the same problem. But I did not understand what you mean with

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 wildcard proxying, so I have DEFAULT

Re: Accounting and Realms

2003-10-31 Thread Jefferson Dümes
Dave 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 Dave Hickey em 31-10-2003 10:04 disse: Hello All, I'm having a little trouble with FreeRadius 0.9.2 and realms and I'm looking for a little help from t

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 PROTECTED] Esat BT

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

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 modules do

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 the 'preacct' st

RE: Accounting and Acct-Session-Time

2003-09-02 Thread Paul Hampson
> From: Sam Critchley > Sent: Tuesday, 2 September 2003 9:50 PM > RFC2866 (RADIUS Accounting) provides the following description of > attribute type 46, Acct-Session-Time: > "This attribute indicates how many seconds the user has received service > for, and can only be present in Accounting-Reque

Re: Accounting and Acct-Session-Time

2003-09-02 Thread Oliver Graf
On Tue, Sep 02, 2003 at 01:49:54PM +0200, Sam Critchley wrote: > 1. Does FreeRADIUS behave in accordance with the RFC? If so, would it just > ignore an Interim-Update Acct-Session-Time packet coming in? No. It is there and you should be able to work with it. > 2. How do other people set up so tha

Re: Accounting with Quintum

2003-08-26 Thread Peter Nixon
On Mon August 25 2003 07:14, [EMAIL PROTECTED] wrote: > Hi there, > > I have a Quintum AS800 used for terminating calls. I'm running the CDR > server utility to calculate the minutes generated by it and then make > accounting. I have heard that I can do the whole things with Freeradius. > Can any o

Re: Accounting from AS5300

2003-08-24 Thread Alan DeKok
SingSong <[EMAIL PROTECTED]> wrote: > I'm trying to capture the accounting info from AS5300 to FreeRadius. I'm able > capture from Ascend, but not from Cisco. Some Cisco boxes only do accounting for TACACS+, and not for RADIUS. Look for 'tacp2rad', which is a simple daemon to convert TACACS+

Re: Accounting

2003-08-15 Thread Chris Parker
At 09:02 AM 8/15/2003 -0700, Bernard, Mark N. wrote: Hi; Does anyone know if it is possible to log commands that were used on Cisco network device to the radius server and if so is it documented anywhere? With TACACS, yes. Cisco does not send this via Radius accounting, only via TACACS. -Chri

Re: accounting proxy problem

2003-07-31 Thread Alan DeKok
Dave Mason <[EMAIL PROTECTED]> wrote: > It looks like the proxy works OK but I dont want cdr to run on the proxy > server. I dont have any DEFAULT or other entries in the acct_users > file. I suspect I need something there, or maybe rlm_cdr needs some > extra smarts to know it's a proxy reques

Re: Accounting with freeradius

2003-07-29 Thread Oliver Graf
On Tue, Jul 29, 2003 at 04:25:30PM +0200, Oliver Graf wrote: > On Tue, Jul 29, 2003 at 04:12:25PM +0200, GAUDIN Thomas wrote: > > How enable accounting on linux??? > > I'm sorry, but the linux kernel has no aaa extensions. > > Perhaps you would like to write a kernel module which does aaa > accou

Re: Accounting with freeradius

2003-07-29 Thread Oliver Graf
On Tue, Jul 29, 2003 at 04:12:25PM +0200, GAUDIN Thomas wrote: > How enable accounting on linux??? I'm sorry, but the linux kernel has no aaa extensions. Perhaps you would like to write a kernel module which does aaa accounting? What do you want to account? Processor time? Memory usage? I'm just

RE: Accounting with freeradius

2003-07-29 Thread GAUDIN Thomas
How enable accounting on linux??? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Accounting with freeradius

2003-07-29 Thread Peter Nixon
On Tue, 29 Jul 2003 04:07 pm, GAUDIN Thomas wrote: > Hello, > > I have configured freeradius with openldap and there is no problem with > authentication. Now, I would like to do accounting and I don't understand > how do it. I have configured radiusd.conf and I don't know what I can do > with acct_

Re: accounting problem

2003-07-22 Thread Oliver Graf
On Tue, Jul 22, 2003 at 03:39:54PM +0200, labis siegfried wrote: > my data between acct-output-octets and cisco-pre-output-octest are very > diefferents? is it normal pre means before. so these are probably the octets before the session is established. acct-output-octets are the octets of the ses

RE: Accounting CISCO MySQL problem! Need HELP!! URGENT!

2003-07-17 Thread Oleg Ustinov
Hi there, I've this problem solved, but still follow problem: When I account only stop packets, I have succesful call records in the MySQL, where is unsuccessful? What I need change? Oleg Please help urgent! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of

Re: Accounting Packets with zero session length

2003-07-16 Thread
I got this message when I define Simultaneous-use=1 in Freeradius 0.8 and the user connect still connected and connect again in the same radius The radius allow him to connect twice how can I block the users to connect twice? Sorry for my english Frederico On Tue, 2003-07-15 at 08:35, Rob Hartzenb

Re: Accounting Packets with zero session length

2003-07-15 Thread Rob Hartzenberg
Hi again, > > > > > > Tue Jul 15 10:28:49 2003 : Error: rlm_sql: Stop packet with zero session > > length. (user '[EMAIL PROTECTED]', nas '155.239.xx.xxx') > > > > > > Any ideas on how to get around this? > > change > #define CISCO_ACCOUNTING_HACK > to > #undef CISCO_ACCOUNTING_HACK > > in src/

Re: Accounting Packets with zero session length

2003-07-15 Thread Oliver Graf
On Tue, Jul 15, 2003 at 11:30:04AM +0200, Rob Hartzenberg wrote: > Hi List, > > I seem to be getting alot of accounting packets with zero session length. > The FreeRadius server seems to discard these instead of taking them into > account. > The problem here, is that it then appears as if the user

Re: accounting with postgresql

2003-07-09 Thread salvin
[EMAIL PROTECTED] wrote on 7/10/2003 11:56:53 AM: > > >Hi > >I managed to compile freeradius with postgresql but when I start the radius server >and try to do accounting >using NT RadPing then I get the following error message : > >rlm_sql_postgresql: PostgreSQL Query failed Error: no connectio

Re: accounting with postgres

2003-07-09 Thread Ulrich Walcher
> After installing freeradius4.8 I installed postgresql 7.3.3 Did you compile with: ??? --with-postgres-lib-dir=/your/path/to/postgres/lib \ --with-postgres-include-dir=/your/path/to/postgres/include \ --with-postgres-dir=/your/path/to/postgres \ "/your/path/to/postgres" defaults to "/usr/local/p

Re: accounting with postgres

2003-07-09 Thread Peter Nixon
On Wed, 9 Jul 2003 06:16 am, Salvin Kumar wrote: > After installing freeradius4.8 I installed postgresql 7.3.3 freeradius4.8?? Are you sure? Assuming that you made a typo and you are actually using Freeradius 8.1 then you should check that the postgresql module actually compiled correctly. do y

RE: accounting problem

2003-07-07 Thread Deryk Piper
> Having some problems getting the acct logging to work, I had > it working > and then just the other day it just stoped. I even had the > day off so it > wasn't anyting I touched, just stoped Friday morning.. (stuff deleted) > heres my detail debug section on a startup You'll probably also wa

Re: Accounting group

2003-07-07 Thread Tom Emerson
On Monday 07 July 2003 12:31 am, hilman firmansyah wrote: > Hello, > > How to make different accounting group , example silver and gold. > I need Monthy-Max-hours = 30 hours for silver group member > and 250 hours for gold group member. > > Any clue ? Condensed version: (sql) counter reset=mont

RE: accounting with postgresql

2003-07-02 Thread sagar . patil
Hi Salvin,   I never played with this as I am still a beginner but I have this information for U.   Radiusreport http://www.pgregg.com/projects/radiusreport/ and RadiusSplit http://www.pgregg.com/projects/radiussplit/   These utilities seems to be really good . They are listed at page 130

RE: Accounting and Session-Timeout

2003-06-26 Thread Andrea Coppini
Title: Message this seems to be an extremely popular question (I joined this list to ask this same question).   Tom Emerson had replied with an excellent step-by-step procedure, and here it is (hope you don't mind Tom):   [TOM START]the solution is to set up a "counter" with "reset=neve

Re: Accounting and Session-Timeout

2003-06-26 Thread Chris Brotsos
At 04:09 PM 6/26/2003, you wrote: Hello everybody, I have here, up and running, a FreeRadius 0.8.1 server accessing a MySQL database to authenticate my users. I have a table 'radreply', where I can define a custom radreply for each user. I'm using this for a quite easy thing: I'm replying with t

Re: accounting

2003-06-26 Thread Salavat Yalalov
You can use ";" in query: accounting_stop_query = "UPDATE ${acct_table1} SET AcctStopTime = > '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = > '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', > AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay =

Re: accounting time

2003-06-13 Thread Chris van Meerendonk
On Fri, 2003-06-13 at 11:39, Roberto Pioli wrote: > > It's possible for sure, I'm using start/stop date/time, in Dialup-Admin > > is implemented something for callduration per month if I remember > > correctly. I changed the sql query in the Authorization Queries: > > > > authorize_check_query = "S

Re: accounting time

2003-06-13 Thread Roberto Pioli
> It's possible for sure, I'm using start/stop date/time, in Dialup-Admin > is implemented something for callduration per month if I remember > correctly. I changed the sql query in the Authorization Queries: > > authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM > ${authcheck_tabl

Re: accounting time

2003-06-13 Thread Chris van Meerendonk
Roberto, It's possible for sure, I'm using start/stop date/time, in Dialup-Admin is implemented something for callduration per month if I remember correctly. I changed the sql query in the Authorization Queries: authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table

RE: Accounting Variance

2003-06-10 Thread Farid Mohammed
: [EMAIL PROTECTED] Subject: Re: Accounting Variance On Tuesday 10 June 2003 2:31 am, Farid Mohammed wrote: > > Cany anyone help on explaining the following: > > I do a daily calculations on the accounting table > Report day 1: today hours16672 > Report day 2: yeserday hours

Re: Accounting Variance

2003-06-10 Thread Tom Emerson
On Tuesday 10 June 2003 2:31 am, Farid Mohammed wrote: > > Cany anyone help on explaining the following: > > I do a daily calculations on the accounting table > Report day 1: today hours16672 > Report day 2: yeserday hours 16699 > For this I do the following: > > select count(*) from radacct

Re: accounting file

2003-06-06 Thread John M. Luker
Sorry, that should have been "Funk & Wagnalls". Am fining myself $5 for making stupid error while trying to be a smarta**. All fines are donated to The Leukemia & Lymphoma Society (seriously). J. At 04:25 PM 6/5/03, you wrote: Hugu, I don't know for sure, but I think it's hermetically sealed in

Re: accounting file

2003-06-06 Thread John M. Luker
Hugu, I don't know for sure, but I think it's hermetically sealed in a mayonnaise jar on Funk & Wagner's doorstep since Noon todayno one knows the contents of that envelope. Sorry, I couldn't help it...it's over 90 here in Portland today and we're all a little giddy. J. At 04:04 PM 6/5/03, y

Re: accounting going to local and another server

2003-02-20 Thread Alan DeKok
[EMAIL PROTECTED] wrote: > I am using freeradius 0.8.1 and am trying to have all accounting logged > locally and then forwarded to another radius server. Use 'radrelay', which comes with the server. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: accounting problem

2003-02-07 Thread Chris Brotsos
At 03:09 PM 2/7/2003, you wrote: Hello all freeradius-users, sorry again for my bad english... :) i changed radtest script to do acct, so as a result i got: Accounting: no Accounting-Status-Type record. modcall[accounting]: module "unix" returns noop Accounting: no Accounting-Status-Type recor

Re: accounting problem

2003-02-07 Thread falcon
Hello falcon, Saturday, February 8, 2003, 12:09:21 AM, you wrote: f> Hello all freeradius-users, f> sorry again for my bad english... :) f> i changed radtest script to do acct, so as a result i got: f> Accounting: no Accounting-Status-Type record. f> modcall[accounting]: module "unix" returns

Re: accounting problem

2003-02-07 Thread Alan DeKok
falcon <[EMAIL PROTECTED]> wrote: > what does > >Accounting: no Accounting-Status-Type record. > mean? That attribute isn't in the request. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: accounting script for freeradius

2003-02-06 Thread Jason Jin
Hi, I'm wondering how people gather accounting information from , say, either the details files or mysql database? is there some existing scripts somewhere that doing this? TIA, jason - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: accounting performance

2003-01-27 Thread Simon White
27-Jan-03 at 16:23, Giuliano Zorzi ([EMAIL PROTECTED]) wrote : > Hi, > I'm stress-testing my freeradius test server using radclient and the > performance-testing doc. Is there a way to test the whole > authentication/accounting-start/accounting-stop process ? radclient can send auth and acct pack

Re: accounting problems

2003-01-11 Thread Andrew Pilley
On Fri, Jan 10, 2003 at 11:26:32AM -0600, Ray wrote: > everything seems to be working well. but we are having some minor issues. > OT humor: how do you make it clear that 'HP Authorized Customer' is not their > username? if it happens regularly enough with that exact username, create a user wit

Re: accounting problems

2003-01-10 Thread Alan DeKok
Ray <[EMAIL PROTECTED]> wrote: > anyways, while looking over the accounting data we are noticing that > a number of login/logout accounting packets are missing. the old > system had the same problem, so its not that freeRadius is worse, > but it seems wierd to me that this is normal. what are som

Re: accounting request

2002-12-29 Thread Thomas Krantz
There are two session-id attributes. If you are referring to "Acct-Session-Id" they are not unique. If you don't have any "Acct-Unique-Session-Id" attribute, add the rlm_acct_unique before the details module. These values are unique. / Thomas On Fri, 27 Dec 2002, m&m's wrote: > Hi > In my detail

Re: accounting only, it just stops?

2002-12-04 Thread Ray
thanks, that was the problem (or at least it fixed it) also it turned out i wasn't using the version i though i was. looks like someone installed freeRadius 0.5 rpms. (i wasn't the one who originally setup this box) and 0.7.1 i installed in a place listed later the default paths. On Wednesday

Re: accounting only, it just stops?

2002-12-04 Thread Alan DeKok
Ray <[EMAIL PROTECTED]> wrote: > Wed Dec 4 12:18:52 2002 : Info: The maximum number of threads (32) are > active, cannot spawn new thread to handle request > > > on the mysql server (mysql> show processlist;) it shows 5 sleeping > connections, and have been sleeping since a few seconds after s

A quick question re: accounting

2002-11-20 Thread Malcolm Caldwell
Hello, Sorry to bother everyone with this. I have been reading the fine documentation and the source for the last hour and don't know the answer to this question. Is it possible to select different account mechanisms on a per user or per nas basis. For eg. If the username is fred I would like

RE: Accounting

2002-10-29 Thread Gene Parks
Title: Message Just shoot me today.   I think I left my brain at home.   I found my own operator error over here.   Sorry. Gene -Original Message-From: Gene Parks Sent: Tuesday, October 29, 2002 2:15 PMTo: [EMAIL PROTECTED]Subject: Accounting Is there something I am missing with t

Re: Accounting Issue

2002-10-17 Thread Chris Parker
At 02:32 PM 10/17/2002 +1000, Scott Harris wrote: Hi guys, Having an accounting issue ... why does the bandwidth not get detected everytime ... it is not being captured in sql or detailed? Version - Freeradius 0.7.1 Radius.conf Section - accounting { acct_unique detail

Re: Accounting help

2002-08-20 Thread Alan DeKok
George <[EMAIL PROTECTED]> wrote: > The main one is the acct-status-type. What's the difference between setting > it to start or on acct? Start means that a user has started a new session. On means that the NAS has rebooted, and is turning accounting on. Alan DeKok. - List info/subscri

Re: Accounting is Where?

2002-08-13 Thread Artur Hecker
hi michael i had the same problems under my potato-debian without any sql, i.e. the radutmp, radwtmp and stmp simply haven't existed although they were in all relevant accounting sections etc. at the same time, the details file was full of lines. i tried to create the files with zero length, to

RE: Accounting is Where?

2002-08-13 Thread Chris Parker
At 03:24 PM 8/13/2002 -0400, Funk, Michael wrote: >Okay... I checked everything. Permissions are permitting, modules are >modulating, etc. > >could this have anything to do with the fact that I'm using SQL to auth and >trying to write to the traditional log files? I see all the goop in the >sql.

RE: Accounting is Where?

2002-08-13 Thread Funk, Michael
le is working fine, just not accounting! -Original Message- From: Chris Parker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: Re: Accounting is Where? At 12:04 PM 8/13/2002 -0400, Funk, Michael wrote: >Okay. > >I'm try

Re: Accounting is Where?

2002-08-13 Thread Chris Parker
At 12:04 PM 8/13/2002 -0400, Funk, Michael wrote: >Okay. > >I'm trying to use mySQL to authenticate, but I need to log accounting to >flat files. (The local tables are read-only and I can't afford the >performance hit to log to SQL) > >The auth works fine, but the accounting files aren't bein

Re: accounting-start proxy error

2002-08-13 Thread Josh . Howlett
>> It works fine for authentication request/accept and accounting-stop, but >> my NAS complains about the accounting-start messages: > > Then it's most likely a problem with the attributes in the > accounting start packet. > >> WARNING: Identifier does not match - ignoring response >>

Re: accounting-start proxy error

2002-08-11 Thread Alan DeKok
[EMAIL PROTECTED] wrote: > It works fine for authentication request/accept and accounting-stop, but my > NAS complains about the accounting-start messages: Then it's most likely a problem with the attributes in the accounting start packet. > WARNING: Identifier does not match - ignorin

Re: accounting columns in the mysql database

2002-08-02 Thread Gumilar Satriawan
i dont know exactly, but may you can trace in sql.conf radacct table on sqlupdatequery ( maybe) or other Goemilar Satriawan Kok __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - List info/subscribe/unsubscr

Re: accounting columns in the mysql database

2002-08-02 Thread Peter Nixon
On Fri, 2 Aug 2002 12:18:09 +0300 "Nikodim Nikodimov" <[EMAIL PROTECTED]> wrote: > Hi freeradius users, > > Which columns from the mysql database are for the Input and output > traffic. And what is the dimension? > > NN Hi You might like to try the following radacct table structure: http://w

Re: Accounting Flooding..

2002-08-02 Thread Gumilar Satriawan
Thanx martin and Mike so I changed MAX_RETRIES =2 (old value = 30) in Portslave sources .to reduces acc traffic packets Any suggestion else... Gumilar Satiawan __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com

Re: Accounting Flooding..

2002-07-29 Thread Martin Shears
Every 5 seconds I am guessing...if radius doesn't respond it probably resends, first word that comes to mind is firewall :) Make sure you have nothing blocking outgoing udp I think. Martin On Tue, 30 Jul 2002 16:29, you wrote: Hi All Gurus, Why my portslave send too many accounting start pac

Re: Accounting request

2002-07-25 Thread Alan DeKok
Shauli Lehavi <[EMAIL PROTECTED]> wrote: > I'm sending an accounting request using the sample code in the radclient.c > and my request is silently discarded. ... > I'm building the following accounting packet: > > lrad_attr_add_int(request, PW_ACCT_STATUS_TYPE, PW_STATUS_START); There is no su

Re: Accounting request

2002-07-25 Thread CheongMeng
U might want to try configuring your share secret at raddb/clients.conf On Thu, 25 Jul 2002, Shauli Lehavi wrote: > Date: Thu, 25 Jul 2002 13:09:42 +0200 > From: Shauli Lehavi <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: "'[EMAIL PROTECTED]'" > <[EMAIL PROTECTED]> > Subject: Accou

Re: accounting on a proxy

2002-07-02 Thread Chris Parker
At 10:59 AM 7/2/2002 +0100, [EMAIL PROTECTED] wrote: >Hi, > >Is it possible to ocnfigure a Freeradius proxy to log details of >accounting packets that it is proxying? Yes. Simply add the appropriate module to the 'accounting' block of the server's config. -Chris -- \\\|||/// \ St

Re: Accounting

2002-06-03 Thread Ronan Lucio
Hi Alan, > http://www.freeradius.org/radiusd/scripts/exec-program-wait Thank's a lot for your help and your patience. It worked fine now. Thank's Ronan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Accounting

2002-06-03 Thread Ronan Lucio
Hi Alan, Thank you very much for your answer. I'm sorry by bothered you. It wasn't my intention. I've read the whole documentation tha comes in freeradius-0.5 tar ball but I the documentation wasn't been enough to me. I've also looked for it in the freeradius homepage, but I had also not found

Re: Accounting

2002-06-03 Thread Alan DeKok
Ronan Lucio <[EMAIL PROTECTED]> wrote: > Could you please tell me how am I supposed to set acct_users files > to execute a script? I thought that's what I was doing. As I've said repeatedly, go to 'scripts/exec-program-wait'. READ IT. Heck, a copy of it is online at: http://www.freeradius

Re: Accounting

2002-06-03 Thread Ronan Lucio
Hi Alan, Could you please tell me how am I supposed to set acct_users files to execute a script? My acct_users files has just one example: #DEFAULT NAS-IP-Address == 10.0.0.1, Replicate-To-Realm := "realmname" and README file shows: 3g. NEW RADIUS ATTRIBUTES (to be used in the USERS file). N

Re: Accounting

2002-05-31 Thread Alan DeKok
Ronan Lucio <[EMAIL PROTECTED]> wrote: > I've put the follow line in raddb/acct_users files > > DEFAULT Exec-Program-Wait = "/usr/local/etc/raddb/vrflogin.py %u %f" Does this look anything like the example in the file 'scripts/exec-program-wait'? NO! That's why it does not work. Alan De

Re: Accounting

2002-05-31 Thread Ronan Lucio
Hello Alan, I've put the follow line in raddb/acct_users files DEFAULT Exec-Program-Wait = "/usr/local/etc/raddb/vrflogin.py %u %f" It's a simple test that I'm doing. It just logs a username and the Framed-IP-Address to a file. In users file I've changed nothing. Now, when I make a connection

Re: Accounting

2002-05-31 Thread Ronan Lucio
On Fri, 31 May 2002 15:50:47 -0400 "Alan DeKok" <[EMAIL PROTECTED]> wrote: > Ronan Lucio <[EMAIL PROTECTED]> wrote: > > I have already did it, but as far as I've understood it, when the > > user disconnects, this script isn't executed, is it? > > If you configure 'acct_users' like it says to d

Re: Accounting

2002-05-31 Thread Alan DeKok
Ronan Lucio <[EMAIL PROTECTED]> wrote: > I have already did it, but as far as I've understood it, when the > user disconnects, this script isn't executed, is it? If you configure 'acct_users' like it says to do at the start of the script, yes, it is. READ the comments at the start if the fil

Re: Accounting

2002-05-31 Thread Ronan Lucio
Alan, > > Is there a way to execute a external script in accounting step? > > See 'scripts/exec-program-wait' > > Alan DeKok. I have already did it, but as far as I've understood it, when the user disconnects, this script isn't executed, is it? Thank's Ronan - List info/subscribe/unsubs

Re: Accounting

2002-05-31 Thread Alan DeKok
Ronan Lucio <[EMAIL PROTECTED]> wrote: > I have a radius server (not freeradius) that execute a external > script which make some checks to validate the user. > When such user is allowed, the script insert a record in a > Postgres database with (User-Name, Framed-IP-Address, Connect-Info > Calling

Re: accounting update packets don't write into mysql database

2002-05-30 Thread Chris Parker
At 11:09 AM 5/30/2002 +0200, Simon wrote: >On Thu, May 30, 2002 at 10:10:41AM +0200, Dirk Tanneberger wrote: > > Hi, > > > > I have a problem with accounting update packets. > > I use freeradius 0.5 with mysql authentification and accounting. > > Start- and stop-records are write correctly in the

Re: accounting update packets don't write into mysql database

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 10:10:41AM +0200, Dirk Tanneberger wrote: > Hi, > > I have a problem with accounting update packets. > I use freeradius 0.5 with mysql authentification and accounting. > Start- and stop-records are write correctly in the database, but when > the router send accounting upda

Re: Accounting errors from an Ascend unit

2002-05-28 Thread William Ragsdale
Greetings, We recently inherited an old Ascend dialup unit at one of our new sites. When we add it to our freeradius server we generate a bunch of: Error: Received Accounting-Request packet from with invalid signature! Any suggestions on what to look at/fix? I have tried to track down the p

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread freeradius-users
[EMAIL PROTECTED] wrote: >11.2 is really really old, wow. That predates even the 11.3 docs, which >was about the first release that was marginally functional for a NAS. Well, our 3640's have actually been like tanks for several years - reliable and solid. They only do basic Modem and ISDN dial-

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread Chris Parker
At 07:15 PM 5/17/2002 +0100, freeradius-users wrote: >[EMAIL PROTECTED] wrote: > > >Read the docs. This is covered in the 'cisco' readme in the 'docs' > >directory. > >I did that before posting to the list... ;-). > > > >You need to add a config command to your cisco NAS that tells them not > >to

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread freeradius-users
[EMAIL PROTECTED] wrote: >Read the docs. This is covered in the 'cisco' readme in the 'docs' >directory. I did that before posting to the list... ;-). >You need to add a config command to your cisco NAS that tells them not >to send the accounting packet until it has assigned the IP. The doc

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread Chris Parker
At 06:43 PM 5/17/2002 +0100, freeradius-users wrote: >FreeRadius 0.5 snapshot 15-05-2002 on RedHat 7.1. >Using MySQL for authentication, authorisation and accouinting. >Cisco 3640 dial NAS, IOS 11.2 > > >I'm having a problem with accounting update information. The Cisco doesn't >send the Framed-I

  1   2   >