Hi Giuseppe,

Please refer to the radius tutorial (http://openser.org/docs/openser-radius-1.0.x.html) and be sure that the radius dictionary on server contains all needed entries (attrs and vals).

regards, bogdan

Giuseppe Parlato wrote:

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

---

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users