empty vsa attributes in sql

Martin Ovenstone ovenstone at bluewin.ch
Thu Aug 3 23:01:51 CEST 2006


Hi Alan

Thanks very much, it is working fine now.

Martin
> Martin Ovenstone <ovenstone at bluewin.ch> wrote:
>   
>> Can someone help me to get the erx vsa attributtes into the mysql.
>> As I can see they are processed correctly, but the sql statement is 
>> empty for this part.
>>     
>
>   The SQL statement you posted doesn't reference ERX anywhere in it.
> Therefore, they won't go into the DB.
>
>   
>>         ERX-Pppoe-Description = "pppoe 00:12:59:12:90:4e"
>>         ERX-Ingress-Policy-Name = "L2TP50"
>>     
> ...
>   
>> '%{request:Acct-Output-Gigapackets}', '%{request:Pppoe-Description}', 
>> '%{request:Ingress-Policy-Name}')"
>>     
>
>   You don't need the "request:" there.  And you *do* want to use the
> same names here as shown in debug mode, for the packet contents.
>
>   i.e. There is no "Ingress-Policy-Name" in the request.  There IS
> "ERX-Ingress-Policy-Name", but you're not referring to it.
>
>   Alan DeKok.
> --
>   http://deployingradius.com       - The web site of the book
>   http://deployingradius.com/blog/ - The blog
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>   




More information about the Freeradius-Users mailing list