Hi, i left the redundant for a while and today i am trying again, and it fails

I have this on the radiusd.conf

  detail {
        fail = 1
        }
        redundant redundant_sql {
                sql1
                sql2
                handled
        }

        redundant redundant_sqlip {
                sqlippool1
                sqlippool1
                #notfound = return
                handled
        }

And on the sites-enable/default

authorize {
        preprocess
        chap
        mschap
        suffix
        eap {
                ok = return
        }
        redundant_sql
        pap
        expiration
        logintime
        pap
}

authenticate {
        Auth-Type PAP {
                pap
        }
        Auth-Type CHAP {
                chap
        }
        Auth-Type MS-CHAP {
                mschap
        }
        unix
        eap
}

preacct {
        preprocess
        acct_unique
        suffix
}

accounting {
        detail
        redundant_sql
        radutmp
        redundant_sqlip
}


session {
        radutmp
        redundant_sql
}


post-auth {
        redundant_sql
        redundant_sqlip
        exec
        Post-Auth-Type REJECT {
                attr_filter.access_reject
        }
}

pre-proxy {
}

post-proxy {
        eap
}


And Sql stills fail when one of the database isn't available. Is this configuration right?





On Wed, Oct 27, 2010 at 4:36 PM, Rhommel Lamas <roml@rhommell.com> wrote:
ok i was getting crazy around here thought it was something about my configuration :) Good To know that
Sql instances should have a variable that you can setup in case you are using a failover and it adjust some parameters like

1.- readclients: Actually i had to set the variable readclients to NO on one of my sql instances, i think it would be helpfull to set that on the radiusd.conf something like readclients = sql_redundant.
2.- sqlippool.conf: I think it wouldbe helpfull if sql-instance-name could be assigned from a redundant instance declared on the radiusd.conf


Of course those are ideas i don't know you guys have more experience on this maybe mine are lame.


Thanks for the Help.


Rhommel Lamas.




On Oct 27, 2010, at 4:17 PM, Alan DeKok wrote:

> Rhommel Lamas wrote:
>> For example i have 2 Databases server, and 1 radius server, i need to configure it for failover.
>> I already configured both Sql instances, and both sqlippool instances.
>
>  OK.
>
>> When i start radius i see two scenarios:
>> 1.- If both Databases are up and running Radius Works.
>
>  That's the intent.
>
>> 2.- If one of my mysql is down radius won't start because it fails to connect to the database that is down.
>
>  That's also the intent.
>
>> Is this the right way or i am failling on something?
>
>  It's the way it works now.  We're looking into making it more flexible
> in the future.
>
>  Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html




--
Best Regards,

Rhommel A. Lamas N. 

Sent from my Blackberry 8900.