On May 26, 2015, at 15:39 , Boris Epstein <[email protected]> wrote:
> Hi Louis,
>
> Thanks for responding.
>
> There is no error message - it looks like it simply is not connecting.
> Example:
>
> -sh-4.1$ pfcmd ifoctetshistorymac 00:25:64:40:05:47
> switch|port|read_time|mac|ifInOctets|ifOutOctets|throughPutIn|throughPutOut
> -sh-4.1$
>
> Device with this MAC is certainly plugged in and adequately reflected by the
> OWA.
>
> That was why I decided that it was simply a connection failure of some sort -
> but, naturally, I could be wrong regarding that.
If there was an error connecting to the database, you should see something like
the following:
# pfcmd ifoctetshistorymac help
unable to connect to database: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/pf/lib/pf/ifoctetslog.pm
line 60
So the question really is whether there is anything to find for that MAC in the
accouting tables.
Run this query in mysql and see if it returns anything:
mysql> select switch,port,read_time,mac,ifInOctets,ifOutOctets from ifoctetslog
where mac='00:25:64:40:05:47' order by read_time desc;
Regards,
--
Louis Munro
[email protected] :: 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)
------------------------------------------------------------------------------
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
