Re: [PacketFence-users] PF 13.1 Error on import

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi Romy,

I had that one too https://github.com/inverse-inc/packetfence/issues/8105#issuecomment-2090621697

I think that one should have been fixed in that commit https://github.com/inverse-inc/packetfence/commit/52248bd53bac6a51ee38b4b0dffa108a1d1c0071

I just check and it has NOT been backported to maintenance.

I will do it. It will be in the next iteration.

Thanks for report.

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: Andres, Romy <rom...@ib...>
Sent: Tuesday, September 3, 2024 6:27 AM
To: Goimard, Jeremy; pac...@li...
Subject: AW: PF 13.1 Error on import

Hi Jeremy, Thanks for your reply. It took some time, but now I have a newly set up Packetfence server version 13. 2. The commands: curl https: //patch-diff. githubusercontent. com/raw/inverse-inc/packetfence/pull/8193. diff | patch -p1 --dry-run
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd
Hi Jeremy,
Thanks for your reply.

It took some time, but now I have a newly set up Packetfence server version 13.2.

The commands:

curl https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff<https://urldefense.com/v3/__https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOyiHGZFyg$> | patch -p1 --dry-run
and
curl https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff<https://urldefense.com/v3/__https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOyiHGZFyg$> | patch -p1

went through fine.

There is a new problem with the import.
Here is the output of the command:
---------------------------------------------------------------------------------------------------------------------------------------------------------
root@packet2:/home/ibmt# /usr/local/pf/addons/full-import/import.sh -f /home/ibmt/pk1-export_21082024-1.tgz
/tmp/tmp.NZ3gWAAeWf /home/ibmt
=================================================================================
Extracting archive...
Found the following content in the archive:
insgesamt 345736
-rw-r--r-- 1 root root       256 21. Aug 11:45 add_files.txt
-rw-r--r-- 1 root root      1225 21. Aug 11:45 grants.sql
-rw-r--r-- 1 root root   2985019 21. Aug 00:30 packetfence-db-dump-2024-08-21_00h30.sql.gz
-rw-r--r-- 1 root root 174675478 21. Aug 00:30 packetfence-files-dump-2024-08-21_00h30.tgz
-rw-r--r-- 1 root root      1630 21. Aug 11:45 stored_config_files.txt
drwxr-xr-x 3 root root      4096 21. Aug 11:45 usr
=================================================================================
Found files dump 'packetfence-files-dump-2024-08-21_00h30.tgz'
Extracting files dump
=================================================================================
Found compressed database dump 'packetfence-db-dump-2024-08-21_00h30.sql.gz'
Uncompressed database dump 'packetfence-db-dump-2024-08-21_00h30.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-08-21_00h30.sql into pf
ERROR 1062 (23000) at line 1239: Duplicate entry '1' for key 'PRIMARY'
Cleaning temporary directory
-----------------------------------------------------------------------------------------------------------------------------------------
Can you please help again?

Thank you very much for your efforts.

best regards Romy

--
Verwaltung IT
Fraunhofer Institut für Biomedizinische Technik

Mailing address:
Joseph-von-Fraunhofer-Weg 1
66280 Sulzbach
Germany

Visiting address:
Ensheimer Straße 48
66386 St.Ingbert
Germany

phone:  0049 6897 9071 412
email:    rom...@ib...<mailto:rom...@ib...>
http://www.ibmt.fraunhofer.de<https://urldefense.com/v3/__http://www.ibmt.fraunhofer.de/__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOwm7nuXQA$>

Von: Goimard, Jeremy <jeg...@ak...>
Gesendet: Donnerstag, 27. Juni 2024 16:53
An: pac...@li...
Cc: Andres, Romy <rom...@ib...>
Betreff: Re: PF 13.1 Error on import

Hi Romy,

Long story: a PR has been introduce in 13.1 (https://github.com/inverse-inc/packetfence/pull/7754<https://urldefense.com/v3/__https://github.com/inverse-inc/packetfence/pull/7754__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOyspuLNvA$>) and we opened a ticket about that issue (https://github.com/inverse-inc/packetfence/issues/8105<https://urldefense.com/v3/__https://github.com/inverse-inc/packetfence/issues/8105__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOwUXFKjgg$>) and a PR (https://github.com/inverse-inc/packetfence/pull/8106<https://urldefense.com/v3/__https://github.com/inverse-inc/packetfence/pull/8106__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOzs9Mu2Xw$>) that fix the import from 13.1 to 13.2.

We also provide first a fix for 13.1 to 13.2 and a new PR is waiting for the previous version:
https://github.com/inverse-inc/packetfence/pull/8193<https://urldefense.com/v3/__https://github.com/inverse-inc/packetfence/pull/8193__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOzo2RE16A$>

Short story:

- for packetfence-export before 13.1, files are saved under /usr/local/pf

- for packetfence-export after 13.1 (included), files are saved in ./

So,

- import a exported file from 13.1 or before, in 13.1 or 13.2 will not work.

- import a exported file from 13.1 in 13.2 should work

To apply the fix until PR#8193 is merged and backported to 13.1 and 13.2 maintenance branches,

you need to apply that patch with the following command lines:

```

cd /usr/local/pf/
curl https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff<https://urldefense.com/v3/__https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOyiHGZFyg$> | patch -p1 --dry-run
```

if fine then:

```

cd /usr/local/pf/
curl https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff<https://urldefense.com/v3/__https://patch-diff.githubusercontent.com/raw/inverse-inc/packetfence/pull/8193.diff__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOyiHGZFyg$> | patch -p1
```

Then do the importation.

Thanks for your feedback.

Regards

Jeremy Goimard
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!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOw0s9l2DA$>  [signature_3425345268] <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOzbHqkqmA$>  [signature_4082763092] <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOxWGX8B3w$>  [signature_1928680685] <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOyjqsTKUQ$>

________________________________
From: Andres, Romy via PacketFence-users <pac...@li...<mailto:pac...@li...>>
Sent: Wednesday, June 26, 2024 6:33:21 AM
To: pac...@li...<mailto:pac...@li...>
Cc: Andres, Romy
Subject: [PacketFence-users] PF 13.1 Error on import

Hello everyone,

With the command /usr/local/pf/addons/full-import/export.sh we successfully create an export file.

When importing this file on another Packetfence server (version 13.1) with /usr/local/pf/addons/full-import/import.sh -f the following error occurs:

Get PF version in PacketFence export
grep: /tmp/tmp.JjkJJJKAA3b/usr/local/pf/conf/pf-release: File or directory not found

How can the export file be imported successfully?
Are there special options to set for export?

Thanks in advance for your help.

Romy