pgmodeler icon indicating copy to clipboard operation
pgmodeler copied to clipboard

How to use on Debian 12?

Open GitStorageOne opened this issue 1 year ago • 20 comments

Hello!

When I execute pre-compiled appimage v1.1.1, I get error:

./pgmodeler-1.1.1-linux64.appimage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by ./pgmodeler-1.1.1-linux64.appimage)
./pgmodeler-1.1.1-linux64.appimage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgmode9ffzPY/lib/libgui.so.1)
./pgmodeler-1.1.1-linux64.appimage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgmode9ffzPY/lib/libcanvas.so.1)
./pgmodeler-1.1.1-linux64.appimage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgmode9ffzPY/lib/libconnector.so.1)
./pgmodeler-1.1.1-linux64.appimage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgmode9ffzPY/lib/libcore.so.1)
./pgmodeler-1.1.1-linux64.appimage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgmode9ffzPY/lib/libparsers.so.1)
./pgmodeler-1.1.1-linux64.appimage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgmode9ffzPY/lib/libcli.so.1)

So, not sure what to do..
Is it a bug or Debian 12 is not supported?


Debian 12 with KDE Plasma

GitStorageOne avatar Mar 19 '24 18:03 GitStorageOne

Hi

It seems a Glibc version incompatibility as hinted by the error message. pgModeler libs require 3.4.32, which one is installed in your system?

rkhaotix avatar Mar 19 '24 18:03 rkhaotix

libc6-dev/stable,stable-security,now 2.36-9+deb12u4 amd64 [installed,automatic]
libc6/stable,stable-security,now 2.36-9+deb12u4 amd64 [installed]

I guess 2.36?

GitStorageOne avatar Mar 19 '24 18:03 GitStorageOne

I remember having a similar problem with my own software when I compiled it using the latest OS. Many users reported something similar, so I used a separate virtual machine with an old OS to compile. This library is backwards compatible, so after compiling on an older OS my application worked everywhere.

GitStorageOne avatar Mar 19 '24 18:03 GitStorageOne

AppImage is designed to be backward compatible with older Glibc version. The problem is with pgModeler build itself. I needed to get rid of that backward compatibility so I could use newer Qt versions. Unfortunately, for the problem you're facing, the solution is to use a newer OS (I don't know how old is Debian 12) but to give you an idea, pgModeler is built on a opensuse 15.5.

rkhaotix avatar Mar 19 '24 18:03 rkhaotix

I see,
Debian 12 was released June 10th, 2023

GitStorageOne avatar Mar 19 '24 18:03 GitStorageOne

I will test on the most popular and latest distro - Ubuntu 22.04 LTS.

GitStorageOne avatar Mar 19 '24 19:03 GitStorageOne

It doesn't work either.
It seems, pre-compiled appimage has very limited OS support, which also is not listed anywhere.

GitStorageOne avatar Mar 19 '24 20:03 GitStorageOne

As far as I understand, targeting to GLIBC 3.4.30 would be OK for the most distros.

GitStorageOne avatar Mar 19 '24 20:03 GitStorageOne

Yeah, I know. I still consider pgModeler AppImages experimental. For the next release I will try to build them on a distro a bit more older than the one I use for development.

rkhaotix avatar Mar 19 '24 20:03 rkhaotix

Yeah, I know. I still consider pgModeler AppImages experimental.

I'm getting the same error with .run bundle, so it's more general issue.

For the next release I will try to build them on a distro a bit more older than the one I use for development.

Latest Ubuntu LTS could be safe choice for the build server.

GitStorageOne avatar Mar 19 '24 20:03 GitStorageOne

Thanks for the suggestion. I'll build a snapshot later today and let you know. ;)

rkhaotix avatar Mar 19 '24 20:03 rkhaotix

Does not work on Debian 12 (stable) with XFCE for AppImage version 1.1.2 (2024-04-08) either.

libc6/stable,stable-security,now 2.36-9+deb12u4 amd64 [installed]
libc6/now 2.28-10 i386 [residual-config]
./pgModeler-1.1.2.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by ./pgModeler-1.1.2.AppImage)
./pgModeler-1.1.2.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModetkYfBO/lib/libgui.so.1)
./pgModeler-1.1.2.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModetkYfBO/lib/libcanvas.so.1)
./pgModeler-1.1.2.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModetkYfBO/lib/libconnector.so.1)
./pgModeler-1.1.2.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModetkYfBO/lib/libcore.so.1)
./pgModeler-1.1.2.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModetkYfBO/lib/libparsers.so.1)
./pgModeler-1.1.2.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModetkYfBO/lib/libcli.so.1)

