Search Postgresql Archives

Re: orafce error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





po 22. 4. 2019 v 13:21 odesílatel Prakash Ramakrishnan <prakash.ramakrishnan.ap@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux