[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: SQL not a variable
From:       Alan DeKok <aland () deployingradius ! com>
Date:       2019-04-30 16:43:05
Message-ID: C8D81D06-F34E-4B6F-B721-7D9A9EC425B0 () deployingradius ! com
[Download RAW message or body]

On Apr 30, 2019, at 11:58 AM, Nicolas Breuer <Nicolas.Breuer@belcenter.biz> wrote:
> 
> Hello,
> 
> It's not working...
> 
> allocate-find = "SELECT ip_address FROM radippool WHERE (pool_name like \
> '%{reply:Pool-Suffix}*%%' and pool_name not like '%%STATx%%')  AND expiry_time < \
> NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE" 
> [IP-POOLING-01]         expand: SELECT ip_address FROM radippool WHERE (pool_name \
> like '%{reply:Pool-Suffix}*%' and pool_name not like '%STATx%')  AND expiry_time < \
> NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE -> SELECT \
> ip_address FROM radippool WHERE (pool_name like 'BC*%' and pool_name not like \
> '2019-04-30 17:55:08TATx%')  AND expiry_time < NOW() ORDER BY rand(), pool_name, \
> expiry_time LIMIT 1 FOR UPDATE 
> What I'm doing wrong?

  Unfortunately, there are two layers of expansion.  You'll need to use: \
%%%%STATx%%%%

  Alan DeKok.


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


[prev in list] [next in list] [prev in thread] [next in thread]