php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #56585 Installation errors (file missing from SQLite src?)
Submitted: 2005-10-08 17:55 UTC Modified: 2005-11-02 14:07 UTC
From: waltzer at autumnweave dot com Assigned:
Status: Closed Package: PDO_SQLITE (PECL)
PHP Version: 5.0.5 OS: Linux 2.6.12 SMP
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: waltzer at autumnweave dot com
New email:
PHP Version: OS:

 

 [2005-10-08 17:55 UTC] waltzer at autumnweave dot com
Description:
------------
It appears that one of the source files for SQLite is missing from the package (sqlite3.h).

Also some confusion in the tools and packages between PEAR and PECL (thats minor though and not a PDO thing, I understand that).

Setup:
PHP version is 5.0.5 (not listed in the drop down).
PEAR version 1.4.1 stable
PDO 1.0RC1
PDO_MYSQL 1.0RC1
PHP is built with the SQLite extension (undrestand that's based on SQLite 2 while PDO is SQLite 3. Didn't see any problems with that mentioned other than perhaps don't jump back and forth between the two in working with a given database).

Description:
`pear install pdo_sqlite-beta` returns:
  No releases available for package
  "pear.php.net/pdo_sqlite" - package pecl/pdo_sqlite
  can be installed with "pecl install pdo_sqlite"

`pecl install pdo_sqlite-beta` returns:
  pear/PDO_SQLITE requires PHP extension "pdo"
  (version >= 1.0RC1)

`pecl list` returns (full pecl list):
  xdebug  2.0.0beta4 beta
  (not entirely true, other pecl packages
 (APC, APD, xdiff) have been installed)

`pear list` returns (abbreviated list):
  APC       3.0.8  stable
  PDO       1.0RC1 beta
  PDO_MYSQL 1.0RC1 beta

which leads me to
`pecl install -n pdo_sqlite-beta` The line(s) that seem to
 point out the error are
 (Note: full output follows below):
----------------------------------
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/configure: line 5090: ./sqlite/src/sqlite3.h: No such file or directory

In file included from /tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/pdo_sqlite.c:31:
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:24:21: sqlite3.h: No such file or directory

In file included from /tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/pdo_sqlite.c:31:
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:50: error: syntax error before "sqlite3"

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:50: warning: no semicolon at end of struct or union

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:53: error: syntax error before '}' token

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:53: warning: data definition has no type or storage class

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:56: error: syntax error before "pdo_sqlite_db_handle"

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:56: warning: no semicolon at end of struct or union

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:57: warning: data definition has no type or storage class

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:58: error: syntax error before ':' token

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:59: error: syntax error before ':' token

/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:60: warning: data definition has no type or storage class

make: *** [pdo_sqlite.lo] Error 1
ERROR: `make' failed

--------------------
The full output is:
--------------------
warning: pear/PDO_SQLITE requires PHP extension "pdo" (version >= 1.0RC1)
downloading PDO_SQLITE-1.0RC1.tgz ...
Starting to download PDO_SQLITE-1.0RC1.tgz (859,745 bytes)
...........................................................................................................................................................................done: 859,745 bytes
111 source files, building
running: phpize
Configuring for:
PHP Api Version:         20031224
Zend Module Api No:      20041030
Zend Extension Api No:   220040412
building in /var/tmp/pear-build-root/PDO_SQLITE-1.0RC1
running: /tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/configure
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
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/local/php
checking for PHP includes... -I/usr/local/php/include/php -I/usr/local/php/include/php/main -I/usr/local/php/include/php/TSRM -I/usr/local/php/include/php/Zend
checking for PHP extension directory... /usr/local/php/lib/php/extensions/no-debug-non-zts-20041030
checking for re2c... exit 0;
checking for gawk... gawk
checking for sqlite 3 driver for PDO... yes, shared
checking for PDO includes... checking for PDO includes... /usr/local/php/include/php/ext
checking how to run the C preprocessor... gcc -E
checking for egrep... grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for char *... yes
checking size of char *... 4
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/configure: line 5090: ./sqlite/src/sqlite3.h: No such file or directory
checking for usleep... yes
checking for nanosleep... yes
checking time.h usability... yes
checking time.h presence... yes
checking for time.h... yes
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 for a sed that does not truncate output... /bin/sed
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking command to parse /usr/bin/nm -B output... ok
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
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... no
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 to build shared libraries... yes
checking whether to build static libraries... no
checking whether -lc should be explicitly linked in... no
creating libtool
configure: creating ./config.status
config.status: creating config.h
running: make
/bin/sh /var/tmp/pear-build-root/PDO_SQLITE-1.0RC1/libtool --mode=compile gcc -I@ext_builddir@/sqlite/src -DPDO_SQLITE_BUNDLED=1 -DSQLITE_OMIT_CURSOR -I/usr/local/php/include/php/ext -I. -I/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1 -DPHP_ATOM_INC -I/var/tmp/pear-build-root/PDO_SQLITE-1.0RC1/include -I/var/tmp/pear-build-root/PDO_SQLITE-1.0RC1/main -I/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1 -I/usr/local/php/include/php -I/usr/local/php/include/php/main -I/usr/local/php/include/php/TSRM -I/usr/local/php/include/php/Zend  -DHAVE_CONFIG_H  -g -O2   -c /tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/pdo_sqlite.c -o pdo_sqlite.lo
gcc -I@ext_builddir@/sqlite/src -DPDO_SQLITE_BUNDLED=1 -DSQLITE_OMIT_CURSOR -I/usr/local/php/include/php/ext -I. -I/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1 -DPHP_ATOM_INC -I/var/tmp/pear-build-root/PDO_SQLITE-1.0RC1/include -I/var/tmp/pear-build-root/PDO_SQLITE-1.0RC1/main -I/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1 -I/usr/local/php/include/php -I/usr/local/php/include/php/main -I/usr/local/php/include/php/TSRM -I/usr/local/php/include/php/Zend -DHAVE_CONFIG_H -g -O2 -c /tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/pdo_sqlite.c  -fPIC -DPIC -o pdo_sqlite.lo
In file included from /tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/pdo_sqlite.c:31:
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:24:21: sqlite3.h: No such file or directory
In file included from /tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/pdo_sqlite.c:31:
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:50: error: syntax error before "sqlite3"
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:50: warning: no semicolon at end of struct or union
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:53: error: syntax error before '}' token
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:53: warning: data definition has no type or storage class
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:56: error: syntax error before "pdo_sqlite_db_handle"
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:56: warning: no semicolon at end of struct or union
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:57: warning: data definition has no type or storage class
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:58: error: syntax error before ':' token
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:59: error: syntax error before ':' token
/tmp/tmp5Jiwpw/PDO_SQLITE-1.0RC1/php_pdo_sqlite_int.h:60: warning: data definition has no type or storage class
make: *** [pdo_sqlite.lo] Error 1
ERROR: `make' failed


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-10-31 22:13 UTC] wez@php.net
This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.


 [2005-11-02 14:07 UTC] waltzer at autumnweave dot com
Confirmed, everything seems fine as of PDO 1.0RC2. Thanks!
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 23 13:01:29 2024 UTC