Hello Lakmin -
On Sat, 29 Jan 2000, S.K.D. Lakmin Premnath wrote:
> <html><div>hi </div>
> <br>
> <div>I need help from you all to run a stored procedure on MSSQL server
> my ultimate goal is to add peak / ecnomical / offpeak rate(rates are
> defined on a table and a particular pre paid amout) for login users
> depends on username and login time. In here user's session-timeout is
> calculated on time he logged in depend on time and rate. </div>
> <br>
> <div>I have written a SQL stored procedure to do this calculation but I
> can't intigrate it into single sql statement.</div>
> <div>my sql statements are " execute proc_calsess %n " and
> " select PASSWORD,CHKATTR,REPLYATTR from SUBSCRIBERS where
> USERNAME='%n' "</div>
> <div>here proc_calsess procedure calculate the Session-Timeout amout from
> Dollar amout he has when login time.</div>
> <br>
What you want to do is have your stored procedure do your calculations first,
and then do the normal things that an AuthSelect would do (return the password
and any other check and reply attributes). Then the AuthSelect in the Radiator
configuration file would simply call the stored procedure and proceed normally
with the AuthColumnDef's.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
