Hi Louis,
One more thing I noticed is the following...
The accounting.pm file is using these two queries:
$accounting_statements->{'acct_view_sql'} = get_db_handle()->prepare(qq[
SELECT
CONCAT(SUBSTRING(callingstationid,1,2),':',SUBSTRING(callingstationid,3,2),':',SUBSTRING(callingstationid,5,2),':',
SUBSTRING(callingstationid,7,2),':',SUBSTRING(callingstationid,9,2),':',SUBSTRING(callingstationid,11,2))
AS mac,
but in my DB the calling-station-id already has the colons in it, so the
substrings will start getting parts of the address with colons in it.
not sure if this is something that got messed up in the radius conf (where
it was expected to homogenize the formatting, or was it expecting a
different reporting format from the NAS or something else, but in my case,
the "mac" field as calculated will not match...
thanks!
On Wed, Jul 19, 2017 at 8:04 PM, Diego Garcia del Rio <garc...@gmail.com>
wrote:
> Hi Louis,
>
> Yes, the radacct table also has data.
>
> I just noticed though that on my httpd.admin.error log file the following
> is being logged each time I try to access the graph.
>
> Jul 19 23:00:38 PacketFence-ZEN httpd_admin_err: [Wed Jul 19 23:00:38
> 2017] -e: Argument "" isn't numeric in numeric gt (>) at /usr/local/pf/html/
> pfappserver/root/graph/pie.tt line 59.
>
> also, when using ./pfcmd ifoctetshistorymac I don't get any data either.
>
> See here for some data from the radacct table:
>
> MariaDB [pf]> select * from radacct
> -> ;
> +-----------+-------------------+---------------------------
> -------+-------------------+-----------+-------+------------
> --+-----------+-----------------+---------------------+-----
> ----------------+---------------------+--------------+------
> -----------+---------------+----------------------+---------
> -------------+-----------------+------------------+---------
> --------------------+-------------------+-------------------
> -+-------------+----------------+-----------------+
> | radacctid | acctsessionid | acctuniqueid |
> username | groupname | realm | nasipaddress | nasportid |
> nasporttype | acctstarttime | acctupdatetime | acctstoptime
> | acctinterval | acctsessiontime | acctauthentic | connectinfo_start
> | connectinfo_stop | acctinputoctets | acctoutputoctets |
> calledstationid | callingstationid | acctterminatecause |
> servicetype | framedprotocol | framedipaddress |
> +-----------+-------------------+---------------------------
> -------+-------------------+-----------+-------+------------
> --+-----------+-----------------+---------------------+-----
> ----------------+---------------------+--------------+------
> -----------+---------------+----------------------+---------
> -------------+-----------------+------------------+---------
> --------------------+-------------------+-------------------
> -+-------------+----------------+-----------------+
> | 1 | 59BBE3C4-00000007 | 4a0c8abc1db9b2e180f7501f313b9ded |
> ac:37:43:a4:41:46 | | null | 10.0.10.10 | 3 |
> Wireless-802.11 | 2017-07-19 20:13:35 | 2017-07-19 20:13:35 | 2017-07-19
> 20:14:06 | NULL | 32 | RADIUS | CONNECT
> 802.11a/n/ac | CONNECT 802.11a/n/ac | 489362 | 33813114 |
> f8:e7:1e:af:12:2c:principal | ac:37:43:a4:41:46 | Idle-Timeout |
> | | 10.100.0.11 |
> | 2 | 59BBE3C4-00000008 | 4a0c8abc1db9b2e180f7501f313b9ded |
> ac:37:43:a4:41:46 | | null | 10.0.10.10 | 3 |
> Wireless-802.11 | 2017-07-19 20:14:19 | 2017-07-19 20:14:19 | 2017-07-19
> 20:17:49 | NULL | 209 | RADIUS | CONNECT
> 802.11a/n/ac | CONNECT 802.11a/n/ac | 353797 | 263304 |
> 58:b6:33:bf:4b:cc:principal | ac:37:43:a4:41:46 | Idle-Timeout |
> | | 10.100.0.11 |
> | 3 | 59BBE3C4-0000000A | 4a0c8abc1db9b2e180f7501f313b9ded |
> ac:37:43:a4:41:46 | | null | 10.0.10.10 | 4 |
> Wireless-802.11 | 2017-07-19 20:34:44 | 2017-07-19 20:34:44 | 2017-07-19
> 20:35:49 | NULL | 66 | RADIUS | CONNECT
> 802.11a/n/ac | CONNECT 802.11a/n/ac | 423669 | 30089496 |
> 58:b6:33:bf:4b:cc:principal | ac:37:43:a4:41:46 | User-Request |
> | | 10.100.0.11 |
> | 4 | 59BBE3C4-0000000C | 4a0c8abc1db9b2e180f7501f313b9ded |
> ac:37:43:a4:41:46 | | null | 10.0.10.10 | 1 |
> Wireless-802.11 | 2017-07-19 20:58:11 | 2017-07-19 20:58:11 | 2017-07-19
> 20:58:19 | NULL | 8 | RADIUS | CONNECT
> 802.11g/n | CONNECT 802.11g/n | 49939 | 63202 |
> 58:b6:33:bf:4b:c8:principal | ac:37:43:a4:41:46 | Idle-Timeout |
> | | 10.100.0.11 |
>
>
>
> Thanks !!!
>
>
>
>
> On Wed, Jul 19, 2017 at 7:29 PM, Louis Munro <lmu...@inverse.ca> wrote:
>
>> Hi Diego,
>> Can you see if you have data in the radacct table?
>>
>> Regards,
>> --
>> Louis Munro
>> lmu...@inverse.ca :: www.inverse.ca
>> +1.514.447.4918 x125 :: +1 (866) 353-6153 x125
>> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
>> www.packetfence.org)
>>
>> On Jul 19, 2017, at 18:25, Diego Garcia del Rio via PacketFence-users <
>> packetfence-users@lists.sourceforge.net> wrote:
>>
>> Dear users,
>>
>> I have a setup where users are being authenticated using mac-based auth
>> with radius. This is a system with Ruckus' ZD1200 and a few APs. Radius
>> auth works well and I have configured radius accounting as well. In fact, I
>> see the radius accounting packets being sent to PF -both interim acct
>> records as well as upon connect/disconnect-.
>>
>> I even see the records being entered into the radacct and radacct_log
>> tables. The radacct_log shows a few entries such as the following:
>>
>>
>> | 13 | 59BBE3C4-00000011 | ac:37:43:a4:xx:xx | 10.0.10.10 | Start
>> | 2017-07-19 21:24:07 | 0 | 0 |
>> 0 | 4a0c8abc1db9b2e180f7501f313b9ded |
>> | 14 | 59BBE3C4-00000011 | ac:37:43:a4:xx:xx | 10.0.10.10 |
>> Interim-Update | 2017-07-19 21:29:07 | 77539 | 106422 |
>> 300 | 4a0c8abc1db9b2e180f7501f313b9ded |
>> | 15 | 59BBE3C4-00000012 | ac:37:43:a4:xx:xx | 10.0.10.10 | Start
>> | 2017-07-19 21:29:59 | 0 | 0 |
>> 0 | 4a0c8abc1db9b2e180f7501f313b9ded |
>> | 16 | 59BBE3C4-00000011 | ac:37:43:a4:xx:xx | 10.0.10.10 | Stop
>> | 2017-07-19 21:29:59 | 112233 | 157549 |
>> 352 | 4a0c8abc1db9b2e180f7501f313b9ded |
>> | 17 | 59BBE3C4-00000012 | ac:37:43:a4:xx:xx | 10.0.10.10 |
>> Interim-Update | 2017-07-19 21:34:59 | 125499 | 181451 |
>> 300 | 4a0c8abc1db9b2e180f7501f313b9ded |
>> | 18 | 59BBE3C4-00000012 | ac:37:43:a4:xx:xx | 10.0.10.10 | Stop
>> | 2017-07-19 21:38:55 | 0 | 0 |
>> 236 | 4a0c8abc1db9b2e180f7501f313b9ded |
>>
>> the MAC is matching the device as shown in the node table:
>>
>> MariaDB [pf]> select mac, pid, computername from node where
>> mac="ac:37:43:a4:41:46" ;
>> +-------------------+-------+--------------------------+
>> | mac | pid | computername |
>> +-------------------+-------+--------------------------+
>> | ac:37:43:a4:xx:xx | diego | android-98d54ed505c746a1 |
>> +-------------------+-------+--------------------------+
>>
>>
>> anyone has any clue on why I might not be able to see the accounting info
>> being processed? In the GUI, when selecting "Top 25 Bandwidth Consumers" I
>> see the following:
>>
>> What's going on?There's not enough data to generate this graph. Is
>> PacketFence in production
>>
>> But im pretty sure im in production mode...
>>
>> thanks!
>>
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot______
>> _________________________________________
>> PacketFence-users mailing list
>> PacketFence-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>
>>
>>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
