Redundant Freeradius

[Rhommel Lamas]

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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20101111/cb0ea448/attachment.html>