Redundant SQL

[Alan DeKok]

Breuer Nicolas wrote:
...
>  I started radius. Ok - on SQL1.
> 
>  If i kill mysqld without restarting the server.
> 
>  rlm_sql_mysql: MYSQL check_error: 2002 received

  What are the *other* debug messages?  i.e. it tries to connect.  Does
it succeed?

  The code in rlm_sqlippool && rlm_sql is written to STOP if it can't
connect to the database.  But if the connection request succeeds, and
subsequent queries return an "unconnected" error, there isn't much that
the server can do.

> sqlippool_command: database query error in: 'COMMIT'
> rlm_sql (sql): Released sql socket id: 2
> rlm_sqlippool: IP address could not be allocated.
> +++[ip_pooling] returns noop
...
> The system doesn't load the SQL2. I need to restart the radius
>  to have the sql2 working and the ip allocated.

  You can run the redundancy by hand:

	...
	ip_pooling
	if (!ok) {
		ip_pooling2
		if (!ok) {
			...
		}
	}

  That should work...

  Alan DeKok.