Re: Query help

2012-10-15 Thread Phil Mayers
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

RE: Query help

2012-10-15 Thread Jonathan Bastin
[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

Re: Query help

2012-10-14 Thread Arran Cudbard-Bell
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

Re: Query help

2012-10-14 Thread Fajar A. Nugraha
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.

Re: Query help

2012-10-14 Thread Fajar A. Nugraha
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

RE: Query help

2012-10-12 Thread Jonathan Bastin
@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

RE: Query help

2012-10-10 Thread Jonathan Bastin
' 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

Re: Query help

2012-10-10 Thread Phil Mayers
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)

RE: Query help

2012-10-10 Thread Jonathan Bastin
] 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

Re: Query help

2012-10-10 Thread Alan DeKok
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

RE: Query help

2012-10-10 Thread Jonathan Bastin
@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

Re: Query help

2012-10-10 Thread Phil Mayers
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

Query help

2012-10-09 Thread Jonathan Bastin
I am trying to write a query to look at peoples quota and change their speed biased on these details. So far I have: if (%{sql: SELECT radgroupcheck.value FROM radusergroup Inner Join radgroupcheck ON radusergroup.groupname = radgroupcheck.groupname WHERE radusergroup.username = '%{User-Name}'

Re: Query help

2012-10-09 Thread Alan DeKok
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

RE: Query help

2012-10-09 Thread Jonathan Bastin
=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

Quick mysql query help

2006-05-24 Thread Jeremy ohara
hi there guys. i just need some help with mysql query. how can i include c:\dafds\ddsfsd into a feild. example ++-+---++--+ | id | UserName |password |DO |datalocation|

Please ignore Quick mysql query help

2006-05-24 Thread Jeremy ohara
This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. -