Re: Comparing Two Attributes

2012-07-27 Thread Jenny Blunt
: SELECT * where XXX = '%{SQL-Location-Id}' } } Is this possible? On 26 Jul 2012, at 12:41, Jenny Blunt wrote: How do I go about comparing two attributes from an update request? I have the following in my default conf. file: update request { SQL-Location := %{sql: SELECT xxx

Re: Comparing Two Attributes

2012-07-27 Thread Jenny Blunt
Thanks, my mistake - copied from wrong place. On 27 Jul 2012, at 14:27, Alan DeKok wrote: Jenny Blunt wrote: On a similar note, If I wanted to use the first result in the second update request, how can I go about that? I've tried the following, but I get a blank value for SQL-Location-Id

Huntgroup Implementation with MySQL and Radgroupcheck

2012-07-26 Thread Jenny Blunt
I'm looking for some help with the implementation of huntgroups.Am using mysql and have followed the following topic through: http://freeradius.1045715.n5.nabble.com/Huntgroup-Checking-td4950385.htmlIn sites-available/default I have this, (just after preprocess: update request {

Re: Huntgroup Implementation with MySQL and Radgroupcheck

2012-07-26 Thread Jenny Blunt
I forgot to mention that the look up works if I enter the Huntgroup-Name in radcheck.For some reason, it's just failing in radgroupcheckOn Jul 26, 2012, at 09:51 AM, Jenny Blunt jennyshoeh...@me.com wrote:I'm looking for some help with the implementation of huntgroups.Am using mysql and have

Re: Huntgroup Implementation with MySQL and Radgroupcheck

2012-07-26 Thread Jenny Blunt
, at 10:07 AM, Phil Mayers p.may...@imperial.ac.uk wrote:On 07/26/2012 09:51 AM, Jenny Blunt wrote: I'm looking for some help with the implementation of huntgroups. Am using mysql and have followed the following topic through:http://freeradius.1045715.n5.nabble.com/Huntgroup-Checking-td4950385

Comparing Two Attributes

2012-07-26 Thread Jenny Blunt
How do I go about comparing two attributes from an update request?I have the following in my default conf. file:update request { SQL-Location := "%{sql: SELECT xxx}"} update request { SQL-Location-Id := "%{sql: SELECT yyy }"}if (SQL-Location != SQL-Location-Id ) { reject}And my debug log

Re: Comparing Two Attributes

2012-07-26 Thread Jenny Blunt
Mucho graciasOn Jul 26, 2012, at 01:01 PM, Phil Mayers p.may...@imperial.ac.uk wrote:On 26/07/12 12:41, Jenny Blunt wrote: How do I go about comparing two attributes from an update request? I have the following in my default conf. file: update request { SQL-Location := "%{sql: SELEC