Hello
is there a way to ignore an attribute value when I make an authorization request to MsSQL database? that value is not important I think and it creates an error:
 
 
ERROR:
radius_xlat:  '122@domain.com'
rlm_sql (sql): sql_set_user escaped user --> '122@domain.com'
radius_xlat:  'VoIP_Radius '122@domain.com''
rlm_sql (sql): Reserving sql socket id: 16
radius_xlat:  ''
radius_xlat:  'VoIP_Radius '122@domain.com','',                                   '','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:  ''
 
 
MsSQL authorization queries:
 
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 tried to remove value VoIP from authorization query but the problem doesn't expire.
 
 
Giuseppe
 
Thank you