Hello again Nick, ok, first, make sure your user/group rights are properly set in your mysql folder / files... it should be set to u: mysql, p: mysql , validate with your config and make sure you're using the same users/groups define in your my.cnf or in your init.d script... ( command: chown to change the ownership of a file or folder... then restart mysql and test )
also... - is there enough space on your drive ? ( dk -k ) - dmesg reports any errors ? ( check for any OOPS, WOOPS, ERRORS or any SegFault msg ) - too much IOWAIT maybe ? ( start top and validate the iowait % : should be less than 25% for accurate answers from MySQL ) If after that, you can't resolve your mysql issue, activate the General query log and check this log to see what's going wrong... ( howto: http://dev.mysql.com/doc/refman/5.0/en/query-log.html ) Good luck M-A Le 11-04-19 18:15, Ritter, Nicholas a écrit : > 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
