Re: (RADIATOR) Running a SQL Query before autheticate a user on MSSQL database

Tue, 18 Jan 2000 01:23:11 -0800 


Hello Lakmin -

This is what your email looks like (see below). Please send your configuration
file as an attachment so I can read it and help you.

thanks

Hugh


On Wed, 19 Jan 2000, S.K.D. Lakmin Premnath wrote:
> <html><div>hi hugh</div>
> <br>
> <div>I'm connecting MSSQL fron BSDI box to authentication and accounting
> from SQL database. Here I need to run a stored procedure (say this
> procedure update CHECKATTR column from SUBSCRIBERS table) before it comes
> to authenticate a particular user. When I try to do as follows it will
> reject the authentication but radpwtst shows accounting is okay.</div>
> <div>pls advice me how to do this and which side do I have to run this
> unix side or NT side...</div>
> <br>
> <div>thankx</div>
> <div>lakmin</div>
> <br>
> <br>
> <br>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;AuthBy SQL&gt;</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> DBSource&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> dbi:FreeTDS:database=icarddb;host=xxx.xx.xxx.xx;port=1433</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> DBUsername&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xxxxx</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> DBAuth&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
> xxxxx</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthSelect execute
> proc_rupee %n</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthSelect select
> PASSWORD, \</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHECKATTR, REPLYATTR
> \</div>
> <div>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ('Session-Timeout = ' +
> CAST((RUPEEVALUE * 30) AS char(200))), \</div>
> <div>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REPLYATTR \ </div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from SUBSCRIBERS 
> \</div>
> 
><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> where USERNAME='%n'</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthColumnDef 0,
> User-Password, check</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthColumnDef 1, GENERIC,
> check</div>
> <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthColumnDef 2, GENERIC,
> reply&nbsp;&nbsp;&nbsp; </div>
> 
><div><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;</x-tab>-----------</div>
> 
><div><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;</x-tab>-----------</div>
> 
><div><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;</x-tab>-----------</div>
> <br>
> 
><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;</x-tab>&lt;/AuthBy&gt;
> <BR>
> 
> <div align="center">
> ================================================<br>
> S.K.D. Lakmin Premnath.<br>
> (Systems Engineer)<br>
> Lanka Internet Services Limited.<br>
> (
> <a href="http://www.lanka.net/" eudora="autourl">http://www.lanka.net</a>
> )<br>
> Network Operating Center<br>
> No, 156 1/1 Walukarama Road,<br>
> Colombo 3,<br>
> Sri Lanka.<br>
> Tel : +94 1 565071<br>
> Fax : +94 75 335637<br>
> Email : [EMAIL PROTECTED]<br>
> <br>
> =================================================<br>
> </html>
> 
> 
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
-- 
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.

Reply via email to