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
