Hi! I have a question about failover configuration.
I have freeradius + sqlippool module for ip-assigning. I have 2 databases for redundancy (described in sql1 and sql2).
my file from enabled-server:
server allauth {
listen {
type = auth
ipaddr = *
port = 1812
}
authorize {
auth_log
update control {
Pool-Name = 'main_pool'
}
redundant {
# we need this only to get new Pool-name, if user exist in our defined group.
sql1
sql2
}
update control {
# any user must be accepted.
Auth-Type = 'Accept'
}
}
post-auth {
redundant {
sqlippool1 # this module use sql1 for assigning
sqlippool2 # this module use sql2 for assigning, if first will fails.
main_pool
}
reply_log
}
}
I've run the freeradius, but when I turned off my first database (sql1), my redundancy in post-auth return incorrect code:, sqlippool1 returns "noop", neither "fail".
May be I've selected the wrong way to solve my task? Any comments are welcome... How can I switch ip-assigning on sqlippool2, when sql1 (used by sqlippool1) doesn't work?
some information from log:
Wed Feb 3 15:36:29 2010 : Error: rlm_sql (sql1): Failed to connect DB handle #1
Wed Feb 3 15:36:29 2010 : Error: rlm_sql (sql1): reconnect failed, database down?
Wed Feb 3 15:36:29 2010 : Error: sqlippool_command: database query error in: 'COMMIT'
Wed Feb 3 15:36:29 2010 : Info: [sqlippool1] expand: SELECT id FROM radippool WHERE pool_name='%{control:Pool-Name}' LIMIT 1 -> SELECT id FROM radippool WHERE pool_name='main_pool' LIMIT 1
Wed Feb 3 15:36:29 2010 : Error: rlm_sql_mysql: Socket not connected
Wed Feb 3 15:36:29 2010 : Debug: rlm_sql (sql1): Attempting to connect rlm_sql_mysql #1
Wed Feb 3 15:36:29 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Wed Feb 3 15:36:29 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server user@ip:dbname
Wed Feb 3 15:36:29 2010 : Error: rlm_sql_mysql: Mysql error 'Lost connection to MySQL server at 'reading initial communication packet', system error: 0'
Wed Feb 3 15:36:29 2010 : Error: rlm_sql (sql1): Failed to connect DB handle #1
Wed Feb 3 15:36:29 2010 : Error: rlm_sql (sql1): reconnect failed, database down?
Wed Feb 3 15:36:29 2010 : Error: sqlippool_query1: database query error
Wed Feb 3 15:36:29 2010 : Debug: rlm_sql (sql1): Released sql socket id: 1
Wed Feb 3 15:36:29 2010 : Info: [sqlippool1] IP address could not be allocated as no pool exists with that name.
Wed Feb 3 15:36:29 2010 : Info: +++[sqlippool1] returns noop
Wed Feb 3 15:36:29 2010 : Info: ++- policy redundant returns noop