Re: [RADIATOR] ::Accounting Request Proxying for Remote OSS Systems::

2014-11-04 Thread Hugh Irvine
gt; -Original Message- > From: Hugh Irvine [mailto:h...@open.com.au] > Sent: Monday, November 03, 2014 2:08 AM > To: Mohammed Alhaj Ali > Cc: Heikki Vatiainen; radiator@open.com.au > Subject: Re: [RADIATOR] ::Accounting Request Proxying for Remote OSS Systems:: > > &

Re: [RADIATOR] ::Accounting Request Proxying for Remote OSS Systems::

2014-11-04 Thread Mohammed Alhaj Ali
Hi.. Thank you Sir, I'll try to use the existing identifier on clause. Regards, -Original Message- From: Hugh Irvine [mailto:h...@open.com.au] Sent: Monday, November 03, 2014 2:08 AM To: Mohammed Alhaj Ali Cc: Heikki Vatiainen; radiator@open.com.au Subject: Re: [RAD

Re: [RADIATOR] ::Accounting Request Proxying for Remote OSS Systems::

2014-11-02 Thread Hugh Irvine
Hello - You need to reference both AuthBy clauses in your Handler: # Add Identifier for reference in accounting Handler Identifier SQLAccounting AccountingTable zooomonline.ZOOOM_ACCOUNTING AcctColumnD

[RADIATOR] ::Accounting Request Proxying for Remote OSS Systems::

2014-11-02 Thread Mohammed Alhaj Ali
Hi, I'm trying to setup only accounting request proxying for remote OSS systems, as well to keep accounting messages to be written on SQL database with the original . I applied the below configuration, and I had received the accounting on the remote system, but I loss accounting update on the

Re: [RADIATOR] Accounting logs in mysql or oracle db

2013-06-20 Thread Hugh Irvine
Hello Manish - See "goodies/sql.cfg" in the distribution and section 5.31 in the Radiator 4.11 reference manual ("doc/ref.pdf"). regards Hugh On 20 Jun 2013, at 15:22, "Arya, Manish Kumar" wrote: > Hi, > >Can some one please help us to configure radiator to push Radius > accounting

Re: [RADIATOR] Accounting logs in mysql or oracle db

2013-06-19 Thread A . L . M . Buxey
Hi, > Can some one please help us to configure radiator to push Radius >accounting logs into mysql or oracle databases ? >some sample configs may help us. have you read the ref.pdf RADIATOR reference guide from the OSC site? if so, what configuration have you currently got so that w

[RADIATOR] Accounting logs in mysql or oracle db

2013-06-19 Thread Arya, Manish Kumar
Hi,      Can some one please help us to configure radiator to push Radius accounting logs into mysql or oracle databases ? some sample configs may help us. Regards, -Manish___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/lis

Re: [RADIATOR] Accounting records are not written to database

2012-11-06 Thread Hugh Irvine
Hello Rohan - The session database and the MaxSessions and/or Simultaneous-Use directives are designed to limit a particular user to some predetermined number of sessions at the same time (typically one). To do this, Radiator maintains a state table in the session database of all sessions for

Re: [RADIATOR] Accounting records are not written to database

2012-11-06 Thread rohan.henry
Thanks Hugh. It's working now! The Socket6.pm module needed to be installed. Tue Nov 6 09:28:28 2012: DEBUG: Handling request with Handler 'NAS-Identifier="Juniper_E320_2"' Tue Nov 6 09:28:28 2012: DEBUG: SQLSDB Deleting session for fritzsamuels1, 208.138.43.125, 805307373 Tue Nov 6 09:28:28

Re: [RADIATOR] Accounting records are not written to database

2012-11-05 Thread Hugh Irvine
Hello Rohan - To see what is happening with the crash you should run radiusd from the command line so you can see the relevant Perl messages. Something like this (with your local pathnames): /usr/bin/perl /usr/local/bin/radiusd -foreground -log_stdout -trace 4 -config_file /etc/radia

Re: [RADIATOR] Accounting records are not written to database

2012-11-05 Thread Christian Kratzer
Hi, On Mon, 5 Nov 2012, rohan.he...@cwjamaica.com wrote: > Hugh, > > re: server crash see config and log files attached. What exactly do you mean when you say the server crashes ? I cannot find any perl exceptions in the logs and nothing at first sight in the config that would cause anything li

Re: [RADIATOR] Accounting records are not written to database

