PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

Started by Hanan Breneralmost 10 years ago5 messagesgeneral

hbrener@allot.com

almost 10 years ago

Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8
and get from https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html - plruby libraries(postgresql-plruby-0.5.3-4.el6.x86_64).
Additional installed postgresql95-libs (postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)
Trying add plruby to PostgreSQL -
create function plruby_call_handler() returns language_handler
as '/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so'
language 'c';
The follows error appears - could not load library "/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so": /usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so: undefined symbol: FunctionCall3
Add libraries path to LD_LIBRARY+PATH environment variable, recreating ld .so.cache doesn't change result - the same error appears.

What could be a problem!?
Thanks in advance for any replies or tips how it could be done...
Hanan Brener

Database and Data Collection Team Leader

Allot Communications

Tom Lane

tgl@sss.pgh.pa.us

almost 10 years ago

In reply to: Hanan Brener (#1)

Re: PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

Hanan Brener <hbrener@allot.com> writes:

Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8
and get from https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html - plruby libraries(postgresql-plruby-0.5.3-4.el6.x86_64).
Additional installed postgresql95-libs (postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)
Trying add plruby to PostgreSQL -
create function plruby_call_handler() returns language_handler
as '/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so'
language 'c';
The follows error appears - could not load library "/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so": /usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so: undefined symbol: FunctionCall3

Seems like you've got a broken build of plruby there. FunctionCall3 has
been a macro, not a real function, for quite a long time. AFAICS this
error would only be possible if plruby had been compiled against postgres
header files from 9.0 or before, which would be a packaging mistake.
Suggest complaining to whoever the package builder is.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Adrian Klaver

adrian.klaver@aklaver.com

almost 10 years ago

In reply to: Hanan Brener (#1)

Re: PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

On 06/30/2016 09:24 AM, Hanan Brener wrote:

Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8

How did you install the Postgres server?

and get from
*https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html*

I would say where you install plruby from depends on where you installed
Postgres from.

FYI the Postgres community has repos:

https://www.postgresql.org/download/linux/redhat/

- *_plruby_* libraries(postgresql-plruby-0.5.3-4.el6.x86_64).

Additional installed postgresql95-libs
(postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)

Trying add plruby to PostgreSQL -

create function plruby_call_handler() returns language_handler

as '/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so'

language 'c';

The follows error appears - could not load library
"/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so":
/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so: undefined symbol:
FunctionCall3

Add libraries path to LD_LIBRARY+PATH environment variable, recreating
ld .so.cache doesn't change result ï¿½ the same error appears.

What could be a problem!?

Thanks in advance for any replies or tips how it could be done...

*Hanan Brener*

*Database and Data Collection Team Leader*

Allot Communications

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Hanan Brener

hbrener@allot.com

almost 10 years ago

In reply to: Adrian Klaver (#3)

Re: PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

The Postgresql server 9.5 installed from (www.enterprisedb.com/)

Hanan Brener
Database and Data Collection Team Leader
Allot Communications

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Thursday, June 30, 2016 7:47 PM
To: Hanan Brener <hbrener@allot.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

On 06/30/2016 09:24 AM, Hanan Brener wrote:

Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8

How did you install the Postgres server?

and get from
*https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x
86_64.rpm.html*

I would say where you install plruby from depends on where you installed Postgres from.

FYI the Postgres community has repos:

https://www.postgresql.org/download/linux/redhat/

- *_plruby_* libraries(postgresql-plruby-0.5.3-4.el6.x86_64).

Additional installed postgresql95-libs
(postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)

Trying add plruby to PostgreSQL -

create function plruby_call_handler() returns language_handler

as '/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so'

language 'c';

The follows error appears - could not load library
"/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so":
/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so: undefined symbol:
FunctionCall3

Add libraries path to LD_LIBRARY+PATH environment variable, recreating
ld .so.cache doesn't change result - the same error appears.

What could be a problem!?

Thanks in advance for any replies or tips how it could be done...

*Hanan Brener*

*Database and Data Collection Team Leader*

Allot Communications

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Adrian Klaver

adrian.klaver@aklaver.com

almost 10 years ago

In reply to: Hanan Brener (#4)

Re: PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

On 06/30/2016 10:08 AM, Hanan Brener wrote:

The Postgresql server 9.5 installed from (www.enterprisedb.com/)

I don't know how you would do that.

I saw(sort of) your post on the EDB forum:

http://forums.enterprisedb.com/jforum.page?module=search&action=search&forum=3&match_type=all&search_keywords=ruby

Clicking on the link yielded:

"The topic you are trying to see does not exist."

So you might want to try again there.

Hanan Brener
Database and Data Collection Team Leader
Allot Communications

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Thursday, June 30, 2016 7:47 PM
To: Hanan Brener <hbrener@allot.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

On 06/30/2016 09:24 AM, Hanan Brener wrote:

Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8

How did you install the Postgres server?

and get from
*https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x
86_64.rpm.html*

I would say where you install plruby from depends on where you installed Postgres from.

FYI the Postgres community has repos:

https://www.postgresql.org/download/linux/redhat/

- *_plruby_* libraries(postgresql-plruby-0.5.3-4.el6.x86_64).

Additional installed postgresql95-libs
(postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)

Trying add plruby to PostgreSQL -

create function plruby_call_handler() returns language_handler

as '/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so'

language 'c';

The follows error appears - could not load library
"/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so":
/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so: undefined symbol:
FunctionCall3

Add libraries path to LD_LIBRARY+PATH environment variable, recreating
ld .so.cache doesn't change result - the same error appears.

What could be a problem!?

Thanks in advance for any replies or tips how it could be done...

*Hanan Brener*

*Database and Data Collection Team Leader*

Allot Communications

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general