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

Thu, 20 Jan 2000 04:50:19 -0800 

hi hugh

I am connecting to MSSQL from BSDI unix box. 
So before running the select SQL query I need to execute a stored procedure.
exec proc_calsess %n
select USERNAME, REPLYATTR from SUBSCRIBERS where USERNAME = %n' 
When I run these two sql query from my cfg file  it gave an error " Error
processing tds packet.  Coulnd't get column information" . So please help
me to intigrate these two sql statements into one single AuthSelect
statement. These two query works fine in NT SQL Server Query Analyzer 

I have attached all logfile.

thanks 
lakmin

hi hugh

I am connecting to MSSQL from BSDI unix box. 
So before running the select SQL query I need to execute a stored procedure.
exec proc_calsess %n
select USERNAME, REPLYATTR from SUBSCRIBERS where USERNAME = %n' 
When I run these two sql query from my cfg file  it gave an error " Error processing 
tds packet.  Coulnd't get column information" . So please help me to intigrate these 
two sql statements into one single AuthSelect statement. These two query works fine in 
NT SQL Server Query Analyzer 

thanks 
lakmin


Abstract from radpwtst

radpwtst -user noc@chksql -password noc
sending Access-Request...
Rejected
sending Accounting-Request Start...
OK
sending Accounting-Request Stop...
OK


Abstract from .cfg file

<Handler Realm=chksql>
        RewriteUsername s/^([^@]+).*/$1/
        AuthByPolicy ContinueWhileAccept

        <AuthBy SQL>
        DefaultReply Service-Type = Framed,\
        Framed-Protocol = PPP,\
        Framed-IP-Address = 255.255.255.254,\
        Framed-IP-Netmask = 255.255.255.255,\
        Framed-Routing = None,\
        Framed-MTU = 1500,\
        Framed-Compression = Van-Jacobson-TCP-IP

        # Adjust DBSource, DBUsername, DBAuth to suit your DB
        DBSource        dbi:FreeTDS:database=icarddb;host=xxx.xx.xxx.xx;port=1433
        DBUsername      xxxx
        DBAuth          xxxx

        AuthSelect execute proc_calsess %n \
                select PASSWORD, \
                CHECKATTR, REPLYATTR \
                from SUBSCRIBERS \
                        where USERNAME = '%n'

        AuthColumnDef 0, User-Password, check
        AuthColumnDef 1, GENERIC, check
        AuthColumnDef 2, GENERIC, reply

        # You may want to tailor these for your ACCOUNTING table
        AccountingTable ACCOUNTING
        AcctColumnDef   USERNAME,User-Name
        AcctColumnDef   TIME_STAMP,Timestamp,integer
        AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type      
        AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
        AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
        AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
        AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
        AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
        AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
        AcctColumnDef   NASIDENTIFIER,NAS-Identifier
        AcctColumnDef   NASPORT,NAS-Port,integer
        AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
   </AuthBy>
        AcctLogFileName %L/menik/detail-%m-%Y-proxy-chksql
</Handler>
                                                   



Abstract from mylog file

Thu Jan 20 17:45:50 2000: DEBUG: Handling with Radius::AuthSQL
Thu Jan 20 17:45:50 2000: DEBUG: Handling with Radius::AuthSQL
Thu Jan 20 17:45:50 2000: DEBUG: Query is: execute proc_calsess lakminsk select
PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME = 'lakminsk'

Thu Jan 20 17:45:50 2000: DEBUG: Radius::AuthSQL looks for match with lakminsk
Thu Jan 20 17:45:50 2000: DEBUG: Query is: execute proc_calsess DEFAULT select P
ASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME = 'DEFAULT'

Thu Jan 20 17:45:50 2000: ERR: Execute failed for 'execute proc_calsess DEFAULT
select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME = 'DEFAULT
'': Error processing tds packet.  Coulnd't get column information
Thu Jan 20 17:45:50 2000: ERR: Execute failed for 'execute proc_calsess DEFAULT
select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME = 'DEFAULT
'': Error processing tds packet.  Coulnd't get column information
Thu Jan 20 17:45:50 2000: INFO: Access rejected for lakminsk: No such user
Thu Jan 20 17:45:50 2000: DEBUG: Check if Handler Realm=lan should be used to ha
ndle this request
Thu Jan 20 17:45:50 2000: DEBUG: Check if Handler Realm=chksql should be used to
 handle this request
Thu Jan 20 17:45:50 2000: DEBUG: Handling request with Handler 'Realm=chksql'
Thu Jan 20 17:45:50 2000: DEBUG: Rewrote user name to lakminsk
Thu Jan 20 17:45:50 2000: DEBUG:  Adding session for lakminsk@chksql, 203.63.154
.1, 1234
Thu Jan 20 17:45:50 2000: DEBUG: do query is: delete from RADONLINE where NASIDE
NTIFIER='203.63.154.1' and NASPORT=1234

Thu Jan 20 17:45:50 2000: DEBUG: do query is: insert into RADONLINE (USERNAME, N
ASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE,
SERVICETYPE) values ('lakminsk@chksql', '203.63.154.1', 1234, '00001234', 948368
750, '', 'Async', 'Framed-User')

Thu Jan 20 17:45:50 2000: DEBUG: Handling with Radius::AuthSQL
Thu Jan 20 17:45:50 2000: DEBUG: Handling accounting with Radius::AuthSQL
Thu Jan 20 17:45:50 2000: DEBUG: do query is: insert into ACCOUNTING
                (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTSESSIONID, NASPORT)
                values
                ('lakminsk', 948368750, 'Start', '00001234', 1234)             
Thu Jan 20 17:45:50 2000: DEBUG: Accounting accepted
Thu Jan 20 17:45:50 2000: DEBUG: Check if Handler Realm=lan should be used to ha
ndle this request
Thu Jan 20 17:45:50 2000: DEBUG: Check if Handler Realm=chksql should be used to
 handle this request
Thu Jan 20 17:45:50 2000: DEBUG: Handling request with Handler 'Realm=chksql'
Thu Jan 20 17:45:50 2000: DEBUG: Rewrote user name to lakminsk
Thu Jan 20 17:45:50 2000: DEBUG:  Deleting session for lakminsk@chksql, 203.63.1
54.1, 1234
Thu Jan 20 17:45:50 2000: DEBUG: do query is: delete from RADONLINE where NASIDE
NTIFIER='203.63.154.1' and NASPORT=1234

Thu Jan 20 17:45:50 2000: DEBUG: Handling with Radius::AuthSQL
Thu Jan 20 17:45:50 2000: DEBUG: Handling accounting with Radius::AuthSQL
Thu Jan 20 17:45:50 2000: DEBUG: do query is: insert into ACCOUNTING
                (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTO
CTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, NASPORT)
                values
                ('lakminsk', 948368750, 'Stop', 0, 20000, 30000, '00001234', 100
0, 1234)

Thu Jan 20 17:45:50 2000: DEBUG: Accounting accepted

================================================
S.K.D. Lakmin Premnath.
(Systems Engineer)
Lanka Internet Services Limited.
( http://www.lanka.net )
Network Operating Center
No, 156 1/1 Walukarama Road,
Colombo 3,
Sri Lanka.
Tel : +94 1 565071
Fax : +94 75 335637
Email : [EMAIL PROTECTED]

=================================================

Reply via email to