[Bug 578053] New: 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#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.
http://bugzilla.novell.com/show_bug.cgi?id=578053
http://bugzilla.novell.com/show_bug.cgi?id=578053#c
yang xiaoyu
http://bugzilla.novell.com/show_bug.cgi?id=578053
http://bugzilla.novell.com/show_bug.cgi?id=578053#c1
Reinhard Max
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.
http://bugzilla.novell.com/show_bug.cgi?id=578053
http://bugzilla.novell.com/show_bug.cgi?id=578053#c2
Reinhard Max
http://bugzilla.novell.com/show_bug.cgi?id=578053
http://bugzilla.novell.com/show_bug.cgi?id=578053#c3
--- Comment #3 from Joshua Tolley
https://bugzilla.novell.com/show_bug.cgi?id=578053
https://bugzilla.novell.com/show_bug.cgi?id=578053#c4
Thomas Zimmermann
https://bugzilla.novell.com/show_bug.cgi?id=578053
https://bugzilla.novell.com/show_bug.cgi?id=578053#c
zj jia
https://bugzilla.novell.com/show_bug.cgi?id=578053
https://bugzilla.novell.com/show_bug.cgi?id=578053#c5
Reinhard Max
https://bugzilla.novell.com/show_bug.cgi?id=578053
https://bugzilla.novell.com/show_bug.cgi?id=578053#c6
Reinhard Max
https://bugzilla.novell.com/show_bug.cgi?id=578053
https://bugzilla.novell.com/show_bug.cgi?id=578053#c7
Reinhard Max
http://bugzilla.novell.com/show_bug.cgi?id=578053
SMASH SMASH
http://bugzilla.novell.com/show_bug.cgi?id=578053
Swamp Workflow Management
http://bugzilla.novell.com/show_bug.cgi?id=578053
Swamp Workflow Management
http://bugzilla.novell.com/show_bug.cgi?id=578053
Swamp Workflow Management
http://bugzilla.novell.com/show_bug.cgi?id=578053
http://bugzilla.novell.com/show_bug.cgi?id=578053#c11
--- Comment #11 from Swamp Workflow Management
http://bugzilla.novell.com/show_bug.cgi?id=578053
Swamp Workflow Management
http://bugzilla.novell.com/show_bug.cgi?id=578053
http://bugzilla.novell.com/show_bug.cgi?id=578053#c12
--- Comment #12 from Swamp Workflow Management
http://bugzilla.novell.com/show_bug.cgi?id=578053
Swamp Workflow Management
participants (1)
-
bugzilla_noreply@novell.com