Hello Chris -

On Wed, 17 May 2000, Christopher Andersson wrote:
> 
> Good day,
> 
> I'm all of a sudden getting this error message on the console:
> 
> Wed May 17 14:08:09 2000: ERR: sendTo: send failed: No route to host
> DBD::mysql::db do failed: You have an error in your SQL syntax near ' 'sendTo: send 
>failed: No route to host')' at line 2 at Radius/SqlDb.pm line 228.
> Wed May 17 14:08:09 2000: ERR: do failed for 'insert into RADLOG (TIME_STAMP, 
>PRIORITY, MESSAGE) 
>                 values (958565289, , 'sendTo: send failed: No route to host')': You 
>have an error in your SQL syntax near ' 'sendTo: send failed: No route to host')' at 
>line 2
> 
> Anyone?
> The accounting table gets updated as it should!
> I'm using mySql for logging and accounting, and there hasn't been any problems 
>whatsoever
> in the past. And an almost unchanged config-file from /goodies.
> 

Hmmmm - there are a couple of things going on here. The first is that you are
losing connectivity to a proxy Radius host - that is the message that is being
logged 'sendTo: send failed: No route to host', so the first thing to fix is
that problem. Secondly, the LogSQL.pm routine is complaining about the SQL
syntax that is generated when it tries to log that particular message,
undoubtedly due to the single quotes in the string.

What version of Radiator and what database?

I know Mike did some work on AuthSQL.pm recently for this same reason, so I
will ask him about dealing with this as well.

thanks 

Hugh

-- 
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.

Reply via email to