Re: Storing in SQL, Procedure call

Troy Settle <troy@psknet.com> · Wed, 07 Jun 2006 09:02:46 -0400

Jackie Lau wrote:

I tried both suggestions and still no luck.  Any other suggestion on how
to get a Stored Procedure to work with FreeRadius, unixODBC/FreeTDS and
Microsoft SQL Server 2000?  For some reason when trying to call a Stored
Procedure rlm_sql module is trying to perform a query rather then the

procedure call.  Thanks! 

What are you needing to do with the stored procedure that you can't do 

with an insert or update?  If you need to perform tasks on the data, 

look at putting a trigger on the table.  You can also work with the raw 

data by creating views that would allow you to bring in other information.

FWIW, I'm just doing straight inserts/updates keyed on Acct-Unique-Id, 

which is used as a unique index on the radacct table.  I then have 

several views that use radacct, including radwho (list of active logins) 

and radiusdat (which transforms the data for use by my billing system).

--
  Troy Settle
  Pulaski Networks
  http://www.psknet.com
  866.477.5638