On 10/12/2012 09:16 AM, Jonathan Bastin wrote:
Issue with doing it that way is you would get decimal values returned which
freeradius can't deal with.
As others have pointed out - that's trivially dealt with.
Hell, use right-shift if you want:
select limit 10
select quota 10
...it doesn't
[mailto:freeradius-users-bounces+jonathan.bastin=peerpointinternet.co.uk@lis
ts.freeradius.org] On Behalf Of Fajar A. Nugraha
Sent: 15 October 2012 01:40
To: FreeRadius users mailing list
Subject: Re: Query help
On Mon, Oct 15, 2012 at 7:35 AM, Fajar A. Nugraha l...@fajar.net wrote:
If yes
On 12 Oct 2012, at 09:16, Jonathan Bastin
jonathan.bas...@peerpointinternet.co.uk wrote:
Issue with doing it that way is you would get decimal values returned which
freeradius can't deal with.
So use round()...
http://www.w3schools.com/sql/sql_func_round.asp
-Arran
-
List
On Fri, Oct 12, 2012 at 3:16 PM, Jonathan Bastin
jonathan.bas...@peerpointinternet.co.uk wrote:
Issue with doing it that way is you would get decimal values returned which
freeradius can't deal with.
I am posting a bounty of $200
Good to hear that. Hopefuly someone will be able to help you.
On Mon, Oct 15, 2012 at 7:35 AM, Fajar A. Nugraha l...@fajar.net wrote:
If yes, it should be MUCH quicker to simply do the comparison INSIDE
the sql statement. Something like (untested, should work for mysql):
if (%{sql: ( (SELECT radgroupcheck.value FROM radusergroup Inner Join
radgroupcheck
@lists.freeradius.org
Subject: Re: Query help
On 10/10/12 15:25, Jonathan Bastin wrote:
To me it looks like the value is wrapping. Is this due to that even
the interpreter in the site config file is 32-bit only. If this is the
case I presume my only resort it perl. If this is the case could
someone help
'
Subject: RE: Query help
This is the full dump I get
rad_recv: Access-Request packet from host 193.000.221.00 port 1645, id=213,
length=141
Framed-Protocol = PPP
User-Name = 02085000...@peerpointinternet.co.uk
CHAP-Password = 0x045f3e13da52acf8b9e784c0c125ed102f
On 10/10/12 14:23, Jonathan Bastin wrote:
I have been looking at this further am I am having trouble finding the answer.
Is anyone able to point me into the right direction.
You might find it a bit easier to debug if you perform the two SQL
queries (for the quota, and the current limit)
] On Behalf Of Phil Mayers
Sent: 10 October 2012 15:00
To: freeradius-users@lists.freeradius.org
Subject: Re: Query help
On 10/10/12 14:23, Jonathan Bastin wrote:
I have been looking at this further am I am having trouble finding the
answer. Is anyone able to point me into the right direction.
You
Jonathan Bastin wrote:
To me it looks like the value is wrapping. Is this due to that even the
interpreter in the site config file is 32-bit only.
Yes. All numbers in RADIUS are 32-bit.
I think v3 will extend the internal code in the server to use 64-bit
numbers.
Alan DeKok.
-
List
@lists.freer
adius.org
[mailto:freeradius-users-bounces+jonathan.bastin=peerpointinternet.co.uk@lis
ts.freeradius.org] On Behalf Of Alan DeKok
Sent: 10 October 2012 15:36
To: FreeRadius users mailing list
Subject: Re: Query help
Jonathan Bastin wrote:
To me it looks like the value is wrapping
On 10/10/12 15:25, Jonathan Bastin wrote:
To me it looks like the value is wrapping. Is this due to that even the
interpreter in the site config file is 32-bit only. If this is the case I
presume my only resort it perl. If this is the case could someone help me
convert this?
You could divide
Jonathan Bastin wrote:
*Issue I get is that I always get *
Tue Oct 9 13:43:17 2012 : Info: ++- if (%{sql: SELECT
radgroupcheck.value FROM radusergroup Inner Join radgroupcheck ON
radusergroup.groupname = radgroupcheck.groupname WHERE
radusergroup.username = '%{User-Name}' AND
=peerpointinternet.co...@lists.freeradius.org
[mailto:freeradius-users-bounces+jonathan.bastin=peerpointinternet.co...@lists.freeradius.org]
On Behalf Of Alan DeKok
Sent: 09 October 2012 14:17
To: FreeRadius users mailing list
Subject: Re: Query help
Jonathan Bastin wrote:
*Issue I get is that I
14 matches
Mail list logo