Thread: Please help for error ( file is required for XML support )

Please help for error ( file is required for XML support )

From
Sachin Khanna
Date:

Hi

 

I am new to postgreSQL , I am trying to install the same with XML support but it is giving below error on configuration.

 

./configure --prefix=/opt/postgresql-12.3/pqsql --with-libxml --datadir=/home/postgres/ --with-includes=/usr/lib64/

 

checking for libxml/parser.h... no

configure: error: header file <libxml/parser.h> is required for XML support

 

 

 

I am using below RHEL flavor and have installed below xml package for support

 

  Operating System: Red Hat Enterprise Linux Server 7.9 Beta (Maipo)

       CPE OS Name: cpe:/o:redhat:enterprise_linux:7.9:beta:server

            Kernel: Linux 3.10.0-1136.el7.ppc64le

      Architecture: ppc64-le

 

 

rpm -qi libxml2-2.9.1-6.el7.4.ppc64le

Name        : libxml2

Version     : 2.9.1

Release     : 6.el7.4

Architecture: ppc64le

Install Date: Thu 09 Jul 2020 02:55:33 PM CDT

Group       : Development/Libraries

Size        : 2594518

License     : MIT

Signature   : RSA/SHA256, Tue 26 Nov 2019 08:05:06 AM CST, Key ID 199e2f91fd431d51

Source RPM  : libxml2-2.9.1-6.el7.4.src.rpm

Build Date  : Tue 26 Nov 2019 07:21:34 AM CST

Build Host  : ppc-029.build.eng.bos.redhat.com

Relocations : (not relocatable)

Packager    : Red Hat, Inc. <http://bugzilla.redhat.com/bugzilla>

Vendor      : Red Hat, Inc.

URL         : http://xmlsoft.org/

Summary     : Library providing XML and HTML support

Description :

This library allows to manipulate XML files. It includes support

to read, modify and write XML and HTML files. There is DTDs support

this includes parsing and validation even with complex DtDs, either

at parse time or later once the document has been modified. The output

can be a simple SAX stream or and in-memory DOM like representations.

In this case one can use the built-in XPath and XPointer implementation

to select sub nodes or ranges. A flexible Input/Output mechanism is

available, with existing HTTP and FTP modules and combined to an

URI library.

 

 

ls -ltr /usr/lib64/ | grep -i xml

-rwxr-xr-x.  1 root root    68528 May 19  2015 libxmlrpc_util.so.3.32

-rwxr-xr-x.  1 root root   136488 May 19  2015 libxmlrpc.so.3.32

-rwxr-xr-x.  1 root root    68488 May 19  2015 libxmlrpc_server.so.3.32

-rwxr-xr-x.  1 root root    68336 May 19  2015 libxmlrpc_server_cgi.so.3.32

-rwxr-xr-x.  1 root root    68416 May 19  2015 libxmlrpc_server_abyss.so.3.32

-rwxr-xr-x.  1 root root    69720 May 19  2015 libxmlrpc_client.so.3.32

-rwxr-xr-x.  1 root root   138240 May 19  2015 libxmlrpc_abyss.so.3.32

-rwxr-xr-x.  1 root root  2271136 Nov 26  2019 libxml2.so.2.9.1

-rwxr-xr-x.  1 root root   403952 Dec  6  2019 libQtXml.so.4.8.7

-rwxr-xr-x.  1 root root  5621696 Dec  6  2019 libQtXmlPatterns.so.4.8.7

-rwxr-xr-x.  1 root root   336816 Feb 19  2020 libQt5Xml.so.5.9.7

lrwxrwxrwx.  1 root root       16 Jul  9 14:55 libxml2.so.2 -> libxml2.so.2.9.1

lrwxrwxrwx.  1 root root       17 Jul  9 14:55 libxmlrpc.so.3 -> libxmlrpc.so.3.32

lrwxrwxrwx.  1 root root       23 Jul  9 14:55 libxmlrpc_abyss.so.3 -> libxmlrpc_abyss.so.3.32

lrwxrwxrwx.  1 root root       22 Jul  9 14:55 libxmlrpc_util.so.3 -> libxmlrpc_util.so.3.32

lrwxrwxrwx.  1 root root       24 Jul  9 14:55 libxmlrpc_server.so.3 -> libxmlrpc_server.so.3.32

lrwxrwxrwx.  1 root root       28 Jul  9 14:55 libxmlrpc_server_cgi.so.3 -> libxmlrpc_server_cgi.so.3.32

lrwxrwxrwx.  1 root root       30 Jul  9 14:55 libxmlrpc_server_abyss.so.3 -> libxmlrpc_server_abyss.so.3.32

lrwxrwxrwx.  1 root root       24 Jul  9 14:56 libxmlrpc_client.so.3 -> libxmlrpc_client.so.3.32

lrwxrwxrwx.  1 root root       18 Jul  9 14:56 libQt5Xml.so.5.9 -> libQt5Xml.so.5.9.7

lrwxrwxrwx.  1 root root       18 Jul  9 14:56 libQt5Xml.so.5 -> libQt5Xml.so.5.9.7

lrwxrwxrwx.  1 root root       17 Jul 21 15:51 libQtXml.so.4.8 -> libQtXml.so.4.8.7

lrwxrwxrwx.  1 root root       17 Jul 21 15:51 libQtXml.so.4 -> libQtXml.so.4.8.7

lrwxrwxrwx.  1 root root       25 Jul 21 15:51 libQtXmlPatterns.so.4.8 -> libQtXmlPatterns.so.4.8.7

lrwxrwxrwx.  1 root root       25 Jul 21 15:51 libQtXmlPatterns.so.4 -> libQtXmlPatterns.so.4.8.7

lrwxrwxrwx.  1 root root       27 Aug 27 02:52 libxml2.so -> /usr/lib64/libxml2.so.2.9.1

 

 

Thanks and Regards,
SACHIN KHANNA
212 BASIS DBA TEAM OFFSHORE

Office : 204058624
Cell : 9049522511
Email: sachin.khanna@sysco.com

Infosys Technologies Limited ® | PUNE

 

Re: Please help for error ( file is required for XML support )

From
Ashutosh Sharma
Date:
On Thu, Aug 27, 2020 at 6:30 PM Sachin Khanna <Sachin_Khanna@infosys.com> wrote:
>
> Hi
>
>
>
> I am new to postgreSQL , I am trying to install the same with XML support but it is giving below error on
configuration.
>
>
>
> ./configure --prefix=/opt/postgresql-12.3/pqsql --with-libxml --datadir=/home/postgres/ --with-includes=/usr/lib64/
>

It seems like your include path is pointing to  "/usr/lib64/" which
basically contains the libraries and not the header files, I guess. To
include libraries you should be using --with-libraries option.

Also, I feel that these types of questions are not for hackers
mailing-list. These are configuration related issues and should
probably be raised in pgsql-general mailing list
(pgsql-general.postgresql.org).

-- 
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com