There is a frequntie in it. So i can when i have lucky i can login every 240 seconds. I use second db failover first db is down.
Thu Jan 27 14:29:07 2005 : Auth: Login OK: [user/password] (from client nas3.domain.nl port 1812) Thu Jan 27 14:29:10 2005 : Info: rlm_sql (sql1): Trying to (re)connect unconnected handle 4.. Thu Jan 27 14:29:10 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Thu Jan 27 14:29:13 2005 : Error: Discarding new request from client nas3.domain.nl:32770 - ID: 18 due to live request 15 Thu Jan 27 14:29:37 2005 : Error: Discarding new request from client nas3.domain.nl:32770 - ID: 18 due to live request 15 Thu Jan 27 14:29:43 2005 : Error: WARNING: Unresponsive child (id 3210005424) for request 15 Thu Jan 27 14:29:43 2005 : Info: rlm_sql (sql1): Trying to (re)connect unconnected handle 3.. Thu Jan 27 14:29:43 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3 Thu Jan 27 14:29:46 2005 : Error: Discarding new request from client nas3.domain.nl:32770 - ID: 22 due to live request 25 Thu Jan 27 14:29:49 2005 : Error: Discarding new request from client nas3.domain.nl:32770 - ID: 22 due to live request 25 Thu Jan 27 14:31:28 2005 : Error: WARNING: Unresponsive child (id 3199515568) for request 25 Thu Jan 27 14:31:28 2005 : Info: rlm_sql (sql1): Trying to (re)connect unconnected handle 2.. Thu Jan 27 14:31:28 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2 Thu Jan 27 14:31:31 2005 : Error: Discarding new request from client nas3.domain.nl:32771 - ID: 26 due to live request 35 Thu Jan 27 14:31:55 2005 : Error: Discarding new request from client nas3.domain.nl:32771 - ID: 26 due to live request 35 Thu Jan 27 14:32:06 2005 : Error: WARNING: Unresponsive child (id 3189025712) for request 35 Thu Jan 27 14:32:06 2005 : Info: rlm_sql (sql1): Trying to (re)connect unconnected handle 1.. Thu Jan 27 14:32:06 2005 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1 Thu Jan 27 14:32:09 2005 : Error: Discarding new request from client nas3.domain.nl:32771 - ID: 31 due to live request 45 Thu Jan 27 14:32:19 2005 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:domain Thu Jan 27 14:32:19 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.160.10' (110)' Thu Jan 27 14:32:19 2005 : Error: rlm_sql (sql1): Failed to connect DB handle #4 Thu Jan 27 14:32:19 2005 : Info: rlm_sql (sql1): There are no DB handles to use! skipped 2, tried to connect 1 Thu Jan 27 14:32:19 2005 : Auth: Login OK: [user/password] (from client nas3.domain.nl port 1812) Thu Jan 27 14:32:30 2005 : Error: Discarding new request from client nas3.domain.nl:32771 - ID: 31 due to live request 45 Thu Jan 27 14:32:33 2005 : Error: Discarding new request from client nas3.domain.nl:32771 - ID: 31 due to live request 45 Thu Jan 27 14:32:52 2005 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:domain Thu Jan 27 14:32:52 2005 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.160.10' (110)' Thu Jan 27 14:32:52 2005 : Error: rlm_sql (sql1): Failed to connect DB handle #3 Thu Jan 27 14:32:52 2005 : Info: rlm_sql (sql1): There are no DB handles to use! skipped 2, tried to connect 1 Thu Jan 27 14:32:52 2005 : Auth: Login OK: [user/password] (from client nas3.domain.nl port 1812) Thu Jan 27 14:33:06 2005 : Error: WARNING: Unresponsive child (id 3178535856) for request 45 Thu Jan 27 14:33:06 2005 : Info: rlm_sql (sql1): There are no DB handles to use! skipped 3, tried to connect 0 Thu Jan 27 14:33:06 2005 : Auth: Login OK: [user/password] (from client nas3.domain.nl port 1812) > 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 Met vriendelijke groet, M. v Dop www.westwireless.nl - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
