Hello Tyler -
>
>
>Usually our radius server works along happily then I get an error like this;
>
>[OpenLink][ODBC]Connection rejected by data source (SQL-08004)(DBD:
>st_execute/SQLExecute err=-1)
>Wed Feb 21 16:26:33 2001: ERR: do failed for 'insert into Calls
> (CallDate, AcctStatusType, AcctDelayTime, AcctSessionId,
>NASIdentifier, NASPort)
> values
> ('Feb 21, 2001 16:26', 2, 7, '338526183', '216.94.40.5',
>10212)': [OpenLink][ODBC][SQL Server]Cannot insert the value NULL into
>column 'UserName', table 'plat.dbo.calls'; column does not allow nulls.
>INSERT fails. (SQL-S1000)
>[OpenLink][ODBC][SQL Server]Login incorrect. (SQL-S1000)
>[OpenLink][ODBC]Connection rejected by data source (SQL-08004)(DBD:
>st_execute/SQLExecute err=-1)
>
>This errors continue on and on and does not let users authenticate. This is
>only resolved when I restart the radius daemon. Sometimes it continues on
>with "Cannot connect to database, backing off for 600 seconds", resulting in
>more down time. It is running on a Redhat 6.2 computer connecting to a MS
>SQL7 database via openlink. Please help. Thanks in advance.
>
This looks like a problem with either the OpenLink ODBC driver, or
with MSSQL itself (although I am inclined to think it is the OpenLink
driver).
I would suggest that you try either the free Sybase client libraries,
or the DBD-Proxy module.
I have also copied this to Mike for his comments.
regards
Hugh
--
NB: I am travelling this week, so there may be delays in our correspondence.
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
