Re: [PacketFence-users] Fwd: Upgrade 9.1 to 9.3

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Salle,
Thanks
The logs in attach

Regards

Cumprimentos,

*Domingos Varela*
Tel. +244 923 229 330 | Luanda - Angola


Sallee, Jake via PacketFence-users <pac...@li...>
escreveu no dia sexta, 14/02/2020 à(s) 16:41:

> 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 <sou...@gm...>
> Sent: Friday, February 14, 2020 6:39 AM
> To: pac...@li...
> 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 <sou...@gm...<mailto:sou...@gm...>>
> 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 <
> pac...@li...<mailto:
> pac...@li...>> 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 <
> pac...@li...<mailto:
> pac...@li...>>
> Sent: Thursday, February 13, 2020 1:18 AM
> To: pac...@li...<mailto:
> pac...@li...>
> 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 <sou...@gm...<mailto:sou...@gm...
> ><mailto:sou...@gm...<mailto:sou...@gm...>>>
> Date: terça, 11/02/2020, 14:11
> Subject: Upgrade 9.1 to 9.3
> To: <pac...@li...<mailto:
> pac...@li...><mailto:
> pac...@li...<mailto:
> pac...@li...>>>
>
>
> 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
> Pac...@li...<mailto:
> Pac...@li...>
> 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
> Pac...@li...
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>