Message 2: Calls Online
from "Bruno Tremblay" <bruno@mustangtechno.com>
Message 3: Re: ODBC: SQLExecDirect Error -1053:
from "Lorri Thomas" <lorri@cowtown.net>
Message 4: Re: NASidentifier problem
from "Alan D. Criado" <ACriado@elink.net>
Message 5: Re: NASidentifier problem
from "Alan D. Criado" <ACriado@elink.net>
Message 6: Re: NASidentifier problem
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 7: Re: NASidentifier problem
from Bob Dozier <rwdozier@apex2000.net>
Message 8: Re: ODBC: SQLExecDirect Error -1053:
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 9: Re: Calls Online
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 10: Re: Calls Online
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 11: Re: Time of Day restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 12: Re: NASidentifier problem
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Re: Time of Day restrictions
from "Zak Wolfinger" <zak@cyberlink.com>
Message 14: RE: Calls Online
from "Bruno Tremblay" <bruno@mustangtechno.com>
Message 15: Re: ODBC: SQLExecDirect Error -1053:
from Sheldon Edwards <slick@caribsurf.com>
Message 16: Re: ODBC: SQLExecDirect Error -1053:
from "Lorri Thomas" <lorri@cowtown.net>
Message 17: RE: Time of Day restrictions
from "McCallum, Michael" <mccallum@corp.telsoft.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Time of Day restrictions
From: "McCallum, Michael" <mccallum@corp.telsoft.net>
Date: Fri, 22 May 1998 07:40:21 -0400
Is there anyway to set time of day restrictions for attributes within
Radius for Ascend equipment. Thanks.
Michael W. McCallum, PE & MCP
Vice President - Networking Technologies
TelSoft Consultants, Inc.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Calls Online
From: "Bruno Tremblay" <bruno@mustangtechno.com>
Date: Fri, 22 May 1998 08:05:00 -0400
Hi,
I have some problemes with my calls online.
All Other things appear to work fine.
There the message I got.
Radrecv: Request from host c7a6db03 code=4, id=30, length=126
Acct-Status-Type = Stop
NAS-Identifier = XXX.XXX.XXX.X
Acct-Delay-Time = 0
NAS-Port = 8
Acct-Session-ID = "1138774.21.08.0"
Acct-Authentic = RADIUS
User-Service = Framed-User
Acct-Session-Time = 16
Framed-Protocol = PPP
Framed-Addrress = XXX.XXX.XXX.XXX
Acct-Input-Packets = 52
Acct-Output-Packets = 53
Acct-Input-Octets = 3771
Acct-Output-Octets = 17466
SQL Statement: INSERT INTO Calls (CallDate,AcctStatusType,NASIdentifier,
AcctDelayTime,UserName,NASPort, AcctSessionID,
AcctSessionTime,FramedAddress,AcctInputOctets,AcctOutputOctets) VALUES
(Now(),2,'XXX.XXX.XXX.X',0,'XXXppp',8,'1137844.21.08.0',16.'XXX.XXX.XXX.XXX,
3771,17466)
SQL Statement: UPDATE CallsOnline Set Usersname='XXXppp',AcctStatusType=2,
CallDate=Now(), FramedAddress='XXX.XXX.XXX.XXX' WHERE
NASIdentifier='XXX.XXX.XXX.XXX' and NASPort=8 AND (DateADD('s',
0-i.AcctDelayTime, i.CallDate) >= CallDate or CallDate IS NULL)
ODBC Error:07001:-3010:
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.
Expected 2.
SQL Statement: UPDATE SubAccounts SET TimeLeft=TimeLeft-16 Where
TimeLieft<>Null And TimeLeft<>-9999 And Login='XXXppp'
Sending Accounting Ack of id 30 to c7a6db03 (Vserver (XXX.XXX.XXX.X))
Resp Time: 230 Auth: 8/1 -> 9 Acct: 14/0/0 -> 14
If someone can say me which value I need to use in table ServerAccess,
StartTime and StopTime. Each time I tried to use that service I got tha
error in logs : Server:Vserver9 (XXX.XXX.XXX.XXX) Port:15 (Time)
Thanks
Bruno Tremblay
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: ODBC: SQLExecDirect Error -1053:
From: "Lorri Thomas" <lorri@cowtown.net>
Date: Fri, 22 May 1998 07:19:25 -0500
Yes, I restarted Radius twice once the change was made & still.......
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Cc: List RadiusNT <RadiusNT@emerald.iea.com>
Date: Thursday, May 21, 1998 5:57 PM
Subject: Re: ODBC: SQLExecDirect Error -1053:
>> Lorri Thomas wrote:
>>
>> I'm getting the following error:
>>
>> ODBC: SQLExecDirect Error -1053:[Microsoft][ODBC Microsoft Access 97
Driver]
>> Index or primary key can't contain a Null value.
>>
>> I went into RadAttributes and changed #4 to NAS-Identifier, I have the
service
>> running in NT & it's authenticating users fine,..... it is just that my 2
>> Portmasters keep sending "requests" that Radius doesn't understand - or
maybe
>> it's just me that doesn't understand. Any ideas? Need more info?
>
>Did you restart RadiusNT after making the change? Since the dictionary
>is cached into memory, just changing it would not immediately fix the
>problem.
>
>--
>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 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: NASidentifier problem
From: "Alan D. Criado" <ACriado@elink.net>
Date: Fri, 22 May 1998 13:07:10 -0400
Hello Dale.
jeff.binkley@asacomp.com (Jeff Binkley)
Had written back to Lamar with the definitions below (thanks Jeff):
Here's the definition of 50 and 51 from the 3Com RADIUS dictionary
file for the TC hub.
ATTRIBUTE Acct_Multi_Session_ID 50 string
ATTRIBUTE Acct_Link_Count 51 integer
However, even though I entered these attributes via "Emerald Admin, Config
Radius, Attributes section" as you indicated below, the
"Received unknown attribute 51"
"Received unknown attribute 50"
messages still come up.
Is this something that is worth even being concerned about?
Thank you.
Alan D. Criado
At 11:17 PM 5/14/98 -0700, Dale E. Reed Jr. wrote:
>Lamar Townsend wrote:
>>Also, what is the unknown attribute 50 and 51? Below is part of
>> the Radius log.
>
>I'm not sure about the 50 and 51 attributes. Check the USR docs
>and they should tell you what they are. You can add them in the
>Emerald Admin, Config Radius, Attributes section.
jeff.binkley@asacomp.com (Jeff Binkley)
Here's the definition of 50 and 51 from the 3Com RADIUS dictionary
file for the TC hub.
ATTRIBUTE Acct_Multi_Session_ID 50 string
ATTRIBUTE Acct_Link_Count 51 integer
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: NASidentifier problem
From: "Alan D. Criado" <ACriado@elink.net>
Date: Fri, 22 May 1998 13:07:10 -0400
Hello Dale.
jeff.binkley@asacomp.com (Jeff Binkley)
Had written back to Lamar with the definitions below (thanks Jeff):
Here's the definition of 50 and 51 from the 3Com RADIUS dictionary
file for the TC hub.
ATTRIBUTE Acct_Multi_Session_ID 50 string
ATTRIBUTE Acct_Link_Count 51 integer
However, even though I entered these attributes via "Emerald Admin, Config
Radius, Attributes section" as you indicated below, the
"Received unknown attribute 51"
"Received unknown attribute 50"
messages still come up.
Is this something that is worth even being concerned about?
Thank you.
Alan D. Criado
At 11:17 PM 5/14/98 -0700, Dale E. Reed Jr. wrote:
>Lamar Townsend wrote:
>>Also, what is the unknown attribute 50 and 51? Below is part of
>> the Radius log.
>
>I'm not sure about the 50 and 51 attributes. Check the USR docs
>and they should tell you what they are. You can add them in the
>Emerald Admin, Config Radius, Attributes section.
jeff.binkley@asacomp.com (Jeff Binkley)
Here's the definition of 50 and 51 from the 3Com RADIUS dictionary
file for the TC hub.
ATTRIBUTE Acct_Multi_Session_ID 50 string
ATTRIBUTE Acct_Link_Count 51 integer
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 6 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: NASidentifier problem
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Fri, 22 May 1998 10:24:13 -0700
Alan D. Criado wrote:
>
> Hello Dale.
>
> jeff.binkley@asacomp.com (Jeff Binkley)
>
> Had written back to Lamar with the definitions below (thanks Jeff):
>
> Here's the definition of 50 and 51 from the 3Com RADIUS dictionary
> file for the TC hub.
>
> ATTRIBUTE Acct_Multi_Session_ID 50 string
> ATTRIBUTE Acct_Link_Count 51 integer
>
> However, even though I entered these attributes via "Emerald Admin, Config
> Radius, Attributes section" as you indicated below, the
>
> "Received unknown attribute 51"
> "Received unknown attribute 50"
>
> messages still come up.
Did you restart RadiusNT? The dictionary is cached upon startup.
The attriubutes typically have dashes to seperate the words, not
underscores. Its not a big deal, though.
-- 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: NASidentifier problemFrom: Bob Dozier <rwdozier@apex2000.net>Date: Fri, 22 May 1998 12:29:42 -0500
I seem to have gotten removed from the list. How do I get on thedigest list?
Thanks,
....Bob
Alan D. Criado wrote:> > Hello Dale.> > jeff.binkley@asacomp.com (Jeff Binkley)> > Had written back to Lamar with the definitions below (thanks Jeff):> > Here's the definition of 50 and 51 from the 3Com RADIUS dictionary> file for the TC hub.> > ATTRIBUTE Acct_Multi_Session_ID 50 string> ATTRIBUTE Acct_Link_Count 51 integer> > However, even though I entered these attributes via "Emerald Admin, Config> Radius, Attributes section" as you indicated below, the> > "Received unknown attribute 51"> "Received unknown attribute 50"> > messages still come up.> > Is this something that is worth even being concerned about?> > Thank you.> > Alan D. Criado> > At 11:17 PM 5/14/98 -0700, Dale E. Reed Jr. wrote:> >Lamar Townsend wrote:> >>Also, what is the unknown attribute 50 and 51? Below is part of> >> the Radius log.> >> >I'm not sure about the 50 and 51 attributes. Check the USR docs> >and they should tell you what they are. You can add them in the> >Emerald Admin, Config Radius, Attributes section.> > jeff.binkley@asacomp.com (Jeff Binkley)> > Here's the definition of 50 and 51 from the 3Com RADIUS dictionary> file for the TC hub.> > ATTRIBUTE Acct_Multi_Session_ID 50 string> ATTRIBUTE Acct_Link_Count 51 integer
-- _____________________________________________________________________Bob Dozier rwdozier@apex2000.net Apex 2000 Internet Services Corporation Phone: (915) 570-1676
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ODBC: SQLExecDirect Error -1053:From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 22 May 1998 10:37:23 -0700
Lorri Thomas wrote:> > Yes, I restarted Radius twice once the change was made & still.......
If the error is still persisting, includ the full -x15 debug fromthe receive to the resp line.
> -----Original Message-----> From: Dale E. Reed Jr. <daler@iea-software.com>> To: radiusnt@iea-software.com <radiusnt@iea-software.com>> Cc: List RadiusNT <RadiusNT@emerald.iea.com>> Date: Thursday, May 21, 1998 5:57 PM> Subject: Re: ODBC: SQLExecDirect Error -1053:> > >> Lorri Thomas wrote:> >>> >> I'm getting the following error:> >>> >> ODBC: SQLExecDirect Error -1053:[Microsoft][ODBC Microsoft Access 97> Driver]> >> Index or primary key can't contain a Null value.> >>> >> I went into RadAttributes and changed #4 to NAS-Identifier, I have the> service> >> running in NT & it's authenticating users fine,..... it is just that my 2> >> Portmasters keep sending "requests" that Radius doesn't understand - or> maybe> >> it's just me that doesn't understand. Any ideas? Need more info?> >> >Did you restart RadiusNT after making the change? Since the dictionary> >is cached into memory, just changing it would not immediately fix the> >problem.> >> >--> >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 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls OnlineFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 22 May 1998 10:43:00 -0700
Bruno Tremblay wrote:> > I have some problemes with my calls online.> All Other things appear to work fine.>> SQL Statement: UPDATE CallsOnline Set Usersname='XXXppp',AcctStatusType=2,> CallDate=Now(), FramedAddress='XXX.XXX.XXX.XXX' WHERE> NASIdentifier='XXX.XXX.XXX.XXX' and NASPort=8 AND (DateADD('s',> 0-i.AcctDelayTime, i.CallDate) >= CallDate or CallDate IS NULL)> > ODBC Error:07001:-3010:> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.> Expected 2.
This error means one of the fields listed above doesn't match afield in the CallsOnline query. Actually, this looks like a bugin RadiusNT 2.5, since it should be "username", not "usersname".You could modify the query to have the column named usersname fornow until we can release a correction for it. > If someone can say me which value I need to use in table ServerAccess,> StartTime and StopTime. Each time I tried to use that service I got tha> error in logs : Server:Vserver9 (XXX.XXX.XXX.XXX) Port:15 (Time)
They are minutes past midnight. SO if the customer can logn 8am to5pm, it would be Start: 480 and Stop: 1020 (17*60). RadiusNT understandsthat a start time larger than a stop time means wrap midnight. Soreversing the numbers would mean the user could login from 5pm to8am.
-- 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: Calls OnlineFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 22 May 1998 10:45:45 -0700
Bruno Tremblay wrote:> > I have some problemes with my calls online.> All Other things appear to work fine.
You did leave out the one very important piece of information that shouldalways be included in a support question: What version of RadiusNT youare using.
I just check the 2.5.110, and it doesn't have this misspelling.
> SQL Statement: UPDATE CallsOnline Set Usersname='XXXppp',AcctStatusType=2,> CallDate=Now(), FramedAddress='XXX.XXX.XXX.XXX' WHERE> NASIdentifier='XXX.XXX.XXX.XXX' and NASPort=8 AND (DateADD('s',> 0-i.AcctDelayTime, i.CallDate) >= CallDate or CallDate IS NULL)> > ODBC Error:07001:-3010:> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.> Expected 2.
-- 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 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Time of Day restrictionsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 22 May 1998 10:46:19 -0700
McCallum, Michael wrote:> > Is there anyway to set time of day restrictions for attributes within> Radius for Ascend equipment. Thanks.
See the Server Port Access Options in the RadiusNT 2.5 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 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NASidentifier problemFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 22 May 1998 11:08:22 -0700
Bob Dozier wrote:> > I seem to have gotten removed from the list. How do I get on the> digest list?
Send a message to radiusnt-digest-request with subscribe inthe body of it.
-- 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 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Time of Day restrictionsFrom: "Zak Wolfinger" <zak@cyberlink.com>Date: Fri, 22 May 1998 13:50:29 -0500
Is there an easy way to do this on a per user basis? Iguess I could setup an AccountType for the user and populatethe ServerAccess table for the new account type, but with acouple hundred ports, it seems to be a long process. UnlessI'm doing it wrong?
Zak
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Friday, May 22, 1998 12:53 PMSubject: Re: Time of Day restrictions
>McCallum, Michael wrote:>>>> Is there anyway to set time of day restrictions forattributes within>> Radius for Ascend equipment. Thanks.>>See the Server Port Access Options in the RadiusNT 2.5documentation.>>-->Dale E. Reed Jr. (daler@iea-software.com)>_________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NTFAQs> Internet Solutions for Today |http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Calls OnlineFrom: "Bruno Tremblay" <bruno@mustangtechno.com>Date: Fri, 22 May 1998 15:02:02 -0400
Radius V. 2.5.110
I change "usersname" to "username" and I still getting the same error.Any idea ?I don't want any times restrictions on ServerAccess do I set Start time to 0and Stop time to 1440
Thank's
Bruno Tremblay
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Friday, May 22, 1998 1:43 PMTo: radiusnt@iea-software.comSubject: Re: Calls Online
Bruno Tremblay wrote:>> I have some problemes with my calls online.> All Other things appear to work fine.>> SQL Statement: UPDATE CallsOnline Set Usersname='XXXppp',AcctStatusType=2,> CallDate=Now(), FramedAddress='XXX.XXX.XXX.XXX' WHERE> NASIdentifier='XXX.XXX.XXX.XXX' and NASPort=8 AND (DateADD('s',> 0-i.AcctDelayTime, i.CallDate) >= CallDate or CallDate IS NULL)>> ODBC Error:07001:-3010:> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.> Expected 2.
This error means one of the fields listed above doesn't match afield in the CallsOnline query. Actually, this looks like a bugin RadiusNT 2.5, since it should be "username", not "usersname".You could modify the query to have the column named usersname fornow until we can release a correction for it.
> If someone can say me which value I need to use in table ServerAccess,> StartTime and StopTime. Each time I tried to use that service I got tha> error in logs : Server:Vserver9 (XXX.XXX.XXX.XXX) Port:15 (Time)
They are minutes past midnight. SO if the customer can logn 8am to5pm, it would be Start: 480 and Stop: 1020 (17*60). RadiusNT understandsthat a start time larger than a stop time means wrap midnight. Soreversing the numbers would mean the user could login from 5pm to8am.
--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 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ODBC: SQLExecDirect Error -1053:From: Sheldon Edwards <slick@caribsurf.com>Date: Thu, 22 Jan 1998 15:06:06 -0500
Check the Calls Table in Access and make sure that the field name isNASIdentifier. If not change the field name to this and see if this fixes theproblem...
> Lorri Thomas wrote:> >> > Yes, I restarted Radius twice once the change was made & still.......>>> > -----Original Message-----> > From: Dale E. Reed Jr. <daler@iea-software.com>> > To: radiusnt@iea-software.com <radiusnt@iea-software.com>> > Cc: List RadiusNT <RadiusNT@emerald.iea.com>> > Date: Thursday, May 21, 1998 5:57 PM> > Subject: Re: ODBC: SQLExecDirect Error -1053:> >> > >> Lorri Thomas wrote:> > >>> > >> I'm getting the following error:> > >>> > >> ODBC: SQLExecDirect Error -1053:[Microsoft][ODBC Microsoft Access 97> > Driver]> > >> Index or primary key can't contain a Null value.> > >>> > >> I went into RadAttributes and changed #4 to NAS-Identifier, I have the> > service> > >> running in NT & it's authenticating users fine,..... it is just that my 2> > >> Portmasters keep sending "requests" that Radius doesn't understand - or> > maybe> > >> it's just me that doesn't understand. Any ideas? Need more info?> > >> > >Did you restart RadiusNT after making the change? Since the dictionary> > >is cached into memory, just changing it would not immediately fix the> > >problem.> > >> > >--> > >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 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ODBC: SQLExecDirect Error -1053:From: "Lorri Thomas" <lorri@cowtown.net>Date: Fri, 22 May 1998 14:33:42 -0500
Checked Calls Table and is was NASIdentifier........
-----Original Message-----From: Sheldon Edwards <slick@caribsurf.com>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Friday, May 22, 1998 3:07 PMSubject: Re: ODBC: SQLExecDirect Error -1053:
>Check the Calls Table in Access and make sure that the field name is>NASIdentifier. If not change the field name to this and see if this fixesthe>problem...>>>>> Lorri Thomas wrote:>> >>> > Yes, I restarted Radius twice once the change was made & still.......>>>>>> > -----Original Message----->> > From: Dale E. Reed Jr. <daler@iea-software.com>>> > To: radiusnt@iea-software.com <radiusnt@iea-software.com>>> > Cc: List RadiusNT <RadiusNT@emerald.iea.com>>> > Date: Thursday, May 21, 1998 5:57 PM>> > Subject: Re: ODBC: SQLExecDirect Error -1053:>> >>> > >> Lorri Thomas wrote:>> > >>>> > >> I'm getting the following error:>> > >>>> > >> ODBC: SQLExecDirect Error -1053:[Microsoft][ODBC Microsoft Access 97>> > Driver]>> > >> Index or primary key can't contain a Null value.>> > >>>> > >> I went into RadAttributes and changed #4 to NAS-Identifier, I havethe>> > service>> > >> running in NT & it's authenticating users fine,..... it is just thatmy 2>> > >> Portmasters keep sending "requests" that Radius doesn't understand -or>> > maybe>> > >> it's just me that doesn't understand. Any ideas? Need more info?>> > >>> > >Did you restart RadiusNT after making the change? Since thedictionary>> > >is cached into memory, just changing it would not immediately fix the>> > >problem.>> > >>> > >-->> > >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 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Time of Day restrictionsFrom: "McCallum, Michael" <mccallum@corp.telsoft.net>Date: Fri, 22 May 1998 16:00:43 -0400
Thanks for the information on the documentation. I found the referenceand have a question.
I need to grant access for an accounttype from midnight to 0800 and 2000to midnight. According to the table layout it looks like I could onlygrant access either from midnight to 0800 OR 2000 to midnight but notboth for a single account type. Any suggestions?
Also, if server access is enabled do I have to populate entries for allpossible servers so a valid record is found?
Thanks...
Michael W. McCallum, PE & MCPVice President - Networking TechnologiesTelSoft Consultants, Inc.
> -----Original Message-----> From: Dale E. Reed Jr. [SMTP:daler@iea-software.com]> Sent: Friday, May 22, 1998 1:46 PM> To: radiusnt@iea-software.com> Subject: Re: Time of Day restrictions> > McCallum, Michael wrote:> > > > Is there anyway to set time of day restrictions for attributes> within> > Radius for Ascend equipment. Thanks.> > See the Server Port Access Options in the RadiusNT 2.5 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