(RADIATOR) Authlog

Hey guys, Can we user Radiator variables for table names in the Authlog SQL statement? I want to do this: insert into RadLog-%Y-%m \ (Priority, Message, User_Name, FailedPass) \ values \ (%0, %1, %2, %3)

(RADIATOR) Nortel

I have the following: Thu Dec 18 16:33:27 2003: ERR: Attribute number 28 (vendor 2637) is not defined in your dictionary Thu Dec 18 16:33:27 2003: DEBUG: Packet dump: *** Received from 196.3.210.110 port 2048 Code: Accounting-Request Identifier: 177 Authentic:

(RADIATOR) Propel Dictionary

Hey guys, I want to add some attributes to the dictionary file or create a new one for Propel. Can you guide me please? They Are: VENDOR Propel 14895 ATTRIBUTE Propel-Accelerate 1 integer ATTRIBUTE Propel-Dialed-Digits 2 string ATTRIBUTE

RE: (RADIATOR) Can you use SQL if statements in radiator?

Ok the idea you gave me before worked for me. I see now how to use the AuthBy. Thanks to Toomas also! Thanks, Craig. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body

RE: (RADIATOR) Can you use SQL if statements in radiator?

being logged on correctly. Is this the designed behaviour? Craig. -Original Message- From: Hugh Irvine [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 6:55 PM To: Craig Gittens Cc: Toomas Karner; Radiator Subject: Re: (RADIATOR) Can you use SQL if statements in radiator

RE: (RADIATOR) Can you use SQL if statements in radiator?

don't know how to code in PERL. Craig. -Original Message- From: Hugh Irvine [mailto:[EMAIL PROTECTED] Sent: Friday, November 28, 2003 7:26 PM To: Craig Gittens Cc: Toomas Karner; Radiator Subject: Re: (RADIATOR) Can you use SQL if statements in radiator? Hello Craig - In that case you

RE: (RADIATOR) Can you use SQL if statements in radiator?

Ok, thanks to Toomas I have come up with this solution but it doesn't work unless I comment out the second AuthBy...it does do an ACCEPT for the first AuthBy but doesn't work for some reason unless I comment out the second AuthBy. Log below. It doesn't send a reply unless I comment out the second

(RADIATOR) Can you use SQL if statements in radiator?

Hey guys, I am trying to get a new product to work where when the username and password is used and is valid then it would update the SQL database with an end date for the product. So I need this logic to work in a SQL statement in Radiator: User is a valid user and is allowed online, User entry

(RADIATOR) Weird Ascend filter behaviour

Hey guys, The problem is fairly simple. With the following statements, I cannot surf or get DNS so I know that the last 2 statements work. Is there a flaw in my logic? I am using the following on a CVX 1800: Ascend-Data-Filter = ip IN FORWARD dstip 205.214.199.52 srcip 0.0.0.0 6 dstport = 80

(RADIATOR) Problem with Reply Attributes

Hey guys the Framed-IP-Address reply attribute cause a link failure when conencting to a Nortel CVX. I know I can use Framed-Address instead but I can't find the option anywhere in the Radiator manual or goodies directory. is there a document that will tell me what is acceptable in a reply

RE: (RADIATOR) Problem with Reply Attributes

Ok. I got this figured BTW. It seems the new software load doesn't like a Framed-IP-Addess of 255.255.255.254. It will only accept the attribute if it contains a valid address. Yes I looked in the dictionary file as well. Thanks, Craig. -Original Message-From: [EMAIL

(RADIATOR) Getting problems with new Cisoc IOS NAS

Hey guys I can't update my sessions table cause it gets an error since there is no NAS-Port present in stop and start recordscan anyone give me an idea if there is a command on Cisco VDPN LNS L2TP to get it to send over NAS-Port info? Thanks, Craig. Wed Sep 3 16:26:07 2003: DEBUG: Packet

RE: (RADIATOR) Emergency - Please help

I have an idea, what if I did a SQL function to clear old/failed records in the event that the user tries again? I know the function would have to return something. Would radiator freak out? : AllocateQuery AllocateIP (%0,%1,%2,'%3',%4) update RADPOOL set state = 0 where USERNAME = '%2' update

RE: (RADIATOR) Emergency - Please help

Of Mike McCauley Sent: Friday, August 29, 2003 8:34 PM To: Craig Gittens; Matthew Trout; Radiator Cc: Hugh Irvine Subject: Re: (RADIATOR) Emergency - Please help Hello Craig, On Fri, 29 Aug 2003 11:54 pm, Craig Gittens wrote: Ok I had: DeAllocateQuery update RADPOOL set STATE=0,TIME_STAMP=%t

(RADIATOR) Emergency - Please help

I have been having endless problems with an upgrade the modem providers have done. What I am seeing now is that IP allocation is done and gives 6-8 IP addresses to the same person. Ok we are investigating and I will get back to you with data. However, in the mean time I want to add the Deallocate

RE: (RADIATOR) Emergency - Please help

=1062163950 where USERNAME=''': It seems we don't get a username in a stop packet or it isn't replaced automatically. How inconvenient. ANyone have any ideas? Thanks, Craig. -Original Message- From: Matthew Trout [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 9:09 AM To: 'Craig Gittens

RE: (RADIATOR) Emergency - Please help

Acct-Session-Time = 5073 Acct-Delay-Time = 0 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike McCauley Sent: Friday, August 29, 2003 8:56 AM To: Craig Gittens; Radiator Cc: Hugh Irvine Subject: Re: (RADIATOR) Emergency - Please help Hello

RE: (RADIATOR) Emergency - Please help

:40 AM To: 'Craig Gittens'; Mike McCauley; Radiator Cc: Hugh Irvine Subject: RE: (RADIATOR) Emergency - Please help The query I gave you will do that - you probably aren't seeing the user in the stop packet An alternative is to try doing it by NAS port - e.g. DeallocateQuery update RADPOOL set

(RADIATOR) Linux PPP concentrator problems

Hey guys, I hope someone can help. I am using a linux PPP concentrator with a radius plugin client to send a request to my radiator server. The NAS-Port-Type is set to come in as Virtual but I am not seeing it on the radiator server. I am wondering what is happening. A debug is pasted below. If I

RE: (RADIATOR) insert log sql

the question above? Thanks, Craig. -Original Message- From: Hugh Irvine [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 8:05 PM To: Craig Gittens Cc: Radiator Subject: Re: (RADIATOR) insert log sql Hello Craig - I generally find it easier to use Handlers for this sort

RE: (RADIATOR) Database support fault tolerance

Hey Dan, I don't want to step on toes.It seems like the root problem here is to fix the communication between the Radius server and the SQL server. Is it some sort of remote link? Regards, Craig. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED]

(RADIATOR) insert log sql

Hey guys, Is there a way to exempt certain usernames from entering the sql log? I want to insert if username != TEST. Thanks, Craig === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator'

RE: (RADIATOR) What does this mean?

/ClientListSQL Help? Could it be because it's not the latest version of perl? Thanks, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hugh Irvine Sent: Friday, June 20, 2003 1:08 AM To: Craig Gittens Cc: Radiator Subject: Re: (RADIATOR) What does

(RADIATOR) What does this mean?

('NAS-Port-Type', 'Virtual'); } and I am using a database with the field Prehandlerhook set to vpr ThanksIA, Craig Gittens Internet Infrastructure Support Manager Sunbeach Communications Inc. San Remo Belmont Road, St. Michael, Barbados Voice: (246) 430-1569 Fax: (246) 228-6330 === Archive

(RADIATOR) rewrite NAS-Port-type?

I am trying to implement a VPN solution using linux pppd and it is sending the port type as Async. The problem is I don't want dialup customers able to use this service as well. I was wondering if you could rewqrite NAS port type before authentication in the CLIENT? Thanks, Craig. === Archive

(RADIATOR) install from 2.19 to 3.6?

Is it safe to jump an install from 2.19 to 3.6? I want to resolve Virtual problems where my VPNs crash the radius server. Craig. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in

RE: (RADIATOR) Duplicate kinda requests

console it just scrolls by on trace 3 with one username failing 2-3 times a second. Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hugh Irvine Sent: Sunday, February 16, 2003 5:33 PM To: Craig Gittens Cc: Radiator Subject: Re: (RADIATOR) Duplicate

(RADIATOR) Duplicate kinda requests

I have a problem with ADSL users we authenticate here. They pound the server right now with 2-3 requests every second if their account has expired. How would you handle this? They are not duplicate requests. TIA, Craig. === Archive at http://www.open.com.au/archives/radiator/ Announcements on

(RADIATOR) GRIC and HOST clause

Hi, I was just wondering if this would work since I define my Clients in a SQL DB and the NAS clients are going to be the same for all dialup parties. (Your GRIC example in the Ref Manual assumes you have a different client defined for the GRIC customers.) Realm DEFAULT AuthBy RADIUS