On Mar 30, 2007, at 22:07, Tom Brice wrote:
After a little reading I see that PHP5 comes with sqlite3. The
only conclusion that I can come to is that something is linking to
the supplied sqlite3 rather than MacPorts version and the supplied
sqlite3 fails on OS X 10.3.9 for some reason. Here's how I came to
this end:
* The php5 install that I cannot get to work with apache2 via
mod_php does work in the CLI.
* In the darwin 7 variant of the php5 Portfile I added "--with-pdo-
sqlite=${prefix}/bin/sqlite3" to the configure.args-append line.
Building this still fails mod_php usage with apache2.
* I changed the darwin 7 variant to "configure.args-append --
without-sqlite --without-pdo-sqlite" and reintsalled. THIS WORKS
with mod_php and apache2!!
I wasn't using sqlite3 with php before so I can live without it.
However, I think it might be "fixable" by making sure that php uses
the MacPorts sqlite3 rather that the supplied version. By adding
the appropriate DIR to "--with-sqlite=DIR --with-pdo-sqlite=DIR" it
might work. I guess it should be "{prefix}/bin/sqlite3". the
configure file states:
"Use --with-sqlite=DIR to specify DIR where
Sqlite include and library files are located,
if not using bundled library."
I had tried before to fix the sqlite situation in the php5 port and
reached an impasse with an error message which I did not have time to
research. Searching for that error message today brought me to this
bug report, which turns out not to be a bug:
http://bugs.php.net/bug.php?id=30749
As I understand it now, the standard sqlite support in php5 uses and
requires sqlite2, a version of which is included with php5. As of php
5.1, pdo sqlite support is also available, which uses sqlite3, and in
the absence of instructions to the contrary, I believe it is this pdo
sqlite component which was reaching out to the system's sqlite3
library rather than the MacPorts version.
I have committed a new revision of the php5 port which disables
standard and pdo sqlite support, and adds a new +sqlite variant for
those who want to reenable it:
http://trac.macosforge.org/projects/macports/changeset/23410
This seems to work for me on 10.4.9 Intel. Will someone with access
to 10.3.9 PPC please test it there and let me know if both versions
work properly (both when specifying +sqlite and when not)? Thanks.
_______________________________________________
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/macports-users
