* This is the VOP Radius mailing list *
I am using MS SQL Server 2000
Best Regards,
Christian Ransley B.Sc.
Technical Operations Manager
Keyworld Ltd.
UB42, Industrial Zone
San Gwann SGN 09
Tel: (+356) 2540 2540
Fax: (+356) 2540 2541
Email: [EMAIL PROTECTED]
Website: http://www.keyworld.net
-----Original Message-----
From: Eric Dean [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 3:07 PM
To: [EMAIL PROTECTED]
Subject: [VOPRadius] Accounting Log Accurate Display
* This is the VOP Radius mailing list *
SQLServer?
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Chris Ransley
> Sent: Friday, December 05, 2003 7:40 AM
> To: [EMAIL PROTECTED]
> Subject: [VOPRadius] Accounting Log Accurate Display
>
>
> * This is the VOP Radius mailing list *
>
> Sorry for being such a dimwit but how do I do that?
>
> Best Regards,
>
> Christian Ransley B.Sc.
> Technical Operations Manager
>
> Keyworld Ltd.
> UB42, Industrial Zone
> San Gwann SGN 09
> Tel: (+356) 2540 2540
> Fax: (+356) 2540 2541
>
> Email: [EMAIL PROTECTED]
> Website: http://www.keyworld.net
>
>
> -----Original Message-----
> From: Eric Dean [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 04, 2003 3:08 PM
> To: [EMAIL PROTECTED]
> Subject: [VOPRadius] Accounting Log Accurate Display
>
> * This is the VOP Radius mailing list *
> Create a trigger that does a subsql lookup to see if a record
> with that data already exists and then flag the incoming
> records as duplicates.
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Chris Ransley
> > Sent: Thursday, December 04, 2003 3:29 AM
> > To: [EMAIL PROTECTED]
> > Subject: [VOPRadius] Accounting Log Accurate Display
> >
> >
> > * This is the VOP Radius mailing list *
> > That's a very good workaround however this would generate
> > additional lines of errors in the error log. Is there another
> > way that would not do that?
> >
> > Best Regards,
> >
> > Christian Ransley B.Sc.
> > Technical Operations Manager
> >
> > Keyworld Ltd.
> > UB42, Industrial Zone
> > San Gwann SGN 09
> > Tel: (+356) 2540 2540
> > Fax: (+356) 2540 2541
> >
> > Email: [EMAIL PROTECTED]
> > Website: http://www.keyworld.net
> >
> >
> > -----Original Message-----
> > From: Eric Dean [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 04, 2003 1:39 AM
> > To: [EMAIL PROTECTED]
> > Subject: [VOPRadius] Accounting Log Accurate Display
> >
> > * This is the VOP Radius mailing list *
> > Place a unique constraint on
> > username,nasip,framedip,acctsessionid,acctstatustype...dupes
> > will fail database insert
> >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of Chris Ransley
> > > Sent: Wednesday, December 03, 2003 10:42 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: [VOPRadius] Accounting Log Accurate Display
> > >
> > >
> > > * This is the VOP Radius mailing list *
> > > Does anyone have a script that can read from the
> accounting log and
> > > display an accurate session history of a user. The issue
> I am having
> > > is that I seem to have several duplicate entries with
> delay of 5 or
> > > 10 seconds.
> > >
> > > I require this to be able to bill the user for his exact usage. I
> > > keep the data in an SQL dbase.
> > >
> > > Best Regards,
> > >
> > > Christian Ransley B.Sc.
> > > Technical Operations Manager
> > >
> > > Keyworld Ltd.
> > > UB42, Industrial Zone
> > > San Gwann SGN 09
> > > Tel: (+356) 2540 2540
> > > Fax: (+356) 2540 2541
> > >
> > > Email: [EMAIL PROTECTED]
> > > Website: http://www.keyworld.net
>
>
> **
> To leave this list, send an email to
> [EMAIL PROTECTED] and put the word "LEAVE" in the
> BODY of the email.
>
**
To leave this list, send an email to [EMAIL PROTECTED]
and put the word "LEAVE" in the BODY of the email.
**
To leave this list, send an email to [EMAIL PROTECTED]
and put the word "LEAVE" in the BODY of the email.