(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 ctmsun4.macau.ctm.net (ctmsun4.macau.ctm.net [202.175.36.44])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id g2CADW306841
for [EMAIL PROTECTED]; Tue, 12 Mar 2002 04:13:32 -0600
Received: from C2035 (quintin.office.ctm.net [202.175.4.50])
by ctmsun4.macau.ctm.net (8.12.2/8.12.2) with SMTP id g2CBj1Rb014504
for [EMAIL PROTECTED]; Tue, 12 Mar 2002 19:45:01 +0800 (CST)
Message-ID: 151f01c1c9bc$a8d80ad0$cc65010a@C2035
From: Quintin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: AcctSQLStatement in v.2.19
Date: Tue, 12 Mar 2002 19:54:26 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary==_NextPart_000_151C_01C1C9FF.B6E46770
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.

This is a multi-part message in MIME format.

--=_NextPart_000_151C_01C1C9FF.B6E46770
Content-Type: text/plain;
charset=big5
Content-Transfer-Encoding: quoted-printable

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 Authentication disabled in the log =
file. Could you please help??


AuthBy SQL
Identifier debitinfo
DBSourceDBI:mysql:ewallet:192.168.1.239:3306
DBUsername radius
DBAuth  radius
FailureBackoffTime 60
AccountingStartsOnly
AuthSelect
AcctSQLStatement delete from DEBITINFO where USERNAME=3D'%U'
AcctSQLStatement insert into DEBITINFO (USERNAME, NASIDENTIFIER, =
NASPORT, \
 TIME_STAMP, DEBIT_TIMESTAMP, DEBIT_AMOUNT) values ('%U', '%N', =
\
 0%{NAS-Port}, %{Timestamp}, %{Timestamp}, 1000)
/AuthBy

Handler
RewriteUsername s/^([^@]+).*/$1/
SessionDatabase MarkStart
MaxSessions 1
AuthBy GROUP
  AuthByPolicy ContinueUntilReject
   AuthBy GROUP
 AuthByPolicy ContinueWhileAccept
AuthBy debitinfo
AuthBy authen-ewallet
AuthBy debitwhenauth-ewallet
   /AuthBy
/AuthBy
 AuthLog authlog
 AcctLogFileName /var/adm/radacct/%C/detail
/Handler

Thanks!

Quintin




--=_NextPart_000_151C_01C1C9FF.B6E46770
Content-Type: text/html;
charset=big5
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META http-equiv=3DContent-Type content=3Dtext/html; charset=3Dbig5
META content=3DMSHTML 6.00.2712.300 name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DMingLiu size=3D2Dear Hughes,/FONT/DIV
DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2/FONTnbsp;/DIV
DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Actually, I like to insert =
some information into the=20
database when my customer login. The following config is from Hughes =
long time=20
ago and itnbsp;is stillnbsp;working in 2.18.2 . However, if the same =
config=20
running in 2.19, it rejects and will show Authentication disabled in =
the log=20
file. Could you please help??/FONT/DIV
DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2/FONTnbsp;/DIV
DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2/FONTnbsp;/DIV
DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2lt;AuthBy =
SQLgt;BRnbsp;nbsp;nbsp; Identifier=20
debitinfoBRnbsp;nbsp;nbsp; DBSourcenbsp;nbsp;nbsp;=20
DBI:mysql:ewallet:192.168.1.239:3306BRnbsp;nbsp;nbsp; DBUsername=20
radiusBRnbsp;nbsp;nbsp;=20
DBAuthnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;radiusBRnbsp;nbsp;nbsp;=20
FailureBackoffTime 60BRnbsp;nbsp;nbsp;=20
AccountingStartsOnlyBRnbsp;nbsp;nbsp; AuthSelect/FONT/DIV
DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2nbsp;nbsp;nbsp; =
AcctSQLStatement delete from=20
DEBITINFO where USERNAME=3D'%U'BRnbsp;nbsp;nbsp; AcctSQLStatement =
insert into=20
DEBITINFO (USERNAME, NASIDENTIFIER, NASPORT,=20
\BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; TIME_STAMP,=20
DEBIT_TIMESTAMP, DEBIT_AMOUNT) values ('%U', '%N',=20
\BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 0%{NAS-Port},=20
%{Timestamp}, %{Timestamp}, 1000)BRlt;/AuthBygt;/FONT/DIV
DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2/FONTnbsp;/DIV
DIVFONT face=3DMingLiu=20
size=3D2lt;Handlergt;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20
RewriteUsernamenbsp;nbsp;nbsp;nbsp;=20
s/^([^@]+).*/$1/BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
SessionDatabase=20
MarkStartBRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; MaxSessions=20
1BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;AuthBy=20
GROUPgt;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
AuthByPolicy=20
ContinueUntilRejectBRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n=
bsp;nbsp;=20

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 Authentication disabled in the log =
 file. Could you please help??


 AuthBy SQL
 Identifier debitinfo
 DBSourceDBI:mysql:ewallet:192.168.1.239:3306
 DBUsername radius
 DBAuth  radius
 FailureBackoffTime 60
 AccountingStartsOnly
 AuthSelect
 AcctSQLStatement delete from DEBITINFO where USERNAME=3D'%U'
 AcctSQLStatement insert into DEBITINFO (USERNAME, NASIDENTIFIER, =
 NASPORT, \
  TIME_STAMP, DEBIT_TIMESTAMP, DEBIT_AMOUNT) values ('%U', '%N', =
 \
  0%{NAS-Port}, %{Timestamp}, %{Timestamp}, 1000)
 /AuthBy

 Handler
 RewriteUsername s/^([^@]+).*/$1/
 SessionDatabase MarkStart
 MaxSessions 1
 AuthBy GROUP
   AuthByPolicy ContinueUntilReject
AuthBy GROUP
  AuthByPolicy ContinueWhileAccept
 AuthBy debitinfo
 AuthBy authen-ewallet
 AuthBy debitwhenauth-ewallet
/AuthBy
 /AuthBy
  AuthLog authlog
  AcctLogFileName /var/adm/radacct/%C/detail
 /Handler


I don't quite understand what your Handler is meant to do.

The AuthBy SQL with Identifier debitinfo has authentication turned off with 
the empty AuthSelect, so it will reject any authentication requests. Your 
AuthByPolicy is set to ContinueWhileAccept, so it will always fail 
authentication. 

And why do you have two AuthBy GROUP's?

Perhaps if you describe your requirements in some detail, I will be able to 
make some suggestions.

regards

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (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 17:48:30 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

From [EMAIL PROTECTED] Tue Mar 12 17:48:30 2002
Received: from ctmsun4.macau.ctm.net (ctmsun4.macau.ctm.net [202.175.36.44])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id g2CNmS308583;
Tue, 12 Mar 2002 17:48:29 -0600
Received: from C2035 (quintin.office.ctm.net [202.175.4.50])
by ctmsun4.macau.ctm.net (8.12.2/8.12.2) with SMTP id 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:29:21 +0800
MIME-Version: 1.0
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.

Dear Hugh,

Thanks for ur quick response.  Actually, I just want to add some information
into another table (it's not required to authenticate here) after the
SessionDatabase and before any LDAP/UNIX authentication.

I have tried many configuration even with two Auth Groups,  do you have any
ideas?

Thanks  Rgds,

Quintin

- Original Message -
From: Hugh Irvine [EMAIL PROTECTED]
To: Quintin [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 7:28 AM
Subject: Re: (RADIATOR) AcctSQLStatement in v.2.19

 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 Authentication disabled in the log =
  file. Could you please help??
 
 
  AuthBy SQL
  Identifier debitinfo
  DBSourceDBI:mysql:ewallet:192.168.1.239:3306
  DBUsername radius
  DBAuth  radius
  FailureBackoffTime 60
  AccountingStartsOnly
  AuthSelect
  AcctSQLStatement delete from DEBITINFO where USERNAME=3D'%U'
  AcctSQLStatement insert into DEBITINFO (USERNAME, NASIDENTIFIER, =
  NASPORT, \
   TIME_STAMP, DEBIT_TIMESTAMP, DEBIT_AMOUNT) values ('%U', '%N',

=

  \
   0%{NAS-Port}, %{Timestamp}, %{Timestamp}, 1000)
  /AuthBy
 
  Handler
  RewriteUsername s/^([^@]+).*/$1/
  SessionDatabase MarkStart
  MaxSessions 1
  AuthBy GROUP
AuthByPolicy ContinueUntilReject
 AuthBy GROUP
   AuthByPolicy ContinueWhileAccept
  AuthBy debitinfo
  AuthBy authen-ewallet
  AuthBy debitwhenauth-ewallet
 /AuthBy
  /AuthBy
   AuthLog authlog
   AcctLogFileName /var/adm/radacct/%C/detail
  /Handler

 I don't quite understand what your Handler is meant to do.

 The AuthBy SQL with Identifier debitinfo has authentication turned off

with

 the empty AuthSelect, so it will reject any authentication requests. Your
 AuthByPolicy is set to ContinueWhileAccept, so it will always fail
 authentication.

 And why do you have two AuthBy GROUP's?

 Perhaps if you describe your requirements in some detail, I will be able

to

 make some suggestions.

 regards

 Hugh


 --
 Radiator: the most portable, flexible and configurable RADIUS server
 anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
 -
 Nets: internetwork inventory and management - graphical, extensible,
 flexible with hardware, software, platform and database independence.

---

-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985   Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) AcctSQLStatement in v.2.19

2002-03-12 Thread Toomas Kärner 

Hi Mike.

Here is a working example for you.

AuthBy SQL
 Identifier AcctStartOnlyLight
 DBSource
 DBUsername
 DBAuth
IgnoreAuthentication
AccountingStartsOnly
AcctSQLStatement UPDATE users SET LOCKED_TO_PVC=%{NAS-Real-Port} \
WHERE username='%n' and ACTIV = 'Enabled'
/AuthBy

AuthBy SQL
 Identifier Auth
 DBSource
 DBUsername
 DBAuth

AuthSelect select PASSWORD,CHECKATTR,LOCKED_TO_PVC,REPLYATTR,RATE,BURST from
users \
   where USERNAME ='%n' and ACTIV = 'Enabled'

 AuthColumnDef 0, User-Password, check
 AuthColumnDef 1, GENERIC, check
 AuthColumnDef 2, RB-NAS-Real-Port, check
 AuthColumnDef 3, GENERIC, reply
 AuthColumnDef 4, RB-Rate-Limit-Rate, reply
 AuthColumnDef 5, RB-Rate-Limit-Burst, reply

 DefaultSimultaneousUse 1

NoDefault

RejectEmptyPassword

AddToReplyIfNotExist Rate-Limit-Rate=100,Rate-Limit-Burst=1

 AccountingTable log
 AcctColumnDef USERNAME,User-Name
 AcctColumnDef DATE,Timestamp,formatted-date,'%Y-%m-%d'
 AcctColumnDef TIME,Timestamp,formatted-date,'%H:%M:%S'
 AcctColumnDef TYPE,Acct-Status-Type
 AcctColumnDef FRAMED_IP,Framed-IP-Address
 AcctColumnDef IN_OCTETS,Acct-Input-Octets,integer
 AcctColumnDef OUT_OCTETS,Acct-Output-Octets,integer
 AcctColumnDef SESSION_ID,Acct-Session-Id
 AcctColumnDef RATE,Rate-Limit-Rate
 AcctColumnDef BURST,Rate-Limit-Burst
 AcctColumnDef DURATION,Acct-Session-Time,integer
 AcctColumnDef BRAS,NAS-Identifier
 AcctColumnDef VPI_VCI,NAS-Real-Port
 AcctFailedLogFileName %L/SQLacct-failed-mudapingviin-%Y-%m-%d

/AuthBy

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 submission from
 [Quintin [EMAIL PROTECTED]]
 Date: Tue, 12 Mar 2002 17:48:30 -0600
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]

 From [EMAIL PROTECTED] Tue Mar 12 17:48:30 2002
 Received: from ctmsun4.macau.ctm.net (ctmsun4.macau.ctm.net
[202.175.36.44])
 by server1.open.com.au (8.11.0/8.11.0) with ESMTP id g2CNmS308583;
 Tue, 12 Mar 2002 17:48:29 -0600
 Received: from C2035 (quintin.office.ctm.net [202.175.4.50])
 by ctmsun4.macau.ctm.net (8.12.2/8.12.2) with SMTP id 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:29:21 +0800
 MIME-Version: 1.0
 Content-Type: text/plain;
 charset=iso-8859-1
 Content-Transfer-Encoding: 7bit
 X-Priority: 3
 X-MSMail-Priority: Normal
 X-Mailer: Microsoft Outlook Express 6.00.2600.
 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.

 Dear Hugh,

 Thanks for ur quick response.  Actually, I just want to add some
information
 into another table (it's not required to authenticate here) after the
 SessionDatabase and before any LDAP/UNIX authentication.

 I have tried many configuration even with two Auth Groups,  do you have
any
 ideas?

 Thanks  Rgds,

 Quintin

 - Original Message -
 From: Hugh Irvine [EMAIL PROTECTED]
 To: Quintin [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Wednesday, March 13, 2002 7:28 AM
 Subject: Re: (RADIATOR) AcctSQLStatement in v.2.19

  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 Authentication disabled in the log =
   file. Could you please help??
  
  
   AuthBy SQL
   Identifier debitinfo
   DBSourceDBI:mysql:ewallet:192.168.1.239:3306
   DBUsername radius
   DBAuth  radius
   FailureBackoffTime 60
   AccountingStartsOnly
   AuthSelect
   AcctSQLStatement delete from DEBITINFO where USERNAME=3D'%U'
   AcctSQLStatement insert into DEBITINFO (USERNAME, NASIDENTIFIER, =
   NASPORT, \
TIME_STAMP, DEBIT_TIMESTAMP, DEBIT_AMOUNT) values ('%U',
'%N',

 =

   \
0%{NAS-Port}, %{Timestamp}, %{Timestamp}, 1000)
   /AuthBy
  
   Handler
   RewriteUsername s/^([^@]+).*/$1/
   SessionDatabase MarkStart
   MaxSessions 1
   AuthBy GROUP
 AuthByPolicy ContinueUntilReject
  AuthBy GROUP
AuthByPolicy ContinueWhileAccept
   AuthBy debitinfo
   AuthBy authen-ewallet
   AuthBy debitwhenauth-ewallet
  /AuthBy
   /AuthBy
AuthLog authlog
AcctLogFileName /var/adm/radacct/%C/detail
   /Handler
 
  I don't quite understand what your Handler is meant to do.
 
  The AuthBy SQL with Identifier debitinfo has authentication turned off

 with

  the empty

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'

 Looking in a Trace 6 I don't seem to see it executing the statement.  Is
 there any specific place that I should put it in the config?


The AcctSQLStatement goes in the AuthBy SQL clause.

If you still have a problem, please send me a copy of the configuration file 
and a trace 4 debug showing what is happening.

regards

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) AcctSQLStatement

2002-02-24 Thread Ronan Eckelberry, Network/Systems Admin 
,check
AuthColumnDef 4,Session-Timeout,reply
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer-date
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef NASPORTTYPE,NAS-Port-Type,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef SERVICETYPE,Service-Type,integer
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctSQLStatement update LIMITED_20HRS set
TIMELEFT=TIMELEFT-'%{Acct-Session-Time}' where USERNAME='%n'
AddToReply Service-Type=Framed-User, \
Framed-Protocol=PPP, \
Framed-IP-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 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'
 
  Looking in a Trace 6 I don't seem to see it executing the statement.  Is
  there any specific place that I should put it in the config?
 

 The AcctSQLStatement goes in the AuthBy SQL clause.

 If you still have a problem, please send me a copy of the configuration
file
 and a trace 4 debug showing what is happening.

 regards

 Hugh


 --
 Radiator: the most portable, flexible and configurable RADIUS server
 anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
 -
 Nets: internetwork inventory and management - graphical, extensible,
 flexible with hardware, software, platform and database independence.


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) AcctSQLStatement

2002-02-24 Thread Hugh Irvine 
 AcctColumnDef NASIDENTIFIER,NAS-IP-Address
 AcctColumnDef NASPORT,NAS-Port,integer
 AcctColumnDef NASPORTTYPE,NAS-Port-Type,integer
 AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
 AcctColumnDef SERVICETYPE,Service-Type,integer
 AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
 AcctColumnDef CALLEDSTATIONID,Called-Station-Id
 AcctSQLStatement update LIMITED_20HRS set
 TIMELEFT=TIMELEFT-'%{Acct-Session-Time}' where USERNAME='%n'
 AddToReply Service-Type=Framed-User, \
 Framed-Protocol=PPP, \
 Framed-IP-Netmask = 255.255.255.255

 /AuthBy

 AuthBy SQL
 Identifier LIMITED_30HRS
 DBSource dbi:mysql:radius:xxx.xxx.xxx.xxx
 DBUsername x
 DBAuth x
 DefaultSimultaneousUse 1
 Description Database to use to authenticate 30 Hour users
 FailureBackoffTime 5
 Timeout 10
 AuthSelect select
 PASSWORD,PORTLIMIT,STATICIP,SIMLOGIN,TIMELEFT from LIMITED_30HRS where
 USERNAME='%n' AND ACTIVE='Y'
 AuthColumnDef 0,User-Password,check
 AuthColumnDef 1,Port-Limit,reply
 AuthColumnDef 2,Framed-IP-Address,reply
 AuthColumnDef 3,Simultaneous-Use,check
 AuthColumnDef 4,Session-Timeout,reply
 AccountingTable ACCOUNTING
 AcctColumnDef USERNAME,User-Name
 AcctColumnDef TIME_STAMP,Timestamp,integer-date
 AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
 AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
 AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
 AcctColumnDef ACCTSESSIONID,Acct-Session-Id
 AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
 AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
 AcctColumnDef NASIDENTIFIER,NAS-IP-Address
 AcctColumnDef NASPORT,NAS-Port,integer
 AcctColumnDef NASPORTTYPE,NAS-Port-Type,integer
 AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
 AcctColumnDef SERVICETYPE,Service-Type,integer
 AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
 AcctColumnDef CALLEDSTATIONID,Called-Station-Id
 AcctSQLStatement update LIMITED_20HRS set
 TIMELEFT=TIMELEFT-'%{Acct-Session-Time}' where USERNAME='%n'
 AddToReply Service-Type=Framed-User, \
 Framed-Protocol=PPP, \
 Framed-IP-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 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'
  
   Looking in a Trace 6 I don't seem to see it executing the statement. 
   Is there any specific place that I should put it in the config?
 
  The AcctSQLStatement goes in the AuthBy SQL clause.
 
  If you still have a problem, please send me a copy of the configuration

 file

  and a trace 4 debug showing what is happening.
 
  regards
 
  Hugh
 
 
  --
  Radiator: the most portable, flexible and configurable RADIUS server
  anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
  -
  Nets: internetwork inventory and management - graphical, extensible,
  flexible with hardware, software, platform and database independence.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) AcctSQLStatement

2002-02-24 Thread Hugh Irvine 


Hello Ronan -

Yes the same thing would happen because the first AuthBy clause will Accept 
all of the accounting requests.

regards

Hugh


On Mon, 25 Feb 2002 14:48, Ronan Eckelberry, Network/Systems Admin wrote:
 Cool.  thanx for the info Hugh.  One other question thoughwould I
 still get the same result if I changed the AuthByPolicy to
 ContinueUntilAccept?

 -Ronan

 - Original Message -
 From: Hugh Irvine [EMAIL PROTECTED]
 To: Ronan Eckelberry, Network/Systems Admin [EMAIL PROTECTED];
 [EMAIL PROTECTED]
 Sent: Sunday, 24 February, 2002 20:05
 Subject: Re: (RADIATOR) AcctSQLStatement

  Hello Ronan -
 
  The problem you have is due to the way you have set up your configuration
  file. You have an AuthByPolicy of ContinueWhileReject, so all accounting
  packets are are being processed by the first AuthBy SQL clause.
 
  In your situation you would be better off using Handlers like this:
 
  # define AuthBy clauses
 
  AuthBy SQL
  Identifier SUBSCRIBERS
  .
  AddToReply Class = SUBSCRIBERS
  /AuthBy
 
  AuthBy SQL
  Identifier LIMITED_20HRS
  .
  AddToReply Class = LIMITED_20HRS
  /AuthBy
 
  AuthBy SQL
  Identifier LIMITED_30HRS
  .
  AddToReply Class = LIMITED_30HRS
  /AuthBy
 
  # define Handlers
 
  Handler Request-Type = Accounting-Request, Class = SUBSCRIBERS
  ..
  AuthBy SUBSCRIBERS
  .
  /Handler
 
  Handler Request-Type = Accounting-Request, Class = LIMITED_20HRS
  ..
  AuthBy LIMITED_20HRS
  .
  /Handler
 
  Handler Request-Type = Accounting-Request, Class = LIMITED_30HRS
  ..
  AuthBy LIMITED_30HRS
  .
  /Handler
 
  Handler
  ..
  AuthByPolicy ContinueWhileReject
  AuthBy SUBSCRIBERS
  AuthBy LIMITED_20HRS
  AuthBy LIMITED_30HRS
  .
  /Handler
 
 
  regards
 
  Hugh
 
  On Mon, 25 Feb 2002 11:17, Ronan Eckelberry, Network/Systems Admin wrote:
   I have it in the AuthBy SQL Clause.  I don't see it executing in a
   trace though.  Maybe I am typing something wrong.  Here is a snip from

 the

   config:
  
   Realm DEFAULT
 Description Default Realm for authenticating users
 RejectHasReason
 RewriteUsername s/^([^@]+).*/$1/
 SessionDatabase RADONLINE
 AuthByPolicy ContinueWhileReject
  
   AuthBy SQL
   Identifier SUBSCRIBERS
   DBSource dbi:mysql:radius:xxx.xxx.xxx.xxx
   DBUsername x
   DBAuth x
   DefaultSimultaneousUse 1
   Description Database to use to authenticate users
   FailureBackoffTime 5
   Timeout 10
   AuthSelect select PASSWORD,PORTLIMIT,STATICIP,SIMLOGIN

 from

   SUBSCRIBERS where USERNAME='%n' AND ACTIVE='Y'
   # AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME='%n'
   AuthColumnDef 0,User-Password,check
   AuthColumnDef 1,Port-Limit,reply
   AuthColumnDef 2,Framed-IP-Address,reply
   AuthColumnDef 3,Simultaneous-Use,check
   AccountingTable ACCOUNTING
   AcctColumnDef USERNAME,User-Name
   AcctColumnDef TIME_STAMP,Timestamp,integer-date
   AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
   AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
   AcctColumnDef

 ACCTOUTPUTOCTETS,Acct-Output-Octets,integer

   AcctColumnDef ACCTSESSIONID,Acct-Session-Id
   AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
   AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
   AcctColumnDef NASIDENTIFIER,NAS-IP-Address
   AcctColumnDef NASPORT,NAS-Port,integer
   AcctColumnDef NASPORTTYPE,NAS-Port-Type,integer
   AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
   AcctColumnDef SERVICETYPE,Service-Type,integer
   AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
   AcctColumnDef CALLEDSTATIONID,Called-Station-Id
   AddToReply Service-Type=Framed-User, \
   Framed-Protocol=PPP, \
   Framed-IP-Netmask = 255.255.255.255
  
   /AuthBy
  
   AuthBy SQL
   Identifier LIMITED_20HRS
   DBSource dbi:mysql:radius:xxx.xxx.xxx.xxx
   DBUsername x
   DBAuth x
   DefaultSimultaneousUse 1
   Description Database to use to authenticate 20 Hour

 users

   FailureBackoffTime 5
   Timeout 10
   AuthSelect select
   PASSWORD,PORTLIMIT,STATICIP,SIMLOGIN,TIMELEFT from LIMITED_20HRS where
   USERNAME='%n' AND ACTIVE='Y'
   AuthColumnDef 0,User-Password,check
   AuthColumnDef 1,Port-Limit,reply
   AuthColumnDef 2,Framed-IP-Address,reply
   AuthColumnDef 3

(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 statement.  Is
there any specific place that I should put it in the config?

-Ronan


Ronan Eckelberry
[EMAIL PROTECTED]
Network/Systems Engineer
Webco Solutions, Inc
(352)746-2500
www.webcosolutions.com

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

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 the 
following paragraph from section 6.26 of the 2.18.2 release manual (see underlines 
under a fixed text viewer):

 When AuthBy SQL receives an Accounting-Request message, it can store any
 number of the attributes from the request in an SQL table. You can control
 the table it stores in, and the names of the columns where the attributes
 are stored, and the attribute that is stored there. To enable SQL
  ^
 accounting you must define AccountingTable and you must define at least
  ^^^
 one AcctColumnDef. If you don't do both of these AuthBy SQL will
  
 acknowledge Accounting-Request message but will not store them anywhere.
  
 The example goodies/sql.cfg in the Radiator distribution shows a typical
 setup that will work with the table schemas in the goodies directory. 

Re-reading this, this is, in fact true since, in this specific AuthBy, I am not 
storing them anywhere, but I am doing something else besides aknowledging them.

 
 Have a look at section 6.26 in the Radiator manual.
From doing this I got the original doubt :-)

 
 regards
Thanx for your help...

 
 Hugh
 
 
 At 15:22 -0300 01/7/27, Mariano Absatz wrote:
 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 Handler to process accounting stops
 
   Handler Acct-Status-Type = Stop
.
   /Handler
 
   # define Handler to process other accounting requests
 
   Handler Request-Type = Accounting-Request
.
   /Handler
 Yes...
 but nonetheless, I want to apply all of the processing of Handler Request-
 Type = Accounting-Request to the same packets that also match Handler Acct-
 Status-Type = Stop and it is cleaner (at least for my eye) if I have one
 AuthBy OnlyDoThisWithStops and one AuthBy DoThisWithEveryAcctPack and use
 both in the Handler Request-Type = Accounting-Request.
 
 
   # define Handlers for everything else
 
   Handler .
.
   /Handler
 
   Handler
.
   /Handler
 
   hth
 
   Hugh
 
 
   On Friday 27 July 2001 03:20, Mariano Absatz wrote:
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.
   
Now I want to do a couple of AcctSQLStatement's but I want them only to
be executed when I get a Stop packet (to do time-block and also
byte-block)
   
I want to use AccountingStopsOnly in my new AuthBy SQL especially
trying to avoid Alive packets that would make accumulative substract
time when I shouldn't.
   
I don't want to ignore altogether alive packets because billing will use
them if the Stop packet gets lost...
   
Any ideas?
   

--
Mariano Absatz
El Baby
--
Not the brightest crayon in the box now, are we?

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

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 
used to do anything.

This is from section 6.26.13 in the manual:

This parameter allows you to execute arbitrary SQL statements each 
time an accounting request is received.

Do you think we should make the manual clearer?

regards

Hugh


At 11:27 -0300 01/7/31, Mariano Absatz wrote:
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 the
following paragraph from section 6.26 of the 2.18.2 release manual 
(see underlines
under a fixed text viewer):

  When AuthBy SQL receives an Accounting-Request message, it can store any
  number of the attributes from the request in an SQL table. You can control
  the table it stores in, and the names of the columns where the attributes
  are stored, and the attribute that is stored there. To enable SQL
   ^
  accounting you must define AccountingTable and you must define at least
   ^^^
  one AcctColumnDef. If you don't do both of these AuthBy SQL will
   
  acknowledge Accounting-Request message but will not store them anywhere.
   
  The example goodies/sql.cfg in the Radiator distribution shows a typical
  setup that will work with the table schemas in the goodies directory.

Re-reading this, this is, in fact true since, in this specific 
AuthBy, I am not
storing them anywhere, but I am doing something else besides 
aknowledging them.


  Have a look at section 6.26 in the Radiator manual.
From doing this I got the original doubt :-)


  regards
