Problems with Centos 5.2 64 Bits, SiteBuilder 4.5 and SQLite 2
Well, not everything OK.
I'm having a serious problem with SiteBuilder 4.5 and SQLite 2.
SiteBuilder requires SQLite 2 with UTF8 support, but apparently it is not available for Centos 5.2 64 bits.
And it looks like SiteBuilder does not work with SQLite 3 yet.
Yum shows this package:
yum search sqlite2
...
php-sqlite2.x86_64 : PHP5 bindings to SQLite, a file-based SQL engine
But I can't install it:
yum install php-sqlite2
...
Package php-pdo - 5.2.6-1.el5.art.x86_64 already installed and latest version
Nothing to do
I have tried to compile and install SQLite 2, but it's not working, SiteBuilder is showing some error 500 messagens and the sites are not working.
wget
http://pecl.php.net/get/SQLite-1.0.3.tgz
tar zxvf SQLite-1.0.3.tgz
cd SQLite-1.0.3
vi libsqlite/src/main.c
#ifdef SQLITE_UTF8
const char sqlite_encoding[] = "UTF-8";
#else
const char sqlite_encoding[] = "UTF-8";
/* const char sqlite_encoding[] = "iso8859"; */
#endif
vi sqlite.c
Comment the line bellow:
/* static unsigned char arg3_force_ref[] = {3, BYREF_NONE, BYREF_NONE, BYREF_FORCE }; */
Change these lines:
function_entry sqlite_functions[] = {
PHP_FE(sqlite_open, arg3_force_ref)
PHP_FE(sqlite_popen, arg3_force_ref)
To:
function_entry sqlite_functions[] = {
PHP_FE(sqlite_open, third_arg_force_ref)
PHP_FE(sqlite_popen, third_arg_force_ref)
phpize
./configure --with-sqlite --with-php-config=/usr/bin/php-config
make
cp modules/sqlite.so /usr/lib64/php/modules
vi /etc/php.d/sqlite.ini
; Enable sqlite extension module
extension=sqlite.so
php -v
apachectl -t
apachectl restart
Everything looks OK, but it's not working.
SiteBuilder's log shows messages like this:
Invalid server response: http/1.0 500 internal server error ...
Cannot update modules data....
Can anyone help me?
Thank you.
Alexandre