2012-11-05 Thread rohan.henry
Hugh, re: server crash see config and log files attached. Rohan On Sat, 3 Nov 2012 09:06:44 +1100 Hugh Irvine wrote: > >Hello Rohan - > >The easiest way to do this is to store only the Stop records, and calculate >the start time from the attributes present in the accounting stop request. > >S

Re: [RADIATOR] Accounting records are not written to database

2012-11-02 Thread rohan.henry
Thanks. That technique works! Except that I used below. ACCT_START_TIME,%b-0%{Acct-Session-Time},literal The field is NULL if I used type integer-date (below). mcatra1 | Juniper_E320_2 | 805307373 | 208.131.170.180 | NULL | Nov 2, 2012 18:35 Regards, Rohan On Sat, 3 Nov 201

Re: [RADIATOR] Accounting records are not written to database

2012-11-02 Thread Hugh Irvine
Hello Rohan - On 3 Nov 2012, at 09:39, wrote: > Hugh, > > So does it mean that I wouldn't need to process the Start record as defined > by: HandleAcctStatusTypes Start,Stop? > Yes - you would just use HandleAcctStatusTypes Stop > And in this way a session only gets inserted into t

Re: [RADIATOR] Accounting records are not written to database

2012-11-02 Thread rohan.henry
Hugh, So does it mean that I wouldn't need to process the Start record as defined by: HandleAcctStatusTypes Start,Stop? And in this way a session only gets inserted into the database only if the Stop record is processed? On Sat, 3 Nov 2012 09:06:44 +1100 Hugh Irvine wrote: > >Hello Rohan - >

Re: [RADIATOR] Accounting records are not written to database

2012-11-02 Thread Hugh Irvine
Hello Rohan - The easiest way to do this is to store only the Stop records, and calculate the start time from the attributes present in the accounting stop request. Something like this (the value is in epoch seconds): Timestamp - Acct-Session-Time - Acct-Delay-Time For the crash I wil

Re: [RADIATOR] Accounting records are not written to database

2012-11-02 Thread rohan.henry
Hugh, After some additional advice I realize that how Radiator adds the the records makes perfect sense. Since I have the option of inserting Interim records as well. So you can ignore. But I would still would like to know why Simultaneous-Use or Maxsessions does not work and crash the applic

Re: [RADIATOR] Accounting records are not written to database

2012-11-02 Thread rohan.henry
Hugh, Now that records are being written to the database, I want a single record per session that includes both Stop and Start times like below. User_Name, NAS_IP_Address, NAS_Port, Framed_IP_Address, Acct_Start_Time, Acct_Stop_Time, Acct_Session_ID jwilliams12 208.138.43.123 805306450 72.27.33

Re: [RADIATOR] Accounting records are not written to database

2012-11-01 Thread Hugh Irvine
Hello Rohan - Can you please explain exactly what you are trying to do? It is normal for you to get two records in your accounting table, as that is what you have configured. If you can tell us what you are trying to achieve we will be able to make sensible suggestions. regards Hugh On 2

Re: [RADIATOR] Accounting records are not written to database

2012-11-01 Thread rohan.henry
Thanks Michael, I was able to go further with the advice using the AuthByPolicy and AuthBy GROUP under the existing Handler. Only that two records are added to my accounting database for a single session - one at Start and one at Stop. AddToRequest SERVICESTATUS = ACTIVE Sess

Re: [RADIATOR] Accounting records are not written to database

2012-11-01 Thread Michael
Looks like your "AuthBy xDSL" is accepting, therefore since the default AuthByPolicy is ContinueWhileIgnore, it will stop at the xDSL authby and the "AuthBy SQLAccounting" is not processed. I personally handle accounting in a separate handler. To me, handling accounting and authorization in t

Re: [RADIATOR] Accounting records are not written to database

2012-11-01 Thread rohan.henry
Hugh, Config and logs attached. And the application crashed when testing Simultaneous-Use for both configurations below. In my AuthBy config: "DefaultSimultaneousUse 1" With "AuthAttrDef Simultaneous-Use,Simultaneous-Use,check" Or In my Handler: MaxSessions 1 On Fri, 2 Nov 2012 07:19

Re: [RADIATOR] Accounting records are not written to database

2012-11-01 Thread Hugh Irvine
Hello Rohan - We will need to see the configuration file (no secrets) together with a trace 4 debug showing what is happening. regards Hugh On 2 Nov 2012, at 05:53, wrote: > Hello, > > Why doesn't the following work? > > > Identifier SQLAccounting > DBSource dbi:mysql:inetdb_test >

[RADIATOR] Accounting records are not written to database

