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
