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
