RE: online users not showing in fr/mysql cli

4 Mar 2015

      I get this ...

===================
mysql> select * from radacct;
+-----------+---------------+------------------+----------+-----------+-------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+-------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+---------------------+--------+---------------------+-------+
| radacctid | 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 | _accttime           | _srvid | _dailynextsrvactive | _apid |
+-----------+---------------+------------------+----------+-----------+-------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+-------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+---------------------+--------+---------------------+-------+
|         1 | 81a00002      | c33bdf750bd6363e | zaib     |           |       | 101.11.11.255 | 6         | Ethernet    | 2015-03-04 05:20:59 | 2015-03-04 05:23:24 |             145 | RADIUS        |                   |                  |            3161 |              116 | service1        | 00:0C:29:25:75:D1 | User-Request       | Framed-User | PPP            | 172.16.0.255    |              0 |             0 |                      | 2015-03-04 05:22:59 |   NULL |                NULL |  NULL |
|         2 | 81a00003      | 02b241b2e7884a9d | zaib     |           |       | 101.11.11.255 | 7         | Ethernet    | 2015-03-04 05:23:43 | 2015-03-04 06:08:36 |            2693 | RADIUS        |                   |                  |           36425 |              116 | service1        | 00:0C:29:25:75:D1 | User-Request       | Framed-User | PPP            | 172.16.0.255    |              0 |             0 |                      | 2015-03-04 06:07:44 |   NULL |                NULL |  NULL |
|         3 | 81a00006      | 54194569577307e5 | zaib     |           |       | 101.11.11.255 | 10        | Ethernet    | 2015-03-04 05:42:39 | 2015-03-04 05:43:17 |              38 | RADIUS        |                   |                  |           35574 |             3978 | service1        | 70:54:D2:16:A5:D9 | User-Request       | Framed-User | PPP            | 172.16.0.254    |              0 |             0 |                      | 2015-03-04 05:42:39 |   NULL |                NULL |  NULL |
|         4 | 81a00007      | 104d104e961eb580 | zaib     |           |       | 101.11.11.255 | 11        | Ethernet    | 2015-03-04 06:17:59 | 2015-03-04 06:48:17 |            1818 | RADIUS        |                   |                  |           25817 |              116 | service1        | 00:0C:29:25:75:D1 | User-Request       | Framed-User | PPP            | 172.16.0.255    |              0 |             0 |                      | 2015-03-04 06:47:59 |   NULL |                NULL |  NULL |
|         5 | 81a00008      | 745eb72b15a3702d | zaib     |           |       | 101.11.11.255 | 12        | Ethernet    | 2015-03-04 06:48:22 | 2015-03-04 07:16:59 |            1717 | RADIUS        |                   |                  |           23513 |              116 | service1        | 00:0C:29:25:75:D1 | User-Request       | Framed-User | PPP            | 172.16.0.255    |              0 |             0 |                      | 2015-03-04 07:16:52 |   NULL |                NULL |  NULL |
|         6 | 81a00009      | 94038399ad1919ea | zaib     |           |       | 101.11.11.255 | 13        | Ethernet    | 2015-03-04 07:51:08 | NULL                |             870 | RADIUS        |                   |                  |           13385 |              116 | service1        | 00:0C:29:25:75:D1 |                    | Framed-User | PPP            | 172.16.0.255    |              0 |             0 |                      | 2015-03-04 08:05:38 |   NULL |                NULL |  NULL |
+-----------+---------------+------------------+----------+-----------+-------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+-------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+----------------------+---------------------+--------+---------------------+-------+
6 rows in set (0.00 sec)

======================
and I ahve attached phpmyadmin result as well too in the attachment...
 Subject: RE: online users not showing in fr/mysql cli
From: A.L.M.Buxey@lboro.ac.uk
Date: Wed, 4 Mar 2015 08:00:36 +0000
To: aacable@hotmail.com; freeradius-users@lists.freeradius.org

So that's an interim update. What about stop? If you do a simple 'select * from radacct' what are you getting? 

alan

RE: online users not showing in fr/mysql cli

JAHANZAIB SYED