s}' when '' then 0 else
cast('%{Acct-Input-Octets}' as numeric) end, case '%{Acct-Output-Octets}'
when '' then 0 else cast('%{Acct-Output-Octets}' as numeric) end, \
'%{Service-Type}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Ascend-S
ession-Svr-Key}')
I replaced my AddQUery to the above statment
Have a good night list and hugh
Kind Regards
Nathan Franklin
TSN Internet [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
'When doing something, the toughest and quite obviously, the most important
step is always the first one. We all suffer from the problem of inertia...
getting started is all it takes.'
- Original Message -
From: "Hugh Irvine" <[EMAIL PROTECTED]>
To: "Nathan 'Franko' Franklin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 3:41 PM
Subject: (RADIATOR) Re: Values Disappearing
>
> Hello Nathan -
>
> I am surprised that you are having a problem with the AddQuery, as it
> is only used when an accounting start is received, and the counters
> should be zero.
>
> Could you please send me a complete copy of the configuration file (no
> secrets) together with a trace 4 debug showing what is happening?
>
> regards
>
> Hugh
>
>
> On Wednesday, Apr 2, 2003, at 09:24 Australia/Melbourne, Nathan
> 'Franko' Franklin wrote:
>
> > Hello List And Hugh
> >
> > I have a problem, I am trying to set up our session database without
> > much
> > success.
> > I am using SessionDatabase SQL.
> >
> > The current field in my Online table for input and output octects is
> > BIGINT,
> > (SQL SERVER)
> > This is working fine except for the fact when we get a user that is
> > download
> > over 2 gig in any one session.
> > After this we get an Arithimic overflow error.
> >
> > This is my query below:
> > AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
> > ACCTSESSIONID, FRAMEDADDRESS, AccInputOctets, AccOutputOctets, \
> > SERVICETYPE,NASPortDNIS,callerid,AscendKey) values ('%n', '%N',
> > %{NAS-Port},
> > '%{Acct-Session-Id}', \
> > '%{Framed-IP-Address}', '%{Acct-Input-Octets}',
> > '%{Acct-Output-Octets}', \
> > '%{Service-Type}','%{Called-Station-Id}','%{Calling-Station-
> > Id}','%{Ascend-S
> > ession-Svr-Key}')
> >
> > notice how %{Acct-Input-Octets}and %{Acct-Output-Octets} are enclosed
> > by '',
> > This is a problem,
> > I tried converting our fields in the database to numeric so we could
> > handle
> > the data coming through, but then the sql statement errored as i
> > thought it
> > would saying error converting varchar to numeric. So i took away the ''
> > around the two values, and after I did that the values disappeared.
> > Without
> > the quotes %{Acct-Input-Octets} and %{Acct-Output-Octets} return empty
> > values.
> >
> > Even if I try to cast the value as numeric it still comes back as
> > empty.
> >
> > IN casting numeric I mean this
> >
> > AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
> > ACCTSESSIONID, FRAMEDADDRESS, AccInputOctets, AccOutputOctets, \
> > SERVICETYPE,NASPortDNIS,callerid,AscendKey) values ('%n', '%N',
> > %{NAS-Port},
> > '%{Acct-Session-Id}', \
> > '%{Framed-IP-Address}', cast('%{Acct-Input-Octets}' as numeric),
> > cast('%{Acct-Output-Octets}' as numeric), \
> > '%{Service-Type}','%{Called-Station-Id}','%{Calling-Station-
> > Id}','%{Ascend-S
> > ession-Svr-Key}')
> >
> > this Still causes the values to return empty.
> >
> > The values are returning empty becuase I print out the sql string
> > before
> > execution
> >
> > Any help in this matter would be very much appreciated.
> >
> > Thanks everyone
> >
> >
> > Kind Regards
> >
> > Nathan Franklin
> > TSN Internet
> > [EMAIL PROTECTED]
> > MSN: [EMAIL PROTECTED]
> >
> > 'I do not regret the things I have done, but those I have left undone.'
> >
> >
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
