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