Thanx for your help...


  Hugh


  At 15:22 -0300 01/7/27, Mariano Absatz wrote:
  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 Handler to process accounting stops
  
Handler Acct-Status-Type = Stop
 .
/Handler
  
# define Handler to process other accounting requests
  
Handler Request-Type = Accounting-Request
 .
/Handler
  Yes...
  but nonetheless, I want to apply all of the processing of Handler Request-
  Type = Accounting-Request to the same packets that also match 
Handler Acct-
  Status-Type = Stop and it is cleaner (at least for my eye) if I have one
  AuthBy OnlyDoThisWithStops and one AuthBy 
DoThisWithEveryAcctPack and use
  both in the Handler Request-Type = Accounting-Request.
  
  
# define Handlers for everything else
  
Handler .
 .
/Handler
  
Handler
 .
/Handler
  
hth
  
Hugh
  
  
On Friday 27 July 2001 03:20, Mariano Absatz wrote:
 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.
 
 Now I want to do a couple of AcctSQLStatement's but I want 
them only to
 be executed when I get a Stop packet (to do time-block and also
 byte-block)

 I want to use AccountingStopsOnly in my new AuthBy SQL especially
 trying to avoid Alive packets that would make accumulative substract
 time when I shouldn't.

 I don't want to ignore altogether alive packets because 
