Oh and in addition to that email :)
I have tried using tcpdump and capturing the accounting packets. and
they do contain the Tunnel-Connection attribute, I checked with Ethereal
to see what extra goodies there were availible
Graeme
On Tue, 2004-07-20 at 17:20, Graeme Hinchliffe wrote:
> Hiya
> I am trying to account additional attributes on our accounting server.
> It is happily accounting radacct at the moment, but I would like to log
> some of the other atributes.
>
> At this moment I am just trying at add one "Acct-Tunnel-Connection". I
> have added an extra field into the radacct table, and modified the
> accounting start query to use this extra field and referenced the
> attribute with '%{Acct-Tunnel-Connection}' at the right place in the
> insert statement.
>
> Accounting has continued as normal, but this extra field has not been
> written to the db. I am using postgresql for the accounting, and simply
> altered the radacct table with
>
> alter table radacct add column tunnelname varchar(255);
>
> any suggestions or ideas as to what I have missed?
>
> Thanks
--
-----
Graeme Hinchliffe (BSc)
Core Internet Systems Designer
Zen Internet (http://www.zen.co.uk/)
ICQ 3842605 (link)
Direct: 0845 058 9074
Main : 0845 058 9000
Fax : 0845 058 9005
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
