Hi Arum,

No worries. Thanks for your understanding.


Note, that there is also that issue that is opened if you are using 
mariadb-backup:
https://github.com/inverse-inc/packetfence/issues/8257

As I wrote, I am currently rewriting the doc about upgrade with mariadb-backup.


If you are on a standalone WITHOUT mariadb-backup, you should be fine with the 
import/export mechanism from latest 13.2.0 on Debian 11 to PacketFence 14.0.0 
on Debian 12.


Thank you for using PacketFence.

Regards

Jeremy Goimard
Senior Software Engineer

[signature_117474225]


Office: +1 613 670 8438

Akamai Technologies - Inverse
145 Broadway
Cambridge, MA 02142


Connect with Us:

[signature_1388875202]<https://community.akamai.com/> [signature_3364560605] 
<http://blogs.akamai.com/>  [signature_2499095976] <https://twitter.com/akamai> 
 [signature_3425345268] <http://www.facebook.com/AkamaiTechnologies>  
[signature_4082763092] <http://www.linkedin.com/company/akamai-technologies>  
[signature_1928680685] 
<http://www.youtube.com/user/akamaitechnologies?feature=results_main>


________________________________
From: Arun Kangle <akan...@gmail.com>
Sent: Tuesday, September 17, 2024 8:16:11 AM
To: Goimard, Jeremy
Cc: packetfence-users@lists.sourceforge.net
Subject: Re: [PacketFence-users] Unable to upgrade to 14.0

Thanks for the reply and sorry for not paying attention if the email was sent 
only to you. - Arun On Tue, Sep 17, 2024 at 5: 39 PM Goimard, Jeremy <jegoimar@ 
akamai. com> wrote: Hi Arum, Please continue to use the sourceforge list. No 
private
ZjQcmQRYFpfptBannerStart
This Message Is From an Untrusted Sender
You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd
Thanks for the reply and sorry for not paying attention if the email was sent 
only to you.
- Arun

On Tue, Sep 17, 2024 at 5:39 PM Goimard, Jeremy 
<jegoi...@akamai.com<mailto:jegoi...@akamai.com>> wrote:

Hi Arum,


Please continue to use the sourceforge list.

No private help if you are not a client.


