I got the this error:
 
radius_xlat:  '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]'
radius_xlat:  'VoIP_Radius '[EMAIL PROTECTED]''
rlm_sql (sql): Reserving sql socket id: 16
radius_xlat:  ''
radius_xlat:  'VoIP_Radius '[EMAIL PROTECTED]','',                                   '','192.168.1.1','''
rlm_sql: Failed to create the pair: Unknown value VOIP for attribute Service-Type
rlm_sql (sql): Error getting data from database
radius_xlat:  ''
in mssql.conf file i have
 
authorize_check_query = "VoIP_Radius '%{User-Name}'"
authorize_reply_query = "VoIP_Radius '%{User-Name}','%{Calling-Station-Id}',   \
                                '%{Called-Station-Id}','%{NAS-IP-Address}','%{h323-conf-id}','VOIP'"
 
 
I don't know sql server really much and I'm starting learning freeradius, so can some one explain me how "authorize_check_query" and "authorize_reply_query" dialogue with ms sql server?  
 
then, "Failed to create the pair" means there was a problem to get data from database I think but more exactely what does the error say ?
 
 
Thanks
Giuseppe
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to