[Bug 578053] New: postgresql-plperl looks for libperl.so in the wrong place

newer
[Bug 902302] "yast2 samba-client...

older
[Bug 842979] VUL-0: CVE-2013-1739:...

bugzilla_noreply＠novell.com

8 Feb 2010 8 Feb '10

19:33

http://bugzilla.novell.com/show_bug.cgi?id=578053 http://bugzilla.novell.com/show_bug.cgi?id=578053#c0 Summary: postgresql-plperl looks for libperl.so in the wrong place Classification: openSUSE Product: openSUSE 11.3 Version: Factory Platform: All OS/Version: openSUSE 11.3 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: eggyknap@gmail.com QAContact: qa@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/532.8 (KHTML, like Gecko) Chrome/4.0.299.0 Safari/532.8 On a completely new openSUSE 11.3 machine, I installed the postgresql-server, postgresql, and postgresql-plperl packages. After starting PostgreSQL and letting it initialize a new database, I sudo-d to the postgres user, and tried to add the PL/Perl language, as follows, with the error below: postgres@linux-e16r:~> createlang plperl createlang: language installation failed: ERROR: could not load library "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory libperl.so lives in /usr/lib/perl5/5.10.0/i586-linux-thread-multi/CORE/libperl.so. Creating a symlink at /usr/lib/libperl.so to the installed libperl.so binary works around the problem. This also exists in at least one of the 10.x versions, though I don't have access to the servers to know the precise version(s) As a secondary note, the description of the postgresql-plperl package, at least as it appears in YaST2, says the package also includes PL/Tcl and PL/Python. This is incorrect. Thirdly, the documentation also claims "PostgreSQL also offers the builtin procedural language PL/SQL". This is also incorrect -- PL/SQL is an Oracle-specific language. PostgreSQL offers PL/pgSQL, which fact might be worth noting in the PL/Perl documentation, or it might not. Reproducible: Always Steps to Reproduce: 1.install postgresql, postgresql-server, and postgresql-plperl 2.start postgresql (/etc/init.d/postgresql start) 3.become the postgres user (sudo su - postgres) 4.create the plperl language in the default database: createlang plperl Actual Results: # createlang plperl createlang: language installation failed: ERROR: could not load library "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory Expected Results: createlang should have no output, and a 0 exit status I realize this is a packaging bug, and likely not something distributed by Novell directly. I saw nowhere else to file the bug. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

Show replies by date

bugzilla_noreply＠novell.com

9 Feb 9 Feb

02:28

New subject: [Bug 578053] postgresql-plperl looks for libperl.so in the wrong place

http://bugzilla.novell.com/show_bug.cgi?id=578053 http://bugzilla.novell.com/show_bug.cgi?id=578053#c yang xiaoyu changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |xyyang@novell.com AssignedTo|bnc-team-screening@forge.pr |max@novell.com |ovo.novell.com | -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

09:42

New subject: [Bug 578053] postgresql-plperl looks for libperl.so in the wrong place

http://bugzilla.novell.com/show_bug.cgi?id=578053 http://bugzilla.novell.com/show_bug.cgi?id=578053#c1 Reinhard Max changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P4 - Low Status|NEW |ASSIGNED --- Comment #1 from Reinhard Max 2010-02-09 10:42:55 CET --- (In reply to comment #0)

...

postgres@linux-e16r:~> createlang plperl createlang: language installation failed: ERROR: could not load library "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory

I'll check that.

...

As a secondary note, the description of the postgresql-plperl package, at least as it appears in YaST2, says the package also includes PL/Tcl and PL/Python. This is incorrect.

This is a leftover from the times when all three modules lived in a single package. The description of the other two was adjusted, but it look like I missed PL/Perl.

...

Thirdly, the documentation also claims "PostgreSQL also offers the builtin procedural language PL/SQL". This is also incorrect -- PL/SQL is an Oracle-specific language. PostgreSQL offers PL/pgSQL, which fact might be worth noting in the PL/Perl documentation, or it might not.

Whoops for the wrong name, I'll fix that. The mentioning in the package description also dates back to the time when PL/Perl, PL/Tcl and PL/Python came as a single package called postgresql-pl and was added so that people know that this package is not needed if all they want is PL/pgSQL. I'll leave that note in the desctiption of the postgresql-pl source package, but remove it from the language-speciffic subpackages.

...

I realize this is a packaging bug, and likely not something distributed by Novell directly. I saw nowhere else to file the bug.

Well, we do the packaging, so this is exactly the right place to complain. ;) -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.