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