No subject

[Quintin]

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" <hugh at open.com.au>
To: "Quintin" <wtlam at macau.ctm.net>; <radiator at open.com.au>
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                               mikem at open.com.au
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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.