Hello Lakmin -
Thanks for sending the file - much better!
On Wed, 19 Jan 2000, S.K.D. Lakmin Premnath wrote:
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. pls advice me how to do this and which
side do I have to run this unix side or NT side...
thankx
lakmin
<AuthBy SQL>
������� DBSource������� dbi:FreeTDS:database=icarddb;host=xxx.xx.xxx.xx;port=1433
������� DBUsername����� xxxxx
������� DBAuth��������� xxxxx
������� AuthSelect execute proc_rupee %n
������� AuthSelect select PASSWORD, \
������� CHECKATTR, REPLYATTR \
#������ ('Session-Timeout = ' + CAST((RUPEEVALUE * 30) AS char(200))), \
#������ REPLYATTR \
������� from SUBSCRIBERS \
��������������� where USERNAME='%n'
������� AuthColumnDef 0, User-Password, check
������� AuthColumnDef 1, GENERIC, check
������� AuthColumnDef 2, GENERIC, reply���
-----------
-----------
-----------
</AuthBy>
You can only define one AuthSelect in your configuration file. In your case
above, the second AuthSelect will replace the first one when the configuration
file is parsed. You will need to create a single AuthSelect that will first run
the stored procedure then do whatever else you require.
This question was discussed on the list some months ago (for Oracle I believe)
and you might have a look at the archive:
http://www.thesite.com.au/~radiator/
I seem to remember that the syntax was not completely obvious, but it worked
fine.
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.
