Installing orafce fails

[Bruce Johnson]

Environment:

Rocky Linux release 8.8

Postgres15 installed via dnf per official Postgres repo https://www.postgresql.org/download/linux/redhat/#yum

cloned the orafce.git locally

followed the directions :

make

make install

and get the error:

# make
Makefile:94: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target '/contrib/contrib-global.mk'.  Stop.

it is referenced as $(topsrcdir)/contrib/contrib-global.mk 

contrib-global.mk doesn't exist on the system, so I"m guessing I"m missing some -devel package or something?

(I get the same result if I do

export NO_PGXS=1

before running make

[Pavel Stehule]

čt 10. 8. 2023 v 6:02 odesílatel Bruce Johnson <joh...@pharmacy.arizona.edu> napsal:

Environment:

Rocky Linux release 8.8

Postgres15 installed via dnf per official Postgres repo https://www.postgresql.org/download/linux/redhat/#yum

cloned the orafce.git locally

followed the directions :

make

make install

and get the error:

# make
Makefile:94: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target '/contrib/contrib-global.mk'.  Stop.

it is referenced as $(topsrcdir)/contrib/contrib-global.mk 

contrib-global.mk doesn't exist on the system, so I"m guessing I"m missing some -devel package or something?

yes, you miss postgresql server devel package

 https://www.percona.com/blog/postgresql-simple-c-extension-development-for-a-novice-user/

(I get the same result if I do

export NO_PGXS=1

before running make

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/ff61f348-d123-4528-83d0-58a85200bb5en%40googlegroups.com.

[Johnson, Bruce E - (bjohnson)]

On Aug 9, 2023, at 9:08 PM, Pavel Stehule <pavel....@gmail.com> wrote:

External Email

čt 10. 8. 2023 v 6:02 odesílatel Bruce Johnson <joh...@pharmacy.arizona.edu> napsal:

Environment:

Rocky Linux release 8.8

Postgres15 installed via dnf per official Postgres repo https://www.postgresql.org/download/linux/redhat/#yum

cloned the orafce.git locally

followed the directions :

make

make install

and get the error:

# make
Makefile:94: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target '/contrib/contrib-global.mk'.  Stop.

it is referenced as $(topsrcdir)/contrib/contrib-global.mk 

contrib-global.mk doesn't exist on the system, so I"m guessing I"m missing some -devel package or something?

yes, you miss postgresql server devel package

 https://www.percona.com/blog/postgresql-simple-c-extension-development-for-a-novice-user/

The devel package was installed, but the $PATH was not set properly. Once set it worked.

Thank you!

As an aside, trying to run dnf install postgreql15-devel on this system fails because of a requirement for perl(IPC::Run) which isn’t in the enabled repos:

repo id              repo name

appstream            Rocky Linux 8 - AppStream

baseos               Rocky Linux 8 - BaseOS

epel                 Extra Packages for Enterprise Linux 8 - x86_64

extras               Rocky Linux 8 - Extras

pgdg-common          PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64

pgdg11               PostgreSQL 11 for RHEL / Rocky 8 - x86_64

pgdg12               PostgreSQL 12 for RHEL / Rocky 8 - x86_64

pgdg13               PostgreSQL 13 for RHEL / Rocky 8 - x86_64

pgdg14               PostgreSQL 14 for RHEL / Rocky 8 - x86_64

pgdg15               PostgreSQL 15 for RHEL / Rocky 8 - x86_64

For Rocky Linux it requires either the Rocky Linux Development or the Rocky LinuxPowerTools repos  be enabled.

We haven’t need to install either of those repositories for any of our linux systems most of which run RL8. Since I was in hack mode yesterday trying to get it to work I just installed it via cpan and used rpm rebuild to remove the requirement :/ Didn’t think to look on pkgs.org until this morning..

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs

[Pavel Stehule]

čt 10. 8. 2023 v 18:10 odesílatel Johnson, Bruce E - (bjohnson) <Joh...@pharmacy.arizona.edu> napsal:

you can write notice to https://github.com/orafce/orafce/blob/master/README.asciidoc and send me pull request

Regards

Pavel

 

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/FF55544B-9250-492D-BAB8-5A7B440A5BFF%40arizona.edu.