Setup a new instance of PF on Centos 7. Went through initial setup no
problem. Installed certificates to use on the web interface and since then
can't access it through the admin portal.
Following is showing up in pfconfig.log:
May 8 15:24:51 youi-packetfence-p1 pfconfig: pfconfig(5353) ERROR:
[mac:[undef]] Couldn't connect to MySQL database to access L2. This is a
major problem ! Check the MySQL section in /usr/local/pf/conf/pfconfig.conf
and make sure your database schema is up to date !
(pfconfig::backend::mysql::_db_error)
May 8 15:24:51 youi-packetfence-p1 pfconfig: Could not write namespace
interfaces::dhcplistener_ints(youi-packetfence-p1.corp.youi.tv) to L2 cache
!
May 8 15:24:51 youi-packetfence-p1 pfconfig: pfconfig(5353) ERROR:
[mac:[undef]] Could not write namespace interfaces::listen_ints(
youi-packetfence-p1.corp.youi.tv) to L2 cache !
(pfconfig::manager::cache_resource)
May 8 15:24:51 youi-packetfence-p1 pfconfig: pfconfig(5353) ERROR:
[mac:[undef]] Caught error DBI
connect('database=pf;host=localhost;port=3306','admin',...) failed: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2
"No such file or directory") at /usr/local/pf/lib/pfconfig/backend/mysql.pm
line 47.
while connecting to database. (pfconfig::backend::mysql::_get_db)
I've confirmed the MariaDB service is running
DNS is good, I can ping out by Hostname
Ran netstat, confirmed mysql is listening on 3306
Looked through pf.conf and pfconfig.conf and all the database information
is correct
Rebooted multiple times
Ran mysql command and logged in as admin, using same credentials as what I
have in the config files. Was able to access the pf database.
Not sure if it's worth still investigating, or I should wipe and start
fresh (really haven't setup a whole lot).
Any help is greatly appreciated!
Thanks
--
*Stuart Gendron*
IT Support Specialist
*You.i Labs*
307 Legget Drive, Kanata, ON, K2K 3C8
<https://maps.google.com/?q=307+Legget+Drive,+Kanata,+ON,%C2%A0K2K+3C8&entry=gmail&source=g>
t (613) 228-9107 x258 | c (613) 697-6853
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
