New subject: Freeradius-Users Digest, Vol 46, Issue 98 : Why is groupnamefield blank in radacct

25 Feb 2009

      Thank Kalik

I tried editing the dialup.conf and added groupname with a value of
'%{SQL-Group}' but still it writes nothing for the groupname in the radacct
table. Can you help me as to how exactly I have to edit the dialup.conf ?

I am new to freeRADIUS so please bear with with.

Thanks in anticipation.

        accounting_start_query = " \
          INSERT INTO ${acct_table1} \
            (acctsessionid,    acctuniqueid,     username,groupname, \
             realm,            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}','%{SQL-Group}' , \
             '%{Realm}', '%{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}')"

2009/2/25 <freeradius-users-request@lists.freeradius.org>
...
Send Freeradius-Users mailing list submissions to
       freeradius-users@lists.freeradius.org
To subscribe or unsubscribe via the World Wide Web, visit
       http://lists.freeradius.org/mailman/listinfo/freeradius-users
or, via email, send a message with subject or body 'help' to
       freeradius-users-request@lists.freeradius.org
You can reach the person managing the list at
       freeradius-users-owner@lists.freeradius.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Freeradius-Users digest..."
Today's Topics:
1. RE: Freeradius-Users Digest, Vol 46, Issue 96 (Shimon Weinreich)
  2. Re: Why is groupname field blank in radacct (tnt@kalik.net)
  3. RE: SMF manifest to run freeradius in solaris 10 (Thomas Noppe)
----------------------------------------------------------------------
Message: 1
Date: Wed, 25 Feb 2009 11:53:56 +0200
From: "Shimon Weinreich" <shimon@openu.ac.il>
Subject: RE: Freeradius-Users Digest, Vol 46, Issue 96
To: <freeradius-users@lists.freeradius.org>
Message-ID: <A8DAF37AB05CA74C938F57DD19095766143614@AMNON.openu.local>
Content-Type: text/plain;       charset="windows-1255"
Tnx Ivan,
I'll upgrade it.
-------
?????,
????? ????????
     ??????????? ??????
-----Original Message-----
From: freeradius-users-bounces+shimon=openu.ac.il@lists.freeradius.org[mailto:
freeradius-users-bounces+shimon <freeradius-users-bounces%2Bshimon>=
openu.ac.il@lists.freeradius.org] On Behalf Of
freeradius-users-request@lists.freeradius.org
Sent: Wednesday, February 25, 2009 11:45 AM
To: freeradius-users@lists.freeradius.org
Subject: Freeradius-Users Digest, Vol 46, Issue 96
Send Freeradius-Users mailing list submissions to
       freeradius-users@lists.freeradius.org
To subscribe or unsubscribe via the World Wide Web, visit
       http://lists.freeradius.org/mailman/listinfo/freeradius-users
or, via email, send a message with subject or body 'help' to
       freeradius-users-request@lists.freeradius.org
You can reach the person managing the list at
       freeradius-users-owner@lists.freeradius.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Freeradius-Users digest..."
Today's Topics:
1. SMF manifest to run freeradius in solaris 10 (Thomas Noppe)
  2. Re: does peap/mschap-v2 must use with ldap? (Nicolas Goutte)
  3. RE: auth: Failed to validate the user - NEED SOME HELP !
     (tnt@kalik.net)
  4. RE: SMF manifest to run freeradius in solaris 10 (Mats Blomgren B)
----------------------------------------------------------------------
Message: 1
Date: Wed, 25 Feb 2009 10:09:45 +0100
From: Thomas Noppe <thomas.noppe@uz.kuleuven.ac.be>
Subject: SMF manifest to run freeradius in solaris 10
To: freeradius <freeradius-users@lists.freeradius.org>
Message-ID:
       <
B44A93F24BD174408E495C668C3E3E763945333E06@EX2007-MBX-1.uz.kuleuven.ac.be>
Content-Type: text/plain; charset="us-ascii"
Has anyone got such a manifest for solaris 10?
Kind regards
Thomas
---------------------------------------------------------------------------------------------
Thomas Noppe
Dienst Informatiesystemen - S&O
thomas.noppe@uzleuven.be<mailto:thomas.noppe@uzleuven.be>
+32 16 34 79 87
+32 16 34 78 01
UZ Leuven | campus Gasthuisberg | Herestraat 49 | B - 3000 Leuven |
www.uzleuven.be<http://www.uzleuven.be>

Re: Freeradius-Users Digest, Vol 46, Issue 98 : Why is groupname field blank in radacct

ngwarai zed

tnt＠kalik.net

tags

participants (2)