On Feb 23, 1:46am, Hugh Irvine wrote:
> Subject: Re: (RADIATOR) Connection rejected by data source error
>
> 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.
Yes, I agreee with hugh.
Also it looks to me like the problem is being triggered by an accounting record
with no user name, hence the absence of username from the insert.
That should not trigger an inability to reconnect to the database, so I would
also suspect a problem with the drivers.
Cheers.
>
> 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.
>
>
>-- End of excerpt from Hugh Irvine
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, 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.
