(RADIATOR) Re: Response from a stored procedure in MSSQL

[Hugh Irvine]

Hello Bulent -

I will need to see a copy of your configuration file and a trace 4 
debug from Radiator showing what is happening.

regards

Hugh


On 16 Apr 2004, at 23:21, Bulent Gulcan wrote:

> Hello All,
>
> We are trying to authenticate from a stored procedure in MSSql server.
> In our radius.cfg file the <AuthBy> clause is below.
>
> <AuthBy SQL>
> ....
> AuthSelect exec GetSubscriber %0
>
>         AuthColumnDef   0,User-Password,check
>         AuthColumnDef   1,ValidFrom,check
>         AuthColumnDef   2,Expiration,check
>         AuthColumnDef   3,GENERIC,check
>         AuthColumnDef   4,GENERIC,reply
>         AuthColumnDef   5,Session-Timeout,reply
> ....
> </AuthBy>
>
> At MSSql server side, the stored procedure GetSubscriber works fine 
> and we
> can get a result set.
>
> But at radiator side, we can not get a response from MsSql server for 
> the
> stored procedure :
> ----------
> radpwtst -user username -password passwd -service_type Framed 
> -iterations 1
> sending Access-Request...
> No reply
> sending Accounting-Request Start...
> OK
> sending Accounting-Request Stop...
> OK
> -----------.
>
> Do we have to add some config parameter into <AuthBy> clause to get the
> result set of stored procedure ?
>
> Could you please help us ?
>
> Thanks for your help, regards.
>
> Bulent Gulcan
> Is Net A.S.
> Turkey
>
>

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, 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.