2012-11-01 Thread rohan.henry
Hello, Why doesn't the following work? Identifier SQLAccounting DBSource dbi:mysql:inetdb_test DBUsername inet DBAuth inet@inetdb #Disable SQL authentication AuthSelect HandleAcctStatusTypes Start,Stop AccountingTable ARCH_ACCOUNTING AcctColumnDef USER_NAME,User-Name AcctColumnDef ACCT_START_TIM

Re: [RADIATOR] Accounting into microsoft SQL server

2011-09-09 Thread Hugh Irvine
Hello Nuno - Try something like this: AuthByPolicy ContinueAlways …… # disable authentication AuthSelect # set up accounting AccountingTable ….. …… Identifier PEAP

[RADIATOR] Accounting into microsoft SQL server

2011-09-09 Thread Nuno Marques
Hello, I have this two realms which successfully authenticate and both record accounting into a local file. What I wish do to is that the radiator sends the accounting information directly into SQL server. I’ve tried many “personal possible solutions” but ended up discovering that the commands

Re: [RADIATOR] Accounting process dying

2011-01-28 Thread Christian Kratzer
Hi Jim, On Fri, 28 Jan 2011, Jim wrote: > Thanks that's was very useful. I have done some more debugging and its > apparent that whenever the process dies the last thing it was doing was a SQL > update to a MS-SQL server. Doing some digging and it looks like we are > connecting to MS-SQL via

Re: [RADIATOR] Accounting process dying

2011-01-28 Thread Jim
Heikki Vatiainen wrote: On 01/27/2011 05:48 PM, Jim wrote: We are running separate processes for Radius accounting and authentication, and each is running with 'FarmSize 4'. For the accounting I'm seeing: Thu Jan 27 15:04:57 2011: WARNING: Server farm process 31432 died, restarting Thu

Re: [RADIATOR] Accounting process dying

2011-01-27 Thread Heikki Vatiainen
On 01/27/2011 05:48 PM, Jim wrote: > We are running separate processes for Radius accounting and > authentication, and each is running with 'FarmSize 4'. For the > accounting I'm seeing: > > Thu Jan 27 15:04:57 2011: WARNING: Server farm process 31432 died, > restarting > Thu Jan 27 15:04:57

[RADIATOR] Accounting process dying

2011-01-27 Thread Jim
Hi, We are running separate processes for Radius accounting and authentication, and each is running with 'FarmSize 4'. For the accounting I'm seeing: Thu Jan 27 15:04:57 2011: WARNING: Server farm process 31432 died, restarting Thu Jan 27 15:04:57 2011: DEBUG: Forking server farm instance 1

Re: [RADIATOR] Accounting by SQL and Authentication by ADSI

2010-07-08 Thread Heikki Vatiainen
On 07/08/2010 02:18 PM, adrian wrote: > I want to authenticate my users using ADSI and Record all the acounting > Data in an SQL server. The authentication work well but i can not > record the accounting data. Below are a portion of my radius.cfg. > > > > BindStringLDAP://cn=%0,cn=Users,dc=mizo

[RADIATOR] Accounting by SQL and Authentication by ADSI

2010-07-08 Thread adrian
Hi: I want to authenticate my users using ADSI and Record all the acounting Data in an SQL server. The authentication work well but i can not record the accounting data. Below are a portion of my radius.cfg. BindStringLDAP://cn=%0,cn=Users,dc=mizona,dc=iasprueba,dc=com # Adju

Re: (RADIATOR) Accounting Local and forwarding using rewriteusername problems

2003-10-09 Thread Hugh Irvine
Hello Sergio - You will need to use an AuthBy GROUP with the RewriteUsername inside: AuthByPolicy ContinueAlways AuthBy authBySQL_InsertCallAcct AcctLogFileName %L/radiusd_acct-%Y%m%d.log RewriteUsername s/^([EMAIL PROTECTED]).*/$1/

(RADIATOR) Accounting Local and forwarding using rewriteusername problems

2003-10-09 Thread Sergio Gómez \(E-mail\)
Hi everybody, I have problems using Local and forwarding accounting. First of all here you have a piece of mi cfg file for the 'test' realm: Identifier authBySQL_InsertCallAcct DBSource dbi:ODBC:radius_databasex DBUsername testuser DBAuth testpass

Re: (RADIATOR) Accounting Question

2003-01-25 Thread Hugh Irvine
2 arguments EG -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hugh Irvine Sent: Friday, 24 January 2003 4:08 PM To: Chris Kay Cc: [EMAIL PROTECTED] Subject: Re: (RADIATOR) Accounting Question Hello Chris - The simplest way to do this is with

RE: (RADIATOR) Accounting Question

