SQL IP Pool Not Accepting Redundant SQL
Hi, How to make sqlippool accept redundant SQL as below? sqlippool { sql-instance-name = "redundant_sql" ippool_table = "radippool" ... } radiusd.conf ... redundant redundant_sql { sql1 sql2 } ... if I use sql-instance-name = "sql1" or sql-instance-name = "sql2", it works. But then, I'd like to do redundancy. sql-instance-name = "sql1 sql2" or sql-instance-name = "sql1, sql2" also does not work. Thanks! Det
On 4 Oct 2011, at 12:08, Det Det wrote:
Hi,
How to make sqlippool accept redundant SQL as below?
sqlippool { sql-instance-name = "redundant_sql" ippool_table = "radippool" ... }
radiusd.conf ... redundant redundant_sql { sql1 sql2 } ...
if I use sql-instance-name = "sql1" or sql-instance-name = "sql2", it works. But then, I'd like to do redundancy.
sql-instance-name = "sql1 sql2" or sql-instance-name = "sql1, sql2" also does not work.
-
You can't, 'redundant_sql' is not an sql-instance. You need to create two instances of sqlippool, then wrap them in a redundant block... Arran Cudbard-Bell a.cudbardb@freeradius.org Betelwiki, Betelwiki, Betelwiki.... http://wiki.freeradius.org/ !
You can't, 'redundant_sql' is not an sql-instance. You need to create two instances of sqlippool, then wrap them in a redundant block...
If you're using FR >= 2.1.11 or 3.* Overload the sqlippool module policy.conf policy { sqlippool { redundant { sqlippool1 sqlippool2 } } } Arran Cudbard-Bell a.cudbardb@freeradius.org Betelwiki, Betelwiki, Betelwiki.... http://wiki.freeradius.org/ !
hey thanks! got it working using that configuration below. It also worked when placed in instantiate block. ________________________________ From: Arran Cudbard-Bell <a.cudbardb@freeradius.org> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Cc: Det Det <det.explorer@yahoo.com> Sent: Tuesday, October 4, 2011 6:24 PM Subject: Re: SQL IP Pool Not Accepting Redundant SQL
You can't, 'redundant_sql' is not an sql-instance. You need to create two instances of sqlippool, then wrap them in a redundant block...
If you're using FR >= 2.1.11 or 3.* Overload the sqlippool module policy.conf policy { sqlippool { redundant { sqlippool1 sqlippool2 } } } Arran Cudbard-Bell a.cudbardb@freeradius.org Betelwiki, Betelwiki, Betelwiki.... http://wiki.freeradius.org/ !
participants (2)
-
Arran Cudbard-Bell -
Det Det