Hey there, Not a cluster setup.
I updated the config files to point to 127.0.0.1 instead and am getting more errors now when I restart the pf service. For fun, I changed the certificates under /usr/local/pf/conf/ssl on the original PF server I setup and it also broke (server refusing connection when trying to access admin page). The service packetfence-api-frontend now won't start on either system now, so it seems I did something wrong. I imagine there's more to it then just replacing the certs in the ssl folder? On Wed, May 8, 2019 at 6:47 PM Durand fabrice via PacketFence-users < packetfence-users@lists.sourceforge.net> wrote: > Hello Stuart, > > is it a cluster setup ? > > Also what you can try to do is to set the server to 127.0.0.1 instead of > localhost. > > > https://github.com/inverse-inc/packetfence/blob/devel/conf/pfconfig.conf.example#L5 > > > https://github.com/inverse-inc/packetfence/blob/devel/conf/pf.conf.defaults#L263 > > Regards > > Fabrice > > > Le 19-05-08 à 16 h 00, Stuart Gendron via PacketFence-users a écrit : > > 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 > listPacketFence-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/packetfence-users > > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/packetfence-users > -- *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
