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

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

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

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