Re: [Libdbi-drivers-devel] compile sqlite3+libdbi-drivers on centos 5.9

[Markus H. <mar...@mh...>]

 

At 2015-05-08 03:33, Simon Tiong was heard to say: 

> On 8/5/2015 7:38 AM, mar...@mh... wrote: 
> 
>> Simon Tiong writes:
>>> Dear All,
>>> 
>>> I try to compile libdbi-drivers on centos 5.9 to work with sqlite3.Can 
>>> anyone advice me ? Below is the error message that i get.
>>> 
>>> 
>>> [root@localhost libdbi-drivers-0.9.0]# make
>>> make all-recursive
>>> make[1]: Entering directory `/root/libdbi-drivers-0.9.0'
>>> Making all in drivers
>>> make[2]: Entering directory `/root/libdbi-drivers-0.9.0/drivers'
>>> Making all in mysql
>>> make[3]: Entering directory `/root/libdbi-drivers-0.9.0/drivers/mysql'
>>> make[3]: Nothing to be done for `all'.
>>> make[3]: Leaving directory `/root/libdbi-drivers-0.9.0/drivers/mysql'
>>> Making all in pgsql
>>> make[3]: Entering directory `/root/libdbi-drivers-0.9.0/drivers/pgsql'
>>> make[3]: Nothing to be done for `all'.
>>> make[3]: Leaving directory `/root/libdbi-drivers-0.9.0/drivers/pgsql'
>>> Making all in sqlite
>>> make[3]: Entering directory `/root/libdbi-drivers-0.9.0/drivers/sqlite'
>>> make[3]: Nothing to be done for `all'.
>>> make[3]: Leaving directory `/root/libdbi-drivers-0.9.0/drivers/sqlite'
>>> Making all in sqlite3
>>> make[3]: Entering directory `/root/libdbi-drivers-0.9.0/drivers/sqlite3'
>>> /bin/sh ../../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. 
>>> -I../.. -I../.. -I../../include 
>>> -DDBDIR="/usr/local/var/lib/libdbi/sqlite3" -std=gnu99 -MT 
>>> dbd_sqlite3.lo -MD -MP -MF .deps/dbd_sqlite3.Tpo -c -o dbd_sqlite3.lo 
>>> dbd_sqlite3.c
>>> libtool: compile: gcc -DHAVE_CONFIG_H -I. -I../.. -I../.. 
>>> -I../../include -DDBDIR="/usr/local/var/lib/libdbi/sqlite3" -std=gnu99 
>>> -MT dbd_sqlite3.lo -MD -MP -MF .deps/dbd_sqlite3.Tpo -c dbd_sqlite3.c 
>>> -fPIC -DPIC -o .libs/dbd_sqlite3.o
>>> dbd_sqlite3.c: In function '_real_dbd_connect':
>>> dbd_sqlite3.c:172: error: 'DBI_ERROR_CLIENT' undeclared (first use in 
>>> this function)
>>> dbd_sqlite3.c:172: error: (Each undeclared identifier is reported only once
>>> dbd_sqlite3.c:172: error: for each function it appears in.)
>>> dbd_sqlite3.c: At top level:
>>> dbd_sqlite3.c:316: error: conflicting types for 'dbd_goto_row'
>>> /usr/include/dbi/dbd.h:41: error: previous declaration of 'dbd_goto_row' 
>>> was here
>>> dbd_sqlite3.c: In function 'dbd_list_dbs':
>>> dbd_sqlite3.c:404: error: 'DBI_ERROR_CLIENT' undeclared (first use in 
>>> this function)
>>> dbd_sqlite3.c:409: warning: implicit declaration of function 
>>> '_dirent_buf_size'
>>> dbd_sqlite3.c: In function 'dbd_list_tables':
>>> dbd_sqlite3.c:504: error: 'dbi_inst' undeclared (first use in this function)
>>> dbd_sqlite3.c:504: error: expected ';' before 'instance'
>>> dbd_sqlite3.c:513: error: 'instance' undeclared (first use in this function)
>>> dbd_sqlite3.c:513: warning: implicit declaration of function 
>>> 'dbi_driver_get_instance'
>>> dbd_sqlite3.c:514: warning: implicit declaration of function 
>>> 'dbi_conn_new_r'
>>> dbd_sqlite3.c:514: warning: assignment makes pointer from integer 
>>> without a cast
>>> make[3]: *** [dbd_sqlite3.lo] Error 1
>>> make[3]: Leaving directory `/root/libdbi-drivers-0.9.0/drivers/sqlite3'
>>> make[2]: *** [all-recursive] Error 1
>>> make[2]: Leaving directory `/root/libdbi-drivers-0.9.0/drivers'
>>> make[1]: *** [all-recursive] Error 1
>>> make[1]: Leaving directory `/root/libdbi-drivers-0.9.0'
>>> make: *** [all] Error 2
>>> 
>>> Thank For help.
>>> 
>> 
>> Hi Simon,
>> 
>> this kind of error usually happens when libdbi and libdbi-drivers are
>> out of sync, or if more than one version of libdbi is installed and
>> libdbi-drivers picks up the wrong headers during compilation. Please
>> verify that your libdbi installation is at 0.9.0 or later as well, and
>> remove any outdated headers.
>> 
>> regards,
>> Markus
> Hi Markus,
> 
> Thank you for advices. I solved it with uninstall libdbi & libdbi-drives version which in rpm, and install libdbi 0.9 and libdbi-drives 0.9 .
> 
> This is my step:
> 
> Install libdbi-0.9.0:
> ./configure
> make
> Make install
> 
> Install libdbi-drivers-0.9.0
> [root@localhost libdbi-drivers-0.9.0]# ./configure --with-sqlite3 (RESULT SUCCEEDED DURING MAKE)
> but ./configure --with-sqlite3 --with-mysql (not success during make)
> 
> checking dbi/dbi.h presence... yes
> checking for dbi/dbi.h... yes
> checking for MySQL support... yes
> checking for mysql_config... yes
> checking for MySQL includes... -I/usr/include/mysql
> checking for MySQL libraries...
> checking for PostgreSQL support... no
> checking for SQLite support... no
> checking for SQLite3 support... yes
> checking sqlite3.h usability... yes
> checking sqlite3.h presence... yes
> checking for sqlite3.h... yes
> 
> error during MAKE:
> Attached with ryslog.log
> 
> Please guide me. Thank You. Have a nice day.

Hi, 

this error is a bit weird. The official tarballs contain the
documentation so make should not try to build them. The SGML setup on
your box appears to be broke, all it takes is probably some tweaking of
your SGML_CATALOG_FILES environment variable or of your catalogs proper.
In any case, if you don't need the docs installed locally (they are
available on the libdbi-drivers homepage), you can use the
--disable-docs configure switch to disable building the docs. 

hope this helps 

Markus 

-- 
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38