Hi Andrew,
On Feb 6, 7:11pm, Andrew McManus wrote:
> Subject: Multiple Statements in AcctSQLStatement
> Hi Group,
>
> We are also having problems with multiple entries for the one session being
> inserted.
>
> I have researched the Archive, but i need to know what the following effect
> would be if I tried to include a second SQL Statement in the
> AcctSQLStatement and how the accounting process would handle it.
>
> I'm really new to Radiator, but am a long time SQL user.
You can run multiple queriesd by defining several AcctSQLStatements:
AcctSQLStatement delete from ACCOUNTINGTABLE where .....
AcctSQLStatement INSERT INTO ACCOUNTINGTABLE .....
>
>
> ie:
>
> delete from ACCOUNTINGTABLE where \
> USERNAME='%{User-Name}' and \
> ACCTSESSIONID='%{Acct-Session-Id}' and \
> NASIDENTIFIER='%{NAS-IP-Address}' \
> INSERT INTO ACCOUNTINGTABLE \
> USERNAME, ACCTSESSIONID ... VALUES ('%{User-Name}', '%{Acct-Session-Id}'
>
> Any help would be appreciated.
>
> Regards
>
> > Andrew McManus
> > Senior NT Systems Engineer
> >
> > Davnet Telecommunications Pty Ltd
> > Level 7, 209 Castlereagh Street
> > SYDNEY NSW 2000
> >
> > Tel: 61 2 9272 9600
> > Fax: 61 2 9272 9624
> > mailto:[EMAIL PROTECTED]
> > www.davnet.com.au
> > ---------------------------------------------------------
> > Australian General Telecommunications Carrier License No 23
> > ---------------------------------------------------------
> > Disclaimer:
> >
> > Please note that this correspondence is for the named
> > person's use only and may contain information that is
> > confidential and privileged.
> >
> > If you received this correspondence in error, please
> > immediately delete it from your system and notify
> > the sender. Please ensure that you do not disclose,
> > copy or rely on any part of this correspondence if
> > you are not the intended recipient. We apologise for
> > any inconvenience and thank you for your assistance.
> >
> > Please note that nothing in this correspondence shall
> > be construed or otherwise relied upon by the recipient
> > as an offer, acceptance of an offer, representation,
> > agreement or resolution of any kind.
> > ---------------------------------------------------------
> >
> >
>
>-- End of excerpt from Andrew McManus
--
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
