At 02:14 AM 2/20/2003 +0200, Michael Vasilenko wrote:
Hello!
I've setup two SQL servers for 'failover' feature testing, my config
looks like this:
accounting {
acct_unique
detail
group {
sql_my {
fail = 1
notfound = 2
noop = return
ok = return
updated = return
reject = return
userlock = return
invalid = return
handled = return
}
sql_ms {
fail = 1
notfound = 2
noop = return
ok = return
updated = return
reject = return
userlock = return
invalid = return
handled = return
}
}
unix
radutmp
sradutmp
}
When I manually shutdown first SQL, it works fine, but when I simulating
complete server crash, by dropping all packets to SQL by firewall, sql
module seems to be stuck forever in waiting state.
Maybe I just configure something wrong? Any ideas would be fine.
And just noticed some feature/bug:
rlm_sql_mysql: MYSQL check_error: 2002 received
rlm_sql (sql_my): Couldn't update SQL accounting for START packet -
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
radius_xlat: ''
rlm_sql (sql_my): Released sql socket id: 0
modcall[accounting]: module "sql_my" returns ok
modcall: group group returns ok
Why it returns 'ok' ?
That doesn't look correct... Hmmm. What happened on subsequent packets
to the server? Where they handled by the first sql instance or did they
fail to the next one? Did they server just hang?
-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless!\ Director, Engineering
| @ @ |\ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\--
\ Wholesale Internet Services - http://www.megapop.net
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html