Hello freeradius users, When is start radiusd (master db is down) i use failover db. See log, it take from 13:41 to 13:44 to start connect to the second db. Can any one see in this log whats go wrong? Thu Jan 27 13:41:32 2005 : Info: Using deprecated naslist file. Support for this will go away soon. Thu Jan 27 13:41:32 2005 : Info: Using deprecated clients file. Support for this will go away soon. Thu Jan 27 13:41:32 2005 : Info: Using deprecated realms file. Support for this will go away soon. Thu Jan 27 13:41:32 2005 : Info: rlm_sql (sql1): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Thu Jan 27 13:41:32 2005 : Info: rlm_sql (sql1): Attempting to connect to [EMAIL PROTECTED]:/westwireless Thu Jan 27 13:41:32 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Thu Jan 27 13:44:41 2005 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:db Thu Jan 27 13:44:41 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.160.10' (110)' Thu Jan 27 13:44:41 2005 : Error: rlm_sql (sql1): Failed to connect DB handle #0 Thu Jan 27 13:44:41 2005 : Info: rlm_sql (sql2): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Thu Jan 27 13:44:41 2005 : Info: rlm_sql (sql2): Attempting to connect to [EMAIL PROTECTED]:/db Thu Jan 27 13:44:41 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Thu Jan 27 13:44:41 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1 Thu Jan 27 13:44:41 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2 Thu Jan 27 13:44:41 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3 Thu Jan 27 13:44:41 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Thu Jan 27 13:44:41 2005 : Info: Listening on IP address *, ports 1812/udp and 1813/udp. Thu Jan 27 13:44:41 2005 : Info: Ready to process requests.
> 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 Met vriendelijke groet, M. v Dop www.westwireless.nl - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
