Re: Unknown value error

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-9IKiO1iGCm/QT0dZR+AlfA@xxxxxxxxxxxxxxxx'
> rlm_sql (sql): sql_set_user escaped user --> 
> '122-9IKiO1iGCm/QT0dZR+AlfA@xxxxxxxxxxxxxxxx'
> radius_xlat:  'VoIP_Radius '122-9IKiO1iGCm/QT0dZR+AlfA@xxxxxxxxxxxxxxxx''
> rlm_sql (sql): Reserving sql socket id: 16
> radius_xlat:  ''
> radius_xlat:  'VoIP_Radius 
> '122-9IKiO1iGCm/QT0dZR+AlfA@xxxxxxxxxxxxxxxx','',                                   
> '','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-WLQjAxnOB31AfugRpC6u6w@xxxxxxxxxxxxxxxx
> http://openser.org/cgi-bin/mailman/listinfo/users
>