---------- 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.0000
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
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
> > DBSource DBI: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. Ltd Unix, 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.
