[dev] Horde groupware & sqlite3

[Pieter Vanmeerbeek]

Hi ,

I'm trying to install the groupware rc1 with sqlite 3. However, there seems
to be a problem with this.

I'm using PHP 5.1.6. As far as I understood php 5.1 has a build-in sqlite 3
support system using pdo_sqlite. I compiled php as described
http://be2.php.net/pdo and http://be2.php.net/manual/en/ref.pdo-sqlite.php
as a shared module (disabled sqlite,i.e. sperate support for sqlite version
2,  used pdo_sqlite) and added these modules to my php.ini.


Php -I shows 
....
Configure Command =>  './configure' '--prefix=/ub/pkg/php5'
'--with-apxs2=/ub/pkg/httpd/bin/apxs' '--with-config-file-path=/ub/etc/php5'
'--with-openssl=/ub' '--with-zlib=/ub' '--with-curl=/ub/pkg/curl'
'--with-gdbm=/ub' '--with-db4=/ub' '--with-dom=/ub' '--with-dom-xslt=/ub'
'--with-dom-exslt=/ub' '--with-ldap=/ub/pkg/openldap' '--with-gettext'
'--with-libxml-dir=/ub' '--enable-sqlite-utf8' '--with-mcrypt=/ub'
'--with-iconv' '--enable-mbstring=all' '--enable-mbregex' '--with-gd'
'--with-png-dir=/ub' '--with-jpeg-dir=/ub' '--with-imap=/ub'
'--with-imap-ssl=/ub' '--enable-pdo=shared' '--with-pdo-sqlite=shared'
'--without-sqlite'
PDO drivers => sqlite
pdo_sqlite
PDO Driver for SQLite 3.x => enabled
PECL Module version => (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6
2006/01/01 12:50:12 sniper Exp $
SQLite Library => 3.2.8
....

So this seems in order. 

However upon using the setup.php script and setting the DB type on sqlite,
the script is exited and the /tmp/horde.log shows : 

Aug 28 17:16:18 HORDE [emergency] [horde] DB Error: extension not found:
[DB Error: extension not found] ** Array [on line 1625 of
"/ub/pkg/horde-groupware-1.0-rc1/lib/Horde/DataTree/sql.php"]


Further inspection shows that the sql.php uses the pear DB module which
apparently only has support for sqlite2 (according to the website)

I tried adding the '--with-sqlite=shared' option while configuring php. And
run the setup script again. This time I can create my database/tables.
However I'm getting errors on indexes which already exist. So I converted my
mysql database to an sqlite database using the  conversion script 

mysql2sqlite.pl  | sqlite3 /root/horde.db

While trying to reach horde using my browser /tmp/horde.log now says
something like encrypted or unsupported database (emptied my log file so I
don't now the exact error). Other people on the web seem to dedicate this
error due to the fact I'm trying to read an sqlite3 database with sqlite2
functions. Opening the database using the sqlite3 client program show the
correct database settings (tables are present but empty). So I guess they
are right.

Can anyone help me and point out to me how to tell php or horde to use the
pdo sqlite for my database?

Kind regards,
Pieter





--
---------------------------------------------------
Able: 1996-2006: already 10 safe years in YOUR company!

aXs GUARD has completed security and anti-virus checks on this e-mail (http://www.axsguard.com)
---------------------------------------------------
Able NV: ond.nr 0457.938.087
RPR Mechelen