Message 2: MaxSessionLength in ServerAccess table?
from "Zak Wolfinger" <zak@cyberlink.com>
Message 3: ODBC Error:23000:-1053: Primary key cant contain null value
from "Jorge Pocaterra" <junior@enlared.net>
Message 4: Re: ODBC Error:23000:-1053: Primary key cant contain null value
from postman@cp-tel.net (Postman Account)
Message 5: Re: ODBC Error:23000:-1053: Primary key cant contain null value
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 6: Re: NT SAM Group Query
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 7: Re: Calls-Online
from "Thomas Spaulding" <tsplding@talweb.com>
Message 8: Re: ODBC Error:23000:-1053: Primary key cant contain null value
from "Jorge Pocaterra" <junior@enlared.net>
Message 9: Re: Calls-Online
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 10: Re: ODBC Error:23000:-1053: Primary key cant contain null value
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: NT SAM Group Query
From: Neil Pike <NeilPike@compuserve.com>
Date: Tue, 19 May 1998 08:41:32 -0400
I've had a quick look through the v2.2 (and 2.5) docs and I can't see
that RadiusNT supports what I want to do. Which is :-
Authorisation to specific devices to be controlled by membership of =
NT SAM groups. E.g. for Cisco router A you would need to be a member =
of CiscoGlobalGroupA, for Cisco router B CiscoGlobalGroupB etc. Is =
this possible with RadiusNT? (It looks like it is with Steel-Belted =
Radius)
Neil Pike MVP/MCSE
Protech Computing Ltd
=
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: MaxSessionLength in ServerAccess table?
From: "Zak Wolfinger" <zak@cyberlink.com>
Date: Tue, 19 May 1998 10:17:44 -0500
What is the maximum value Radius will recognize in the
MaxSessionLength field of the ServerAccess table? I have
some "no time limit" accounts. Leaving the field empty
makes it default to 4005 seconds. Setting it to 0 gives
them no time online. I tried setting it to 2592000 (1 month
= 30 days * 24hrs * 60 min * 60 secs) but then in debug mode
it shows -29440 seconds allowed.
Zak Wolfinger email: zak@cyberlink.com
CyberLink, Inc. voice: (219) 235-1400
213 S Main Street fax: (219) 235-1599
South Bend, IN 46601 www: http://www.wolfinger.net/zak
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: ODBC Error:23000:-1053: Primary key cant contain null value
From: "Jorge Pocaterra" <junior@enlared.net>
Date: Tue, 19 May 1998 13:22:47 -0400
Hi Dale
i'm running radiusNT 2.5.107 with a Computone PowerRack and a USR
Totalcontrol, now everithing is running well with the Totalcontrol but when
radius receives the stop record from the computone it gives me the following
error
ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft access 97 driver] Index or index or primary key
cant contain null value
What could be wrong with the data base?
I had the Powerrack working on an other radius server runing RadiusNT 1.49
and it was working well.
Thanks in advance
Jorge Pocaterra T.
Junior@enlared.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: ODBC Error:23000:-1053: Primary key cant contain null value
From: postman@cp-tel.net (Postman Account)
Date: Tue, 19 May 1998 13:03:36 -0500
In the RadAttributes table, change the name of Attribute #4
from NAS-IP-Address to NAS-Identifier. That should fix the problem.
The exact error message from radius -x15 was...
ODBC: SQLExecDirect Error -1053: [Microsoft][ODBC Microsoft
Access 97 Driver] Index or primary key can't contain a Null value.
At 01:22 PM 5/19/98 -0400, you wrote:
>Hi Dale
>
>i'm running radiusNT 2.5.107 with a Computone PowerRack and a USR
>Totalcontrol, now everithing is running well with the Totalcontrol but when
>radius receives the stop record from the computone it gives me the following
>error
>
>ODBC Error:23000:-1053:
>[Microsoft][ODBC Microsoft access 97 driver] Index or index or primary key
>cant contain null value
>
>What could be wrong with the data base?
>
>I had the Powerrack working on an other radius server runing RadiusNT 1.49
>and it was working well.
>
>Thanks in advance
>
>Jorge Pocaterra T.
>Junior@enlared.net
>
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: ODBC Error:23000:-1053: Primary key cant contain null value
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Tue, 19 May 1998 11:07:34 -0700
Jorge Pocaterra wrote:
>
> i'm running radiusNT 2.5.107 with a Computone PowerRack and a USR
> Totalcontrol, now everithing is running well with the Totalcontrol but when
> radius receives the stop record from the computone it gives me the following
> error
>
> ODBC Error:23000:-1053:
> [Microsoft][ODBC Microsoft access 97 driver] Index or index or primary key
> cant contain null value
>
> What could be wrong with the data base?
>
> I had the Powerrack working on an other radius server runing RadiusNT 1.49
> and it was working well.
You need to include the whole request (or atleast the whole SQL statement)
for us to detrmine more about the error. You can go into Access and
add a default value for each of the primary key fields and that should
help resolve most of these problems.
-- 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 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NT SAM Group QueryFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 19 May 1998 11:24:36 -0700
Neil Pike wrote:> > I've had a quick look through the v2.2 (and 2.5) docs and I can't see> that RadiusNT supports what I want to do. Which is :-> > Authorisation to specific devices to be controlled by membership of> NT SAM groups. E.g. for Cisco router A you would need to be a member> of CiscoGlobalGroupA, for Cisco router B CiscoGlobalGroupB etc. Is> this possible with RadiusNT? (It looks like it is with Steel-Belted> Radius)
Currently RadiusNT does not have group support for NT SAM authentication.You would have to use ODBC mode and the Server Port Access option toaccomplish this.
-- 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 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls-OnlineFrom: "Thomas Spaulding" <tsplding@talweb.com>Date: Tue, 19 May 1998 16:32:34 -0400
When I do the Manual Calls Update, it brings up Dr. Watson :-(
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Tuesday, May 19, 1998 1:28 AMSubject: Re: Calls-Online
>Thomas Spaulding wrote:>> >> Before I get too much further into it.....Should this be able to work>> properly with RadiusNT 1.60, MSAccess97, NT4.0 (sp3/Hotfixes), 3COM TCHs>> with T1s ?>> >> If so is there a web site with setup instructions? I can see the IP>> addresses of the server but no data shows up when I run the Query :-(>>Assuming you have manual calls update enabled and you have populated your>Server Ports table with the ports for the TCHs, then it should work>fine.>>-- >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 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ODBC Error:23000:-1053: Primary key cant contain null valueFrom: "Jorge Pocaterra" <junior@enlared.net>Date: Tue, 19 May 1998 16:54:15 -0400
The SQL Statement is
INSERT INTO calls (CallDate,AcctStatusType,AcctDelayTime,UserName,NasPort,AcctSessionID,AcctAuthentic,UserService,AcctSessionTime,FramedProtocol,FramedAddress,AcctinputPackets,AccountOutputPackets, AcctInputOctets,Acctoutputoctets)Values(Now(),2,60,'userlogin',8,'19.08.0',1,2,105,1,'204.179.74.48',46,42,3453,31629)
ODBC Error:23000:-1053:[Microsoft][ODBC Microsoft access 97 driver] index or primary keycan't contain null value
i'm also geting other error :
SQL statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, UserName, Data)VALUES (11, Now, 'userlogin', 'password')
ODBC Error:23000:-1605:[Microsoft][ODBC Microsoft access 97 driver] The Changes you requested tothe table where not succesfull because they would create duplicate values inthe index, primary key, or relationship. change the data in the field orfields that contain duplicate data, remove the index, or redefine the indexto permit duplicate entries and try again
But this is hapenning only with the computone PowerRack and not with theTotalcontrol and they are authenticating in the same radius ...
I have checked the database over and over
the primary key fields for calls areNasidentifier,nasport, acctsesionID,acctsessiontype,calldate
Thanks in advance
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Tuesday, May 19, 1998 2:12 PMSubject: Re: ODBC Error:23000:-1053: Primary key cant contain null value
>Jorge Pocaterra wrote:>>>> i'm running radiusNT 2.5.107 with a Computone PowerRack and a USR>> Totalcontrol, now everithing is running well with the Totalcontrol butwhen>> radius receives the stop record from the computone it gives me thefollowing>> error>>>> ODBC Error:23000:-1053:>> [Microsoft][ODBC Microsoft access 97 driver] Index or index or primarykey>> cant contain null value>>>> What could be wrong with the data base?>>>> I had the Powerrack working on an other radius server runing RadiusNT1.49>> and it was working well.>>You need to include the whole request (or atleast the whole SQL statement)>for us to detrmine more about the error. You can go into Access and>add a default value for each of the primary key fields and that should>help resolve most of these problems.>>-->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: Calls-OnlineFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 19 May 1998 14:12:01 -0700
Thomas Spaulding wrote:> > When I do the Manual Calls Update, it brings up Dr. Watson :-(
This is a known problem with 1.16.60. Upgrade to RadiusNT 2.2 or higher and it will work.
> -----Original Message-----> From: Dale E. Reed Jr. <daler@iea-software.com>> To: radiusnt@iea-software.com <radiusnt@iea-software.com>> Date: Tuesday, May 19, 1998 1:28 AM> Subject: Re: Calls-Online> > >Thomas Spaulding wrote:> >>> >> Before I get too much further into it.....Should this be able to work> >> properly with RadiusNT 1.60, MSAccess97, NT4.0 (sp3/Hotfixes), 3COM TCHs> >> with T1s ?> >>> >> If so is there a web site with setup instructions? I can see the IP> >> addresses of the server but no data shows up when I run the Query :-(> >> >Assuming you have manual calls update enabled and you have populated your> >Server Ports table with the ports for the TCHs, then it should work> >fine.> >> >--> >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
-- 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: Re: ODBC Error:23000:-1053: Primary key cant contain null valueFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 19 May 1998 21:20:56 -0700
Jorge Pocaterra wrote:> > The SQL Statement is> > INSERT INTO calls (CallDate,AcctStatusType,AcctDelayTime,UserName,NasPort,> AcctSessionID,AcctAuthentic,UserService,AcctSessionTime,FramedProtocol,> FramedAddress,AcctinputPackets,AccountOutputPackets, AcctInputOctets,> Acctoutputoctets)Values> (Now(),2,60,'userlogin',8,'19.08.0',1,2,105,1,'204.179.74.48',> 46,42,3453,31629)> > ODBC Error:23000:-1053:> [Microsoft][ODBC Microsoft access 97 driver] index or primary key> can't contain null value
If the debug right above the SQL Statement includes a NAS-IP-Addressattribute (#4) then go into your RadAttributes table and change thename of attribute #4 from NAS-IP-Address to NAS-Identifier and restartRadiusNT. > i'm also geting other error :> > SQL statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, UserName, Data)> VALUES (11, Now, 'userlogin', 'password')> > ODBC Error:23000:-1605:> [Microsoft][ODBC Microsoft access 97 driver] The Changes you requested to> the table where not succesfull because they would create duplicate values in> the index, primary key, or relationship. change the data in the field or> fields that contain duplicate data, remove the index, or redefine the index> to permit duplicate entries and try again> > But this is hapenning only with the computone PowerRack and not with the> Totalcontrol and they are authenticating in the same radius ...
This isn't a big deal. By default, the date field in the RadLogstable is only to the minute. This prevents someone from filling upyour database by continulally giving bad errors. You can change thedata to a more accurate one that includes seconds if you want all ofthem.
-- 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