nas id in radacct table

[Ryan De Kock]

The attribute is not NAS-Id its NAS-Identifier so try

            ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \
             '%{SQL-User-Name}', \
             '%{Realm}', *%{NAS-Identifier}*, '%{NAS-IP-Address}',
'%{NAS-Port}', \
             '%{NAS-Port-Type}', '%S', NULL, \
             '0', '%{Acct-Authentic}', '%{Connect-Info}', \
             '', '0', '0', \
             '%{Called-Station-Id}', '%{Calling-Station-Id}', '', \
             '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', \
             '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')
"



On 12 April 2014 05:20, Benoit <goony at hotmail.fr> wrote:

> Sorry I have to come back with my problem. I tried to figure out some way
> to get what I want but with no success. What I want is basically to add the
> row_id of the nas in the radacct table. So OK I added the field nasid in
> the radacct table (radacct.nasid = nas.id).
>
> In the dialup.conf file, I see the queries that insert lines in the
> radacct table. So I could add
>
> INSERT INTO ${acct_table1} \
>             (acctsessionid,    acctuniqueid,     username, \
>              realm,           * nasid*,         nasipaddress,
> nasportid, \
>              nasporttype,      acctstarttime,    acctstoptime, \
>              acctsessiontime,  acctauthentic,    connectinfo_start, \
>              connectinfo_stop, acctinputoctets,  acctoutputoctets, \
>              calledstationid,  callingstationid, acctterminatecause, \
>              servicetype,      framedprotocol,   framedipaddress, \
>              acctstartdelay,   acctstopdelay,    xascendsessionsvrkey) \
> VALUES \
>             ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \
>              '%{SQL-User-Name}', \
>              '%{Realm}', *%{NAS-Id}*, '%{NAS-IP-Address}', '%{NAS-Port}',
> \
>              '%{NAS-Port-Type}', '%S', NULL, \
>              '0', '%{Acct-Authentic}', '%{Connect-Info}', \
>              '', '0', '0', \
>              '%{Called-Station-Id}', '%{Calling-Station-Id}', '', \
>              '%{Service-Type}', '%{Framed-Protocol}',
> '%{Framed-IP-Address}', \
>              '%{%{Acct-Delay-Time}:-0}', '0',
> '%{X-Ascend-Session-Svr-Key}')"
>
>
> But of course the %{NAS-Id}  variable does not exist. Is there any
> variable where this information is stored? Seems like all the NAS-related
> vars are coming from the client and not from a local query on the database.
>
> I have little understanding yet about the freeradius system but hope to
> get it. This file for me is just a list of SQL queries, but I don't even
> get how and where they are ever executed... Each query name is used in this
> file only, which makes me clueless on how to retrieve anything from those.
>
> Any help would be very appreciated.
>
> Benoit.
>
>
>
> Subject: Re: nas id in radacct table
> From: a.cudbardb at freeradius.org
> Date: Wed, 9 Apr 2014 07:42:51 +0100
> To: freeradius-users at lists.freeradius.org
>
>
>
> > Am I missing a reference that can identify the NAS used for a connection, and other than the nas IP?
>
> rfc2865 speaketh of a legendary second identifier. The NAS-Identifier, which may be used to identify
> a NAS, even when it hopeth between ipeth.
>
> > Do you guys know a workaround for me? Even modifying the code a little bit so that I can save the NAS (database) id in the radacct table would not bother me but I would appreciate some help to locate this part of the code if it comes to this.
>
> The queries are editable... look in the appropriate dialup.conf or queries.conf (v3.0.x) for your SQL dialect.
>
> Arran Cudbard-Bell <a.cudbardb at freeradius.org>
> FreeRADIUS Development Team
>
> FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
>
>
> - List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140412/bedbb845/attachment-0001.html>