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 <romy.and...@ibmt.fraunhofer.de> Sent: Tuesday, September 3, 2024 6:27 AM To: Goimard, Jeremy; packetfence-users@lists.sourceforge.net 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: romy.and...@ibmt.fraunhofer.de<mailto:romy.and...@ibmt.fraunhofer.de> http://www.ibmt.fraunhofer.de<https://urldefense.com/v3/__http://www.ibmt.fraunhofer.de/__;!!GjvTz_vk!VAgvnL-FCQh61PbXFS-0JUfCWDFoGNeGgIHKr4QTD6zOFVys6jr5WxoMfYbE6eDAIM-RJWmMbEeBF8SgkOiNQOwm7nuXQA$> Von: Goimard, Jeremy <jegoi...@akamai.com> Gesendet: Donnerstag, 27. Juni 2024 16:53 An: packetfence-users@lists.sourceforge.net Cc: Andres, Romy <romy.and...@ibmt.fraunhofer.de> 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 <packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net>> Sent: Wednesday, June 26, 2024 6:33:21 AM To: packetfence-users@lists.sourceforge.net<mailto:packetfence-users@lists.sourceforge.net> 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
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