billing will use
 them if the Stop packet gets lost...

 Any ideas?


--
Mariano Absatz
El Baby
--
Not the brightest crayon in the box now, are we?

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at

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, 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 Handler to process accounting stops

  Handler Acct-Status-Type = Stop
   .
  /Handler

  # define Handler to process other accounting requests

  Handler Request-Type = Accounting-Request
   .
  /Handler
Yes...
but nonetheless, I want to apply all of the processing of Handler Request-
Type = Accounting-Request to the same packets that also match Handler Acct-
Status-Type = Stop and it is cleaner (at least for my eye) if I have one
AuthBy OnlyDoThisWithStops and one AuthBy DoThisWithEveryAcctPack and use
both in the Handler Request-Type = Accounting-Request.


  # define Handlers for everything else

  Handler .
   .
  /Handler

  Handler
   .
  /Handler

  hth

  Hugh


  On Friday 27 July 2001 03:20, Mariano Absatz wrote:
   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.
  
   Now I want to do a couple of AcctSQLStatement's but I want them only to be
   executed when I get a Stop packet (to do time-block and also byte-block)
  
   I want to use AccountingStopsOnly in my new AuthBy SQL especially trying
   to avoid Alive packets that would make accumulative substract time when I
   shouldn't.
  
   I don't want to ignore altogether alive packets because billing will use
   them if the Stop packet gets lost...
  
   Any ideas?
  
   TIA
   --
   Mariano Absatz
   El Baby
   --
  
   The generation of random numbers is too important to be left to chance.
   -Robert R. Coveyou Oak Ridge National Laboratory
  
   ===
   Archive at http://www.open.com.au/archives/radiator/
   Announcements on [EMAIL PROTECTED]
   To unsubscribe, email '[EMAIL PROTECTED]' with
   'unsubscribe radiator' in the body of the message.

  --
  Radiator: the most portable, flexible and configurable RADIUS server
  anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
  -
  Nets: internetwork inventory and management - graphical, extensible,
  flexible with hardware, software, platform and database independence.


