MySQL Fail Over Error When 1 DB is Down

[Det Det]

When I shutdown one of the DB, it generates an error. How do I tell freeradius to ignore that and proceed if it can connect to at least one of the DB?


/etc/freeradius/sql2.conf[22]: Instantiation failed for module "sql2"
/etc/freeradius/radiusd.conf[75]: Failed to find module "sql2".
/etc/freeradius/radiusd.conf[75]: Failed to parse "sql2" entry.
/etc/freeradius/sites-enabled/default[1]: Errors parsing authorize section. 




________________________________
From: Det Det <det.explorer at yahoo.com>
To: FreeRadius mailing list <freeradius-users at lists.freeradius.org>
Sent: Monday, August 29, 2011 2:05 PM
Subject: MySQL Fail Over Error When 1 DB is Down


Hi there,

I can't get FreeRADIUS to ignore error and continue processing when 1 DB is down even when it can connect to the other DB. Below is my config.


# radiusd.conf
instantiate {

...

        redundant redundant_sql {
                sql1
                sql2
                handled
        }
}
modules {
...
        $INCLUDE sql1.conf
        $INCLUDE sql2.conf
}

# sql1.conf
sql sql1 {
        database = "mysql"
…
}

# sql2.conf
sql sql2 {
...
        database = "mysql"
}

# sites-enabled/default

authorize {
        redundant_sql
}
accounting {
      redundant_sql
}
session {
        redundant_sql
}
post-auth {
        redundant_sql
        Post-Auth-Type REJECT {
               
 redundant_sql
                attr_filter.access_reject
        }
}


bregards,
det

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110829/b940406b/attachment.html>