[RadiusNT Digest]
radiusnt-digest-request@iea-software.com
Wed, 8 Jul 1998 00:00:49 -0700
Message 1: Re: OK, any online docs on populating serverports table?
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 2: Re: OK, any online docs on populating serverports table?
from "James B. Hrdy" <jhrdy@greensoft.com>
Message 3: How to e-mail usage reports?
from "Michael G. Minnich" <mminnich@logan.net>
Message 4: Re: How to e-mail usage reports?
from "Danny Sinang" <danny@uplink.com.ph>
Message 5: Re: How to e-mail usage reports?
from hostmaster@interaxs.net
Message 6: RE: How to e-mail usage reports?
from "Mike Roberts" <mike@datawest.net>
Message 7: RE: How to e-mail usage reports?
from hostmaster@interaxs.net
Message 8: Re: How to e-mail usage reports?
from "Michael G. Minnich" <mminnich@logan.net>
Message 9: SQL tips for RadiusNT
from postman@cp-tel.net (Postman Account)
Message 10: Re: How to e-mail usage reports?
from will@greennet.net (Will LaSala)
Message 11: Re: How to e-mail usage reports?
from "Michael G. Minnich" <mminnich@logan.net>
Message 12:
from "Chuck Scott" <chuck@iol-intl.net>
Message 13: (no subject)
from Danny <Danny@elink.net>
Message 14: (no subject)
from ckung@amer.net (Charles Kung)
Message 15:
from "Chuck Scott" <chuck@integrityonline.com>
Message 16: Re: How to e-mail usage reports?
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 17: Re: How to e-mail usage reports?
from "Paul Rensel" <paul@ixs.nl>
Message 18: Re: How to e-mail usage reports?
from "Richard Sensale" <wolfen@visitus.net>
Message 19: Re: Calls table primary key
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 20: Re: Emerald Accounting
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 21: Re: StartTime and StopTime not functioning
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 22: Re: StartTime and StopTime not functioning
from "mauro" <mauro@citynet.net.ar>
Message 23: No Accounting
from Victor Alba <victor@webjogger.net>
Message 24: Re: Emerald Accounting
from Glen Harvy <root@aquarius.com.au>
Message 25: Time of day account needed.
from Mark Colasante <mcola@exchange.netexp.net>
Message 26: Re: Emerald Accounting
from Glen Harvy <root@aquarius.com.au>
Message 27: Re: Time of day account needed.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 28: unsubscribe
from Pietro Bisignano <bisignano@imd.it>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: OK, any online docs on populating serverports table?
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Tue, 07 Jul 1998 00:47:32 -0700
> Jason Chimney wrote:
>
> All seems to be going well on the authenticating side of things. Now I have
> turned my attention to accounting. My calls table works fine, but my calls
> online query doesn't, I realize this is due to the fact that my serverports
> table is empty.
>
> Anyone care to give any insight on populating this table. I look at the calls
> table but each port seems to be bound to more than 1 IP address (i.e. calls
> coming in on any given port are not always assigned the same IP address, is
> this ok?)
The only two important fields in the ServePorts table (unless you turn on
features like Server Port Access or ConCurrency control) are ServerID and
Port. The ServerID should match the ServerID of the server this port is
associated to (from the servers table). The Port should match what the NAS
sends in the NAS-Port attribute for accounting records. For example a
livingston PM3 sends 0-47 for a dual CT1 configuration. You need a
record for EACH port. RadiusNT will update the serverports table (via
the CallsOnline view or directly), but it will not add entries to the
table.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: OK, any online docs on populating serverports table?From: "James B. Hrdy" <jhrdy@greensoft.com>Date: Tue, 7 Jul 1998 08:19:45 +0000
If you have a bunch of call records, you could query them into the serverports table.
The calls table has the server ports in it and if you do a where unique update sort of query, you can get them into the serverports table. This is especially helpfull when dealing with a bunch of NAS's....
> > Jason Chimney wrote:> > > > All seems to be going well on the authenticating side of things. Now I> > have turned my attention to accounting. My calls table works fine, but> > my calls online query doesn't, I realize this is due to the fact that my> > serverports table is empty.> > > > Anyone care to give any insight on populating this table. I look at the> > calls table but each port seems to be bound to more than 1 IP address> > (i.e. calls coming in on any given port are not always assigned the same> > IP address, is this ok?)> > The only two important fields in the ServePorts table (unless you turn on> features like Server Port Access or ConCurrency control) are ServerID and> Port. The ServerID should match the ServerID of the server this port is> associated to (from the servers table). The Port should match what the> NAS sends in the NAS-Port attribute for accounting records. For example a> livingston PM3 sends 0-47 for a dual CT1 configuration. You need a record> for EACH port. RadiusNT will update the serverports table (via the> CallsOnline view or directly), but it will not add entries to the table.> > -- > Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>
James B. Hrdyemail: jhrdy@greensoft.comweb: http://www.greensoft.com/billingGreenSoft Solutions, Inc.Voice: 785.843.8683 ext 2032317 Ponderosa DriveFax: 785.840.0055Lawrence, Ks.United States of America
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: How to e-mail usage reports?From: "Michael G. Minnich" <mminnich@logan.net>Date: Tue, 07 Jul 1998 09:56:32 -0400
We have just upgraded to 2.5.124 using (temporarily) an Access database. Wewant to e-mail a usage report to each member at the end of each month,showing username, call history, and total usage. Can someone please pointus to how we can do this?
It would also be nice to automatically then delete or archive the callsrecords for the prior month. I kind of remember a script discussion on thispoint recently.
Sorry if these have been answered before, the search page at iea is notworking right now.
TIA,*********Michael G. Minnich, President Access Visions CorporationVoice: 937.593.7177 x.126 Fax: 937.592.4165
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: "Danny Sinang" <danny@uplink.com.ph>Date: Tue, 7 Jul 1998 22:07:37 +0800
You could make an ASP script to :
1. fetch the data from the database2. save the report to a text file3. email the report to the user4. delete or archive the calls records
Run the script every month.
Go to www.flicks.com to get a free ASP smtp component.
Danny Sinang
-----Original Message-----From: Michael G. Minnich <mminnich@logan.net>To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>Date: Tuesday, July 07, 1998 10:02 PMSubject: How to e-mail usage reports?
>We have just upgraded to 2.5.124 using (temporarily) an Access database. We>want to e-mail a usage report to each member at the end of each month,>showing username, call history, and total usage. Can someone please point>us to how we can do this?>>It would also be nice to automatically then delete or archive the calls>records for the prior month. I kind of remember a script discussion on this>point recently.>>Sorry if these have been answered before, the search page at iea is not>working right now.>>TIA,>*********>Michael G. Minnich, President Access Visions Corporation>Voice: 937.593.7177 x.126 Fax: 937.592.4165
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: hostmaster@interaxs.netDate: Tue, 07 Jul 1998 11:11:43 -0400
I would create a Macro to do all that you want to do.
First, export a tab delimited text file with the email address and statsfrom a query on the Calls table. Use Pegasus mail client to do the mailmerge (create a template text file with placeholders to plug the data fromthe text file into). Then, have the macro run a delete query on the Callstable, or arachive the call records in the Calls Export (History) table.The macro cam even launch Pegasus for you.
I do a very similar operation for our email billing and it works very well.
Jim
btw, if you have the latest copy of the radius.mdb (or whatever it isnamed) you should have the necessary queries to do the archiving anddeletion of the Calls records :)
At 09:56 AM 7/7/98 -0400, you wrote:>We have just upgraded to 2.5.124 using (temporarily) an Access database. We>want to e-mail a usage report to each member at the end of each month,>showing username, call history, and total usage. Can someone please point>us to how we can do this? >>It would also be nice to automatically then delete or archive the calls>records for the prior month. I kind of remember a script discussion on this>point recently.>>Sorry if these have been answered before, the search page at iea is not>working right now.>>TIA,>*********>Michael G. Minnich, President Access Visions Corporation>Voice: 937.593.7177 x.126 Fax: 937.592.4165> ----------------------------hostmaster@interaxs.netInterNet Access Network18 McDaniel StreetDayton, OH 45405-4816Voice: 937-461-3660 Fax:937-228-2773
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: How to e-mail usage reports?From: "Mike Roberts" <mike@datawest.net>Date: Tue, 7 Jul 1998 09:14:39 -0600
Can Seagate Crystal Reports do this? I have just gotten v6.0 and reallyhaven't had time to play with it yet.
*Mike Roberts*DataWest Internet, LLC*Colorado Springs - http://www.datawest.net*(719) 633-5804 - ICQ 387413
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com]On Behalf Ofhostmaster@interaxs.netSent: Tuesday, July 07, 1998 9:12 AMTo: radiusnt@iea-software.comSubject: Re: How to e-mail usage reports?
I would create a Macro to do all that you want to do.
First, export a tab delimited text file with the email address and statsfrom a query on the Calls table. Use Pegasus mail client to do the mailmerge (create a template text file with placeholders to plug the data fromthe text file into). Then, have the macro run a delete query on the Callstable, or arachive the call records in the Calls Export (History) table.The macro cam even launch Pegasus for you.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: How to e-mail usage reports?From: hostmaster@interaxs.netDate: Tue, 07 Jul 1998 11:18:39 -0400
Don't know about that, but, it can all be done from within Access.
Jim
At 09:14 AM 7/7/98 -0600, you wrote:>Can Seagate Crystal Reports do this? I have just gotten v6.0 and really>haven't had time to play with it yet.>>*Mike Roberts>*DataWest Internet, LLC>*Colorado Springs - http://www.datawest.net>*(719) 633-5804 - ICQ 387413>>-----Original Message----->From: radiusnt-request@iea-software.com>[mailto:radiusnt-request@iea-software.com]On Behalf Of>hostmaster@interaxs.net>Sent: Tuesday, July 07, 1998 9:12 AM>To: radiusnt@iea-software.com>Subject: Re: How to e-mail usage reports?>>I would create a Macro to do all that you want to do.>>First, export a tab delimited text file with the email address and stats>from a query on the Calls table. Use Pegasus mail client to do the mail>merge (create a template text file with placeholders to plug the data from>the text file into). Then, have the macro run a delete query on the Calls>table, or arachive the call records in the Calls Export (History) table.>The macro cam even launch Pegasus for you.> ----------------------------hostmaster@interaxs.netInterNet Access Network18 McDaniel StreetDayton, OH 45405-4816Voice: 937-461-3660 Fax:937-228-2773
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: "Michael G. Minnich" <mminnich@logan.net>Date: Tue, 07 Jul 1998 11:23:53 -0400
>btw, if you have the latest copy of the radius.mdb (or whatever it is>named) you should have the necessary queries to do the archiving and>deletion of the Calls records :)
I *knew* that. too little sleep and too many allergies. Sorry.
We want the e-mail usage report not for billing as our billing system isadequate, but to satisfy the curious. When we used an upstream ISP that wasUnix based, they e-mailed monthly txt reports to each user. Since we becamean NT shop, and standalone, we have not sent reports and the natives aregrowing restless.
Thanks for the suggestions so far. When we get something to work, we willpost how we did it.
*********Michael G. Minnich, President Access Visions CorporationVoice: 937.593.7177 x.126 Fax: 937.592.4165
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SQL tips for RadiusNTFrom: postman@cp-tel.net (Postman Account)Date: Tue, 07 Jul 1998 10:29:42 -0500
Does anyone have MS SQL tips for RadiusNT?
I had heard that there is a script to check the database for possible errors..? Is there such a thing...? if so,where is it... what does it do?
Any other suggestions? (I'm trying to learn enoughSQL to get RadiusNT working properly and to keep it running.)
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: will@greennet.net (Will LaSala)Date: Tue, 7 Jul 1998 13:00:37 -0400
I think I'm kinda confused on this one.What type of usage reports?Amount of time during a day or amount of bytes being sent and received or amI missing it totally?ThanksWill ,,,=^. .^=,,,WebmasterGreenNet® ========================================"Link Locally ~ Surf Globally©" http://www.greennet.netCome Play On The Best Quake Server in the NortheastServing Eastern Massachusetts and Southern New HampshireTEL: 978-363-8898 FAX: 978-363-1225 email:will@greennet.net===============================================-----Original Message-----From: Michael G. Minnich <mminnich@logan.net>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Tuesday, July 07, 1998 11:24 AMSubject: Re: How to e-mail usage reports?
>>btw, if you have the latest copy of the radius.mdb (or whatever it is>>named) you should have the necessary queries to do the archiving and>>deletion of the Calls records :)>>I *knew* that. too little sleep and too many allergies. Sorry.>>We want the e-mail usage report not for billing as our billing system is>adequate, but to satisfy the curious. When we used an upstream ISP that was>Unix based, they e-mailed monthly txt reports to each user. Since we became>an NT shop, and standalone, we have not sent reports and the natives are>growing restless.>>Thanks for the suggestions so far. When we get something to work, we will>post how we did it.>>>*********>Michael G. Minnich, President Access Visions Corporation>Voice: 937.593.7177 x.126 Fax: 937.592.4165
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: "Michael G. Minnich" <mminnich@logan.net>Date: Tue, 07 Jul 1998 13:02:55 -0400
At 01:00 PM 7/7/98 -0400, you wrote:>I think I'm kinda confused on this one.>What type of usage reports?>Amount of time during a day or amount of bytes being sent and received or am>I missing it totally?
amount of time during a day. *********Michael G. Minnich, President Access Visions CorporationVoice: 937.593.7177 x.126 Fax: 937.592.4165
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: "Chuck Scott" <chuck@iol-intl.net>Date: Tue, 7 Jul 1998 11:41:49 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01BDA99C.3A45FEE0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
unsubscribe
------=_NextPart_000_0006_01BDA99C.3A45FEE0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
unsubscribe
------=_NextPart_000_0006_01BDA99C.3A45FEE0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: (no subject)From: Danny Date: Tue, 07 Jul 1998 14:55:39 -0400unsubscribe..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: (no subject)From: ckung@amer.net (Charles Kung)Date: Tue, 07 Jul 1998 11:49:40 -0700unsubscribe..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: "Chuck Scott" Date: Tue, 7 Jul 1998 11:57:23 -0700We are currently working on a project, and I have a question for you all. Iam wanting to use various ISP's as hosts for my service. I need a way tohave my customers dial-in to the host ISP's existing term servers, and thenhave the term server, I am assumong thru RADIUS, point the customer to aspecific gateway where myserver is located. In other words, they can utilize the same dial-up numberbut have two servers offering two different types of service. I beleivethis is similar to what Earthlink, AOL, all the big boys do. Any help wouldbe great !!Chuck Scott..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: "Dale E. Reed Jr." Date: Tue, 07 Jul 1998 12:51:49 -0700Michael G. Minnich wrote:> > We want the e-mail usage report not for billing as our billing system is> adequate, but to satisfy the curious. When we used an upstream ISP that was> Unix based, they e-mailed monthly txt reports to each user. Since we became> an NT shop, and standalone, we have not sent reports and the natives are> growing restless.> > Thanks for the suggestions so far. When we get something to work, we will> post how we did it.Getting the reports is the easy part. Mailing them might be thechallenging part. What I would recommend is a simple web interfaceto allow your customers to get thier usage anytime they want. Thenthose that want it can, and those that don't, will not get thiermailbox cluttered with information.-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: "Paul Rensel" Date: Tue, 7 Jul 1998 22:04:44 +0200Hi,We solved this by creating a query which updates an CallHistory table everynight at 00:00, a user can then 'view' this CallHistory table from ourwebsite, they can view totals per month, and selecting the month they canselect the calls per day.Best Regards,..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How to e-mail usage reports?From: "Richard Sensale" Date: Tue, 7 Jul 1998 16:02:06 -0400I have a suggestion. Would it be possible to modify your email invoicingreport to include the usage data on a seperate page? This seems like itshould be feasable.-----Original Message-----From: Dale E. Reed Jr. To: radiusnt@iea-software.com Date: Tuesday, July 07, 1998 10:45 AMSubject: Re: How to e-mail usage reports?>Michael G. Minnich wrote:>>>> We want the e-mail usage report not for billing as our billing system is>> adequate, but to satisfy the curious. When we used an upstream ISP thatwas>> Unix based, they e-mailed monthly txt reports to each user. Since webecame>> an NT shop, and standalone, we have not sent reports and the natives are>> growing restless.>>>> Thanks for the suggestions so far. When we get something to work, we will>> post how we did it.>>Getting the reports is the easy part. Mailing them might be the>challenging part. What I would recommend is a simple web interface>to allow your customers to get thier usage anytime they want. Then>those that want it can, and those that don't, will not get thier>mailbox cluttered with information.>>-->Dale E. Reed Jr. (daler@iea-software.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls table primary keyFrom: "Dale E. Reed Jr." Date: Tue, 07 Jul 1998 13:17:41 -07002Day Internet wrote:> > Is there any reason the calls table uses> > NASIdentifier> NASPort> AcctSessionID> AcctStatusType> > as a primary key rather than a seeded integer?Yes. Althought the NASPort field is not needed, the rest are requiredsince they are the only way of telling whether RadiusNT has seen thisaccounting record before. You could add a INDENTITY column and makea unique index out of the three fields, but what would that gain you? > Now that my Netserver/8i produces AcctSessionID's up to 30-35 chars in len,> I thought I might change the schema to get that column out of the primary> key.You can basically do anything you want. However, you may alter thebehavior of what comes into the database if you change the keys.-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald AccountingFrom: "Dale E. Reed Jr." Date: Tue, 07 Jul 1998 13:25:44 -0700Glen Harvy wrote:> > I have Radius 2.5 Authentication working fine however Accounting isn't.> > When I access the record for my "test" user, no details of his connections> are recorded. The User-on-line doesn't work either.The problem is that it is trying to match the NASIdentifier attributewith the IP Address you specified in the servers table. However, theNAS-Identifier shown below isn't an IP Address. One way to work aroundthis is to add a second server in the Emerald Admin with an IP addressof "comserv2". Then things should start appearing. > Here's an excerpt from my accounting log:-> > radrecv: Request from host cb3a192e code=4, id=20, length=139> Acct-Status-Type = Start> Acct-Session-Id = "35A19CC7D6"> Acct-Delay-Time = 0> User-Name = "terry"> NAS-Identifier = "comserv2"> NAS-Port = 3> NAS-Port-Type = Async> User-Service = Framed-User> Framed-Protocol = PPP> Framed-Address = 203.58.25.47> Framed-Routing = Broadcast-Listen> Framed-MTU = 1500> Framed-Compression = Van-Jacobsen-TCP-IP> Framed-Compression = 2> Framed-IPX-Network = 0> Framed-AppleTalk-Network = 0> Idle-Timeout = 600> Session-Timeout = 0> > SQL Statement: INSERT INTO Calls> (CallDate,AcctStatusType,AcctSessionId,AcctDelayTime,UserName,NASIdentifier,> NASPort,NASPortType,UserService,FramedProtocol,FramedAddress) VALUES> (GetDate(),1,'35A19CC7D6',0,'terry','comserv2',3,0,2,1,'203.58.25.47')> -- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: StartTime and StopTime not functioningFrom: "Dale E. Reed Jr." Date: Tue, 07 Jul 1998 13:29:22 -0700Mauro J. Jaskelioff wrote:> > I can't get the StartTime and StopTime to work. In -x15 mode I can see> Radius using the RadCheckPort Procedure, but radius seems to ignore the> startime and stoptime fields.> Example:> I wan't to limit from 6AM to 6PM> StartTime-------- 120> StopTime----------1080> CurrentTime-------686> > But the user is allowed to login.> > What I am doing wrong?120 is 2am, not 6am. And since 686 is between the start and stop time,the user is allowed on. Maybe you used a bad example, but the aboveis all correct.-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 22 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: StartTime and StopTime not functioningFrom: "mauro" Date: Tue, 7 Jul 1998 18:49:09 -0300You're right, is a bad example.Anyway, no matter what I put in the stoptime and startime, the user isallowed to login. What should I check?-----Original Message-----From: Dale E. Reed Jr. To: radiusnt@iea-software.com Date: Tuesday, July 07, 1998 9:29 PMSubject: Re: StartTime and StopTime not functioning>Mauro J. Jaskelioff wrote:>>>> I can't get the StartTime and StopTime to work. In -x15 mode I can see>> Radius using the RadCheckPort Procedure, but radius seems to ignore the>> startime and stoptime fields.>> Example:>> I wan't to limit from 6AM to 6PM>> StartTime-------- 120>> StopTime----------1080>> CurrentTime-------686>>>> But the user is allowed to login.>>>> What I am doing wrong?>>120 is 2am, not 6am. And since 686 is between the start and stop time,>the user is allowed on. Maybe you used a bad example, but the above>is all correct.>>-->Dale E. Reed Jr. (daler@iea-software.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com>..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 23 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: No AccountingFrom: Victor Alba Date: Tue, 07 Jul 1998 19:16:38 -0400I'm not sure if this is a radius or Emerlad question that's why I've postedto both lists..... Radius itself seems to be working ok but I can't getEmerald to do the accounting. This is what I'm getting when I do theaccounting test using 'Radlogin' :------------------------------------------------------------- Enterprise features enabled.RadiusNT (Emerald Standard) Initialized...radrecv: Request from host d09d8703 code=4, id=240, length=59 NAS-Identifier = 127.0.0.1 NAS-Port = 0 User-Name = "dfadda" Acct-Session-Id = "3574822240" Acct-Status-Type = Start SQL Statement: INSERT INTO Calls(CallDate,NASIdentifier,NASPort,UserName,AcctSessionId,AcctStatusType) VALUES(GetDate(),'127.0.0.1',0,'Pdfadda','3574822240',1)ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'AcctSessionId'.Resp Time: 78 Auth: 0/0 -> 0 Acct: 0/1/0 -> 1-----------------------------------------------------------------That's as far as it goes, then when I open emerald and click on the On-linetab all I get is "SQL failed".What's happening here...?-Victor..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 24 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald AccountingFrom: Glen Harvy Date: Wed, 08 Jul 1998 09:32:34 +1000At 13:25 7/07/98 -0700, you wrote:>Glen Harvy wrote:>> >> I have Radius 2.5 Authentication working fine however Accounting isn't.>> >> When I access the record for my "test" user, no details of his connections>> are recorded. The User-on-line doesn't work either.>>The problem is that it is trying to match the NASIdentifier attribute>with the IP Address you specified in the servers table. However, the>NAS-Identifier shown below isn't an IP Address. One way to work around>this is to add a second server in the Emerald Admin with an IP address>of "comserv2". Then things should start appearing.> OK. I did that and now the "Calls On-Line" works but that's all. Details ofthe login are not showing in the users details section. Here's an excerptfrom the accounting log:-radrecv: Request from host cb3a192e code=4, id=10, length=139 Acct-Status-Type = Start Acct-Session-Id = "35A2AD7635" Acct-Delay-Time = 0 User-Name = "terry" NAS-Identifier = "comserv2" NAS-Port = 3 NAS-Port-Type = Async User-Service = Framed-User Framed-Protocol = PPP Framed-Address = 203.58.25.47 Framed-Routing = Broadcast-Listen Framed-MTU = 1500 Framed-Compression = Van-Jacobsen-TCP-IP Framed-Compression = 2 Framed-IPX-Network = 0 Framed-AppleTalk-Network = 0 Idle-Timeout = 600 Session-Timeout = 0 SQL Statement: INSERT INTO Calls(CallDate,AcctStatusType,AcctSessionId,AcctDelayTime,UserName,NASIdentifier,NASPort,NASPortType,UserService,FramedProtocol,FramedAddress) VALUES(GetDate(),1,'35A2AD7635',0,'terry','comserv2',3,0,2,1,'203.58.25.47')Sending Accounting Ack of id 10 to cb3a192e (comserv2)Resp Time: 40 Auth: 1/1 -> 2 Acct: 1/0/0 -> 1radrecv: Request from host cb3a192e code=4, id=11, length=103 Acct-Status-Type = Stop Acct-Session-Id = "35A2AD7635" Acct-Delay-Time = 0 User-Name = "terry" NAS-Identifier = "comserv2" NAS-Port = 3 Acct-Input-Octets = 2388 Acct-Output-Octets = 7312 Acct-Input-Packets = 22 Acct-Output-Packets = 49 Acct-Session-Time = 120 Acct-Terminate-Cause = 0 SQL Statement: INSERT INTO Calls(CallDate,AcctStatusType,AcctSessionId,AcctDelayTime,UserName,NASIdentifier,NASPort,AcctInputOctets,AcctOutputOctets,AcctSessionTime,AcctTerminateCause) VALUES (GetDate(),2,'35A2AD7635',0,'terry','comserv2',3,2388,7312,120,0)Sending Accounting Ack of id 11 to cb3a192e (comserv2)Resp Time: 20 Auth: 1/1 -> 2 Acct: 2/0/0 -> 2Glen.--------------------------------------------------------------------AQUARIUS Communications for all your Internet<>Fidonet needs <>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailervoice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930http://www.aquarius.com.au <> mailto:sales@aquarius.com.au ..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 25 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Time of day account needed.From: Mark Colasante Date: Tue, 7 Jul 1998 20:07:51 -0400I am running Radius 2.5 with ODBC and SQL server. I would like tocreate an account that only log in during a certain time of day. Isthis merely an account type? If so, what are the Radius attributes touse, etc. Is there an example in the documentation?Thanks,Mark ColasanteNetExpress...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 26 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald AccountingFrom: Glen Harvy Date: Wed, 08 Jul 1998 12:21:13 +1000Hi Dale,I'll read all the documentation before I ask any more stupid questions .Thanks for your support....At 09:32 8/07/98 +1000, you wrote:>At 13:25 7/07/98 -0700, you wrote:>>Glen Harvy wrote:>>> >>> I have Radius 2.5 Authentication working fine however Accounting isn't.>>> >>> When I access the record for my "test" user, no details of his connections>>> are recorded. The User-on-line doesn't work either.>>>>The problem is that it is trying to match the NASIdentifier attribute>>with the IP Address you specified in the servers table. However, the>>NAS-Identifier shown below isn't an IP Address. One way to work around>>this is to add a second server in the Emerald Admin with an IP address>>of "comserv2". Then things should start appearing.>> >>OK. I did that and now the "Calls On-Line" works but that's all. Details of>the login are not showing in the users details section. Here's an excerpt>from the accounting log:->>radrecv: Request from host cb3a192e code=4, id=10, length=139> Acct-Status-Type = Start> Acct-Session-Id = "35A2AD7635"> Acct-Delay-Time = 0> User-Name = "terry"> NAS-Identifier = "comserv2"> NAS-Port = 3> NAS-Port-Type = Async> User-Service = Framed-User> Framed-Protocol = PPP> Framed-Address = 203.58.25.47> Framed-Routing = Broadcast-Listen> Framed-MTU = 1500> Framed-Compression = Van-Jacobsen-TCP-IP> Framed-Compression = 2> Framed-IPX-Network = 0> Framed-AppleTalk-Network = 0> Idle-Timeout = 600> Session-Timeout = 0>> SQL Statement: INSERT INTO Calls>(CallDate,AcctStatusType,AcctSessionId,AcctDelayTime,UserName,NASIdentifier,>NASPort,NASPortType,UserService,FramedProtocol,FramedAddress) VALUES>(GetDate(),1,'35A2AD7635',0,'terry','comserv2',3,0,2,1,'203.58.25.47')>>Sending Accounting Ack of id 10 to cb3a192e (comserv2)>>Resp Time: 40 Auth: 1/1 -> 2 Acct: 1/0/0 -> 1>radrecv: Request from host cb3a192e code=4, id=11, length=103> Acct-Status-Type = Stop> Acct-Session-Id = "35A2AD7635"> Acct-Delay-Time = 0> User-Name = "terry"> NAS-Identifier = "comserv2"> NAS-Port = 3> Acct-Input-Octets = 2388> Acct-Output-Octets = 7312> Acct-Input-Packets = 22> Acct-Output-Packets = 49> Acct-Session-Time = 120> Acct-Terminate-Cause = 0>> SQL Statement: INSERT INTO Calls>(CallDate,AcctStatusType,AcctSessionId,AcctDelayTime,UserName,NASIdentifier,>NASPort,AcctInputOctets,AcctOutputOctets,AcctSessionTime,AcctTerminateCause)> VALUES (GetDate(),2,'35A2AD7635',0,'terry','comserv2',3,2388,7312,120,0)>>Sending Accounting Ack of id 11 to cb3a192e (comserv2)>>Resp Time: 20 Auth: 1/1 -> 2 Acct: 2/0/0 -> 2>>>Glen.>-------------------------------------------------------------------->AQUARIUS Communications for all your Internet<>Fidonet needs ><>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer>voice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930>http://www.aquarius.com.au <> mailto:sales@aquarius.com.au >>Glen.--------------------------------------------------------------------AQUARIUS Communications for all your Internet<>Fidonet needs <>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailervoice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930http://www.aquarius.com.au <> mailto:sales@aquarius.com.au ..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 27 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Time of day account needed.From: "Dale E. Reed Jr." Date: Tue, 07 Jul 1998 22:15:38 -0700Mark Colasante wrote:> > I am running Radius 2.5 with ODBC and SQL server. I would like to> create an account that only log in during a certain time of day. Is> this merely an account type? If so, what are the Radius attributes to> use, etc. Is there an example in the documentation?What you are looking for is Server Port Access. It includes theability to specify start time and stop time control per accounttype. This is covered in the documentation.-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 28 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: unsubscribeFrom: Pietro Bisignano Date: Wed, 08 Jul 1998 08:16:06 +0200unsubscribe