That been wrote, you need to apply maintenance patches first  
(https://www.packetfence.org/doc/14.0.0/PacketFence_Upgrade_Guide.html#_apply_maintenance_patches)
 due to that 
https://github.com/inverse-inc/packetfence/issues/8105<https://urldefense.com/v3/__https://github.com/inverse-inc/packetfence/issues/8105__;!!GjvTz_vk!SZIVyOyJGm_LTrrKR9ny_7tAel4FzXlKtFK5d1QiY2sYccaybHrpwdo2ZxrrdSYNh-JJ-G2vSEE8_w$>
 which as been fixed.


Thanks

Regards.

Jeremy Goimard
Senior Software Engineer

[signature_117474225]


Office: +1 613 670 8438

Akamai Technologies - Inverse
145 Broadway
Cambridge, MA 02142


Connect with Us:

[signature_1388875202]<https://community.akamai.com/> [signature_3364560605] 
<http://blogs.akamai.com/>  [signature_2499095976] 
<https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!SZIVyOyJGm_LTrrKR9ny_7tAel4FzXlKtFK5d1QiY2sYccaybHrpwdo2ZxrrdSYNh-JJ-G1NYUdCyA$>
  [signature_3425345268] 
<https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!SZIVyOyJGm_LTrrKR9ny_7tAel4FzXlKtFK5d1QiY2sYccaybHrpwdo2ZxrrdSYNh-JJ-G0dNznjTw$>
  [signature_4082763092] 
<https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!SZIVyOyJGm_LTrrKR9ny_7tAel4FzXlKtFK5d1QiY2sYccaybHrpwdo2ZxrrdSYNh-JJ-G1cfOWe2w$>
  [signature_1928680685] 
<https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!SZIVyOyJGm_LTrrKR9ny_7tAel4FzXlKtFK5d1QiY2sYccaybHrpwdo2ZxrrdSYNh-JJ-G05Eo2inw$>


________________________________
From: Arun Kangle <akan...@gmail.com<mailto:akan...@gmail.com>>
Sent: Tuesday, September 17, 2024 2:20:18 AM
To: Goimard, Jeremy
Subject: Re: [PacketFence-users] Unable to upgrade to 14.0

Thanks for reply Jeremy, I tried to export / import but getting the following 
error. Could you please help me? I am using 14. 0 Zen. I did not go through the 
configurator. After the first boot, I just edited the "interfaces" file to
ZjQcmQRYFpfptBannerStart
This Message Is From an Untrusted Sender
You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd
Thanks for reply Jeremy,
I tried to export / import but getting the following error. Could you please 
help me?

I am using 14.0 Zen. I did not go through the configurator. After the first 
boot, I just edited the "interfaces" file to add the IP address and copied the 
export.tdz from the source.

root@packetfence:/usr/local/pf/conf# /usr/local/pf/addons/full-import/import.sh 
-f /tmp/export.tgz
/tmp/tmp.VG977Nk5tp /usr/local/pf/conf
=================================================================================
Extracting archive...
Found the following content in the archive:
total 344604
-rw-r--r-- 1 root root       256 Sep 17 05:15 add_files.txt
-rw-r--r-- 1 root root      1225 Sep 17 05:15 grants.sql
-rw-r--r-- 1 root root    113315 Sep 17 05:13 
packetfence-db-dump-2024-09-17_10h43.sql.gz
-rw-r--r-- 1 root root 176971909 Sep 17 05:13 
packetfence-files-dump-2024-09-17_10h43.tgz
-rw-r--r-- 1 root root      1630 Sep 17 05:15 stored_config_files.txt
drwxr-xr-x 3 root root      4096 Sep 17 05:15 usr
=================================================================================
Found files dump 'packetfence-files-dump-2024-09-17_10h43.tgz'
Extracting files dump
=================================================================================
Found compressed database dump 'packetfence-db-dump-2024-09-17_10h43.sql.gz'
Uncompressed database dump 'packetfence-db-dump-2024-09-17_10h43.sql'
=================================================================================
Get PF version in PacketFence export
13.2.0
=================================================================================
Stopping PacketFence services
Synchronizing state of monit.service with SysV service script with 
/lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install disable monit
=================================================================================
The database dump uses mysqldump
---------------------------------------------------------------------------------
Recreating database pf
---------------------------------------------------------------------------------
Dump file was made without triggers and procedures
Importing bare schema for 13.2
---------------------------------------------------------------------------------
Replacing create statements from the dump and removing drop statements
---------------------------------------------------------------------------------
Importing packetfence-db-dump-2024-09-17_10h43.sql into pf
ERROR 1062 (23000) at line 1235: Duplicate entry '1' for key 'PRIMARY'
Cleaning temporary directory

Thanks,
- Arun

On Tue, Sep 17, 2024 at 2:05 AM Goimard, Jeremy 
<jegoi...@akamai.com<mailto:jegoi...@akamai.com>> wrote:

Hi Arun,


As mentioned in change log, PacketFence 14.0.0 in on Debian 12. Not Debian 11.


So, the upgrade script as is is not working. You will need to export/import in 
a new VM.


I am currently updating our documentation.


Thanks for reporting it and using PacketFence

Regards


Jeremy Goimard
Senior Software Engineer

[signature_117474225]


Office: +1 613 670 8438

Akamai Technologies - Inverse
145 Broadway
Cambridge, MA 02142


Connect with Us:

[signature_1388875202]<https://community.akamai.com/> [signature_3364560605] 
<http://blogs.akamai.com/>  [signature_2499095976] 
<https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!XTRjrsF9y4yzANhBbDhQ3oAq0TBKyg5iWXsCp4sapQ6cmuGOQioxapkbwaO4_pQ4e5JbGXamMkwxFw$>
  [signature_3425345268] 
<https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!XTRjrsF9y4yzANhBbDhQ3oAq0TBKyg5iWXsCp4sapQ6cmuGOQioxapkbwaO4_pQ4e5JbGXaZANqd3g$>
  [signature_4082763092] 
<https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!XTRjrsF9y4yzANhBbDhQ3oAq0TBKyg5iWXsCp4sapQ6cmuGOQioxapkbwaO4_pQ4e5JbGXbRsenMsg$>
  [signature_1928680685] 
<https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!XTRjrsF9y4yzANhBbDhQ3oAq0TBKyg5iWXsCp4sapQ6cmuGOQioxapkbwaO4_pQ4e5JbGXbnohoB2g$>


________________________________
From: Arun Kangle via PacketFence-users 
<packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>>
Sent: Monday, September 16, 2024 11:09:39 AM
To: 
packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>
Cc: Arun Kangle
Subject: [PacketFence-users] Unable to upgrade to 14.0

Hi All, Currently I am running 13. 2. 0 version when i run 
"/usr/local/pf/addons/upgrade/do-upgrade. sh" it is failing to recognise the 
latest version automatically and when i entered 14. 0 manually that too fails. 
root@ guestpf: /# /usr/local/pf/addons/upgrade/do-upgrade. sh
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd
Hi All,
Currently I am running 13.2.0 version when i run 
"/usr/local/pf/addons/upgrade/do-upgrade.sh" it is failing to recognise the 
latest version automatically and when i entered 14.0 manually that too fails.

root@guestpf:/# /usr/local/pf/addons/upgrade/do-upgrade.sh
=================================================================================
Installing or upgrading the upgrade tools for PacketFence
Hit:1 
http://deb.debian.org/debian<https://urldefense.com/v3/__http://deb.debian.org/debian__;!!GjvTz_vk!Tn8l-MQM0y3YfN4JBxAhtqrRSRlBC88xhvieNAvl5ycDSHe0en6jmNU7lP9mdsbjsZj1zSQ6k3l175bQNBMwMrYbvPM3vxnVT1fr3Q$>
 bullseye InRelease
Hit:2 
http://deb.debian.org/debian<https://urldefense.com/v3/__http://deb.debian.org/debian__;!!GjvTz_vk!Tn8l-MQM0y3YfN4JBxAhtqrRSRlBC88xhvieNAvl5ycDSHe0en6jmNU7lP9mdsbjsZj1zSQ6k3l175bQNBMwMrYbvPM3vxnVT1fr3Q$>
 bullseye-updates InRelease
Hit:3 http://inverse.ca/downloads/PacketFence/debian/13.2 bullseye InRelease
Hit:4 
http://security.debian.org/debian-security<https://urldefense.com/v3/__http://security.debian.org/debian-security__;!!GjvTz_vk!Tn8l-MQM0y3YfN4JBxAhtqrRSRlBC88xhvieNAvl5ycDSHe0en6jmNU7lP9mdsbjsZj1zSQ6k3l175bQNBMwMrYbvPM3vxn-8cF1mg$>
 bullseye-security InRelease
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
88 packages can be upgraded. Run 'apt list --upgradable' to see them.
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
packetfence-upgrade is already the newest version 
(13.2.0+20240911142550+1449916049+0011+maintenance~13~2+bullseye1).
The following packages were automatically installed and are no longer required:
  libgnutls-dane0 libunbound8
Use 'apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 88 not upgraded.
=================================================================================
Starting upgrade process
=================================================================================
Attempting to disable the monit service so it doesn't interfere with the upgrade
Synchronizing state of monit.service with SysV service script with 
/lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install disable monit
Attempting to stop the monit service so it doesn't interfere with the upgrade
---------------------------------------------------------------------------------
Stopping the PacketFence services
Synchronizing state of monit.service with SysV service script with 
/lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install disable monit
Service                                                 Status    PID
packetfence-api-frontend.service                        stopped   0
packetfence-config.service                              started   0
packetfence-docker-iptables.service                     disabled  0
packetfence-fingerbank-collector.service                disabled  0
packetfence-galera-autofix.service                      disabled  0
packetfence-haproxy-admin.service                       stopped   0
packetfence-haproxy-db.service                          disabled  0
packetfence-haproxy-portal.service                      stopped   0
packetfence-httpd.aaa.service                           stopped   0
packetfence-httpd.admin_dispatcher.service              stopped   0
packetfence-httpd.dispatcher.service                    stopped   0
packetfence-httpd.portal.service                        stopped   0
packetfence-httpd.webservices.service                   stopped   0
packetfence-ip6tables.service                           stopped   0
packetfence-iptables.service                            stopped   0
packetfence-kafka.service                               disabled  0
packetfence-keepalived.service                          stopped   0
packetfence-mariadb.service                             started   1992
packetfence-mysql-probe.service                         disabled  0
packetfence-netdata.service                             stopped   0
packetfence-ntlm-auth-api.service                       disabled  0
packetfence-pfacct.service                              stopped   0
packetfence-pfconnector-client.service                  stopped   0
packetfence-pfconnector-server.service                  stopped   0
packetfence-pfcron.service                              stopped   0
packetfence-pfdetect.service                            disabled  0
packetfence-pfdhcp.service                              stopped   0
packetfence-pfdhcplistener.service                      stopped   0
packetfence-pfdns.service                               stopped   0
packetfence-pffilter.service                            stopped   0
packetfence-pfipset.service                             stopped   0
packetfence-pfldapexplorer.service                      stopped   0
packetfence-pfperl-api.service                          stopped   0
packetfence-pfpki.service                               stopped   0
packetfence-pfqueue-backend.service                     stopped   0
packetfence-pfqueue-go.service                          stopped   0
packetfence-pfqueue-perl.service                        disabled  0
packetfence-pfsetacls.service                           stopped   0
packetfence-pfsso.service                               stopped   0
packetfence-pfstats.service                             stopped   0
packetfence-proxysql.service                            disabled  0
packetfence-radiusd-acct.service                        disabled  0
packetfence-radiusd-auth.service                        stopped   0
packetfence-radiusd-cli.service                         disabled  0
packetfence-radiusd-eduroam.service                     disabled  0
packetfence-radiusd-load_balancer.service               disabled  0
packetfence-radsniff.service                            stopped   0
packetfence-redis-cache.service                         started   1817
packetfence-redis_ntlm_cache.service                    disabled  0
packetfence-redis_queue.service                         stopped   0
packetfence-snmptrapd.service                           disabled  0
packetfence-tracking-config.service                     disabled  1
=================================================================================
Generating full pre-upgrade backup to 
/root/packetfence-pre-upgrade-backup-1726498856.tgz
/root/backup/ , folder already created.

packetfence-files-dump have been created in  /root/backup/

packetfence-files-dump older than 7 days have been removed.

Database backup will start
Not a Galera cluster, nothing to stop
mysqldump completed
Not a Galera cluster, nothing to reenable
/tmp/tmp.MfRZFp07Eq /usr/local/pf
=================================================================================
Copying dump files to temporary export directory
Database dump uses mysqldump. Exporting the grants from the database. Enter the 
MariaDB root password if prompted to
=================================================================================
Building list of configuration files for this current version
=================================================================================
Computing additional files that are referenced in the configuration
Found reference to external file that is in the PF directory 
(/usr/local/pf/conf/admin.conf)
Found reference to external file that is outside the PF directory 
(/usr/local/fingerbank/conf/fingerbank.conf)
Found reference to external file that is in the PF directory 
(/usr/local/pf/conf/iptables-input.conf.inc)
Found reference to external file that is in the PF directory 
(/usr/local/pf/conf/iptables-input-management.conf.inc)
Found reference to external file that is in the PF directory 
(/usr/local/pf/conf/ip6tables-input-management.conf.inc)
Found reference to external file that is in the PF directory 
(/usr/local/pf/conf/report.conf)
=================================================================================
Creating export archive
add_files.txt
grants.sql
packetfence-db-dump-2024-09-16_20h32.sql.gz
packetfence-files-dump-2024-09-16_20h30.tgz
stored_config_files.txt
usr/
usr/local/
usr/local/fingerbank/
usr/local/fingerbank/conf/
usr/local/fingerbank/conf/fingerbank.conf
=================================================================================
Done exporting to /root/packetfence-pre-upgrade-backup-1726498856.tgz
Cleaning temporary directory
=================================================================================
Do you wish to perform the update of the operating system to the latest 
available patches during that process? (y/n): y
=================================================================================
Backing up git_commit_id
Backing up pf-release
=================================================================================
Performing upgrade of the packages
Unable to detect packages to remove
dpkg-query: no packages found matching libmariadb-dev
Unable to detect a libmariadb-dev package, upgrade will continue
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100     5  100     5    0     0      2      0  0:00:02  0:00:01  0:00:01     2
The latest stable PacketFence version is 13.2, enter 'y' to upgrade to this 
version or 'n' to specify the version manually (y/n): n
Please enter the PacketFence version to which you wish to upgrade: 14.0
Hit:1 
http://security.debian.org/debian-security<https://urldefense.com/v3/__http://security.debian.org/debian-security__;!!GjvTz_vk!Tn8l-MQM0y3YfN4JBxAhtqrRSRlBC88xhvieNAvl5ycDSHe0en6jmNU7lP9mdsbjsZj1zSQ6k3l175bQNBMwMrYbvPM3vxn-8cF1mg$>
 bullseye-security InRelease
Hit:2 
http://deb.debian.org/debian<https://urldefense.com/v3/__http://deb.debian.org/debian__;!!GjvTz_vk!Tn8l-MQM0y3YfN4JBxAhtqrRSRlBC88xhvieNAvl5ycDSHe0en6jmNU7lP9mdsbjsZj1zSQ6k3l175bQNBMwMrYbvPM3vxnVT1fr3Q$>
 bullseye InRelease
Hit:3 
http://deb.debian.org/debian<https://urldefense.com/v3/__http://deb.debian.org/debian__;!!GjvTz_vk!Tn8l-MQM0y3YfN4JBxAhtqrRSRlBC88xhvieNAvl5ycDSHe0en6jmNU7lP9mdsbjsZj1zSQ6k3l175bQNBMwMrYbvPM3vxnVT1fr3Q$>
 bullseye-updates InRelease
Ign:4 http://inverse.ca/downloads/PacketFence/debian/14.0 bullseye InRelease
Err:5 http://inverse.ca/downloads/PacketFence/debian/14.0 bullseye Release
  404  Not Found [IP: 192.95.20.194 80]
Reading package lists... Done
E: The repository 'http://inverse.ca/downloads/PacketFence/debian/14.0 bullseye 
Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is therefore 
disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration 
details.
root@guestpf:/#

Am I missing anything?
Thanks in advance,
- Arun
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to