Re: Have anyone a good example failover mysql config?

Michel van Dop Sun, 30 Jan 2005 12:54:53 -0800

On authorize and accounting i using this now:

        group {
                sql1 {
                        fail     = return
                        notfound = return
                       noop     = 2
                        ok       = return
                        updated  = 3
                        reject   = return
                        userlock = 4
                        invalid  = 5
                        handled  = 6
                }
                sql2 {
                        fail     = return
                        notfound = return
                        noop     = 2
                        ok       = return
                        updated  = 3
                        reject   = return
                        userlock = 4
                        invalid  = 5
                        handled  = 6
                }
        }

Same problem! ? Starting slow 240 second to get started and radiusd -X give after starting this on request this:

####### radtest test test localhost 1812 secretkey ###########

Re-sending Access-Request of id 226 to 127.0.0.1:1812
       User-Name = "test"
       User-Password = "\016\211\031\273\032\001T\203t8\375\305\357_qG"
       NAS-IP-Address = radius02
       NAS-Port = 1812
radclient: no response from server

Listening on IP address *, ports 1812/udp and 1813/udp. Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1:32776, id=218, length=57 User-Name = "test" User-Password = "test" NAS-IP-Address = 255.255.255.255 NAS-Port = 1812 modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 modcall[authorize]: module "mschap" returns noop for request 0 rlm_realm: No '@' in User-Name = "theus", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 0 modcall: entering group group for request 0 radius_xlat: 'test' rlm_sql (sql1): sql_set_user escaped user --> 'test' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM users WHERE Username = 'test' ORDER BY id' rlm_sql (sql1): Ignoring unconnected handle 4.. rlm_sql (sql1): Ignoring unconnected handle 3.. rlm_sql (sql1): Ignoring unconnected handle 2.. rlm_sql (sql1): Ignoring unconnected handle 1.. rlm_sql (sql1): Ignoring unconnected handle 0.. rlm_sql (sql1): There are no DB handles to use! skipped 5, tried to connect 0 modcall[authorize]: module "sql1" returns fail for request 0 modcall: group group returns fail for request 0 modcall: group authorize returns fail for request 0 There was no response configured: rejecting request 0 Server rejecting request 0. Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Sending Access-Reject of id 218 to 127.0.0.1:32776 Waking up in 4 seconds... --- Walking the entire request list --- Cleaning up request 0 ID 218 with timestamp 41fd47af Nothing to do. Sleeping until we see a request. rad_recv: Access-Request packet from host 127.0.0.1:32776, id=222, length=57 User-Name = "test" User-Password = "test" NAS-IP-Address = 255.255.255.255 NAS-Port = 1812 modcall: entering group authorize for request 1 modcall[authorize]: module "preprocess" returns ok for request 1 modcall[authorize]: module "chap" returns noop for request 1 modcall[authorize]: module "mschap" returns noop for request 1 rlm_realm: No '@' in User-Name = "theus", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 1 modcall: entering group group for request 1 radius_xlat: 'theus' rlm_sql (sql1): sql_set_user escaped user --> 'test' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM users WHERE Username = 'theus' ORDER BY id' rlm_sql (sql1): Trying to (re)connect unconnected handle 4.. rlm_sql (sql1): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4

----- Original Message ----- From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, January 30, 2005 5:58 PM Subject: Re: Have anyone a good example failover mysql config?

Michel van Dop wrote:
accounting {
       redundant {
               sql1 {
                       ok = return
               }
               sql2
       }
}
But same problems ??? Can any one send a working failover config?
Read again the workaround provided in the bug report: you shouldn't
use "redundant" stanza. (use "group" instead)
Nicolas Baradakis
--
A: Yes.
Q: Are you sure?
A: Because it reverses the logical flow of conversation.
Q: Why is top posting annoying in email?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Have anyone a good example failover mysql config?

Reply via email to