Scratch that - got the certs working, had to play around with the config a bit.
Still getting the SQL error even after changing to 127.0.0.1. At this point I'll feel more comfortable starting fresh. On Thu, May 9, 2019 at 10:00 AM Stuart Gendron <stuart.gend...@youi.tv> wrote: > 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 > -- *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