2003-01-24 Thread Chris Kay
Is there a way to do this with 2 arguments EG > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Hugh Irvine > Sent: Friday, 24 January 2003 4:08 PM > To: Chris Kay > Cc: [EMAIL PROTECTED] > Subject: Re: (RADIATOR

Re: (RADIATOR) Accounting Question

2003-01-23 Thread Hugh Irvine
Hello Chris - The simplest way to do this is with Handlers: . . Note that you should not mix Realms and Handlers in the same configuration file. regards Hugh On Friday, Jan 24, 2003, at 13:12 Australia/Melbourne, Chris Kay wrote: Question I have is this I am wanting to kn

(RADIATOR) Accounting Question

2003-01-23 Thread Chris Kay
Question I have is this I am wanting to know if there is a hook or something that could be made to ignore account from a certain NAS-IP With a supplier I have accounting records coming from the NAS and a Proxy, I would just like to keep the accounting records from the Proxy.. So if IP address d

Re: (RADIATOR) accounting without authentication can't write data to postgres

2003-01-23 Thread Ayotunde Itayemi
d have thought the SQL statement would fail altogether ! Regards, Tunde Itayemi. - Original Message - From: "Hugh Irvine" <[EMAIL PROTECTED]> To: "Dennis Methelev" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 11:07 AM S

Re: (RADIATOR) accounting without authentication can't write datato postgres

2003-01-23 Thread Dennis Methelev
Hugh Irvine wrote: Hello Dennis - Thanks for sending the configuration file and the debug trace. It looks to me like there is an error occuring with your SQL server due to the contents of the attributes you are trying to record. You should check the SQL server log to see what is happening. r

Re: (RADIATOR) accounting without authentication can't write data to postgres

2003-01-23 Thread Hugh Irvine
Hello Dennis - Thanks for sending the configuration file and the debug trace. It looks to me like there is an error occuring with your SQL server due to the contents of the attributes you are trying to record. You should check the SQL server log to see what is happening. regards Hugh On We

(RADIATOR) accounting without authentication can't write data to postgres

2003-01-22 Thread Dennis Methelev
hi, all! my radiator can't record accounting requests to postgres database. in AuthSelect sets without 'select' statement (as seen in reference) - authentication not need. please help. radiator 3.5 (test use) [config fragment] Identifier SQLVOIPACCOUNTING DBSourcedb

Re: (RADIATOR) accounting double up avoidance

2002-11-18 Thread Hugh Irvine
Hello Brad - This is a difficult problem, however, accounting records with a non-zero Acct-Delay-Time attribute will have the "Timestamp" attribute automatically corrected (ie. the Timestamp reflects the time the event occured, not the time it was sent). You should be able to use this fact in

(RADIATOR) accounting double up avoidance

2002-11-17 Thread Mike McCauley
-- Forwarded Message -- Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from ["Brad Lilly" <[EMAIL PROTECTED]>] Date: Sun, 17 Nov 2002 18:23:04 -0600 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] >From [EMAIL PROTECTED] Sun Nov 17 18:23:04 2002 Received: from pc-0

Re: (RADIATOR) Accounting Log file format

2002-11-06 Thread Hugh Irvine
Hello Shan - You would use an AcctFileFormat specification in your Realm or Handler. Section 6.16.5 in the Radiator 3.3.1 reference manual ("doc/ref.html"). Alternatively you could write a hook to do the same thing. regards Hugh On Thursday, November 7, 2002, at 03:14 PM, Mike McCauley wro

(RADIATOR) Accounting Log file format

2002-11-06 Thread Mike McCauley
-- Forwarded Message -- Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [S H A N <[EMAIL PROTECTED]>] Date: Wed, 6 Nov 2002 17:14:25 -0600 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] >From [EMAIL PROTECTED] Wed Nov 6 17:14:24 2002 Received: from smtp12.sin

Re: (RADIATOR) Accounting Handled

