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.
