Now there is different error

root@packetfence:~# /usr/local/pf/addons/full-import/import.sh -f
/tmp/export.tgz
/tmp/tmp.5ivIKXyBON ~
=================================================================================
Extracting archive...
Found the following content in the archive:
total 345072
-rw-r--r-- 1 root root       256 Sep 17 14:43 add_files.txt
-rw-r--r-- 1 root root      1175 Sep 17 14:43 grants.sql
-rw-r--r-- 1 root root    163588 Sep 17 14:42
packetfence-db-dump-2024-09-17_20h12.sql.gz
-rw-r--r-- 1 root root 177166667 Sep 17 14:42
packetfence-files-dump-2024-09-17_20h08.tgz
-rw-r--r-- 1 root root      1630 Sep 17 14:43 stored_config_files.txt
drwxr-xr-x 3 root root      4096 Sep 17 14:43 usr
=================================================================================
Found files dump 'packetfence-files-dump-2024-09-17_20h08.tgz'
Extracting files dump
=================================================================================
Found compressed database dump 'packetfence-db-dump-2024-09-17_20h12.sql.gz'
Uncompressed database dump 'packetfence-db-dump-2024-09-17_20h12.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_20h12.sql into pf
ERROR at line 1: Unknown command '\-'.
Cleaning temporary directory
root@packetfence:~#

On Tue, Sep 17, 2024 at 7:08 PM Goimard, Jeremy <jegoi...@akamai.com> wrote:

