(RADIATOR) log start/stop time in ACCOUNTING table

1999-07-06 Thread Authur Lin
Hello, I want to log the start/stop time for each session in ACCOUNTING table. Please tell me how to do it ? (I use MySQL as SQL server) ... AcctColumnDef NASIPADDRESS,NAS-IP-Address AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef NASPORTTYPE,NAS-Port

Re: (RADIATOR) SNMP Counter logging

1999-07-06 Thread Karl Gaissmaier
Hi Leigh and Mike, Mike McCauley schrieb: > > Hi Leigh, > ... > 5. I have forwarded your message to a chap who I know has some _excellent_ SNMP > monitoring->mysql software with a web interface. Its about 3000 times better > than MRTG, highly configurable, with beautiful graphs, but I dont know

(RADIATOR) log start/stop time in ACCOUNTING table

1999-07-06 Thread Authur Lin
Hello, I want to log the start/stop time for each session in ACCOUNTING table. Please tell me how to do it ? (I use MySQL as SQL server) ... AcctColumnDef NASIPADDRESS,NAS-IP-Address AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef NASPORTTYPE,NAS-Port

Re: (RADIATOR) SNMP Counter logging

1999-07-06 Thread tom minchin
On Tue, Jul 06, 1999 at 09:38:10AM +0200, Karl Gaissmaier wrote: > Hi Leigh and Mike, > > Mike McCauley schrieb: > > > ... > > 5. I have forwarded your message to a chap who I know has some _excellent_ SNMP > > monitoring->mysql software with a web interface. Its about 3000 times better > > than

Re: (RADIATOR) SNMP Counter logging

1999-07-06 Thread Felix Izquierdo
Mike McCauley wrote: > 4. Some NASs send Acct-Status-Type=Alive accounting packets during the session. > 5. I have forwarded your message to a chap who I know has some _excellent_ SNMP > monitoring->mysql software with a web interface. Its about 3000 times better > than MRTG, highly configurable,

Re: (RADIATOR) SNMP Counter logging

1999-07-06 Thread tom minchin
On Tue, Jul 06, 1999 at 12:26:16PM +0200, Felix Izquierdo wrote: > Mike McCauley wrote: > > 4. Some NASs send Acct-Status-Type=Alive accounting packets during the session. > > 5. I have forwarded your message to a chap who I know has some _excellent_ SNMP > > monitoring->mysql software with a web

Re: (RADIATOR) log start/stop time in ACCOUNTING table

1999-07-06 Thread Mike McCauley
Hello Authur, The Timestamp attribute is set in each accounting request, with the time of the session start or stop, so you could add a TIME_STAMP integer column, and add this to your config: AcctColumnDef TIME_STAMP,Timestamp,integer Hope that helps. Cheers. On Jul 6, 4:05pm, Authur Lin

(RADIATOR) (Fwd) Re: Problem on Radius Server