jokay avatar Apr 23 '24 06:04 jokay

Does not work on Debian 12 (stable) with XFCE for AppImage version 1.1.3 (2024-05-13) either.

libc6/stable,stable-security,now 2.36-9+deb12u4 amd64 [installed]
libc6/now 2.28-10 i386 [residual-config]
./pgModeler-1.1.3.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by ./pgModeler-1.1.3.AppImage)
./pgModeler-1.1.3.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKOIUC4/lib/libgui.so.1)
./pgModeler-1.1.3.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKOIUC4/lib/libcanvas.so.1)
./pgModeler-1.1.3.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKOIUC4/lib/libconnector.so.1)
./pgModeler-1.1.3.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKOIUC4/lib/libcore.so.1)
./pgModeler-1.1.3.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKOIUC4/lib/libparsers.so.1)
./pgModeler-1.1.3.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKOIUC4/lib/libcli.so.1)

jokay avatar May 14 '24 12:05 jokay

Unfortunately, I'm about to ditch (or at least suspend) the use of appimages for pgModeler. It causes more trouble than it is effectively portable. Also, the author seems to have abandoned the project in favor of a new implementation of AppImage in Go language.

I'm running a patched older version of linuxdeployqt so it can be compiled in Qt 6 and deploy Qt 6 libraries. The original linuxdeployqt doesn't support Qt 6 and it seems that the author is unwilling to add that support anytime soon.

Anyway, I'll see if the new implementation of AppImage can help me somehow. That's it for now.

rkhaotix avatar May 14 '24 18:05 rkhaotix

AppImage in Go language seems promising 👍🏼

jokay avatar May 14 '24 18:05 jokay

@jokay I made some changes and build new AppImages on a Kubuntu 20.06 with PostgreSQL 12. Could you please test them on your system?

rkhaotix avatar May 15 '24 00:05 rkhaotix

@rkhaotix yes this looks better now.

image

Thank you very much 👍🏼

jokay avatar May 15 '24 06:05 jokay

And with version 1.1.4 we have the same problem again on an up-to-date Debian 12 🙄

./pgModeler-1.1.4-linux64.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by ./pgModeler-1.1.4-linux64.AppImage)
./pgModeler-1.1.4-linux64.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKJtB9D/lib/libgui.so.1)
./pgModeler-1.1.4-linux64.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKJtB9D/lib/libcanvas.so.1)
./pgModeler-1.1.4-linux64.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKJtB9D/lib/libconnector.so.1)
./pgModeler-1.1.4-linux64.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKJtB9D/lib/libcore.so.1)
./pgModeler-1.1.4-linux64.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKJtB9D/lib/libparsers.so.1)
./pgModeler-1.1.4-linux64.AppImage: /lib/x86_64-linux-gnu/libstdc++.so.6: version `GLIBCXX_3.4.32' not found (required by /tmp/.mount_pgModeKJtB9D/lib/libcli.so.1)
user@linux:~/apps$ strings /usr/lib/x86_64-linux-gnu/libstdc++.so.6 | grep GLIBCXX
GLIBCXX_3.4
GLIBCXX_3.4.1
GLIBCXX_3.4.2
GLIBCXX_3.4.3
GLIBCXX_3.4.4
GLIBCXX_3.4.5
GLIBCXX_3.4.6
GLIBCXX_3.4.7
GLIBCXX_3.4.8
GLIBCXX_3.4.9
GLIBCXX_3.4.10
GLIBCXX_3.4.11
GLIBCXX_3.4.12
GLIBCXX_3.4.13
GLIBCXX_3.4.14
GLIBCXX_3.4.15
GLIBCXX_3.4.16
GLIBCXX_3.4.17
GLIBCXX_3.4.18
GLIBCXX_3.4.19
GLIBCXX_3.4.20
GLIBCXX_3.4.21
GLIBCXX_3.4.22
GLIBCXX_3.4.23
GLIBCXX_3.4.24
GLIBCXX_3.4.25
GLIBCXX_3.4.26
GLIBCXX_3.4.27
GLIBCXX_3.4.28
GLIBCXX_3.4.29
GLIBCXX_3.4.30
GLIBCXX_DEBUG_MESSAGE_LENGTH

jokay avatar Oct 07 '24 07:10 jokay