Woops, I did miss that subtle "X-" in the dictionary.... Fixed that.
Now to the variable...
If I use the %{Ascend-Disconnect-Cause:-X-Ascend-Disconnect-Cause}
method to insert the variable, it inserts "X-Ascend-Disconnect-Cause" as a
string into the table, not the actual contents of the variable, but if I
change it to %{X-Ascend-Disconnect-Cause} it inserts properly.
My only question here is, if there is a mixture of NASes (ie portmasters and
ciscos), the above statement would loose the good "AcctTerminateCause"
variables. Is that correct???
Thanks for the simple assistance
John Hengstler
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Chris
Parker
Sent: Monday, December 30, 2002 9:21 AM
To: [EMAIL PROTECTED]
Subject: RE: X-Ascend Atributes?
At 09:10 AM 12/30/2002 -0800, John A. Hengstler wrote:
>I can live with that for the connect start/stop information, but what about
>the acctterminatecause line.
>
>Isn't radius supposed to translate the codes from the dictionary files to
>the actual string?
>
>Example,
>X-Ascend-Disconnect-Cause = 45
> should be translated to :
>VALUE Ascend-Disconnect-Cause PPP-Rcv-Terminate-Req 45
No. Note the suble difference in the entries. One is Ascend-*, the other
is X-Ascend-*.
If you want it to "translate" the numerical value into a string, you'll
need to duplicate the 'Ascend-*' 'VALUE' entries for 'X-Ascend-*'.
>So what variable would I change in sql.conf to have this inserted to
>acctterminatecause?
The current query looks something like:
AcctStopQuery = "Insert into foo ( bar, baz )
values ( %{User-Name}, %{Ascend-Disconnect-Cause} )"
If you want to have it log other values you may need to add them like this:
AcctStopQuery = "Insert into foo ( bar, baz )
values ( %{User-Name},
%{Ascend-Disconnect-Cause:-X-Ascend-Disconnect-Cause} )"
to get it to use 'Ascend-Disconnect-Cause' value to insert, or if it doesn't
exist, to try to use the 'X-Ascend-Disconnect-Cause' value to insert.
-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
