Re: Load-Balance-Key usage

2012-09-28 Thread Alan DeKok
lscrlstld wrote:
 Can I use the Load-Balance-Key to choose a specific home_server?

  That sort of negates the utility of load balancing, doesn't it?

   if ( ... ) { 
 update control { Load-Balance-Key := 1} #sends to server1 
   }
   else {
 update control { Load-Balance-Key := 2} #sends to server2
   }

  Well, you can do that.  But you can't control which server it gets
sent to.  You'll have to play with the key values to figure out how they
map to a server.

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


Re: MySQL Segmentation Fault

2012-09-28 Thread Alan DeKok
Bryan Dobson wrote:
 I have a new installation and configuration that I am working on for
 FreeRadius on CentOS 6.3 the versions are:
 
 freeradius-2.1.12-3.el6.x86_64
 
 Testing authentication, which goes to a remote MySQL database which
 was pre-existing with all user data. It executes the query and then
 immediately gives me a segmentation fault. Of note I have also
 compiled version 2.2 from source and receive the exact same error. I
 would prefer, if a tall possible to stick to using the RPM's from the
 distribution.

  You have two versions of the MySQL client libraries and/or headers
installed.  Go fix that.

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


Re: Load-Balance-Key usage

2012-09-28 Thread Phil Mayers

On 27/09/12 19:04, lscrlstld wrote:


authorize {
...
   if ( ... ) {
 update control { Load-Balance-Key := 1} #sends to server1
   }
   else {
 update control { Load-Balance-Key := 2} #sends to server2
   }
...
}


Not like this. The Load-Balance-Key value is hashed.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: MySQL Segmentation Fault

2012-09-28 Thread Bryan Dobson
Thank you for the reply, I thought this as well, but, checking the
system all I only see a single set of client libraries installed:

[root@radiusdev ~]# rpm -qa | grep mysql
mysql-5.1.61-4.el6.x86_64
mysql-devel-5.1.61-4.el6.x86_64
mysql-libs-5.1.61-4.el6.x86_64
mysql-server-5.1.61-4.el6.x86_64

Do I need all of those or is one causing me the issue still with the faults?

Bryan Dobson wrote:
 I have a new installation and configuration that I am working on for
 FreeRadius on CentOS 6.3 the versions are:

 freeradius-2.1.12-3.el6.x86_64

 Testing authentication, which goes to a remote MySQL database which
 was pre-existing with all user data. It executes the query and then
 immediately gives me a segmentation fault. Of note I have also
 compiled version 2.2 from source and receive the exact same error. I
 would prefer, if a tall possible to stick to using the RPM's from the
 distribution.

 You have two versions of the MySQL client libraries and/or headers
 installed.  Go fix that.

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


Re: MySQL Segmentation Fault

2012-09-28 Thread Thomas Glanzmann
Hello Bryan,

 [root@radiusdev ~]# rpm -qa | grep mysql
 mysql-5.1.61-4.el6.x86_64
 mysql-devel-5.1.61-4.el6.x86_64
 mysql-libs-5.1.61-4.el6.x86_64
 mysql-server-5.1.61-4.el6.x86_64

they all belong to same release.

 Do I need all of those or is one causing me the issue still with the
 faults?

What does 'find /usr -name libmysql\*.so' say?

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


Re: MySQL Segmentation Fault

2012-09-28 Thread Alan DeKok
Bryan Dobson wrote:
 Thank you for the reply, I thought this as well, but, checking the
 system all I only see a single set of client libraries installed:

  shrug  It's not a FreeRADIUS problem.  Something, somewhere, is
using the wrong library.  Use ldd to figure out which are being used.

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


[no subject]

2012-09-28 Thread Bryan Dobson
Thank you for the reply Thomas, this is the results of searching for that:

/usr/lib64/mysql/libmysqlclient.so.16
/usr/lib64/mysql/libmysqlclient.so.16.0.0
/usr/lib64/mysql/libmysqlclient_r.so.16
/usr/lib64/mysql/libmysqlclient_r.so.16.0.0

All of that is your standard libraries included in the RPM package and
fairly common really so far as I can see.

Hello Bryan,

 [root@radiusdev ~]# rpm -qa | grep mysql
 mysql-5.1.61-4.el6.x86_64
 mysql-devel-5.1.61-4.el6.x86_64
 mysql-libs-5.1.61-4.el6.x86_64
 mysql-server-5.1.61-4.el6.x86_64

they all belong to same release.

 Do I need all of those or is one causing me the issue still with the
 faults?

What does 'find /usr -name libmysql\*.so' say?

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