Bugzilla – Bug 1216022
missing /usr/bin/ecpg from postgresql15-devel
Last modified: 2024-01-15 20:30:01 UTC
output of rpm -ql postgresql15-devel: /usr/bin/ecpg /usr/include/pgsql /usr/include/pgsql/ecpg_config.h … output of ls /usr/bin/ec*: /usr/bin/echo
/usr/bin/ecpg is a symlink that gets handled by the update-alternatives mechanism. By default this mechanism selects the highest installed version of PostgreSQL, which would currently be postgresql16, if you have it installed. If the devel package for the selected version is not installed there is no ecpg symlink (same for the binaries that come with other postgresqlXX subpackages for the respective versions). To solve that you can either manually call (as root): update-alternatives --set postgresql /usr/lib/postgresql15 ... or make sure that no postgresql16 packages are installed. But if you are not bound to version 15 for other reasons I would suggest to migrate to version 16 and leave update-alternatives at its defaults.
I did install postgresql, which recommends postgresql15. A zypper se postgresql reveals: postgresql10 to postgresql15 are in database, but no postgresql16.
Ah, indeed, you are on Leap, which does not yet have postgresql16. Sorry for the confusion. In that case I think something went wrong with the automatic alternative selection. For further analysis please post the output of the following two commands: update-alternatives --query postgresql | grep -E 'Status|Best|Value' rpm -qa | grep postgresql | sort
update-alternatives --query postgreql | grep -e 'Status\|Best\|Value': update-alternatives: error: no alternatives for postgreql rpm -qa | grep -e postgresql | sort: postgresql-15-150500.8.19.noarch postgresql15-15.4-150200.5.12.1.x86_64 postgresql15-devel-15.4-150200.5.12.1.x86_64 postgresql15-docs-15.4-150200.5.12.1.noarch postgresql15-llvmjit-15.4-150200.5.12.1.x86_64 postgresql15-plpython-15.4-150200.5.12.1.x86_64 postgresql15-server-15.4-150200.5.12.1.x86_64 postgresql-devel-15-150500.8.19.noarch postgresql-docs-15-150500.8.19.noarch postgresql-llvmjit-15-150500.8.19.noarch postgresql-plpython-15-150500.8.19.noarch postgresql-server-15-150500.8.19.noarch
output of ltrace update-alternatives --query postgreql: setlocale(LC_ALL, "") = "de_DE.UTF-8" bindtextdomain("dpkg", "/usr/share/locale") = "/usr/share/locale" textdomain("dpkg") = "dpkg" getenv("RPM_ADMINDIR") = nil __vasprintf_chk(0x7ffd27b4fdd0, 1, 0x55786ce07a28, 0x7ffd27b4fdf0) = 21 setvbuf(0x7fc93849c500, nil, 2, 0) = 0 strcmp("--query", "--query") = 0 malloc(64) = 0x55786dcb3630 strdup("postgreql") = 0x55786dcb3680 strpbrk(0x55786dcb3680, 0x55786ce07b4d, 0x6c7165, 0x7165726774736f70) = 0 strcmp("query", "set") = -2 strcmp("query", "install") = 8 strcmp("query", "auto") = 16 strcmp("query", "config") = 14 strcmp("query", "remove") = -1 strcmp("query", "remove-all") = -1 strcmp("query", "all") = 16 strcmp("query", "set-selections") = -2 strcmp("query", "display") = 13 strcmp("query", "query") = 0 _setjmp(0x7ffd27b4fdc0, 2, 5, 0) = 0 __vasprintf_chk(0x7ffd27b4fbd0, 1, 0x55786ce07a28, 0x7ffd27b4fbf0) = 31 fopen("/var/lib/alternatives/postgreql", "r") = nil __errno_location() = 0x7fc9384cb6c0 dcgettext(nil, "no alternatives for %s", 5) = "no alternatives for %s" dcgettext(nil, "error", 5) = "error" __fprintf_chk(0x7fc93849c420, 1, 0x55786ce07951, 0x55786ce07934update-alternatives: error: ) = 28 __vfprintf_chk(0x7fc93849c420, 1, 0x55786ce07feb, 0x7ffd27b4fdf0no alternatives for postgreql) = 29 fputc('\n', 0x7fc93849c420 ) = 10 exit(2 <no return ...> +++ exited (status 2) +++ output of ls -l /var/lib/alternatives/postgreql: ls: Zugriff auf '/var/lib/alternatives/postgreql' nicht möglich: Datei oder Verzeichnis nicht gefunden output of ls -l /var/lib/alternatives/postgresql: -rw-r--r-- 1 root root 1791 20. Aug 14:50 /var/lib/alternatives/postgresql Somwhere a "s" took the wrong turn...
Next Try: update-alternatives --query postgresql | grep -e 'Status\|Best\|Value': Status: auto Best: /usr/lib/postgresql15 Value: /usr/lib/postgresql15 update-alternatives --query postgresql-devel | grep -e 'Status\|Best\|Value' update-alternatives: error: no alternatives for postgresql-devel rpm -qif /usr/bin/ecpg: Name : postgresql15-devel Version : 15.4 Release : 150200.5.12.1 Architecture: x86_64 Install Date: Sa 07 Okt 2023 13:46:05 CEST Group : Development/Libraries/C and C++ Size : 1478581 License : PostgreSQL Signature : RSA/SHA256, Mi 09 Aug 2023 16:49:26 CEST, Key ID 70af9e8139db7c82 Source RPM : postgresql15-15.4-150200.5.12.1.src.rpm Build Date : Mi 09 Aug 2023 16:34:43 CEST Build Host : sheep63 Relocations : (not relocatable) Packager : https://www.suse.com/ Vendor : SUSE LLC <https://www.suse.com/> URL : https://www.postgresql.org/ Summary : PostgreSQL client development header files and libraries Description : PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the header files and libraries needed to compile C applications which will directly interact with a PostgreSQL database management server and the ECPG Embedded C Postgres preprocessor. You need to install this package if you want to develop applications in C which will interact with a PostgreSQL server. For building PostgreSQL server extensions, see the postgresql15-server-devel package. Distribution: SUSE Linux Enterprise 15 ls -l /usr/bin/ecpg: ls: Zugriff auf '/usr/bin/ecpg' nicht möglich: Datei oder Verzeichnis nicht gefunden
(In reply to Quirin Blaeser from comment #5) > Somwhere a "s" took the wrong turn... Yep, I was juat about to tell you... But I think I found the reason for the missing ecpg symlink: All postgresqlXX packges that contain binary executables call /usr/share/postgresql/install-alternatives (contained in the postgresql base package) to register themselves with the alternatives mechanism, except for postgresqlXX-devel, which means that the symlink for ecpg will be missing if that package happens to get installed as the last of all postgresqlXX subpackages. As a workaround you can call the following command which should create the symlink: /usr/share/postgresql/install-alternatives 15 I'll have a look at the package and fix it in the next maintenance update.
(In reply to Reinhard Max from comment #7) > (In reply to Quirin Blaeser from comment #5) > > Somwhere a "s" took the wrong turn... > > Yep, I was juat about to tell you... Hmm, here -----^ as well. ;)
BTW, there is no postgresql-devel (or other sub-names) in the alternatives mechanis. The postgresql symbol covers them all, because it makes no sense to have different binaries from different versions active at the same time.
This is an autogenerated message for OBS integration: This bug (1216022) was mentioned in https://build.opensuse.org/request/show/1120248 Factory / postgresql16 https://build.opensuse.org/request/show/1120249 Factory / postgresql15 https://build.opensuse.org/request/show/1120251 Factory / postgresql14 https://build.opensuse.org/request/show/1120252 Factory / postgresql13 https://build.opensuse.org/request/show/1120253 Factory / postgresql12
I'll revert this change and instead take ecpg completely out of the alternatives mechanism, so that the devel package can be installed without requiring any other subpackage (except for the libraries).
This is an autogenerated message for OBS integration: This bug (1216022) was mentioned in https://build.opensuse.org/request/show/1121438 Factory / postgresql11
The fix will be contained in the upcoming updates.
SUSE-SU-2023:4418-1: An update that solves three vulnerabilities and has two security fixes can now be installed. Category: security (important) Bug References: 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Sources used: SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql14-14.10-3.33.1 SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql14-14.10-3.33.1 SUSE Linux Enterprise Server 12 SP5 (src): postgresql14-14.10-3.33.1 SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql14-14.10-3.33.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2023:4425-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed. Category: security (important) Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Jira References: PED-5586 Sources used: SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2 SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2 SUSE Linux Enterprise Server 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2 SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2023:4434-1: An update that solves three vulnerabilities and has two security fixes can now be installed. Category: security (important) Bug References: 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Sources used: SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql13-13.13-3.43.1 SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql13-13.13-3.43.1 SUSE Linux Enterprise Server 12 SP5 (src): postgresql13-13.13-3.43.1 SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql13-13.13-3.43.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2023:4433-1: An update that solves three vulnerabilities and has two security fixes can now be installed. Category: security (important) Bug References: 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Sources used: SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql12-12.17-3.49.1 SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql12-12.17-3.49.1 SUSE Linux Enterprise Server 12 SP5 (src): postgresql12-12.17-3.49.1 SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql12-12.17-3.49.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2023:4455-1: An update that solves three vulnerabilities and has two security fixes can now be installed. Category: security (important) Bug References: 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Sources used: openSUSE Leap 15.4 (src): postgresql13-13.13-150200.5.50.1 openSUSE Leap 15.5 (src): postgresql13-13.13-150200.5.50.1 Legacy Module 15-SP4 (src): postgresql13-13.13-150200.5.50.1 SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql13-13.13-150200.5.50.1 SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql13-13.13-150200.5.50.1 SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql13-13.13-150200.5.50.1 SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql13-13.13-150200.5.50.1 SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql13-13.13-150200.5.50.1 Galera for Ericsson 15 SP5 (src): postgresql13-13.13-150200.5.50.1 SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql13-13.13-150200.5.50.1 SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql13-13.13-150200.5.50.1 SUSE Enterprise Storage 7.1 (src): postgresql13-13.13-150200.5.50.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2023:4454-1: An update that solves three vulnerabilities and has two security fixes can now be installed. Category: security (important) Bug References: 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Sources used: openSUSE Leap 15.4 (src): postgresql12-12.17-150200.8.54.1 openSUSE Leap 15.5 (src): postgresql12-12.17-150200.8.54.1 SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql12-12.17-150200.8.54.1 SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql12-12.17-150200.8.54.1 SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql12-12.17-150200.8.54.1 SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql12-12.17-150200.8.54.1 SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql12-12.17-150200.8.54.1 SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql12-12.17-150200.8.54.1 SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql12-12.17-150200.8.54.1 SUSE Enterprise Storage 7.1 (src): postgresql12-12.17-150200.8.54.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2023:4479-1: An update that solves three vulnerabilities and has two security fixes can now be installed. Category: security (important) Bug References: 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Sources used: SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql14-14.10-150200.5.36.1 SUSE Enterprise Storage 7.1 (src): postgresql14-14.10-150200.5.36.1 openSUSE Leap 15.4 (src): postgresql14-14.10-150200.5.36.1 openSUSE Leap 15.5 (src): postgresql14-14.10-150200.5.36.1 Basesystem Module 15-SP4 (src): postgresql14-14.10-150200.5.36.1 Legacy Module 15-SP5 (src): postgresql14-14.10-150200.5.36.1 SUSE Package Hub 15 15-SP4 (src): postgresql14-14.10-150200.5.36.1 SUSE Package Hub 15 15-SP5 (src): postgresql14-14.10-150200.5.36.1 Server Applications Module 15-SP4 (src): postgresql14-14.10-150200.5.36.1 SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql14-14.10-150200.5.36.1 SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql14-14.10-150200.5.36.1 SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql14-14.10-150200.5.36.1 SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql14-14.10-150200.5.36.1 SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql14-14.10-150200.5.36.1 SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql14-14.10-150200.5.36.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2023:4495-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed. Category: security (important) Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Jira References: PED-5586 Sources used: openSUSE Leap 15.3 (src): postgresql-16-150300.10.18.3 openSUSE Leap 15.4 (src): postgresql-16-150400.4.9.2, postgresql16-mini-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 openSUSE Leap 15.5 (src): postgresql-16-150500.10.3.2, postgresql16-mini-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 Basesystem Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 Basesystem Module 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 Legacy Module 15-SP4 (src): postgresql-16-150400.4.9.2 Legacy Module 15-SP5 (src): postgresql-16-150500.10.3.2 SUSE Package Hub 15 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 SUSE Package Hub 15 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql16-16.1-150200.5.7.1 Server Applications Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 Server Applications Module 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1 SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3 SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3 SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1 SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3 SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1 SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3 SUSE Enterprise Storage 7.1 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
SUSE-SU-2024:0106-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed. Category: security (important) Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962 CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870 Jira References: PED-5586 Sources used: Basesystem Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 Basesystem Module 15-SP5 (src): postgresql16-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql-16-150500.10.3.2 Legacy Module 15-SP4 (src): postgresql-16-150400.4.9.2 Legacy Module 15-SP5 (src): postgresql-16-150500.10.3.2 SUSE Package Hub 15 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 Server Applications Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 Server Applications Module 15-SP5 (src): postgresql16-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql-16-150500.10.3.2 SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql-16-150300.10.18.3, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1 NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.