> Hi Arum,
>
>
> Ok, Sorry I wasn't clear enough.
>
>
> The problem is on the db backup that has been created on 13.2.0.
>
> Please, apply maintenance patches on 13.2.0, not on 14.0.0.
>
> The doc is the same for both
> https://www.packetfence.org/doc/13.2.0/PacketFence_Upgrade_Guide.html#_apply_maintenance_patches
>
> that is why the previous link used 14.0.0
>
>
> Sorry for the misdirection.
>
>
> Thank you
>
> Regards
>
> *Jeremy Goimard*
> *Senior Software Engineer*
> [image: signature_117474225]
> *Office:* +1 613 670 8438
> Akamai Technologies - Inverse
> 145 Broadway
> Cambridge, MA 02142
> Connect with Us:
> [image: signature_1388875202] <https://community.akamai.com/> [image:
> signature_3364560605] <http://blogs.akamai.com/> [image:
> signature_2499095976] <https://twitter.com/akamai> [image:
> signature_3425345268] <http://www.facebook.com/AkamaiTechnologies> [image:
> signature_4082763092]
> <http://www.linkedin.com/company/akamai-technologies> [image:
> signature_1928680685]
> <http://www.youtube.com/user/akamaitechnologies?feature=results_main>
>
>
>
> ------------------------------
> *From:* Arun Kangle <akan...@gmail.com>
> *Sent:* Tuesday, September 17, 2024 9:26 AM
> *To:* Goimard, Jeremy
> *Cc:* packetfence-users@lists.sourceforge.net
> *Subject:* Re: [PacketFence-users] Unable to upgrade to 14.0
>
> Hi Jeremy, I tried the steps given to apply maintenance patch but still
> facing the same error: root@ packetfence: ~# /usr/local/pf/bin/pfcmd
> service pf stop Synchronizing state of monit. service with SysV service
> script with /lib/systemd/systemd-sysv-install.
> ZjQcmQRYFpfptBannerStart
> This Message Is From an Untrusted Sender
> You have not previously corresponded with this sender.
>
> ZjQcmQRYFpfptBannerEnd
> Hi Jeremy,
> I tried the steps given to apply maintenance patch but still facing the
> same error:
>
> root@packetfence:~# /usr/local/pf/bin/pfcmd service pf stop
> 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   1138
> 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   997
> packetfence-redis_ntlm_cache.service                    disabled  0
> packetfence-redis_queue.service                         stopped   0
> packetfence-snmptrapd.service                           disabled  0
> packetfence-tracking-config.service                     disabled  1
> root@packetfence:~# systemctl stop packetfence-config
>
> root@packetfence:~# apt update
> Hit:1 http://security.debian.org/debian-security
> <https://urldefense.com/v3/__http://security.debian.org/debian-security__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhiKCqQuYg$>
> bookworm-security InRelease
> Hit:2 http://inverse.ca/downloads/PacketFence/debian/14.0 bookworm
> InRelease
> Hit:3 http://deb.debian.org/debian
> <https://urldefense.com/v3/__http://deb.debian.org/debian__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhhQJSq3xQ$>
> bookworm InRelease
> Hit:4 http://deb.debian.org/debian
> <https://urldefense.com/v3/__http://deb.debian.org/debian__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhhQJSq3xQ$>
> bookworm-updates InRelease
> Reading package lists... Done
> Building dependency tree... Done
> Reading state information... Done
> 10 packages can be upgraded. Run 'apt list --upgradable' to see them.
> W:
> http://inverse.ca/downloads/PacketFence/debian/14.0/dists/bookworm/InRelease:
> Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the
> DEPRECATION section in apt-key(8) for details.
> root@packetfence:~#
> root@packetfence:~# apt upgrade
> Reading package lists... Done
> Building dependency tree... Done
> Reading state information... Done
> Calculating upgrade... Done
> Some packages could not be installed. This may mean that you have
> requested an impossible situation or if you are using the unstable
> distribution that some required packages have not yet been created
> or been moved out of Incoming.
> The following information may help to resolve the situation:
>
> The following packages have unmet dependencies:
>  netdata-web : Conflicts: netdata-data but 1:1.10.0-1 is to be installed
> E: Broken packages
>
> root@packetfence:~# apt-mark hold netdata
> netdata set on hold.
> root@packetfence:~# apt upgrade
> Reading package lists... Done
> Building dependency tree... Done
> Reading state information... Done
> Calculating upgrade... Done
> The following packages have been kept back:
>   netdata packetfence
> The following packages will be upgraded:
>   git git-man packetfence-archive-keyring packetfence-config
> packetfence-golang-daemon packetfence-ntlm-wrapper packetfence-pfcmd-suid
> packetfence-redis-cache
> 8 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
> Need to get 54.4 MB of archives.
> After this operation, 428 kB of additional disk space will be used.
> Do you want to continue? [Y/n] y
> Get:1 http://security.debian.org/debian-security
> <https://urldefense.com/v3/__http://security.debian.org/debian-security__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhiKCqQuYg$>
> bookworm-security/main amd64 git amd64 1:2.39.5-0+deb12u1 [7,256 kB]
> Get:2 http://security.debian.org/debian-security
> <https://urldefense.com/v3/__http://security.debian.org/debian-security__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhiKCqQuYg$>
> bookworm-security/main amd64 git-man all 1:2.39.5-0+deb12u1 [2,054 kB]
> Get:3 http://inverse.ca/downloads/PacketFence/debian/14.0
> bookworm/bookworm amd64 packetfence-archive-keyring all
> 14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1 [3,924 B]
> Get:4 http://inverse.ca/downloads/PacketFence/debian/14.0
> bookworm/bookworm amd64 packetfence-config all
> 14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1 [52.1 kB]
> Get:5 http://inverse.ca/downloads/PacketFence/debian/14.0
> bookworm/bookworm amd64 packetfence-golang-daemon amd64
> 14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1 [44.9 MB]
> Get:6 http://inverse.ca/downloads/PacketFence/debian/14.0
> bookworm/bookworm amd64 packetfence-ntlm-wrapper amd64
> 14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1 [7,976 B]
> Get:7 http://inverse.ca/downloads/PacketFence/debian/14.0
> bookworm/bookworm amd64 packetfence-pfcmd-suid amd64
> 14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1 [4,576 B]
> Get:8 http://inverse.ca/downloads/PacketFence/debian/14.0
> bookworm/bookworm amd64 packetfence-redis-cache all
> 14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1 [36.7 kB]
> Fetched 54.4 MB in 13s (4,027 kB/s)
> Reading changelogs... Done
> (Reading database ... 124611 files and directories currently installed.)
> Preparing to unpack .../0-git_1%3a2.39.5-0+deb12u1_amd64.deb ...
> Unpacking git (1:2.39.5-0+deb12u1) over (1:2.39.2-1.1) ...
> Preparing to unpack .../1-git-man_1%3a2.39.5-0+deb12u1_all.deb ...
> Unpacking git-man (1:2.39.5-0+deb12u1) over (1:2.39.2-1.1) ...
> Preparing to unpack
> .../2-packetfence-archive-keyring_14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1_all.deb
> ...
> Unpacking packetfence-archive-keyring
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) over
> (14.0.0+20240906134923+1443385130+0012+v14~0~0+bookworm1) ...
> Preparing to unpack
> .../3-packetfence-config_14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1_all.deb
> ...
> Unpacking packetfence-config
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) over
> (14.0.0+20240906134923+1443385130+0012+v14~0~0+bookworm1) ...
> Preparing to unpack
> .../4-packetfence-golang-daemon_14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1_amd64.deb
> ...
> Upgrading from 14.0.0+20240906134923+1443385130+0012+v14~0~0+bookworm1
> Unpacking packetfence-golang-daemon
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) over
> (14.0.0+20240906134923+1443385130+0012+v14~0~0+bookworm1) ...
> Preparing to unpack
> .../5-packetfence-ntlm-wrapper_14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1_amd64.deb
> ...
> Unpacking packetfence-ntlm-wrapper
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) over
> (14.0.0+20240906134923+1443385130+0012+v14~0~0+bookworm1) ...
> Preparing to unpack
> .../6-packetfence-pfcmd-suid_14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1_amd64.deb
> ...
> Unpacking packetfence-pfcmd-suid
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) over
> (14.0.0+20240906134923+1443385130+0012+v14~0~0+bookworm1) ...
> Preparing to unpack
> .../7-packetfence-redis-cache_14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1_all.deb
> ...
> Unpacking packetfence-redis-cache
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) over
> (14.0.0+20240906134923+1443385130+0012+v14~0~0+bookworm1) ...
> Setting up packetfence-redis-cache
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) ...
> Synchronizing state of redis-server.service with SysV service script with
> /lib/systemd/systemd-sysv-install.
> Executing: /lib/systemd/systemd-sysv-install disable redis-server
> Setting up packetfence-pfcmd-suid
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) ...
> Setting up packetfence-config
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) ...
> pfconfig.conf already exists, won't touch it!
> Setting up packetfence-ntlm-wrapper
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) ...
> Setting up packetfence-archive-keyring
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) ...
> Setting up packetfence-golang-daemon
> (14.0.0+20240910143601+1448220744+0012+maintenance~14~0+bookworm1) ...
> Setting up git-man (1:2.39.5-0+deb12u1) ...
> Setting up git (1:2.39.5-0+deb12u1) ...
> Processing triggers for man-db (2.11.2-2) ...
> root@packetfence:~#
> root@packetfence:~#
> root@packetfence:~#
> root@packetfence:~# /usr/local/pf/addons/full-import/import.sh -f
> /tmp/export.tgz
> /tmp/tmp.DZrE5kSBrD ~
>
> =================================================================================
> 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
> root@packetfence:~#
>
> On Tue, Sep 17, 2024 at 5:39 PM Goimard, Jeremy <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!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhiVHm4G_g$>
>>  which
>> as been fixed.
>>
>>
>> Thanks
>>
>> Regards.
>>
>> *Jeremy Goimard*
>> *Senior Software Engineer*
>> [image: signature_117474225]
>> *Office:* +1 613 670 8438
>> Akamai Technologies - Inverse
>> 145 Broadway
>> Cambridge, MA 02142
>> Connect with Us:
>> [image: signature_1388875202] <https://community.akamai.com/> [image:
>> signature_3364560605] <http://blogs.akamai.com/> [image:
>> signature_2499095976]
>> <https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhh8MkC23Q$>
>>  [image: signature_3425345268]
>> <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhjnpXv_Ww$>
>>  [image: signature_4082763092]
>> <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhg5YPw8ng$>
>>  [image: signature_1928680685]
>> <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!Qtj1Vx-IYoUwnQzOWOd0MgRYPibHMSA5t0CC4XxeGF7IvZX6ORoq7y4p3wihUNoUyDKpwhhtlG3Xsg$>
>>
>> ------------------------------
>> *From:* Arun Kangle <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>
>> 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*
>>> [image: signature_117474225]
>>> *Office:* +1 613 670 8438
>>> Akamai Technologies - Inverse
>>> 145 Broadway
>>> Cambridge, MA 02142
>>> Connect with Us:
>>> [image: signature_1388875202] <https://community.akamai.com/> [image:
>>> signature_3364560605] <http://blogs.akamai.com/> [image:
>>> signature_2499095976]
>>> <https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!XTRjrsF9y4yzANhBbDhQ3oAq0TBKyg5iWXsCp4sapQ6cmuGOQioxapkbwaO4_pQ4e5JbGXamMkwxFw$>
>>>  [image: signature_3425345268]
>>> <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!XTRjrsF9y4yzANhBbDhQ3oAq0TBKyg5iWXsCp4sapQ6cmuGOQioxapkbwaO4_pQ4e5JbGXaZANqd3g$>
>>>  [image: signature_4082763092]
>>> <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!XTRjrsF9y4yzANhBbDhQ3oAq0TBKyg5iWXsCp4sapQ6cmuGOQioxapkbwaO4_pQ4e5JbGXbRsenMsg$>
>>>  [image: 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>
>>> *Sent:* Monday, September 16, 2024 11:09:39 AM
>>> *To:* 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