I am having this same problem it seems that on a reboot the the radius
services starts before all of the tables in the SQL server are ready. I have
set the ODBCTimeout from 15-600 without any change. It seems to me that
radius thinks the ODBC connection is ready before all the tables have loaded.
Is there a way to till the radius service to pause for 30 seconds before
starting? This is the only problem that we are having. We wouldn't have
notice this except that we had a extended power outage in the middle of the
night that pulled down our UPS. When the power went back on the radius system
didn't go online. Should I move the SQL server and the radius service to
separate computers or is there another fix? I have included a logfile for each
startup of the Radius service (auto and manual).
***Logfile with auto startup service***
Initializing Winsock...
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
ODBC Error:S0002:208:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'RadAttributes'.
ODBC Error:S0002:208:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'RadValues'.
ODBC Error:S0002:208:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Servers'.
Accounting Column 0 (16): 'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (10): 'AcctSessionID'
Accounting Column 3 (1): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (32): 'UserName'
Accounting Column 6 (1): 'UserService'
Accounting Column 7 (4): 'AcctDelayTime'
Accounting Column 8 (4): 'AcctSessionTime'
Accounting Column 9 (4): 'FramedProtocol'
Accounting Column 10 (16): 'FramedAddress'
Accounting Column 11 (4): 'AcctInputOctets'
Accounting Column 12 (4): 'AcctOutputOctets'
Accounting Column 13 (1): 'AcctTerminateCause'
Accounting Column 14 (1): 'NASPortType'
Accounting Column 15 (10): 'NASPortDNIS'
Accounting Column 16 (11): 'CallerId'
17 Accounting Columns Loaded
config_init(): dict_valfind(Lifetime-In-Days) not found.
Enterprise features enabled.
RadiusNT (Emerald Standard) Initialized...
radrecv: Request from host d1746104 code=1, id=88, length=113
Received unknown attribute 1
Received unknown attribute 3
Received unknown attribute 4
Received unknown attribute 5
Received unknown attribute 61
Received unknown attribute 6
Received unknown attribute 7
Received unknown attribute 24
Received unknown attribute 31
Received unknown attribute 30
Received unknown attribute 44
rad_authenticate_ODBC()
Authenticate: from 209.116.97.4 - No User Name
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUES (51, GetDate(), '', '209.116.97.4')
ODBC Error:S0002:208:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'RadLogs'.
Resp Time: 30 Auth: 0/0 -> 1 Acct: 0/0/0 -> 0
***Logfile with manual startup service***
Initializing Winsock...
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
Accounting Column 0 (16): 'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (10): 'AcctSessionID'
Accounting Column 3 (1): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (32): 'UserName'
Accounting Column 6 (1): 'UserService'
Accounting Column 7 (4): 'AcctDelayTime'
Accounting Column 8 (4): 'AcctSessionTime'
Accounting Column 9 (4): 'FramedProtocol'
Accounting Column 10 (16): 'FramedAddress'
Accounting Column 11 (4): 'AcctInputOctets'
Accounting Column 12 (4): 'AcctOutputOctets'
Accounting Column 13 (1): 'AcctTerminateCause'
Accounting Column 14 (1): 'NASPortType'
Accounting Column 15 (10): 'NASPortDNIS'
Accounting Column 16 (11): 'CallerId'
17 Accounting Columns Loaded
Enterprise features enabled.
RadiusNT (Emerald Standard) Initialized...
radrecv: Request from host d1746104 code=1, id=41, length=113
User-Name = "?"
Challenge-Response = "\001.\254\033\354\3244[APi\\327\244\033j\323"
NAS-Identifier = ???.???.???.???
NAS-Port = 20104
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
State = ""
Caller-Id = "??????????"
NAS-Port-DNIS = "???????"
Acct-Session-Id = "266970863"
rad_authenticate_ODBC()
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(),
DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType,
sa.Password, sa.Login, sa.Shell, sa.LoginLimit From MasterAccounts ma,
SubAccounts sa Where (sa.Login='?' or sa.Shell='?' or sa.Email='?') AND
ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
Checking for duplicate logins.
SQL Statement: RadCheckOnline '?'
? found on-line 0 time(s).
SQL Statement: RadGetConfigs 232
Loading radius defaults for this type...
SQL Statement: RadGetATConfigs 'PPP'
Sending Ack of id 41 to d1746104 (Ascend01)
User-Service = Framed-User
Framed-Protocol = PPP
Resp Time: 601 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0
Sincerely,
Bob
Robert Raines
President, Via-Net, Inc.
614 486-3481, Fax 614 486-3482
----------
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: radiusnt@iea-software.com
> Subject: Re: RadiusNT 2.5.124 startup problem
> Date: Wednesday, June 17, 1998 3:03 AM
>
> 2Day Internet wrote:
> >
> > >RadiusNT 2.5 should reconnect. What you can do is change the
> > >ODBCTimeout
> > >registry setting and make it larger so that RadiusNT will wait longer.
> > >It is possible that is just not waiting long enough.
> >
> > Please advise the key path / value as I dont see such a key.
>
> Page 14 of the RadiusNT manual, in the Command line and Registry
> Settings chapter, includes the key and information on the
> ODBCTimeOut value.
>
> --
> 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