--
Mariano Absatz
El Baby
--
Error, no keyboard - press F1 to continue.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

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 Handler to process accounting stops
 
 Handler Acct-Status-Type = Stop
  .
 /Handler
 
 # define Handler to process other accounting requests
 
 Handler Request-Type = Accounting-Request
  .
 /Handler
Yes...
but nonetheless, I want to apply all of the processing of Handler Request-
Type = Accounting-Request to the same packets that also match Handler Acct-
Status-Type = Stop and it is cleaner (at least for my eye) if I have one 
AuthBy OnlyDoThisWithStops and one AuthBy DoThisWithEveryAcctPack and use 
both in the Handler Request-Type = Accounting-Request.

 
 # define Handlers for everything else
 
 Handler .
  .
 /Handler
 
 Handler
  .
 /Handler
 
 hth
 
 Hugh
 
 
 On Friday 27 July 2001 03:20, Mariano Absatz wrote:
  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.
 
  Now I want to do a couple of AcctSQLStatement's but I want them only to be
  executed when I get a Stop packet (to do time-block and also byte-block)
 
  I want to use AccountingStopsOnly in my new AuthBy SQL especially trying
  to avoid Alive packets that would make accumulative substract time when I
  shouldn't.
 
  I don't want to ignore altogether alive packets because billing will use
  them if the Stop packet gets lost...
 
  Any ideas?
 
  TIA
  --
  Mariano Absatz
  El Baby
  --
 
  The generation of random numbers is too important to be left to chance.
  -Robert R. Coveyou Oak Ridge National Laboratory
 
  ===
  Archive at http://www.open.com.au/archives/radiator/
  Announcements on [EMAIL PROTECTED]
  To unsubscribe, email '[EMAIL PROTECTED]' with
  'unsubscribe radiator' in the body of the message.
 
 -- 
 Radiator: the most portable, flexible and configurable RADIUS server 
 anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
 -
 Nets: internetwork inventory and management - graphical, extensible,
 flexible with hardware, software, platform and database independence.


