hello,
I try the redundant sql with sqlcounter but the problem persist, when the sql1 is
offline the radius1 gone dead I restart the radius manuelly but the users who can't
access with the sql1 can access with the sql2
where is my probleme I dont know ?
there is my config file.
sql.conf:
sql sql1 {
# Database type
# Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
# rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds
driver = "rlm_sql_mysql"
# Connect info
server = "192.168.0.1"
login = "xxxxx"
password = "xxxxxx"
........................
}
sql sql2 {
# Database type
# Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
# rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds
driver = "rlm_sql_mysql"
# Connect info
server = "192.168.0.3"
login = "xxxxx"
password = "xxxxxx"
}
in the radiusd.conf:
...................
sqlcounter limitcounter {
counter-name = Limit-Session-Time
check-name = Max-Limit-Session
sqlmod-inst = sql
key = User-Name
reset = never
}
authorize {
#
# The preprocess module takes care of sanitizing some bizarre
# attributes in the request, and turning them into attributes
# which are more standard.
#
# It takes care of processing the 'raddb/hints' and the
# 'raddb/huntgroups' files.
#
# It also adds a Client-IP-Address attribute to the request.
#
preprocess
#
# The chap module will set 'Auth-Type := CHAP' if we are
# handling a CHAP request and Auth-Type has not already been set
#
# chap
# counter
# attr_filter
# eap
# suffix
files
limitcounter
group {
sql1 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
sql2 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
}
limitcounter
........
}
# Accounting. Log to detail file, and to the radwtmp file, and maintain
# radutmp.
accounting {
# acct_unique
detail
# counter
unix
group {
sql1 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
sql2 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
}
radutmp
# sradutmp
}
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
