Hi Bertrand, Ok the download worked, but the make failed with:
/tmp/tmpACnhIu/SQLite-1.0/sqlite.c:29:17: php.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:30:21: php_ini.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:31:31: ext/standard/info.h: No such file or directory make: *** [sqlite.lo] Error 1 `make' failed The entire make output is below. I appreciate any advice you can give. Am also posting this the php list to see if they have any ideas. Thanks! JR [EMAIL PROTECTED] html]# pear download http://pecl.php.net/get/SQLite-1.0.tgz File SQLite-1.0.tgz downloaded (354024 bytes) [EMAIL PROTECTED] html]# pear install SQLite-1.0.tgz 48 source files, building running: phpize You should update your `aclocal.m4' by running aclocal. Configuring for: PHP Api Version: 20020918 Zend Module Api No: 20020429 Zend Extension Api No: 20021010 building in /var/tmp/pear-build-root/SQLite-1.0 running: /tmp/tmpACnhIu/SQLite-1.0/configure creating cache ./config.cache checking host system type... i686-pc-linux-gnu checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking whether gcc and cc understand -c and -o together... yes checking if compiler supports -R... no checking if compiler supports -Wl,-rpath,... yes checking for PHP prefix... /usr checking for PHP includes... -Idir=/usr/include/php -Idir=/usr/include/php/main -Idir=/usr/include/php/Zend -Idir=/usr/include/php/TSRM checking for PHP extension directory... /usr/lib/20020429 checking how to run the C preprocessor... gcc -E checking for gawk... gawk checking for sqlite support... yes, shared checking size of char *... 4 checking for lemon... no checking for usleep... yes checking for nanosleep... yes checking for time.h... yes checking for Cygwin environment... no checking for mingw32 environment... no checking build system type... i686-pc-linux-gnu checking for ld used by GCC... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for /usr/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -B checking whether ln -s works... yes checking how to recognise dependant libraries... pass_all checking for object suffix... o checking for executable suffix... no checking command to parse /usr/bin/nm -B output... ok checking for dlfcn.h... yes checking for ranlib... ranlib checking for strip... strip checking for objdir... .libs checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions... yes checking whether the linker (/usr/bin/ld) supports shared libraries... yes checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking dynamic linker characteristics... GNU/Linux ld.so checking if libtool supports shared libraries... yes checking whether -lc should be explicitly linked in... no creating libtool updating cache ./config.cache creating ./config.status creating config.h running: make sed -e s/--VERS--/2.8.3/ -e s/--ENCODING--/ISO8859/ /tmp/tmpACnhIu/SQLite-1.0/libsqlite/src/sqlite.h.in >/tmp/tmpACnhIu/SQLite-1.0/libsqlite/src/sqlite.h /bin/sh /var/tmp/pear-build-root/SQLite-1.0/libtool --mode=compile gcc -I/tmp/tmpACnhIu/SQLite-1.0/libsqlite/src -I. -I/tmp/tmpACnhIu/SQLite-1.0 -DPHP_ATOM_INC -I/var/tmp/pear-build-root/SQLite-1.0/include -I/var/tmp/pear-build-root/SQLite-1.0/main -I/tmp/tmpACnhIu/SQLite-1.0 -Idir=/usr/include/php -Idir=/usr/include/php/main -Idir=/usr/include/php/Zend -Idir=/usr/include/php/TSRM -DHAVE_CONFIG_H -g -O2 -prefer-pic -c /tmp/tmpACnhIu/SQLite-1.0/sqlite.c -o sqlite.lo gcc -I/tmp/tmpACnhIu/SQLite-1.0/libsqlite/src -I. -I/tmp/tmpACnhIu/SQLite-1.0 -DPHP_ATOM_INC -I/var/tmp/pear-build-root/SQLite-1.0/include -I/var/tmp/pear-build-root/SQLite-1.0/main -I/tmp/tmpACnhIu/SQLite-1.0 -Idir=/usr/include/php -Idir=/usr/include/php/main -Idir=/usr/include/php/Zend -Idir=/usr/include/php/TSRM -DHAVE_CONFIG_H -g -O2 -c /tmp/tmpACnhIu/SQLite-1.0/sqlite.c -fPIC -DPIC -o sqlite.lo /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:29:17: php.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:30:21: php_ini.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:31:31: ext/standard/info.h: No such file or directory make: *** [sqlite.lo] Error 1 `make' failed -----Original Message----- From: Bertrand Mansion [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 9:45 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Can't get to work w/ PHP <[EMAIL PROTECTED]> wrote : > Hello All, > > I am having a hard time getting sqlite to work with PHP. > > I have installed the RPM from the web site and can compile a test C > program that works no problem. > > But can't get it to work w/ PHP. > > I have extension = extension=libsqlite.so in my php.ini file. But when > I do a php -v from the command line it says it can't locate the > libsqlite.so file. > > Also when I look I do have libsqlite.so in my /usr/lib/. > > Also if I run pear install sqlite, I get "No releases found for > package 'sqlite'". Which brings up the a question in addition to why > is the pear installer not working?, of do I need to run that being > that I installed the RPM from the sqlite.org web site? > > I am running 4.3.3 of PHP. This is a php related question, you might get more comments on the PECL mailing list. Anyway, here is what you can do: # pear download http://pecl.php.net/get/SQLite-1.0.tgz # pear install SQLite-1.0.tgz Then, in your php scripts, use : if (!extension_loaded('sqlite')) { dl('sqlite.so'); } unless, you load it in your php.ini file by default. HTH Bertrand Mansion Mamasam --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]