--
Mariano Absatz
El Baby
--
Error, no keyboard - press F1 to continue. 

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(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.

Now I want to do a couple of AcctSQLStatement's but I want them only to be executed 
when I get a Stop packet (to do time-block and also byte-block)

I want to use AccountingStopsOnly in my new AuthBy SQL especially trying to avoid 
Alive packets that would make accumulative substract time when I shouldn't.

I don't want to ignore altogether alive packets because billing will use them if 
the Stop packet gets lost...

Any ideas?

TIA
--
Mariano Absatz
El Baby
--
 
The generation of random numbers is too important to be left to chance. 
-Robert R. Coveyou Oak Ridge National Laboratory 

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

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 = Stop
.
/Handler

# define Handler to process other accounting requests

Handler Request-Type = Accounting-Request
.
/Handler

# define Handlers for everything else

Handler .
.
/Handler

Handler
.
/Handler

hth

Hugh


On Friday 27 July 2001 03:20, Mariano Absatz wrote:
 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.

 Now I want to do a couple of AcctSQLStatement's but I want them only to be
 executed when I get a Stop packet (to do time-block and also byte-block)

 I want to use AccountingStopsOnly in my new AuthBy SQL especially trying
 to avoid Alive packets that would make accumulative substract time when I
 shouldn't.

 I don't want to ignore altogether alive packets because billing will use
 them if the Stop packet gets lost...

 Any ideas?

 TIA
 --
 Mariano Absatz
 El Baby
 --

 The generation of random numbers is too important to be left to chance.
 -Robert R. Coveyou Oak Ridge National Laboratory

 ===
 Archive at http://www.open.com.au/archives/radiator/
 Announcements on [EMAIL PROTECTED]
 To unsubscribe, email '[EMAIL PROTECTED]' with
 'unsubscribe radiator' in the body of the message.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(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 (kccg.com [216.235.110.136] (may be forged))
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id f4LDjUD23154
for [EMAIL PROTECTED]; Mon, 21 May 2001 08:45:30 -0500
Received: from WEBDEV [168.187.26.236] by kccg.com
  (SMTPD32-6.04) id A78360D00052; Mon, 21 May 2001 11:42:59 -0400
Message-ID: 003901c0e20b$d84d0de0$[EMAIL PROTECTED]
From: adam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: AcctSQLStatement problem
Date: Mon, 21 May 2001 18:36:42 +0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary==_NextPart_000_0036_01C0E224.FB44BD20
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

This is a multi-part message in MIME format.

--=_NextPart_000_0036_01C0E224.FB44BD20
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all

I'm constructing a daily based dialup connection scheme where every user =
can connect for different period of time on each day
so i have in my authentication table seven fields each represent a day =
and each field have the time he is allowed to connect.

The authentication works fine but i'm facing problems in the updating of =
the information.
bellow is the : updating the table query
AcctSQLStatement update Authentication set %Q =3D =
{%Q}-0%{Acct-Session-Time}, Last =3D '%Q' where USERNAME =3D '%n' And =
Type =3D 'H'

the following is the error
Mon May 21 18:16:30 2001: DEBUG: do query is: update Authentication set =
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D 'H'

Mon May 21 18:16:30 2001: ERR: do failed for 'update Authentication set =
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D 'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax =
error in query expression 'Monday}-01000'. (SQL-37000)(DBD: =
st_prepare/SQLPrepare err=3D-1)

Mon May 21 18:16:31 2001: ERR: do failed for 'update Authentication set =
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D 'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax =
error in query expression 'Monday}-01000'. (SQL-37000)(DBD: =
st_prepare/SQLPrepare err=3D-1)



i think the problem is in %Q=3D{%Q}=20

can anybody help=20

Thanks all


--=_NextPart_000_0036_01C0E224.FB44BD20
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META content=3Dtext/html; charset=3Diso-8859-1 =
http-equiv=3DContent-Type
META content=3DMSHTML 5.00.2920.0 name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Hi all/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I'm constructing a daily based dialup =
connection=20
scheme where every usernbsp;can connect for different period of time on =
each=20
day/FONT/DIV
DIVFONT face=3DArial size=3D2so i have in my authentication table =
seven fields=20
each represent a day and each field have the time he is allowednbsp;to=20
connect./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2The authentication works fine but i'm =
facing=20
problems in the updating of the information./FONT/DIV
DIVFONT face=3DArial size=3D2bellow is the : updating the table=20
query/FONT/DIV
DIVFONT face=3DArial size=3D2AcctSQLStatement update Authentication =
set %Q =3D=20
{%Q}-0%{Acct-Session-Time}, Last =3D '%Q' where USERNAME =3D '%n' And =
Type =3D=20
'H'/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2the following is the error/FONT/DIV
DIVFONT face=3DArial size=3D2FONT size=3D2
PMon May 21 18:16:30 2001: DEBUG: do query is: update Authentication =
set=20
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D=20
'H'/P
PMon May 21 18:16:30 2001: ERR: do failed for 'update Authentication =
set=20
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D=20
'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax error in query =
expression=20
'Monday}-01000'. (SQL-37000)(DBD: st_prepare/SQLPrepare err=3D-1)/P
PMon May 21 18:16:31 2001: ERR: do failed for 'update Authentication =
set=20
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D=20
'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax error in query =
expression=20
'Monday}-01000'. (SQL-37000)(DBD: st_prepare/SQLPrepare err=3D-1)/P
Pnbsp;/P
Pi think the problem is in %Q=3D{%Q} /P
Pcan anybody help /P
PThanks all/P/FONT/DIV/FONT/BODY/HTML

--=_NextPart_000_0036_01C0E224.FB44BD20--




---End of forwarded mail from