unixodbc: Query sending problem

Mykhaylo Tyulchenko tyulchen at ukr.net
Tue Aug 9 12:54:54 CEST 2005


Hi,
I'm having some problem with sending SQL query to MSSQL 7.0 Server through 
UnixODBC driver of FreeRadius (module rlm_sql_unixodbc)
with error: 

rlm_sql_unixodbc: ' [unixODBC][FreeTDS][SQL Server]Unclosed quotation mark 
before the character string ''.'


My SQL query is a stored procedure executed on MSSQL server  with some 
parameters:

exec sp_authenticate 'setup','123456',null,0,'255.255.255.255','L3',2

 FreeTDS and UnixODBC configured fine,
so i have normal MSSQL server execution of that query testing by
tsql and isql programms.

But when i try to use that query as  Authorization Query in mssql.conf i get 
next screen:


radius_xlat:  'exec sp_authenticate 
'setup','123456',null,0,'255.255.255.255','L3',2'
rlm_sql (sql): Reserving sql socket id: 4
query:  exec sp_authenticate 'setup','123456',null,0,'255.255.255.255','L3',2
radius_xlat:  ''
radius_xlat:  'exec sp_authenticate ''
query:  exec sp_authenticate '
rlm_sql_unixodbc: ' [unixODBC][FreeTDS][SQL Server]Unclosed quotation mark 
before the character string ''.'
rlm_sql_getvpdata: database query error
radius_xlat:  ''
rlm_sql (sql): Released sql socket id: 4
  modcall[authorize]: module "sql" returns ok for request 0
modcall: group authorize returns ok for request 0


Please help.
FreeRadius 1.0.4, UnixODBC 2.2.11, MSSQL 7.0

Regards,
Mykhaylo Tyulchenko



More information about the Freeradius-Users mailing list