Re: orafce error

po 22. 4. 2019 v 13:21 odesílatel Prakash Ramakrishnan <
prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> napsal:

>
> Hi Team,
>
> While am creating the orafce extension we are getting below error.
>
> ==> ll
> total 728
> -rw-r--r--. 1 postgres postgres 7863 Mar 27 18:54 aggregate.c
> -rw-r--r--. 1 postgres postgres 21826 Mar 27 18:54 alert.c
> -rw-r--r--. 1 postgres postgres 9234 Mar 27 18:54 assert.c
> -rw-r--r--. 1 postgres postgres 390 Mar 27 18:54 assert.h
> -rw-r--r--. 1 postgres postgres 14618 Mar 27 18:54 builtins.h
> -rw-r--r--. 1 postgres postgres 915 Mar 27 18:54 charlen.c
> -rw-r--r--. 1 postgres postgres 10205 Mar 27 18:54 charpad.c
> -rw-r--r--. 1 postgres postgres 9863 Mar 27 18:54 convert.c
> -rw-r--r--. 1 postgres postgres 987 Mar 27 18:54 COPYRIGHT.orafce
> -rw-r--r--. 1 postgres postgres 23179 Mar 27 18:54 datefce.c
> drwxr-xr-x. 4 postgres postgres 53 Mar 27 18:54 doc
> drwxr-xr-x. 2 postgres postgres 4096 Mar 27 18:54 expected
> -rw-r--r--. 1 postgres postgres 25400 Mar 27 18:54 file.c
> -rw-r--r--. 1 postgres postgres 874 Mar 27 18:54 INSTALL.orafce
> -rw-r--r--. 1 postgres postgres 88 Mar 27 18:54 magic.c
> -rw-r--r--. 1 postgres postgres 1851 Mar 27 18:54 Makefile
> -rw-r--r--. 1 postgres postgres 1493 Mar 27 18:54 META.json
> drwxr-xr-x. 2 postgres postgres 88 Mar 27 18:54 msvc
> -rw-r--r--. 1 postgres postgres 1584 Mar 27 18:54 NEWS
> -rw-r--r--. 1 postgres postgres 4949 Mar 27 18:54 nvarchar2.c
> -rw-r--r--. 1 postgres postgres 2900 Mar 27 18:54 orafce--3.2--3.3.sql
> -rw-r--r--. 1 postgres postgres 365 Mar 27 18:54 orafce--3.3--3.4.sql
> -rw-r--r--. 1 postgres postgres 287 Mar 27 18:54 orafce--3.4--3.5.sql
> -rw-r--r--. 1 postgres postgres 7339 Mar 27 18:54 orafce--3.5--3.6.sql
> -rw-r--r--. 1 postgres postgres 1684 Mar 27 18:54 orafce--3.6--3.7.sql
> -rw-r--r--. 1 postgres postgres 538 Mar 27 18:54 orafce--3.7--3.8.sql
> -rw-r--r--. 1 postgres postgres 109269 Mar 27 18:54 orafce--3.8.sql
> -rw-r--r--. 1 postgres postgres 1211 Mar 27 18:54 orafce.c
> -rw-r--r--. 1 postgres postgres 204 Mar 27 18:54 orafce.control
> -rw-r--r--. 1 postgres postgres 1267 Mar 27 18:54 orafce.h
> -rw-r--r--. 1 postgres postgres 11206 Mar 27 18:54 others.c
> -rw-r--r--. 1 postgres postgres 126 Mar 27 18:54 parallel_schedule
> -rw-r--r--. 1 postgres postgres 881 Mar 27 18:54 parse_keyword.c
> -rw-r--r--. 1 postgres postgres 73 Mar 27 18:54 parse_keyword.h
> -rw-r--r--. 1 postgres postgres 27787 Mar 27 18:54 pipe.c
> -rw-r--r--. 1 postgres postgres 1242 Mar 27 18:54 pipe.h
> -rw-r--r--. 1 postgres postgres 12230 Mar 27 18:54 plunit.c
> -rw-r--r--. 1 postgres postgres 21366 Mar 27 18:54 plvdate.c
> -rw-r--r--. 1 postgres postgres 6840 Mar 27 18:54 plvlex.c
> -rw-r--r--. 1 postgres postgres 148 Mar 27 18:54 plvlex.h
> -rw-r--r--. 1 postgres postgres 27773 Mar 27 18:54 plvstr.c
> -rw-r--r--. 1 postgres postgres 5843 Mar 27 18:54 plvsubst.c
> -rw-r--r--. 1 postgres postgres 7141 Mar 27 18:54 putline.c
> -rw-r--r--. 1 postgres postgres 7853 Mar 27 18:54 random.c
> -rw-r--r--. 1 postgres postgres 31928 Mar 27 18:54 README.asciidoc
> -rw-r--r--. 1 postgres postgres 7011 Mar 27 18:54 shmmc.c
> -rw-r--r--. 1 postgres postgres 328 Mar 27 18:54 shmmc.h
> drwxr-xr-x. 2 postgres postgres 4096 Mar 27 18:54 sql
> -rw-r--r--. 1 postgres postgres 52045 Mar 27 18:54 sqlparse.c
> -rw-r--r--. 1 postgres postgres 2883 Mar 27 18:54 sqlparse.h
> -rw-r--r--. 1 postgres postgres 2488 Mar 27 18:54 sqlparse.y
> -rw-r--r--. 1 postgres postgres 90136 Mar 27 18:54 sqlscan.c
> -rw-r--r--. 1 postgres postgres 27079 Mar 27 18:54 sqlscan.l
> -rw-r--r--. 1 postgres postgres 4105 Mar 27 18:54 utility.c
> -rw-r--r--. 1 postgres postgres 5742 Mar 27 18:54 varchar2.c
> postgres(at)hamrhenppp001(dot)enterprisenet(dot)org:
> /home/postgres/software/orafce-master
> ==> make
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o parse_keyword.o parse_keyword.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o convert.o convert.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o file.o file.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o datefce.o datefce.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o magic.o magic.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o others.o others.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o plvstr.o plvstr.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o plvdate.o plvdate.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o shmmc.o shmmc.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o plvsubst.o plvsubst.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o utility.o utility.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o sqlparse.o sqlparse.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o plvlex.o plvlex.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o alert.o alert.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include -c -o pipe.o pipe.c
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC -I. -I./ -I/usr/pgsql-11/include/server
> -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -*I/usr/include
> -c -o putline.o putline.c*
> *In file included from /usr/pgsql-11/include/server/libpq/libpq.h:20:0,*
> * from putline.c:10:*
> */usr/pgsql-11/include/server/libpq/libpq-be.h:23:25: fatal error:
> openssl/ssl.h: No such file or directory*
> * #include <openssl/ssl.h>*
> * ^*
> *compilation terminated.*
> *make: *** [putline.o] Error 1*
>
>
looks like you missing openssl devel files.

https://stackoverflow.com/questions/17915098/openssl-ssl-h-no-such-file-or-directory-during-installation-of-git

Regards

Pavel

> --
>
>
> Regards,
> Prakash.R
> Postgresql DBA
>