Minor correction,

sqlite doesn't come with php4. You must install it separately, and it must be sqlite v2.8.x and not sqlite v3.2.x, and it works fine with php4, as long as the sqlite.so extension is listed in your php.ini .

the other way to create the sqlite.db is: $ cd roundcubemail $ sqlite sqlite.db

.read SQL/sqlite.initial.sql .quit

$ sudo chown :www-data sqlite.db $ chmod 0660 sqlite.db

Also make sure that yor logs and temp directory are writable by the webserver and have the correct permisisons.

$ sudo chown :www-data logs temp $ chmod 0770 logs temp

-- Robi

On 11/4/05, Auke Kok sofar@foo-projects.org wrote:

Auke Kok wrote:

...

Hi guys,

[snip]

...

Any clues? I cant get google to turn me up with helpful info.

Auke

okay people, listen up.

I just spent about two whole days trying to figure out how to get roundcube to work with sqlite.

In the end I did succeed. I will not tell you how, but instead be NICER and give you a piece of text that I suggest you include in the README for future reference. It contains all the hints that would have saved me about 10 hours of fiddling, hacking php and trying every other possibility. just copy+paste.

Auke

=========================

DATABASE SETUP

• mysql

Setting up the mysql database can be done by creating an empty database, importing the table layout and granting the proper permissions to the roundcube user. Here is an example of that procedure:

# mysql

...

create database 'roundcubemail'; GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost

     IDENTIFIED BY 'password';

...

quit

# mysql roundcubemail < SQL/mysql.initial.sql

• sqlite

Sqlite requires specifically php5 (sqlite in php4 currently doesn't work with roundcube), and you need sqlite 2 (preferably 2.8) to setup the sqlite db (sqlite 3.x also doesn't work at the moment). Here is an example how you can setup the sqlite.db for roundcube:

# sqlite -init SQL/sqlite.initial.sql sqlite.db

Make sure your configuration points to the sqlite.db file and that the webserver can write to the file.

=========================

simply stunning how simple documentation can be, yet mind-boggling the problems if it is absent.

Please include this in the stock README for next releases, you will make a lot of people happy.

Auke