---------- 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.0000
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
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
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>
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">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dbig5">
<META content=3D"MSHTML 6.00.2712.300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DMingLiu size=3D2>Dear Hughes,</FONT></DIV>
<DIV><FONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2></FONT> </DIV>
<DIV><FONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2>Actually, 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 it is still 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>
<DIV><FONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2></FONT> </DIV>
<DIV><FONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2></FONT> </DIV>
<DIV><FONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2><AuthBy =
SQL><BR> Identifier=20
debitinfo<BR> DBSource =20
DBI:mysql:ewallet:192.168.1.239:3306<BR> DBUsername=20
radius<BR> =20
DBAuth radius<BR> =20
FailureBackoffTime 60<BR> =20
AccountingStartsOnly<BR> AuthSelect</FONT></DIV>
<DIV><FONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2> =
AcctSQLStatement delete from=20
DEBITINFO where USERNAME=3D'%U'<BR> AcctSQLStatement =
insert into=20
DEBITINFO (USERNAME, NASIDENTIFIER, NASPORT,=20
\<BR> TIME_STAMP,=20
DEBIT_TIMESTAMP, DEBIT_AMOUNT) values ('%U', '%N',=20
\<BR> 0%{NAS-Port},=20
%{Timestamp}, %{Timestamp}, 1000)<BR></AuthBy></FONT></DIV>
<DIV><FONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2></FONT> </DIV>
<DIV><FONT face=3DMingLiu=20
size=3D2><Handler><BR> =20
RewriteUsername =20
s/^([^@]+).*/$1/<BR> =
SessionDatabase=20
MarkStart<BR> MaxSessions=20
1<BR> <AuthBy=20
GROUP><BR> =
AuthByPolicy=20
ContinueUntilReject<BR> &n=
bsp; =20
<AuthBy=20
GROUP><BR> =
=20
AuthByPolicy=20
ContinueWhileAccept<BR> &n=
bsp; =20
AuthBy=20
debitinfo<BR> =
=20
AuthBy=20
authen-ewallet<BR> &=
nbsp; =20
AuthBy=20
debitwhenauth-ewallet<BR> =
=20
</AuthBy><BR> =20
</AuthBy><BR> =
AuthLog=20
authlog<BR> =
AcctLogFileName=20
/var/adm/radacct/%C/detail<BR></Handler></FONT></DIV>
<DIV><FONT face=3DMingLiu size=3D2></FONT> </DIV>
<DIV><FONT face=3DMingLiu size=3D2><FONT =
face=3DMingLiu>Thanks!</FONT></FONT></DIV>
<DIV><FONT face=3DMingLiu size=3D2></FONT> </DIV>
<DIV><FONT face=3DMingLiu size=3D2><FONT =
face=3DMingLiu>Quintin</FONT></FONT></DIV>
<DIV><FONT face=3DMingLiu size=3D2> </DIV>
<DIV><BR></DIV></FONT></BODY></HTML>
------=_NextPart_000_151C_01C1C9FF.B6E46770--
-------------------------------------------------------
--
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.
