Sorry...it appears to be a database error: tail -f packetfence.log:
Apr 19 17:12:38 pfmon(1) INFO: checking registered nodes for expiration (main::cleanup) Apr 19 17:12:38 pfmon(1) WARN: database query failed with: Can't find file: './pf/node.frm' (errno: 13). (errno: 1017), will try again (pf::db::db_query_execute) Apr 19 17:12:38 pfmon(1) WARN: database query failed with: Can't find file: './pf/node.frm' (errno: 13). (errno: 1017), will try again (pf::db::db_query_execute) Apr 19 17:12:38 pfmon(1) WARN: database query failed with: Can't find file: './pf/node.frm' (errno: 13). (errno: 1017), will try again (pf::db::db_query_execute) Apr 19 17:12:38 pfmon(1) ERROR: Database issue: We tried 3 times to serve query node_ungrace_sql called from pf::node::nodes_maintenance and we failed. Is the database running? (pf::db::db_query_execute) I changed the default path in /etc/my.cnf to point to a different location. The pf mysql user can connect to the DB when I test it manually, but I get the follow error when I do a "show tables" on the pf database: ERROR 1018 (HY000): Can't read dir of './pf/' (errno: 13) Any thoughts on how to correct this, it seems like a mysql filesystem perms error, but not sure. Nick -----Original Message----- From: Ritter, Nicholas [mailto:[email protected]] Sent: Tuesday, April 19, 2011 4:49 PM To: [email protected] Subject: Re: [Packetfence-users] PF 2.1.0 and CentOS 5.6 There were no errors in the log, so I proceeded with a fresh install of CentOS 5.6 using 5.6 spin ISOs, and PacketFence 2.1.0 install via RPM repo. The install went fine, but the first time I logged into the web-based admin UI, I get a number of errors which are listed on the first dashboard page after the login is completed: Error: Problems executing 'PFCMD fingerprint view all' /usr/local/pf/bin/pfcmd line 2073 (#1) Can't use string ("0") as a HASH ref while "strict refs" in use at /usr/local/pf/bin/pfcmd line 2073. at /usr/local/pf/bin/pfcmd line 2073 main::print_results('dhcp_fingerprint_view_all', 'all') called at /usr/local/pf/bin/pfcmd line 1391 main::fingerprint() called at /usr/local/pf/bin/pfcmd line 164 main::__ANON__() called at /usr/local/pf/bin/pfcmd line 212 Error: Problems executing 'PFCMD class view all' /usr/local/pf/bin/pfcmd line 2067 (#1) Can't use string ("0") as a HASH ref while "strict refs" in use at /usr/local/pf/bin/pfcmd line 2067. at /usr/local/pf/bin/pfcmd line 2067 main::print_results('class_view_all', 'all') called at /usr/local/pf/bin/pfcmd line 1331 main::class() called at /usr/local/pf/bin/pfcmd line 160 main::__ANON__() called at /usr/local/pf/bin/pfcmd line 212 Error: Problems executing 'PFCMD ui dashboard recent_violations' /usr/local/pf/bin/pfcmd line 2067 (#1) Can't use string ("0") as a HASH ref while "strict refs" in use at /usr/local/pf/bin/pfcmd line 2067. at /usr/local/pf/bin/pfcmd line 2067 main::print_results('nugget_recent_violations', 3) called at /usr/local/pf/bin/pfcmd line 1898 main::ui() called at /usr/local/pf/bin/pfcmd line 200 main::__ANON__() called at /usr/local/pf/bin/pfcmd line 212 function.array-shift]: The argument should be an array in /usr/local/pf/html/admin/status/dashboard.php on line 165'>Report BugWarning: array_shift() [function.array-shift]: The argument should be an array in /usr/local/pf/html/admin/status/dashboard.php on line 165 Report BugWarning: Invalid argument supplied for foreach() in /usr/local/pf/html/admin/status/dashboard.php on line 166 Error: Problems executing 'PFCMD ui dashboard recent_registrations' /usr/local/pf/bin/pfcmd line 2067 (#1) Can't use string ("0") as a HASH ref while "strict refs" in use at /usr/local/pf/bin/pfcmd line 2067. at /usr/local/pf/bin/pfcmd line 2067 main::print_results('nugget_recent_registrations', 3) called at /usr/local/pf/bin/pfcmd line 1898 main::ui() called at /usr/local/pf/bin/pfcmd line 200 main::__ANON__() called at /usr/local/pf/bin/pfcmd line 212 function.array-shift]: The argument should be an array in /usr/local/pf/html/admin/status/dashboard.php on line 165'>Report BugWarning: array_shift() [function.array-shift]: The argument should be an array in /usr/local/pf/html/admin/status/dashboard.php on line 165 Report BugWarning: Invalid argument supplied for foreach() in /usr/local/pf/html/admin/status/dashboard.php on line 166 -----Original Message----- From: Marc-André Jutras [mailto:[email protected]] Sent: Tuesday, April 19, 2011 2:06 PM To: [email protected] Cc: Ritter, Nicholas Subject: Re: [Packetfence-users] PF 2.1.0 and CentOS 5.6 Nicholas, restart PF and check in /usr/local/pf/logs/packetfence.log for any errors... if you can't find anything, just send us your log file... check also in /var/log/messages if there's any errors there too... Regards, M-A Le 11-04-19 14:38, Ritter, Nicholas a écrit : > > Have there been any reports of issues with PF 2.1.0 and CentOS 5.6? > > I ask because I applied the 5.6 CentOS updates to a CentOS 5.5 box > running PacketFence 2.1.0 and I am having various problems. Examples > of problems I am having: > > 1)I add a switch via the PF WebUI, but switches.conf does not show all > of the config directives for the given switch > > 2)Weird cases where the mac address is removed from a cisco switch > with port-security enabled, but the VLAN is not changed > > 3)VLAN assignments based on category field as defined in > /usr/local/pf/lib/pf/vlan/custom.pm are ignored > > 4)normalVLAN setting both globally and for a specific switch is ignored. > > I am going to do fresh install of CentOS 5.6 and PacketFence 2.1.0 and > see what happens. > > Nick > > > ------------------------------------------------------------------------------ > Benefiting from Server Virtualization: Beyond Initial Workload > Consolidation -- Increasing the use of server virtualization is a top > priority.Virtualization can reduce costs, simplify management, and improve > application availability and disaster protection. Learn more about boosting > the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev > > > _______________________________________________ > Packetfence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users -- Marc-Andre Jutras, Project manager - Inverse inc. [email protected] :: +1.514.447.4918 (x110) :: http://www.inverse.ca Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
