Hi Louis,
Thanks again for your help.
The system may have updated PF as I run regular yum updates - I think it
actually has.
Here is the MySQL output:
mysql> show create table locationlog;
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create
Table
|
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| locationlog | CREATE TABLE `locationlog` (
`mac` varchar(17) DEFAULT NULL,
`switch` varchar(17) NOT NULL DEFAULT '',
`port` varchar(8) NOT NULL DEFAULT '',
`vlan` varchar(50) DEFAULT NULL,
`connection_type` varchar(50) NOT NULL DEFAULT '',
`dot1x_username` varchar(255) NOT NULL DEFAULT '',
`ssid` varchar(32) NOT NULL DEFAULT '',
`start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`end_time` datetime DEFAULT NULL,
`switch_ip` varchar(17) DEFAULT NULL,
`switch_mac` varchar(17) DEFAULT NULL,
KEY `locationlog_view_mac` (`mac`,`end_time`),
KEY `locationlog_view_switchport` (`switch`,`port`,`end_time`,`vlan`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.04 sec)
mysql>
Boris.
On Wed, Feb 18, 2015 at 4:58 PM, Louis Munro <[email protected]> wrote:
>
>
> On Feb 18, 2015, at 16:53 , Boris Epstein <[email protected]> wrote:
>
> > Just did it a couple of times on a couple of different nodes. Got the
> following:
> >
> > Feb 18 16:52:43 httpd.admin(23909) WARN: database query failed with:
> Unknown column 'locationlog.stripped_user_name' in 'field list' (errno:
> 1054), will try again (pf::db::db_query_execute)
> > Feb 18 16:52:43 httpd.admin(23909) WARN: database query failed with:
> Unknown column 'locationlog.stripped_user_name' in 'field list' (errno:
> 1054), will try again (pf::db::db_query_execute)
> > Feb 18 16:52:43 httpd.admin(23909) WARN: database query failed with:
> Unknown column 'locationlog.stripped_user_name' in 'field list' (errno:
> 1054), will try again (pf::db::db_query_execute)
> > Feb 18 16:52:43 httpd.admin(23909) ERROR: Database issue: We tried 3
> times to serve query node_last_locationlog_sql called from
> pf::node::node_view and we failed. Is the database running?
> (pf::db::db_query_execute)
> > Feb 18 16:52:43 httpd.admin(23909) INFO: loading Net::MAC::Vendor cache
> from /usr/local/pf/conf/oui.txt (pf::util::load_oui)
> > Feb 18 16:52:44 httpd.admin(23909) ERROR: Can't use string ("0") as a
> HASH ref while "strict refs" in use at
> /usr/local/pf/html/pfappserver/lib/pfappserver/Model/Node.pm line 144.
> > (pfappserver::Model::Node::view)
> > Feb 18 16:52:46 httpd.admin(23909) WARN: Node was not found.
> (pfappserver::Model::Node::exists)
> > [root@pf1 logs]#
> >
>
>
>
> Hi Boris,
> Is this system a fresh install or an upgrade from a previous release?
>
> Also, could you connect to the mysql database and run this query please?
>
> mysql> show create table locationlog;
>
> 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)
>
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
