Message 2:
from "Rick Morgan" <eval2@gtn.net>
Message 3: Radius / SQL question for Calls Table
from postman@cp-tel.net (Postman Account)
Message 4: Re: Radius / SQL question for Calls Table
from Brian Lube <brian@mpinet.net>
Message 5: SQL Timing Out
from CPD- Jr <jr@ceub.br>
Message 6: Re: SQL Timing Out
from "Fernando Lessa Pesa Filho" <flp@myway.com.br>
Message 7: Re: Attribute 26 - vendor specific ?
from "Mike Stankavich" <mike@ethergate.com>
Message 8: Re: User Restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 9: Re: User Restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 10: (no subject)
from linyan <linyan@chinagb.net>
Message 11: RE: User Restrictions
from "Robert F. O'Connor" <sysadmin@metro.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: meaning
From: "Humberto Guzman" <hguzman@sysop.com.mx>
Date: Mon, 24 Aug 1998 11:56:20 +0000
Hello,
I understand, most of what I find in my RadiusNT log, but the following
three logs are new to me :) .... Could someone tell me what they mean and
how I can correct them...
Sun Aug 23 17:49:20 1998: ODBC Error:08001:6:
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]Specified SQL server not found.
Sun Aug 23 18:14:08 1998: ODBC Error:23000:2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_RadLogs': Attempt to insert duplicate key in object 'RadLogs'.
Mon Aug 24 09:55:40 1998: ODBC Error:37000:151:
[Microsoft][ODBC SQL Server Driver][SQL Server] '$' is an invalid money
value.
Thanks!
Humberto Guzman
________________________________________
Servicio de Comunicacion En Linea SA de CV
SysOp Interrnet
Tel. 338-9424
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: "Rick Morgan" <eval2@gtn.net>
Date: Tue, 25 Aug 1998 13:09:59 -0400
unsubscribe
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Radius / SQL question for Calls Table
From: postman@cp-tel.net (Postman Account)
Date: Tue, 25 Aug 1998 12:31:29 -0500
Do you have to shut down RadiusNT to delete old calls table
information from the SQL database? (...for the previous month)
Also, is there a command to automate the deletion process... such
as a variable... or statement... to delete the previous month's call data?
....as opposed to having to specifiy the previous month by name.
Thanks in advance...
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Radius / SQL question for Calls Table
From: Brian Lube <brian@mpinet.net>
Date: Tue, 25 Aug 1998 14:30:04 -0400
At 12:31 PM 8/25/98 -0500, you wrote:
>
>Do you have to shut down RadiusNT to delete old calls table
>information from the SQL database? (...for the previous month)
>
>Also, is there a command to automate the deletion process... such
>as a variable... or statement... to delete the previous month's call data?
>...as opposed to having to specifiy the previous month by name.
>
>Thanks in advance...
No, and Yes. You can still be running RadiusNT while you are deleting
calls out (but the authentications might be a bit slow).
To automate the process I would suggest using the following command (this
is for stuff over 3 months old) -
DELETE from Calls WHERE CallDate < DateAdd(Day, 0-91, GetDate())
hope this helps!
Brian Lube
System Administrator
MPInet
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: SQL Timing Out
From: CPD- Jr <jr@ceub.br>
Date: Tue, 25 Aug 1998 15:50:00 -0300
Hello All,
The Calls table has more than 10Mb for less than 30 days, I'm trying to
make an asp to show time online per user, but the query is taking too
long and SQL is timing out.
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Any idea how to solve it ?
TIA,
JR
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 6 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: SQL Timing Out
From: "Fernando Lessa Pesa Filho" <flp@myway.com.br>
Date: Wed, 26 Aug 1998 17:43:00 -0300
Hello.
First, you could try increasing the time out: Server.ScriptTimeOut = n
If the problem continues, you could try changing the order of the fields and
put Login as the first one, with the apropriate index. I've done it with
Access and it worked just fine.
I hope this helps you.
Fernando
MyWay ISP
-----Mensagem original-----
De: CPD- Jr <jr@ceub.br>
Para: radiusnt@iea-software.com <radiusnt@iea-software.com>
Data: Terça-feira, 25 de Agosto de 1998 16:03
Assunto: SQL Timing Out
>Hello All,
>The Calls table has more than 10Mb for less than 30 days, I'm trying to
>make an asp to show time online per user, but the query is taking too
>long and SQL is timing out.
>
>Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>
>Any idea how to solve it ?
>TIA,
>JR
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 7 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Attribute 26 - vendor specific ?
From: "Mike Stankavich" <mike@ethergate.com>
Date: Tue, 25 Aug 1998 14:30:10 -0700
Rudy,
I believe that the USR Primary-DNS attribute gets inserted in the
RadAttributes table in the script that builds the database. I know that I'm
using it and I didn't have to add it to RadAttributes. On my system I just
inserted the appropriate rows into the RadATConfigs table and I was off and
running.
Here's the insert statements from my database for account type PPP 56K.
insert RadATConfigs (AccountType, RadAttributeID, RadVendorID,
RadVendorType, Data, Value, RadCheck)
values ('PPP 56K', 26, 429, 36879, '209.210.7.2', null, 0)
insert RadATConfigs (AccountType, RadAttributeID, RadVendorID,
RadVendorType, Data, Value, RadCheck)
values ('PPP 56K', 26, 429, 36880, '209.210.7.3', null, 0)
Mike Stankavich, CTO
NorFab/ISP, Inc.
921 SW Washington St
Portland OR 97205
email: mike@ethergate.com
www - business: http://www.ethergate.com
www - personal: http://users.ethergate.com/mike
(503) 972-2810 office
(503) 972-2823 fax
-----Original Message-----
From: Rudy Komsic <rudyk@cyberglobe.net>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Monday, August 24, 1998 9:40 PM
Subject: Re: Attribute 26 - vendor specific ?
>Vendor Specific Attributes are only supported in ODBC mode. A couple
>of people have reported problems with VSA in 2.5.12x and they are
>testing a correction for it.
>
>You must add the Vendor ID in the RadVendors table (like 9 for
>Cisco, etc) and then you can add attributes into the RadAttriutes
>table with a RadAttributeID of 26, a RadVendorID matching the entry
>you added, and a RadVendorType of the VSA you want to have. The
>data portion will allways be the data speicfic to the VSA.
>
This was an old question I found. I have a USR Total Control Chassis with
the
following Vendor Specific Information. I tried to add it in according to
what
you said but it does not function... I think I need to expand or convert the
RadVendorType field for it to be supported.
Type: 26 (Vendor Specific)
Length: 14
Organization ID: 429 for US Robotics
Indicator: 0x900F
Name: Primary-DNS-Server
Server IP Addr: IP Address of DNS Server
When I tried to add it in, I got a duplicate RadAttributeID error.
How would I add this function into my radius to be able to support the
vendor
specific functions.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 8 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: User Restrictions
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Tue, 25 Aug 1998 17:05:58 -0700
Tim Ballingall wrote:
>
> I'm not disputing that you have do this.. But why..? We already have the
> RadATConfigs table that will essentially do the same thing..?
Because thats the way it was designed. Its one or the other. A future
version may change this, but thats how the current version works.
-- 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 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: User RestrictionsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 25 Aug 1998 17:16:22 -0700
Tim Ballingall wrote> > You seem to be using it the same as I am, except that when I have some> values entered in RadConfig they are causing the generic info ( All info> ) in RadATConfig to be ignored..
RadiusNT does not combine the results of the RadATConfigs with the RadConfigs table. If any records are found in the RadConfigs table,those are sent and the RadATConfigs table is not checked.
-- 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 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: (no subject)From: linyan <linyan@chinagb.net>Date: Wed, 26 Aug 1998 09:42:03 -0800
unsubscribe
--Hello Hello Hello Hello
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: User RestrictionsFrom: "Robert F. O'Connor" <sysadmin@metro.net>Date: Tue, 25 Aug 1998 19:51:44 -0700
Is this in the docs anywhere?
-Robert F. O'ConnorSystem Administrator, Metro.Netsysadmin@metro.net
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.Sent: Tuesday, August 25, 1998 5:16 PMTo: radiusnt@iea-software.comSubject: Re: User Restrictions
Tim Ballingall wrote> > You seem to be using it the same as I am, except that when I have some> values entered in RadConfig they are causing the generic info ( All info> ) in RadATConfig to be ignored..
RadiusNT does not combine the results of the RadATConfigs with the RadConfigs table. If any records are found in the RadConfigs table,those are sent and the RadATConfigs table is not checked.
-- 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