Luois, Here's what I got:
mysql> select switch,port,read_time,mac,ifInOctets,ifOutOctets from ifoctetslog where mac='00:25:64:40:05:47' order by read_time desc; Empty set (0.00 sec) mysql> But the OWA shows me the location, IP and other attributes correctly - and the laptop is actually plugged in, so it all matches! Cheers, Boris. On Tue, May 26, 2015 at 4:23 PM, Louis Munro <[email protected]> wrote: > > > 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 > >
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