2002-08-22 Thread Hugh Irvine
Hello Ray - Your configuration file looks OK. You will see the microseconds logged in the timestamps in the trace 4 debug so you can see how long each operation is taking. This will give you a good idea where things are slow. regards Hugh On Thursday, August 22, 2002, at 09:36 AM, [EMAIL

(RADIATOR) Accounting Handled

2002-08-22 Thread rcortez
Hi, I have configured Accounting Handled and also LogMicroseconds under the Global Parameter Realm this is how it goes. Foreground AuthPort 1645 AcctPort 1646 LogDir /data/LOGFILE LogFile %L/%Y-%m-%d-%H-logfile.log DbDir /usr/local/etc/raddb Trace 4 SocketQueueLength 100 LogMicroseco

(RADIATOR) Accounting Handled

2002-08-19 Thread rcortez
Hi, Where can we put the accounting handled parameter is it on the authby clause? Can i have a sample config on how to implement it. Ray === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubsc

Re: (RADIATOR) Accounting Handled

2002-08-19 Thread Hugh Irvine
Hello Ray - The AccountingHandled parameter just causes an Accounting-Respnse to be sent immediately. You will still receive all accounting requests sent to this Radiator instance. regards Hugh On Monday, August 19, 2002, at 05:13 PM, [EMAIL PROTECTED] wrote: > Hi, > > > > On Accoun

(RADIATOR) Accounting Handled

2002-08-19 Thread rcortez
Hi, On Accounting Handled parameters can I still get an accounting stop? Is the Accounting Handled parameter is only use for retransmission request? Ray === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]

(RADIATOR) Accounting Keep Alives

2002-08-04 Thread Radius Admin
How do I send Accounting Keep Alives to a NAS? How is this implemented in Radiator?   Thanks  

(RADIATOR) Accounting SQL Question

2002-04-24 Thread Tony Bunce
Hello,       I’m kinda stumped on a problem and I was hoping that someone here could help.   He is what I want to do. I want to be able to, from the accounting table, figure out what user was on at a given time with a given ip address.   Here is the valid part of the conf:  

Re: (RADIATOR) "Accounting On"

2002-04-18 Thread Hugh Irvine
Hello Andreas - What you describe should already happen automatically. Could you please send me a copy of your configuration file (no secrets) together with a trace 4 debug showing what happens currently. thanks Hugh On Thu, 18 Apr 2002 18:44, Andreas Häggander wrote: > Hi ! > > We are usi

(RADIATOR) "Accounting On"

2002-04-18 Thread Andreas Häggander
Hi ! We are using Radiator for IPSec-VPN Clients connecting towards a Nortem BSN 5000 (Also callaed Shasta). We are also using a sessiondatabase (MySql) to make sure that a user can´t connect more than twice. If the Shasta are restarted or something happens and it reboots, there is no Stop-

Re: (RADIATOR) Accounting Data

2002-03-19 Thread Hugh Irvine
Hello Shane - You can use ODBC in an AuthBy SQL clause to write to any ODBC database including Access. Have a look at section 23.7 in the Radiator 2.19 reference manual. regards Hugh On Tue, 19 Mar 2002 09:49, Shane Malden wrote: > I have just started to record Accounting Data sent from ou

(RADIATOR) Accounting Data

2002-03-18 Thread Shane Malden
I have just started to record Accounting Data sent from our NAS to a flat file. Is it possible to store this into a MDB (MS Access) file or is it only possible to SQL? I am interested in running reports on this Data to see who uses it the most, Time and Data wise. Our Systems are all NT so anyo

Re: (RADIATOR) Accounting of NT authentication request

2002-03-18 Thread Hugh Irvine
Hello Gionata - I am not sure I understand your question. Even if you are using an clause for authentication, you can still write the accounting packets to a file or database. regards Hugh On Tue, 19 Mar 2002 03:10, [EMAIL PROTECTED] wrote: > Hi all, > in version 2.18 there is not the po

(RADIATOR) Accounting of NT authentication request

2002-03-18 Thread gionata . lamia
Hi all, in version 2.18 there is not the possibility to log the accounting of authentication request from . Is this function enable in the new release ? Thanks Gionata Lamia Networking Services/Systems Integrations T-Systems Italia S.p.A. Strada 2 Palazzo D 20090 - Assago - MI Phone: +39 02 892

Re: (RADIATOR) Accounting logs problem

2002-02-21 Thread Hugh Irvine
Hello Merad - It is usually easier to do this sort of thing with Handlers instead of Realms. Something like this: # define separate Handlers for accounting and authentication # do accounting . # do authentication . regards Hugh On Wed,

(RADIATOR) Accounting logs problem

2002-02-20 Thread Merad Abdelkrim
Hi all, I have a radiator version 2.18.4 installed on an OpenBSD 2.7. I have Realms authenticated by LDAP For that I use the rewriteUsername feature. My problem is that in the accounting logs I don't have the field "login@realm" but only "login" It's a bloquing problem cause we must make account

(RADIATOR) Accounting information not sent?

2002-01-22 Thread Wakefield, Jayanne M.
I have been unable for Radiator to pass a static ip address to the dialin client through a Cisco router. I've looked at cisco.com and in the Radiator archives to find out why this might be. I've included a trace from the connection. It appears that the IP address information is there during the

