Re: Problem using Freeradius with Oracle [sec=unclassified]

2007-12-17 Thread Mother
Hi Frank, Ranner, Frank MR wrote: Oracle doesn't seem to do bit shift. You can multiply by 2^32 instead. AcctInputOctets = '%{%{Acct-Input-Gigawords}:-0}' * 4294967296 + '%{%{Acct-Input-Octets}:-0}' Oracle supports up to 38 digit numbers. Thanks so much for that suggestion, I will give it

RE: Problem using Freeradius with Oracle [sec=unclassified]

2007-12-16 Thread Ranner, Frank MR
> -Original Message- > From: > [EMAIL PROTECTED] > eradius.org > [mailto:[EMAIL PROTECTED] > ists.freeradius.org] On Behalf Of Mother > Sent: Sunday, 16 December 2007 06:28 > To: freeradius-users@lists.freeradius.org > Subject: Problem using Freeradius with

Re: Problem using Freeradius with Oracle

2007-12-15 Thread Mother
Hi Ivan, [EMAIL PROTECTED] wrote: The only difficulty is that there doesn't seem to be an .sql script included with FreeRADIUS to create the Oracle table structure, triggers, etc. so I had to rely on an old version I found. If it's of any help now: http://wiki.freeradius.org/Oracle_DDL_scrip

Re: Problem using Freeradius with Oracle

2007-12-15 Thread tnt
>The only >difficulty is that there doesn't seem to be an .sql script included with >FreeRADIUS to create the Oracle table structure, triggers, etc. so I had >to rely on an old version I found. If it's of any help now: http://wiki.freeradius.org/Oracle_DDL_script Ivan Kalik Kalik Informatika IS

Re: Problem using Freeradius with Oracle

2007-12-15 Thread Mother
Hi David, David Wood wrote: Hi Mike, In message <[EMAIL PROTECTED]>, Mother <[EMAIL PROTECTED]> writes My setup is FreeBSD 6.2, with Freeradius 1.1.7 installed using Ports (I had to hack the configure so it would be built with Oracle, as there is no option in the Ports make, but I digress...

Re: Problem using Freeradius with Oracle

2007-12-15 Thread David Wood
Hi Mike, In message <[EMAIL PROTECTED]>, Mother <[EMAIL PROTECTED]> writes My setup is FreeBSD 6.2, with Freeradius 1.1.7 installed using Ports (I had to hack the configure so it would be built with Oracle, as there is no option in the Ports make, but I digress...). I maintain the FreeBSD ne

Re: Problem using Freeradius with Oracle

2007-12-15 Thread Alan DeKok
Mother wrote: ... > Now, Acc[input/output]Octets as I see in oraclesql.conf is derived like > this: > > AcctInputOctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | > '%{%{Acct-Input-Octets}:-0}' > > So it seems (AFAIK) that it's attempting to bit-shift the Gigawords and > Octets received from the

Problem using Freeradius with Oracle

2007-12-15 Thread Mother
Hi all, My setup is FreeBSD 6.2, with Freeradius 1.1.7 installed using Ports (I had to hack the configure so it would be built with Oracle, as there is no option in the Ports make, but I digress...). I have everything working now, but when the accounting stop message is received, the SQL cal