(RADIATOR) Execute MS SQL Procedure and getting error for Account Start Record.

[Hugh Irvine]

Hello Nayeem -

You can prefix the attributes with '0' like this:

AcctSQLStatement exec AliveUsageDSl \
	'%n', \
	'%{Acct-Status-Type}', \
	0%{Acct-Input-Octets},\
	0%{Acct-Output-Octets}, \
	'%{Acct-Session-Id}', \
	0%{Acct-Session-Time}, \
	'%m/%d/%Y %H:%M:%S', \
	'%{Calling-Station-Id}', \
	'%{Framed-IP-Address}', \
	'%{Acct-Terminate-Cause}'

Or alternatively you can use different AuthBy clauses for starts,  
alives and stops.

hope that helps

regards

Hugh


On 2 May 2006, at 03:10, Nayeem ((Zajil Com)) wrote:

> Dear All,
>
> I'm facing one problem while execute procedure for Start Record for
> Accounting because in start record accounting there is no Acct- 
> Input-Octets,
> Acct-Output-Octets & Acct-Session-Time and while passing parameter to
> procedure it is empty and got error.
>
> For example : For Live Accounting.
>
> In Config File.
>
> AcctSQLStatement exec AliveUsageDSl '%n','%{Acct-Status-Type}',
> %{Acct-Input-Octets},\
> 		%{Acct-Output-Octets},'%{Acct-Session-Id}',
> %{Acct-Session-Time}, \
> 		'%m/%d/%Y %H:%M:%S','%{Calling-Station-Id}',
> '%{Framed-IP-Address}', '%{Acct-Terminate-Cause}'
>
>
>
> On Logs I got this error.
>
> Mon May  1 18:36:18 2006: DEBUG: do query is: 'exec AliveUsageDSl
> 'username at 256.zajil.net','Start', ,,'0032C580', , '05/01/2006
> 18:36:18','ula_02200700074', '', ''':
> Mon May  1 18:36:18 2006: ERR: do failed for 'exec AliveUsageDSl
> 'username at 256.zajil.net','Start', ,,'0032C580', , '05/01/2006
> 18:36:18','ula_02200700074', '', ''': [Microsoft][ODBC SQL Server
> Driver][SQL Server]Line 1: Incorrect syntax near ','. (SQL-42000)(DBD:
> Execute immediate failed err=-1)
> Mon May  1 18:36:18 2006: ERR: do failed for 'exec AliveUsageDSl
> 'username at 256.zajil.net','Start', ,,'0032C580', , '05/01/2006
> 18:36:18','ula_02200700074', '', ''': [Microsoft][ODBC SQL Server
> Driver][SQL Server]Line 1: Incorrect syntax near ','. (SQL-42000)(DBD:
> Execute immediate failed err=-1)
>
>
> So, any one can help to solve this problem.
>
> Thanks.
>
> Regards,
> Nayeem.
>
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.


NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
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, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.