Re: (RADIATOR) accounting log format

2002-01-14 Thread Hugh Irvine
Salut Merad - Ca va la vie? On Tue, 15 Jan 2002 03:55, [EMAIL PROTECTED] wrote: > Hi, > I have a Radiator 2.18.4 installed on an OpenBSD. > I have a realm authenticated by LDAP2. > To make this, I had to use the RewriteUsername to strip the Realm before > send it to the LDAP. > My problem is th

(RADIATOR) accounting log format

2002-01-14 Thread abdelkrim . merad
Hi, I have a Radiator 2.18.4 installed on an OpenBSD. I have a realm authenticated by LDAP2. To make this, I had to use the RewriteUsername to strip the Realm before send it to the LDAP. My problem is that in the accounting logs the realm doesn't appear. I only get the login which is a problem f

Re: (RADIATOR) Accounting responses.

2001-10-02 Thread Hugh Irvine
Hello Ian - On Tuesday 02 October 2001 17:51, Ian Burgess wrote: > Hi > > I have got involved in a radiator config. Everything is running. We are > adding more network functionality (DSL) connections. > > The Telco insists that the Accounting response to the stop record have > certain attributes

(RADIATOR) Accounting responses.

2001-10-02 Thread Ian Burgess
Hi I have got involved in a radiator config. Everything is running. We are adding more network functionality (DSL) connections. The Telco insists that the Accounting response to the stop record have certain attributes reflected back to him. (this is for a billing reason not a technical reason)

Re: (RADIATOR) Accounting Table

2001-09-24 Thread Hugh Irvine
Hello GwangHee - I will need to see a trace 4 debug from Radiator showing what is happening. thanks Hugh On Tuesday 25 September 2001 07:10, GwangHee Yi wrote: > Dear, > > I want to store cdr into mysql accounting table without authentication. > I changed a little bit from sql.cfg. > I have

(RADIATOR) Accounting Table

2001-09-24 Thread GwangHee Yi
Dear, I want to store cdr into mysql accounting table without authentication. I changed a little bit from sql.cfg. I have generated tables with mysqlCreate.sql When I run radius, I got exact log file but accounting table is empty. What's wrong? The below is configuration. Thanks,

Re: (RADIATOR) Accounting Start-Stops

2001-09-20 Thread Hugh Irvine
Hello Jaime - Just use an AccountingStopsOnly in your AuthBy SQL clause. AccountingStopsOnly .. Have a look at section 6.28.12 in the Radiator 2.18.4 reference manual. regards Hugh On Thursday 20 September 2001 22:22, Jaime Elizaga Jr.

(RADIATOR) Accounting Start-Stops

2001-09-20 Thread Jaime Elizaga Jr.
Hi Everyone,   We are currently running Radiator 2.18.4 with MySQL.    I do notice that with ACCOUNTING, there are two records generated for every user session, one is when the user connects and the other is when it the user disconnects. In just a small amount of time, our accounting databa

Re: (RADIATOR) accounting on radiator

2001-09-19 Thread Hugh Irvine
Hello Lloyd - I am not sure I understand your question - could you give me a bit more detail please? thanks Hugh On Wednesday 19 September 2001 16:06, lloyd dagoc wrote: > hello, > have a question, if we are proxying to another radius server and we want to > have accounting on us, do we hav

(RADIATOR) accounting on radiator

2001-09-18 Thread lloyd dagoc
hello, have a question, if we are proxying to another radius server and we want to have accounting on us, do we have to forward accounting to them before proxying of not? which is better (forward accounting or not) if we are proxying to another server ? thanks so much lloyd dagoc === Archive

Re: (RADIATOR) Accounting-Response - While we're on the topic...

2001-09-05 Thread Hugh Irvine
Hello Brian - Radiator will normally send an Accounting-Response for every Accounting-Request received from the NAS. You can check pretty easily by looking at a trace 4 debug from Radiator and verifying the requests received and the replies sent. regards Hugh At 10:31 +1000 01/9/5, Brian

(RADIATOR) Accounting-Response - While we're on the topic...

2001-09-04 Thread Brian Morris
We have configured our sql servers accounting table to reject duplicate accounting records by setting the username+acctsessionid+sessiontime to be the primary key (no duplicates permitted) When the NAS sends a duplicate accounting record, sql/radiator spits out an error and does not write the pa

(RADIATOR) accounting file nonexistant

