[1.3.1]: SQLite support for frontend-php?

[LEM]

Hi again,

I configured my {phpfrontend root}/conf/zabbix.conf.php with the following:

//$DB_TYPE      = "MYSQL";
$DB_TYPE        = "SQLITE3";
$DB_SERVER      = "localhost";
//$DB_DATABASE  = "zabbix";
$DB_DATABASE    = "/tmp/zabbixdb";
$DB_USER        = "root";
$DB_PASSWORD    = "";

Where /tmp/zabbixdb is the path to my ZABBIX SQLite database.
Albeith I'm not 100% sure this database is fully correct, as I faced some SQLite initialization - see other post, this database seems 'good enough' to be opened via the sqlite3 CLI:

olem@homebox:/tmp/zabbix-1.3.1$ sqlite3 /tmp/zabbixdb
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> select * from users;
1|Admin|Zabbix|Administrator|d41d8cd98f00b204e9800998ecf8427e||900|en_gb|30|3
2|guest|Default|User|d41d8cd98f00b204e9800998ecf8427e||900|en_gb|30|1
sqlite>

Anyway, I've only have a blank page when firing a browser to index.php ((

I think my problem is not related to the database, as if select a nonexistent file (say $DB_DATABASE="/dont/exists"), the same blank page occurs

I'm running Ubuntu 6.06 LTS, with:
*SQLite 3.3.8 compiled from sources (as Ubunut 6.06 come shipped with 3.2.8 at maximum)
*php5-sqlite package from Ubuntu repository (5.1.2-1ubuntu3.4)
And my phpinfo report the following infos related to SQLite:

SQLite support	enabled
PECL Module version 	2.0-dev $Id: sqlite.c,v 1.166.2.11 2006/01/01 12:50:14 sniper Exp $
SQLite Library 	2.8.17
SQLite Encoding 	UTF-8

Directive	Local Value	Master Value
sqlite.assoc_case	0	0

Any ideas?

Cheers,

[Alexei]

I don't think that Ubuntu 6.06 has a PHP5 module with support of SQLite 3.x.

The php5-sqlite module is not for SQLite v3.x, it is for SQLite 2.x only!

We used Ubuntu 6.10 with php5-sqlite3 module as a development environment.

[LEM]

We used Ubuntu 6.10 with php5-sqlite3 module as a development environment.

Ok. So, I dist-upgraded my testbox to edgy, and apt-get installed php5-sqlite3 package (added sqlite3.so extension in my php.ini, and of course restarted my Apache server)... and a phpinfo() return me I've got sqlite3 support:

SQLite3 support 	      enabled
sqlite3 library version 	3.3.5

I zapped my zabbix.conf.php and started a new install using SQLite3 type in setup/phase 4.

It just work great now and I can continue evaluating SQLite support.

Many thanks,