Re: (RADIATOR) RadOnLine

2003-06-25 Thread Nicolai van der Smagt
Hello, To do what you want you add this to your clause: AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \ ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, \ SERVICETYPE, STATIONID) values ('%n', '%N', 0%{NAS-Port},\ '%{Acct-Session-Id}', %{Timestamp}, '%{Framed-IP-Addre

RE: (RADIATOR) RadOnLine

2003-06-25 Thread Herman verschooten
Nicolai, I see. Now a question... Can you specify a different SessionDatabase per client or realm ? Herman verschooten -Original Message- From: Nicolai van der Smagt [mailto:[EMAIL PROTECTED] Sent: woensdag 25 juni 2003 20:12 To: Herman verschooten Cc: [EMAIL PROTECTED] Hello, To do

Re: (RADIATOR) RadOnLine

2003-06-25 Thread Hugh Irvine
Hello Herman - Yes you can have different SessionDatabase's on a per-Handler or per-Realm basis. # define SessionDatabase Identifier SDB1 . Identifier SDB2 . . SessionDatabase SDB1 . SessionDatabase SDB2 ...

Re: (RADIATOR) Radonline question

2003-06-09 Thread Hugh Irvine
Hello Lin - You can use different Session Databases for the different Handlers: Identifier NULLSDB Identifier SQLSDB SessionDatabase NULLSDB SessionDatabase SQLSDB . regards Hugh On Tuesday, Jun 10, 2003, at 12:

Re: (RADIATOR) RADONLINE Crashing

2001-04-30 Thread Hugh Irvine
Hello Mustafa - The log message below shows that your SQL server is timing out and Radiator is marking it down and waiting some period of time before trying to use it again. You will have to investigate why the SQL server is so busy that it is not able to respond to any queries. regards Hug

Re: (RADIATOR) RADONLINE Crashing

2001-04-30 Thread mick
I am guessing you are using microsoft sql server. My suggestion would be to delete your table every night Michael Saunders - Original Message - From: Mustafa Mal <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 30, 2001 11:41 PM Subject: (RADIATOR) RADONLINE Crashing >

Re: (RADIATOR) RADONLINE Crashing

2001-05-01 Thread Mustafa Mal
I investigate the timeout. And how can this be rectified? Thanks for your reply. Mustafa - Original Message - From: "Hugh Irvine" <[EMAIL PROTECTED]> To: "Mustafa Mal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, 01 May 2001 12:4

Re: (RADIATOR) RADONLINE Crashing

2001-05-01 Thread Hugh Irvine
Database. > > Can you suggest how can I investigate the timeout. And how can this > be rectified? > > Thanks for your reply. > > Mustafa > > > > - Original Message - > From: "Hugh Irvine" <[EMAIL PROTECTED]> > To: "Mustafa Ma

Re: (RADIATOR) RADONLINE Table ?

2001-07-03 Thread Hugh Irvine
Title: Re: (RADIATOR) RADONLINE Table ? Hello Chairarth - The problem you describe below is due to the NAS not sending the NAS-Port attribute in the accounting stop record. There are two things you can do. First, you should lodge a bug report with your NAS vendor and get the problem fixed

Re: (RADIATOR) RADONLINE Table ?

2001-07-03 Thread chairarth
Hi Hugh, It's ok! Thanks for your kindly help.   Chairath Hugh Irvine wrote:  Hello Chairarth - Here is the hook:  # -*- mode: Perl -*-# addNASPort## PreClientHook to add NAS-Port attribute# # Author: Hugh Irvine ([EMAIL PROTECTED])# Copyright (C) 2001 Open System Consultants# sub {     my $p =

Re: (RADIATOR) Radonline check

2002-02-21 Thread Hugh Irvine
Hello Tuan Anh - > > Does any one know how to refine this problem : > After logout, record in radonline that belong to user was not deleted for > some reason. when user login again SNMP program will be run to check > Simultaneous-Use. User not found on that port and accepted. > But t

Re: (RADIATOR) RADONLINE cleanup script

2003-06-10 Thread Ayotunde Itayemi
HI Ingvar, I assume this script will work with an Oracle DB. My question is do all NASes send alive packets - even Windows 2000 servers using RADIUS authentication? A related question: I have a couple of Windows 2000 servers with multiple IP addresses. I have noticed that I have to manually delet

Re: (RADIATOR) RADONLINE Session Table

2001-06-10 Thread Hugh Irvine
Hello JC - I would suggest checking a trace 4 debug from Radiator and/or using a sniffer (or snoop/tcpdump/whatever) to see what is hapening on the wire. You might also try turning on some debugging on your NAS. Keep in mind that this sort of problem is usually due to congested links and (so

Re: (RADIATOR) Radonline stop error.

2000-03-20 Thread Hugh Irvine
Hello Okan - On Tue, 21 Mar 2000, OKAN ARISU wrote: > Hi Everbody, > > We use Cisco 5300 and Radiator 2.14.1. And also we use the RAS of Telecom of Goverment which is forwarding the dialup reguest from different city of our country to our Radiator. They authenticate and write the 'start' reco

Re: (RADIATOR) radonline missing entries?

2000-10-11 Thread Hugh Irvine
Hello Charles - On Thu, 12 Oct 2000, Charles Sprickman wrote: > Hi, > > I'm seeing some people, seemingly randomly, missing from my radonline > db. These same folks are in my accounting records. Both log to the same > mysql db: > > (accounting) > user ip nasipty

Re: (RADIATOR) radonline missing entries?

2000-10-12 Thread Charles Sprickman
On Thu, 12 Oct 2000, Hugh Irvine wrote: > > At trace 3, I see no oddities associated with this > > username. Any ideas how to track this down?? > > Yes - use trace 4 and watch what happens. I knew you'd say that :) Found my problem: -MySQL session db definition Identifier SDB_mysq

Re: (RADIATOR) radonline missing entries?

2000-10-12 Thread Hugh Irvine
Hello Charles - On Fri, 13 Oct 2000, Charles Sprickman wrote: > On Thu, 12 Oct 2000, Hugh Irvine wrote: > > > > At trace 3, I see no oddities associated with this > > > username. Any ideas how to track this down?? > > > > Yes - use trace 4 and watch what happens. > > I knew you'd say that

Re: (RADIATOR) RADONLINE problems. No queries.

2003-07-28 Thread Hugh Irvine
Hello Charles - Your configuration file is incorrect - it should look like what is shown below (note the Realm clause at the end). regards Hugh #Foreground #LogStdout LogDir /var/adm/radacct DbDir /etc/raddb SnmpgetProg /usr/local/bin/snmpget Trace 4 RewriteUsername s/^([EMAIL PROTEC

Re: (RADIATOR) RADONLINE problems. No queries.

2003-07-29 Thread Charles Alexander McCain
Hugh, That seems to have fixed it. However, i see this now. Tue Jul 29 08:0

Re: (RADIATOR) RADONLINE problems. No queries.

2003-07-29 Thread Hugh Irvine
Hello AL - This is either due to an error in a PreHandlerHook, or your ClientListSQL is returning bogus data for the PREHANDLERHOOK column in the database. If you are not using some of the fields you should change the GetClientQuery and replace the fields you are not using with NULL's. See sec

Re: (RADIATOR) Radonline Insert into problem

2001-06-14 Thread Hugh Irvine
Hello Mohammed - I would suggest that you simplify your configuration file and remove all the commented lines. You should also keep the line lengths fairly short and make sure the continuations are correct ("\"). hth Hugh On Thursday 14 June 2001 23:01, Mohammed Adam wrote: > Hello > > I'm

Re: (RADIATOR) Radonline flushing every 2 hours

2002-02-26 Thread Hugh Irvine
Hello Anton - Please send me a copy of your configuration file (no secrets) together with a trace 4 debug showing what is happening. Radiator will automatically remove all entries for a NAS if it sees a NAS restart, but I can't think of any reason why the entire RADONLINE table would be clea

RE: (RADIATOR) Radonline flushing every 2 hours

2002-02-26 Thread Frank Danielson
ailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 5:33 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: (RADIATOR) Radonline flushing every 2 hours Hello Anton - Please send me a copy of your configuration file (no secrets) together with a trace 4 debug showing what is happ

RE: (RADIATOR) Radonline flushing every 2 hours

2002-02-26 Thread Anton Krall
2002 06:47 p.m. Original > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Original > Subject: RE: (RADIATOR) Radonline flushing every 2 hours Original > Original > Original > Hugh- Original > Original > For general education purposes could you elaborate Original > on Radiator

Re: (RADIATOR) Radonline flushing every 2 hours

2002-02-28 Thread Hugh Irvine
[EMAIL PROTECTED] > web: http://www.mx.inter.net > > Outside Mexico: > Office: +52(555)241-7609 > PBX: +52(555)241-7600 > Mobile: +52(555)105-5160 > > > Original > -Original Message- > Original > From: [EMAIL PROTECTED] > Original > [mailto:[

RE: (RADIATOR) Radonline flushing every 2 hours

2002-02-28 Thread Ronan Eckelberry
6 February, 2002 19:47 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: (RADIATOR) Radonline flushing every 2 hours Hugh- For general education purposes could you elaborate on Radiator clearing entries for a NAS if it sees a NAS restart? I'm not sure how Radiator would detect that ev

Re: (RADIATOR) RADONLINE not showing IP addresses?

1999-11-15 Thread Aaron Holtz
Jay, You need something like: aaa accounting update newinfo in your cisco. Radiator will process the 'Alive' packet that this command generates and that includes the Framed Address the user got. There was a start delay command as well offered here earlier, but I don't recall the exac

Re: (RADIATOR) Radonline showing different timestamp to Accounting

2000-11-24 Thread Hugh Irvine
Hello Raymond - Can you send us a trace 4 showing what is going on? thanks Hugh On Fri, 24 Nov 2000, Raymond Brighenti wrote: > Hi, > > I've had Radiator Auth/Acc to a MySQL database for a while now and > everything's been fine timstamp wise, so I just thought I'd also > use SessionDataba

Re: (RADIATOR) RADONLINE nevering showing more that one person

2000-12-08 Thread Hugh Irvine
Hello Ken - At 11:25 -0500 8/12/00, Ken Sain wrote: >radiator 2.17.1 and radmin 2.14 on slack7.1(kernel 2.2.16) mysql 3.22.32 and >cisco 5300 VoIP. > >seems that when a second person calls in, they never appear in 'Current >Session' from Radmin. i get an error while inserting the record into th

Re: (RADIATOR) RADONLINE nevering showing more that one person

2000-12-18 Thread Hugh Irvine
Hello Ken - At 11:25 -0500 8/12/00, Ken Sain wrote: >radiator 2.17.1 and radmin 2.14 on slack7.1(kernel 2.2.16) mysql 3.22.32 and >cisco 5300 VoIP. > >seems that when a second person calls in, they never appear in 'Current >Session' from Radmin. i get an error while inserting the record into th