2001-07-27 Thread Laramie Combs
Hello all, I recently upgraded my Radiator Authentication server to Redhat 7.0 from Redhat 6.2, and at the same time I upgraded the Radiator package to the latest version (2.18.2) via the RPM from open.com.au. Authentication is working just as well as ever, but my accounting details file is no

Re: (RADIATOR) Accounting

2001-07-02 Thread Hugh Irvine
Hello Javaid - In your situation, I would use DBI and DBD-Sybase, plus the free version of Sybase for Linux (www.sybase.com). This is the best approach because MS-SQL is just a rebadged Sybase and the Sybase client libraries can connect just fine. Note that you do not need to log in to the N

Re: (RADIATOR) Accounting

2001-07-02 Thread jsajjad
Hi Hugh, Things are confusing here.How could we logon into a NT machine database (having MS SQL databse) directly from Linux radiator only by defining hostname and database in DBSource clause.As on first level a NT host requires its admin passwd for remote logon and then in second level we could

Re: (RADIATOR) Accounting

2001-07-02 Thread Hugh Irvine
Hello Javaid - You will find most Perl modules at www.cpan.org and you will need to install DBD, DBD for your database, and the database client libraries on the Radiator host. The database host will already have all libraries installed when the database was installed. hth Hugh A

Re: (RADIATOR) Accounting

2001-07-01 Thread jsajjad
Hi Hugh, After configuring DBSource parameters, my radiator gives the error message "unknown DBSource in radius.cfg" while starting radiusd. May be my installed DBD and DBI modules are not working properly.Would you let me know the authentic web site for those perl modules for downloading and als

Re: (RADIATOR) Accounting

2001-06-30 Thread Hugh Irvine
Hello Javaid - At 15:43 +0500 01/6/30, <[EMAIL PROTECTED]> wrote: >Hi every body, > >I need to know the procedure for how radiator's Accounting logs could be >transfered to another server like MS SQL Server ie i am not interested in >saving accounting logs in local database like oracle , mysql o

(RADIATOR) Accounting

2001-06-30 Thread jsajjad
Hi every body, I need to know the procedure for how radiator's Accounting logs could be transfered to another server like MS SQL Server ie i am not interested in saving accounting logs in local database like oracle , mysql onto the same machine on which radiator is installed.So how remote databas

Re: (RADIATOR) Radiator Accounting Thru MS SQL Server

2001-06-26 Thread Hugh Irvine
Hello Javaid - The usual approach is to use the free version of Sybase for Linux, and configure Radiator with an AuthBy SQL clause together with DBI and DBD-Sybase. You will find further information in sections 6.26 and 23.0 in the Radiator 2.18.2 reference manual. This topic has also been d

(RADIATOR) Radiator Accounting Thru MS SQL Server

2001-06-26 Thread jsajjad
Hi all, Would anybody kindly let me guide the tips and procedure for how to configure Radiator Server on Linux box 6.2 for sending users' Accounting logs to MS SQL Server Machine. Would i have to install some additioanal software or Radiator itself provides the feature/facility for this task. L

Re: (RADIATOR) accounting flat file to CSV ?

