freeradius mysql errors

[Ivan Kalik]

> I'm seeing the following errors in radius.log. Could anybody tell me how
> to
> fix those?
>
> Mon Sep 14 01:10:14 2009 : Error: rlm_sql_mysql: Socket not connected
> Mon Sep 14 01:10:14 2009 : Error: rlm_sql_mysql: Couldn't connect socket
> to
> MySQL server radius at xx.xx.xx.xx:LWT
> Mon Sep 14 01:10:14 2009 : Error: rlm_sql_mysql: Mysql error 'Bad
> handshake'
> Mon Sep 14 01:10:14 2009 : Error: rlm_sql (sql): Failed to connect DB
> handle
> #10
>
> Do i need to increase the number of sql sockets? (at present 15)

No.

> Or do i need to increase the no of requests that radius can keep track
> of(At
> present 1024)

No.

The debug is quite clear about what the problem is. There is nothing you
can do in freeradius to fix mysql server and client incompatibility. You
probably need to update mysql client.

Ivan Kalik
Kalik Informatika ISP