I'm having a problem with php-pdo_sqlite, in that it is linking
itself against my OS X 10.5.8 native sqlite 3.4, instead of the
pkgsrc sqlite 3.6.16. I do have sqlite3 from pkgsrc installed:
% pkg_info|grep sqlite
php5-pdo_sqlite-5.2.10 PHP extension for PHP Data Objects (SQLite v3)
sqlite3-3.6.16 SQL Database Engine in a C Library
I am building php-pdo_sqlite like usual, no special settings.
However, I have tried to mitigate the issue using the following in /
usr/pkg/etc/mk.conf:
PREFER_PKGSRC+=sqlite3
Using the PREFER_PKGSRC setting worked flawlessly when I had the
same issue with freetype 2, so I presume that I am using this
feature correctly. I also tried the same thing but with "sqlite"
instead of "sqlite3", but none of those settings seem to make a
difference. After restarting Apache with mod_php (also from pkgsrc),
phpinfo() still reports the following:
PDO:
PDO support: enabled
PDO drivers: sqlite
pdo_sqlite:
PDO Driver for SQLite 3.x: enabled
PECL Module version: 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.4
2008/12/31 11:17:42 sebastian Exp $
SQLite Library: 3.4.0
I want the last line above to say "SQLite Library: 3.6.16", or at
least 3.5.4 since that version or newer is what I need PHP/PDO to use.
Maybe the problem is that php-pdo_sqlite doesn't respect
PREFER_PKGSRC at all? Any idea what I can do to make php-pdo_sqlite
link against pkgsrc's own sqlite3 instead och my system's sqlite3?