Domingos:
Take a look at the contents of this file:
/usr/local/pf/logs/packetfence.log
I have a sneaking suspicion your database is not running. PF is HIGHLY
dependent on the database, without it PF doesn't really function.
Make sure the database is running and send us the last 100 lines or so of that
log file.
Jake Sallee
Godfather of Bandwidth
System Engineer and Security Specialist
University of Mary Hardin-Baylor
WWW.UMHB.EDU
900 College St.
Belton, Texas
76513
Fone: 254-295-4658
Phax: 254-295-4221
________________________________________
From: Domingos Varela <sousa.var...@gmail.com>
Sent: Friday, February 14, 2020 6:39 AM
To: packetfence-users@lists.sourceforge.net
Cc: Sallee, Jake
Subject: Re: [PacketFence-users] Fwd: Upgrade 9.1 to 9.3
EXTERNAL Exercise Caution
[root@vminednac01 ~]# systemctl status packetfence-httpd.webservices.service
● packetfence-httpd.webservices.service - PacketFence Webservices Apache HTTP
Server
Loaded: loaded
(/usr/lib/systemd/system/packetfence-httpd.webservices.service; enabled; vendor
preset: disabled)
Active: activating (start) since Fri 2020-02-14 12:35:30 UTC; 4s ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 3486 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited,
status=1/FAILURE)
Process: 3499 ExecStartPre=/bin/perl -I/usr/local/pf/lib
-Mpf::services::manager::httpd_webservices -e
pf::services::manager::httpd_webservices->new()->generateConfig() (code=exited,
status=0/SUCCESS)
Process: 3498 ExecStartPre=/usr/bin/rm -f
/usr/local/pf/var/run/httpd.webservices.pid (code=exited, status=0/SUCCESS)
Main PID: 3520 (/usr/sbin/httpd)
CGroup: /packetfence.slice/packetfence-httpd.webservices.service
└─3520 /usr/sbin/httpd -f
/usr/local/pf/var/conf/httpd.conf.d/httpd.webservices -DFOREGROUND -Drhel
Feb 14 12:35:39 vminednac01 kill[3541]: kill: cannot find process ""
Feb 14 12:35:39 vminednac01 systemd[1]: packetfence-httpd.webservices.service:
control process exited, code=exited status=1
Feb 14 12:35:39 vminednac01 systemd[1]: Failed to start PacketFence Webservices
Apache HTTP Server.
Feb 14 12:35:39 vminednac01 systemd[1]: Unit
packetfence-httpd.webservices.service entered failed state.
Feb 14 12:35:39 vminednac01 systemd[1]: packetfence-httpd.webservices.service
failed.
Feb 14 12:35:39 vminednac01 systemd[1]: packetfence-httpd.webservices.service
holdoff time over, scheduling restart.
Feb 14 12:35:39 vminednac01 systemd[1]: Stopped PacketFence Webservices Apache
HTTP Server.
Feb 14 12:35:39 vminednac01 systemd[1]: Starting PacketFence Webservices Apache
HTTP Server...
Feb 14 12:35:42 vminednac01 packetfence[3546]: INFO -e(3546): generating
/usr/local/pf/var/conf/ssl-certificates.conf
(pf::services::manager::httpd::generateCommonConfig)
Feb 14 12:35:42 vminednac01 packetfence[3546]: INFO -e(3546): generating
/usr/local/pf/var/conf/captive-portal-common
(pf::services::manager::httpd::generateCommonConfig)
[root@vminednac01 ~]# systemctl status packetfence-httpd.admin.service
● packetfence-httpd.admin.service - PacketFence Administration Apache HTTP
Server
Loaded: loaded (/usr/lib/systemd/system/packetfence-httpd.admin.service;
enabled; vendor preset: disabled)
Active: inactive (dead) (Result: exit-code) since Fri 2020-02-14 12:36:51
UTC; 391ms ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 3848 ExecStart=/usr/sbin/httpd -f
/usr/local/pf/var/conf/httpd.conf.d/httpd.admin -DFOREGROUND -Drhel
(code=exited, status=1/FAILURE)
Process: 3834 ExecStartPre=/bin/perl -I/usr/local/pf/lib
-Mpf::services::manager::httpd_admin -e
pf::services::manager::httpd_admin->new()->generateConfig() (code=exited,
status=0/SUCCESS)
Process: 3833 ExecStartPre=/usr/bin/rm -f
/usr/local/pf/var/run/httpd.admin.pid (code=exited, status=0/SUCCESS)
Main PID: 3848 (code=exited, status=1/FAILURE)
Feb 14 12:36:51 vminednac01 systemd[1]: Failed to start PacketFence
Administration Apache HTTP Server.
Feb 14 12:36:51 vminednac01 systemd[1]: Unit packetfence-httpd.admin.service
entered failed state.
Feb 14 12:36:51 vminednac01 systemd[1]: packetfence-httpd.admin.service failed.
Feb 14 12:36:51 vminednac01 systemd[1]: packetfence-httpd.admin.service holdoff
time over, scheduling restart.
Feb 14 12:36:51 vminednac01 systemd[1]: Stopped PacketFence Administration
Apache HTTP Server.
Feb 14 12:36:54 vminednac01 systemd[1]: Starting PacketFence Administration
Apache HTTP Server...
[root@vminednac01 ~]# systemctl status packetfence-httpd.aaa.service
● packetfence-httpd.aaa.service - PacketFence AAA Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/packetfence-httpd.aaa.service;
enabled; vendor preset: disabled)
Active: activating (start) since Fri 2020-02-14 12:37:26 UTC; 8s ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 4262 ExecStartPre=/bin/perl -I/usr/local/pf/lib
-Mpf::services::manager::httpd_aaa -e
pf::services::manager::httpd_aaa->new()->generateConfig() (code=exited,
status=0/SUCCESS)
Process: 4261 ExecStartPre=/usr/bin/rm -f /usr/local/pf/var/run/httpd.aaa.pid
(code=exited, status=0/SUCCESS)
Main PID: 4286 (/usr/sbin/httpd)
CGroup: /packetfence.slice/packetfence-httpd.aaa.service
└─4286 /usr/sbin/httpd -f
/usr/local/pf/var/conf/httpd.conf.d/httpd.aaa -DFOREGROUND -Drhel
Feb 14 12:37:36 vminednac01 httpd_aaa_err[4307]: [Fri Feb 14 12:37:36.085087
2020] [ssl:emerg] [pid 4286] AH02238: Unable to configure RSA server private key
Feb 14 12:37:36 vminednac01 httpd_aaa_err[4307]: [Fri Feb 14 12:37:36.085129
2020] [ssl:emerg] [pid 4286] SSL Library Error: error:0B080074:x509 certificate
routines:X509_check_private_key:key values mismatch
Feb 14 12:37:36 vminednac01 httpd_aaa_err[4307]: [Fri Feb 14 12:37:36.085138
2020] [ssl:emerg] [pid 4286] AH02311: Fatal error initialising mod_ssl,
exiting. See /etc/httpd/| /usr/bin/logger -thttpd_...re information
Feb 14 12:37:36 vminednac01 systemd[1]: packetfence-httpd.aaa.service: main
process exited, code=exited, status=1/FAILURE
Feb 14 12:37:36 vminednac01 systemd[1]: Failed to start PacketFence AAA Apache
HTTP Server.
Feb 14 12:37:36 vminednac01 systemd[1]: Unit packetfence-httpd.aaa.service
entered failed state.
Feb 14 12:37:36 vminednac01 systemd[1]: packetfence-httpd.aaa.service failed.
Feb 14 12:37:36 vminednac01 systemd[1]: packetfence-httpd.aaa.service holdoff
time over, scheduling restart.
Feb 14 12:37:36 vminednac01 systemd[1]: Stopped PacketFence AAA Apache HTTP
Server.
Feb 14 12:37:36 vminednac01 systemd[1]: Starting PacketFence AAA Apache HTTP
Server...
Hint: Some lines were ellipsized, use -l to show in full.
[root@vminednac01 ~]# systemctl status packetfence-haproxy-portal.service
● packetfence-haproxy-portal.service - PacketFence HAProxy Load Balancer for
the captive portal
Loaded: loaded (/usr/lib/systemd/system/packetfence-haproxy-portal.service;
enabled; vendor preset: disabled)
Active: activating (start-pre) since Fri 2020-02-14 12:37:47 UTC; 1s ago
Process: 4368 ExecStart=/usr/sbin/haproxy -Ws -f
/usr/local/pf/var/conf/haproxy-portal.conf -p
/usr/local/pf/var/run/haproxy-portal.pid (code=exited, status=1/FAILURE)
Main PID: 4368 (code=exited, status=1/FAILURE); : 4372 (perl)
CGroup: /packetfence.slice/packetfence-haproxy-portal.service
└─control
└─4372 /bin/perl -I/usr/local/pf/lib
-Mpf::services::manager::haproxy_portal -e
pf::services::manager::haproxy_portal->new()->generateConfig()
Feb 14 12:37:47 vminednac01 systemd[1]: packetfence-haproxy-portal.service
holdoff time over, scheduling restart.
Feb 14 12:37:47 vminednac01 systemd[1]: Stopped PacketFence HAProxy Load
Balancer for the captive portal.
Feb 14 12:37:47 vminednac01 systemd[1]: Starting PacketFence HAProxy Load
Balancer for the captive portal...
[root@vminednac01 ~]# systemctl status packetfence-config.service
● packetfence-config.service - PacketFence Config Service
Loaded: loaded (/usr/lib/systemd/system/packetfence-config.service;
disabled; vendor preset: disabled)
Active: active (running) since Fri 2020-02-14 10:13:46 UTC; 2h 24min ago
Main PID: 1752 (pfconfig)
Status: "Ready"
CGroup: /packetfence.slice/packetfence-base.slice/packetfence-config.service
└─1752 pfconfig
Feb 14 10:13:46 vminednac01 pfconfig[1752]: pfconfig(1752) ERROR: [mac:[undef]]
Caught error DBI connect('database=pf;host=localhost;port=3306','pf',...)
failed: Can't connect to local MySQL server
...sql.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__sql.pm&d=DwMFaQ&c=61yQaCoNVjQr1ah003i6yA&r=hv6FWbB_1Tauwq1un9h_XR4pflYMFHr0Ag1rvcLKIQA&m=Wc5i9unISZ3i_w6TfFDi-vntdTZxf_dVZWKJCUNDbJI&s=ix_hqTxjeJjy_qxu9zou8EfUoPWCQrQg47DfE634Gj8&e=>
line 47.
while connecting to database.
(pfconfig::backend::mysql::_get_db)...
Feb 14 10:13:46 vminednac01 pfconfig[1752]: pfconfig(1752) 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/co...sql::_db_error)
Feb 14 10:13:46 vminednac01 pfconfig[1752]: Could not write namespace
interfaces::management_network(vminednac01) to L2 cache !
Feb 14 10:13:46 vminednac01 pfconfig[1752]: pfconfig(1752) ERROR: [mac:[undef]]
Could not write namespace interfaces::management_network(vminednac01) to L2
cache ! (pfconfig::manager::cache_resource)
Feb 14 10:13:48 vminednac01 pfconfig[1752]: pfconfig(1752) ERROR: [mac:[undef]]
Caught error DBI connect('database=pf;host=localhost;port=3306','pf',...)
failed: Can't connect to local MySQL server
...sql.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__sql.pm&d=DwMFaQ&c=61yQaCoNVjQr1ah003i6yA&r=hv6FWbB_1Tauwq1un9h_XR4pflYMFHr0Ag1rvcLKIQA&m=Wc5i9unISZ3i_w6TfFDi-vntdTZxf_dVZWKJCUNDbJI&s=ix_hqTxjeJjy_qxu9zou8EfUoPWCQrQg47DfE634Gj8&e=>
line 47.
while connecting to database.
(pfconfig::backend::mysql::_get_db)...
Feb 14 10:13:48 vminednac01 pfconfig[1752]: pfconfig(1752) 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/co...sql::_db_error)
Feb 14 10:13:48 vminednac01 pfconfig[1752]: pfconfig(1752) ERROR: [mac:[undef]]
Caught error DBI connect('database=pf;host=localhost;port=3306','pf',...)
failed: Can't connect to local MySQL server
...sql.pm<https://urldefense.proofpoint.com/v2/url?u=http-3A__sql.pm&d=DwMFaQ&c=61yQaCoNVjQr1ah003i6yA&r=hv6FWbB_1Tauwq1un9h_XR4pflYMFHr0Ag1rvcLKIQA&m=Wc5i9unISZ3i_w6TfFDi-vntdTZxf_dVZWKJCUNDbJI&s=ix_hqTxjeJjy_qxu9zou8EfUoPWCQrQg47DfE634Gj8&e=>
line 47.
while connecting to database.
(pfconfig::backend::mysql::_get_db)...
Feb 14 10:13:48 vminednac01 pfconfig[1752]: pfconfig(1752) 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/co...sql::_db_error)
Feb 14 10:13:48 vminednac01 pfconfig[1752]: Could not write namespace
config::Network(vminednac01) to L2 cache !
Feb 14 10:13:48 vminednac01 pfconfig[1752]: pfconfig(1752) ERROR: [mac:[undef]]
Could not write namespace config::Network(vminednac01) to L2 cache !
(pfconfig::manager::cache_resource)
Hint: Some lines were ellipsized, use -l to show in full.
[root@vminednac01 ~]#
Cumprimentos,
Domingos Varela
Tel. +244 923 229 330 | Luanda - Angola
Domingos Varela <sousa.var...@gmail.com<mailto:sousa.var...@gmail.com>>
escreveu no dia sexta, 14/02/2020 à(s) 13:34:
Hi Jake,
thanks for your response, the answer below.
Regards
Cumprimentos,
Domingos Varela
Tel. +244 923 229 330 | Luanda - Angola
Sallee, Jake via PacketFence-users
<packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>>
escreveu no dia quinta, 13/02/2020 à(s) 22:01:
Domingos:
I happy to try and help, but we will need more info.
Lets start with your log files. When you try to start the PF services what do
the logs say? You can put your log file on pastebin and link it here.
I am unable to collect the logs during system startup because the system is
stuck "Checking configuration sanity ..." for several hours and does not leave
until I cancel.
If you did the upgrade, did you also do the database schema upgrade?
Yes, 9.1 -> 9.2 and 9.2 -> 9.3 db schema
Jake Sallee
Godfather of Bandwidth
System Engineer and Security Specialist
University of Mary Hardin-Baylor
WWW.UMHB.EDU<http://WWW.UMHB.EDU>
900 College St.
Belton, Texas
76513
Fone: 254-295-4658
Phax: 254-295-4221
________________________________________
From: Domingos Varela via PacketFence-users
<packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>>
Sent: Thursday, February 13, 2020 1:18 AM
To:
packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>
Cc: Domingos Varela
Subject: [PacketFence-users] Fwd: Upgrade 9.1 to 9.3
EXTERNAL Exercise Caution
Hello,
Someone help me, to solve this issue!
Thanks
---------- Forwarded message ---------
De: Domingos Varela
<sousa.var...@gmail.com<mailto:sousa.var...@gmail.com><mailto:sousa.var...@gmail.com<mailto:sousa.var...@gmail.com>>>
Date: terça, 11/02/2020, 14:11
Subject: Upgrade 9.1 to 9.3
To:
<packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net><mailto:packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>>>
Hi,
I tried to upgrade from version 9.1 to 9.3, I followed the steps in the
documentation, but after finishing the system it gets stuck in "cheking
configuration sanity...", and it doesn't go away ... now I have the system out
of service.
image in attach
Can anyone help?
Thanks
Regards
Cumprimentos,
Domingos Varela
Tel. +244 923 229 330 | Luanda - Angola
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net<mailto:PacketFence-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/packetfence-users<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.sourceforge.net_lists_listinfo_packetfence-2Dusers&d=DwMFaQ&c=61yQaCoNVjQr1ah003i6yA&r=hv6FWbB_1Tauwq1un9h_XR4pflYMFHr0Ag1rvcLKIQA&m=Wc5i9unISZ3i_w6TfFDi-vntdTZxf_dVZWKJCUNDbJI&s=kLJQmgTCTCSc8ynxAXgKV9sJ0S-rpI5exgpZaeHsa80&e=>
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
