(RADIATOR) AcctSQLStatement in v.2.19

2002-03-12 Thread Mike McCauley
-- Forwarded Message -- Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [Quintin [EMAIL PROTECTED]] Date: Tue, 12 Mar 2002 04:13:33 -0600 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] From [EMAIL PROTECTED] Tue Mar 12 04:13:33 2002 Received: from

Re: (RADIATOR) AcctSQLStatement in v.2.19

2002-03-12 Thread Hugh Irvine
Hello Quintin - Dear Hughes, Actually, I like to insert some information into the database when my = customer login. The following config is from Hughes long time ago and it = is still working in 2.18.2 . However, if the same config running in = 2.19, it rejects and will show

Re: (RADIATOR) AcctSQLStatement in v.2.19

2002-03-12 Thread Mike McCauley
g2D1JsRb021759; Wed, 13 Mar 2002 09:19:54 +0800 (CST) Message-ID: 156e01c1ca2e$8077b640$cc65010a@C2035 From: Quintin [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] References: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: (RADIATOR) AcctSQLStatement in v.2.19 Date: Wed, 13 Mar 2002 09

Re: (RADIATOR) AcctSQLStatement in v.2.19

2002-03-12 Thread Toomas Kärner
Rgds. Toomas Kärner - Original Message - From: Mike McCauley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:24 AM Subject: Re: (RADIATOR) AcctSQLStatement in v.2.19 -- Forwarded Message -- Subject: BOUNCE [EMAIL PROTECTED]:Non-member

Re: (RADIATOR) AcctSQLStatement

2002-02-24 Thread Hugh Irvine
Hello Ronan - On Sun, 24 Feb 2002 06:19, Ronan Eckelberry wrote: Got a quick question. I have my AcctSQLStatement in my config, but it seems not to execute it This is what I have: AcctSQLStatement update LIMITED_20HRS set TIMELEFT=TIMELEFT-0%{A cct-Session-Time} where USERNAME='%n'

Re: (RADIATOR) AcctSQLStatement

2002-02-24 Thread Ronan Eckelberry, Network/Systems Admin
-Netmask = 255.255.255.255 /AuthBy - Original Message - From: Hugh Irvine [EMAIL PROTECTED] To: Ronan Eckelberry [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, 24 February, 2002 18:08 Subject: Re: (RADIATOR) AcctSQLStatement Hello Ronan - On Sun, 24 Feb 2002 06:19, Ronan

Re: (RADIATOR) AcctSQLStatement

2002-02-24 Thread Hugh Irvine
- Original Message - From: Hugh Irvine [EMAIL PROTECTED] To: Ronan Eckelberry [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, 24 February, 2002 18:08 Subject: Re: (RADIATOR) AcctSQLStatement Hello Ronan - On Sun, 24 Feb 2002 06:19, Ronan Eckelberry wrote: Got a quick question. I

Re: (RADIATOR) AcctSQLStatement

2002-02-24 Thread Hugh Irvine
[EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, 24 February, 2002 18:08 Subject: Re: (RADIATOR) AcctSQLStatement Hello Ronan - On Sun, 24 Feb 2002 06:19, Ronan Eckelberry wrote: Got a quick question. I have my AcctSQLStatement in my config, but it seems not to execute

(RADIATOR) AcctSQLStatement

2002-02-23 Thread Ronan Eckelberry
Got a quick question. I have my AcctSQLStatement in my config, but it seems not to execute it This is what I have: AcctSQLStatement update LIMITED_20HRS set TIMELEFT=TIMELEFT-0%{A cct-Session-Time} where USERNAME='%n' Looking in a Trace 6 I don't seem to see it executing the

Re: (RADIATOR) AcctSQLStatement ONLY AuthBy?

2001-07-31 Thread Mariano Absatz
El 28 Jul 2001, a las 19:36, Hugh Irvine escribió: Hello Mariano - You can do what you describe too, by using the AccountingStartsOnly, AccountingStopsOnly and AccountingAlivesOnly tags in the AuthBy SQL clause. That was (and still is) my intention... the only thing that worried my was

Re: (RADIATOR) AcctSQLStatement ONLY AuthBy?

2001-07-31 Thread Hugh Irvine
Hello Mariano - The lines in the manual that you highlight refer to the automatic generation of the default SQL query for handling accounting requests. The AccountingTable and the AcctColumnDef's are combined to produce the query. The AcctSQLQuery's are completely independent and can be

Re: (RADIATOR) AcctSQLStatement ONLY AuthBy?

2001-07-28 Thread Hugh Irvine
Hello Mariano - You can do what you describe too, by using the AccountingStartsOnly, AccountingStopsOnly and AccountingAlivesOnly tags in the AuthBy SQL clause. Have a look at section 6.26 in the Radiator manual. regards Hugh At 15:22 -0300 01/7/27, Mariano Absatz wrote: El 27 Jul 2001,

Re: (RADIATOR) AcctSQLStatement ONLY AuthBy?

2001-07-27 Thread Mariano Absatz
El 27 Jul 2001, a las 9:17, Hugh Irvine escribió: Hello Mariano - Yes you can certainly have any number of AcctSQLStatement's without an AccountingTable and AcctColumnDef's. You might want to think about using Handlers to process your requests. Something like this: # define

(RADIATOR) AcctSQLStatement ONLY AuthBy?

2001-07-26 Thread Mariano Absatz
Hi, is it possible to have an AuthBy SQL that doesn't even have AccountingTable and AcctColumnDef, but only AcctSQLStatement? The manual seems to say no. Here's what I want to do: I already have my main accounting only AuthBy SQL that processes Start's Stop's and, if they are there, Alive's.

Re: (RADIATOR) AcctSQLStatement ONLY AuthBy?

2001-07-26 Thread Hugh Irvine
Hello Mariano - Yes you can certainly have any number of AcctSQLStatement's without an AccountingTable and AcctColumnDef's. You might want to think about using Handlers to process your requests. Something like this: # define Handler to process accounting stops Handler Acct-Status-Type =

(RADIATOR) AcctSQLStatement problem

2001-05-21 Thread Mike McCauley
--- Forwarded mail from [EMAIL PROTECTED] From: [EMAIL PROTECTED] Date: Mon, 21 May 2001 08:45:31 -0500 To: [EMAIL PROTECTED] Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [adam [EMAIL PROTECTED]] From [EMAIL PROTECTED] Mon May 21 08:45:30 2001 Received: from kccg.com