1999-07-06 Thread Mike McCauley
If anyone has built MD5 on HPUX 10.10, can you tell what the problem is here? Does HPUX support loadable modukles, or do you gave to build a statically lined perl? Cheers. --- Forwarded mail from "Md. Yousuf Niaz" <[EMAIL PROTECTED]> Date: Wed, 07 Jul 1999 05:03:29 +0600 To: "Mike McCauley" <[

(RADIATOR) catch DBI/DBD result code

1999-07-06 Thread Thomas Voss
Hi, is there any way to catch the DBI/DBD result code from an AcctSQLStatement? We use Mysql for accounting and i'd like to have a table with traffic-values that are updated with every stop-record. It's no problem for Radiator to feed multiple tables when it receives one stop-record; i'm just us

(RADIATOR) PreAuthHook: add_attr -> can't call add_attr() on unblessed reference

1999-07-06 Thread Wilbert de Graaf
  I'm trying to add a name-value pair to a request just before authentication occurs. The documentation of radiator has an example:       PreAuthHook sub { $_[0]->add_attr('test-attr', 'test-value'); }         ...       Without the PreAuthHook, everything is working fine, but when

Re: (RADIATOR) Radiator as a NT Service

1999-07-06 Thread Malbanet
Hello; Well I made some minor adjustments following the reply below (one of the things I did was copy the folder "Radius" from c:\radiator\ to c:\perl\lib & c:\perl\site\lib ->> after I did that executing the command line that's in the register from the prompt "c:\>" worked). The Service starts O

RE: (RADIATOR) Radiator as a NT Service

1999-07-06 Thread Michael Gatti
Hello;Well I made some minor adjustments following the reply below (one of thethings I did was copy the folder "Radius" from c:\radiator\ to c:\perl\lib &c:\perl\site\lib ->> after I did that executing the command line that's inthe register from the prompt "c:\>" worked). The Service starts

Re: (RADIATOR) Run perl code to generate more accounting fields

1999-07-06 Thread John Coy
This worked beautifully, thank you. Here's the snippet of my radiusd.cfg file for future reference: # # AuthBy Clause for *accounting packets only* with custom # insert statement to calculate the LOGIN_TIME column in my RADIUS # table. # # # Disable authenticatio

Re: (RADIATOR) catch DBI/DBD result code

1999-07-06 Thread Mike McCauley
Hi Thomas. If you want to do anything more complicated that run a single unconditional SQL statment, then AcctSQLStatement is not for you. You will probably have to set up a PostAuthHook that does exactly what you want. Cheers. On Jul 6, 2:25pm, Thomas Voss wrote: > Subject: (RADIATOR) catch

Re: (RADIATOR) PreAuthHook: add_attr -> can't call add_attr() on unblessed reference

1999-07-06 Thread Mike McCauley
Hello Wilbert, On Jul 6, 8:59pm, Wilbert de Graaf wrote: > Subject: (RADIATOR) PreAuthHook: add_attr -> can't call add_attr() on unbl > > > I'm trying to add a name-value pair to a request just before authentication occurs. The documentation of radiator has an example: > > > PreAuthHook sub

(RADIATOR) filters

1999-07-06 Thread Mike McCauley
Hi, everybody, i got one big problem, i would like you to help me to solve it. The problem: I have three NASs , an ascend 4060 with firmware v 7.0.4, a baynetworks rac 8000, and shiva lanrover xp16. and i need to create a filter that works like this: When I add an user to a UNIX group, that user

Re: (RADIATOR) filters

1999-07-06 Thread Mike McCauley
Actually, this was forwarded by me from Gustavo. Now I will also answer it! On Jul 7, 1:42pm, Mike McCauley wrote: > Subject: (RADIATOR) filters > > Hi, everybody, i got one big problem, i would like you to help me to solve > it. > The problem: > I have three NASs , an ascend 4060 with firmware

Re: (RADIATOR) SNMP Counter logging

1999-07-06 Thread Craig Sanders
On Tue, Jul 06, 1999 at 11:23:04AM -0500, Mike McCauley wrote: > 3. Counters rolling over is not uncommon. Ciscos roll over at 32 bits, > other, I dont know. does anyone know of a way of terminating dialin sessions (async or isdn) to a cisco as5200 which *doesn't* stop the cisco from sending the

Re: (RADIATOR) SNMP Counter logging

1999-07-06 Thread tom minchin
On Wed, Jul 07, 1999 at 03:47:52PM +1000, Craig Sanders wrote: > On Tue, Jul 06, 1999 at 11:23:04AM -0500, Mike McCauley wrote: > > > 3. Counters rolling over is not uncommon. Ciscos roll over at 32 bits, > > other, I dont know. > > does anyone know of a way of terminating dialin sessions (async

Re: (RADIATOR) SNMP Counter logging

1999-07-06 Thread Richi Plana
Hi, On Wed, 7 Jul 1999, Craig Sanders wrote: |o| > 3. Counters rolling over is not uncommon. Ciscos roll over at 32 bits, |o| > other, I dont know. |o| |o| does anyone know of a way of terminating dialin sessions (async or |o| isdn) to a cisco as5200 which *doesn't* stop the cisco from |o| send