2001-04-19 Thread Mariano Absatz
Hi Neale, It's an awful thing to do since the CSV "column names" are "embedded" in the original file and fields are non positional, and some records have more fields than others... I'm answering (late, since I haven't read the list for quite a few days), cause I made a perl script some time a

Re: (RADIATOR) Accounting-Response problem

2001-04-09 Thread Hugh Irvine
Title: Re: (RADIATOR) Accounting-Response problem Hello Ganbold - I will need to see a trace 4 debug from Radiator showing what is happening. thanks Hugh At 19:11 +0800 01/4/9, ganbold wrote: Hi,   I have problem with Radiator-2.18 in FreeBSD 4.0. All modules installed. All is working

(RADIATOR) Accounting-Response problem

2001-04-09 Thread ganbold
Hi,   I have problem with Radiator-2.18 in FreeBSD 4.0. All modules installed. All is working fine except Radiator is not sending accounting-response after receiving accounting-request from NAS. Here is my radiator config file. #

(RADIATOR) Accounting-Response problem

2001-04-09 Thread ganbold
Hi,   I have problem with Radiator-2.18 in FreeBSD 4.0. All modules installed. All is working fine except Radiator is not sending accounting-response after receiving accounting-request from NAS. Here is my radiator config file.

Re: (RADIATOR) accounting flat file to CSV ?

2001-04-09 Thread Hugh Irvine
Hello Neale - Have you had a look in the goodies directory to see if there is anything there? Otherwise I am sure someone on the list has done this at lease once. regards Hugh At 13:45 +1000 01/4/9, Neale Banks wrote: >G'day Hugh, > >On Fri, 6 Apr 2001, Hugh Irvine wrote: > >> Hello Neale

Re: (RADIATOR) Accounting data not going anywhere!

2001-04-09 Thread Hugh Irvine
Hello Jamz - Could you please send me the name of the registered owner of the company that purchased this copy of Radiator? thanks very much regards Hugh At 17:50 +0930 01/4/9, [EMAIL PROTECTED] wrote: >Hello, > I am trying to configure Radiator to log accounting data to my >pos

(RADIATOR) Accounting data not going anywhere!

2001-04-09 Thread Jamz
Hello, I am trying to configure Radiator to log accounting data to my postgres database. The Authorization works fine, rejects and accepts okay. However no accounting data arrives in the named accounting table. If in my section I override the default accounting column names, I get an e

Re: (RADIATOR) accounting flat file to CSV ?

2001-04-08 Thread Neale Banks
G'day Hugh, On Fri, 6 Apr 2001, Hugh Irvine wrote: > Hello Neale - > > On Thursday 05 April 2001 10:15, Neale Banks wrote: > > Greetings all, > > > > Not exclusively Radiator-relevant, but probably RADIUS+Perl relevant... > > > > Does anyone have any pointer to anything to convert flat-file acc

Re: (RADIATOR) accounting flat file to CSV ?

2001-04-05 Thread Hugh Irvine
Hello Neale - On Thursday 05 April 2001 10:15, Neale Banks wrote: > Greetings all, > > Not exclusively Radiator-relevant, but probably RADIUS+Perl relevant... > > Does anyone have any pointer to anything to convert flat-file accounting > records to comma-separated format? > You can use the Acct

(RADIATOR) accounting flat file to CSV ?

2001-04-04 Thread Neale Banks
Greetings all, Not exclusively Radiator-relevant, but probably RADIUS+Perl relevant... Does anyone have any pointer to anything to convert flat-file accounting records to comma-separated format? Alternatively, any other solutions to the need to tabulate a user's STOP records to run some element

Re: (RADIATOR) Accounting Packets

2001-02-05 Thread Hugh Irvine
Hello Cassidy - Just to be clear about the Class attribute: the Class attribute is returned to a NAS in an Access-Accept (in response to an Access-Request). The Class attribute is then *always* (according to the RFC) included by the NAS in all subsequent accounting packets for that session.

(RADIATOR) Accounting Packets

2001-02-05 Thread Cassidy B. Larson
Howdy all! Once again I got a stumper that seems to be 'stumping' me.. I've been in the process of installing a new filtering box, XStop R2000.. they take the class attribute string and that determines what filtering settings a particular user gets (if any).. Problem being, they tell me that t

Re: (RADIATOR) Accounting log problem

2000-11-13 Thread Hugh Irvine
Hello Toni - I think your NAS is not correctly configured. The reason you don't see an accounting log is because you are not receiving any accounting packets from the NAS. hth Hugh On Tue, 14 Nov 2000, Toni Riekkinen wrote: > Hello, > > I've problem with accounting logs, I can't get any acco

(RADIATOR) Accounting log problem

2000-11-13 Thread Toni Riekkinen
Hello, I've problem with accounting logs, I can't get any accounting log at all, not in plain detail-file nor in our database. Authentication works just fine from users-file or database. I've Solaris 8 (5.8) and Oracle8i Release 2 (8.1.6). I've installed timeout patch. This is my current radius

Re: (RADIATOR) accounting

2000-11-10 Thread Hugh Irvine
Title: Re: (RADIATOR) accounting Hello Lina - At 10:50 +0100 00/11/10, Lina NAKHLE wrote: Hello, I have Radiator running on NT server and I'm using the AUTHBY LDAPSDK. I have couple of queries and I'm wondering if anybody can help me: 1) For billing purpose, I need to retrieve a fi

(RADIATOR) accounting

2000-11-10 Thread Lina NAKHLE
Title: accounting Hello, I have Radiator running on NT server and I'm using the AUTHBY LDAPSDK. I have couple of queries and I'm wondering if anybody can help me: 1) For billing purpose, I need to retrieve a field called 'CCAN' from LDAP and added to the accounting logs (the START and STOP

Re: (RADIATOR) Accounting

2000-10-12 Thread Ron Hensley
I get that from Connect-Info. I guess it would depend on what information your NAS is sending over, but a quick look with trace 4 of what information is getting sent from your NAS should show what Attribute has the information you want. I use this: AcctColumnDef CONNECTINFO,Connect-Info

  1   2   3   >