Hello freeradius users,
I use two freeradius servers and two mysql db's (master and slave)
On the first db (sql1) is works great.. fast starting and fast response.
When is stop the master db (first sql1 db for radius) he must use the second db
(slave)
When is start radiusd i can wait 80 second to give:
Starting RADIUS server: [ OK ]
When i test radtest (radtest user password localhost 1812 keyword)
Is see this:
Sending Access-Request of id 117 to 127.0.0.1:1812
User-Name = "user"
User-Password = "password"
NAS-IP-Address = radius02
NAS-Port = 1812
Re-sending Access-Request of id 117 to 127.0.0.1:1812
User-Name = "user"
User-Password =
"\251\211\345\326\022\273\375\235\275\3515\326\240\270\001\267"
NAS-IP-Address = radius02
NAS-Port = 1812
Sending Access-Request of id 135 to 127.0.0.1:1812
User-Name = "user"
User-Password = "password"
NAS-IP-Address = radius02
NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=121, length=90
rad_decode: Received Access-Reject packet from 127.0.0.1 with invalid signature
(err=2)! (Shared secret is incorrect.)
[EMAIL PROTECTED] root]# radtest user password localhost 1812 keyword
After 20 times it works i get acces see this:
Sending Access-Request of id 149 to 127.0.0.1:1812
User-Name = "user"
User-Password = "password"
NAS-IP-Address = radius02
NAS-Port = 1812
rad_recv: Access-Accept packet from host 127.0.0.1:1812, id=149, length=90
WISPr-Bandwidth-Max-Down = 100000
WISPr-Bandwidth-Max-Up = 50000
WISPr-Redirection-URL = "http://www.domain.nl";
Session-Timeout = 21600
Idle-Timeout = 2700
In my radius.log i see this:
Thu Jan 27 10:52:37 2005 : Error: Discarding new request from client
nas3.domain.nl:32770 - ID: 125 due to live request 20
Thu Jan 27 10:52:40 2005 : Error: Discarding new request from client
nas3.domain.nl:32770 - ID: 125 due to live request 20
Thu Jan 27 10:52:46 2005 : Info: rlm_sql (sql1): Trying to (re)connect
unconnected handle 2..
Thu Jan 27 10:52:46 2005 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #2
Thu Jan 27 10:52:46 2005 : Error: WARNING: Unresponsive child (id 3188931504)
for request 20
Thu Jan 27 10:52:49 2005 : Error: Discarding new request from client
nas3.domain.nl:32770 - ID: 129 due to live request 30
Thu Jan 27 10:54:49 2005 : Error: rlm_sql_mysql: Couldn't connect socket to
MySQL server [EMAIL PROTECTED]:db
Thu Jan 27 10:54:49 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to
MySQL server on '192.168.160.10' (110)'
Thu Jan 27 10:54:49 2005 : Error: rlm_sql (sql1): Failed to connect DB handle #4
Thu Jan 27 10:54:49 2005 : Info: rlm_sql (sql1): There are no DB handles to
use! skipped 3, tried to connect 1
Thu Jan 27 10:54:49 2005 : Auth: Login OK: [user/password] (from client
nas3.domain.nl port 1812)
Thu Jan 27 10:54:59 2005 : Error: WARNING: Unresponsive child (id 3178441648)
for request 30
Thu Jan 27 10:54:59 2005 : Info: rlm_sql (sql1): Trying to (re)connect
unconnected handle 4..
Thu Jan 27 10:54:59 2005 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #4
Thu Jan 27 10:55:04 2005 : Info: rlm_sql (sql1): Trying to (re)connect
unconnected handle 1..
Thu Jan 27 10:55:04 2005 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #1
Thu Jan 27 10:55:07 2005 : Error: Discarding new request from client
nas3.domain.nl:32770 - ID: 139 due to live request 33
Thu Jan 27 10:55:10 2005 : Error: Discarding new request from client
nas3.domain.nl:32770 - ID: 139 due to live request 33
Thu Jan 27 10:55:13 2005 : Info: rlm_sql (sql1): Trying to (re)connect
unconnected handle 0..
Thu Jan 27 10:55:13 2005 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #0
Thu Jan 27 10:55:16 2005 : Error: Discarding new request from client
nas3.domain.nl:32770 - ID: 144 due to live request 36
Thu Jan 27 10:55:18 2005 : Info: rlm_sql (sql1): There are no DB handles to
use! skipped 0, tried to connect 0
Thu Jan 27 10:55:18 2005 : Auth: Login OK: [user/password] (from client
nas3.domain.nl port 1812)
Thu Jan 27 10:55:22 2005 : Error: rlm_sql_mysql: Couldn't connect socket to
MySQL server [EMAIL PROTECTED]:db
Thu Jan 27 10:55:22 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to
MySQL server on '192.168.160.10' (110)'
Thu Jan 27 10:55:22 2005 : Error: rlm_sql (sql1): Failed to connect DB handle #3
Thu Jan 27 10:55:22 2005 : Info: rlm_sql (sql1): There are no DB handles to
use! skipped 1, tried to connect 1
Thu Jan 27 10:55:22 2005 : Auth: Login OK: [user/password] (from client
nas3.domain.nl port 1812)
Thu Jan 27 10:55:55 2005 : Error: rlm_sql_mysql: Couldn't connect socket to
MySQL server [EMAIL PROTECTED]:db
Thu Jan 27 10:55:55 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to
MySQL server on '192.168.160.10' (110)'
Thu Jan 27 10:55:55 2005 : Error: rlm_sql (sql1): Failed to connect DB handle #2
Thu Jan 27 10:55:55 2005 : Info: rlm_sql (sql1): There are no DB handles to
use! skipped 1, tried to connect 1
Thu Jan 27 10:55:55 2005 : Auth: Login OK: [user/password] (from client
nas3.domain.nl port 1812)
In my radiusd.conf
$INCLUDE ${confdir}/sql1.conf
$INCLUDE ${confdir}/sql2.conf
accounting {
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
}
}
}
authorize {
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
}
}
}
In sql1.conf and sql2.conf i also try this:
connect_failure_retry_delay = 5 #60
Can any one help me whit this problem to make it faster?
Thanks Michel
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
