Hi guys,
first of all, please add some descriptive information to the INSTALL file that points to proper documentation on how to initialize these databases. Mysql has plenty, but sqlite has none by itself - only needs to be one line of text.
Second, after installing and setting up the DB I get the following after logging in:
<b>DB Error in /var/roundcubemail/program/include/rcube_db.inc (63):</b> DB Error: extension not found<br /><br /> <b>Fatal error</b>: Call to undefined function: query() in <b>/var/roundcubemail/program/include/rcube_db.inc</b> on line <b>124</b><br />
php-4.4.0, pear has SQLite 1.0.3, and I'm running apache-2.0.5x.
Any clues? I cant get google to turn me up with helpful info.
Auke
This message means, that your PHP does not provide SQL support. As far as I know, SQLite is only available with PHP5.
Use phpinfo() to get details about your PHP installation and the included extensions.
Thomas
Auke Kok wrote:
Hi guys,
first of all, please add some descriptive information to the INSTALL file that points to proper documentation on how to initialize these databases. Mysql has plenty, but sqlite has none by itself - only needs to be one line of text.
Second, after installing and setting up the DB I get the following after logging in:
<b>DB Error in /var/roundcubemail/program/include/rcube_db.inc (63):</b> DB Error: extension not found<br /><br /> <b>Fatal error</b>: Call to undefined function: query() in <b>/var/roundcubemail/program/include/rcube_db.inc</b> on line <b>124</b><br />
php-4.4.0, pear has SQLite 1.0.3, and I'm running apache-2.0.5x.
Any clues? I cant get google to turn me up with helpful info.
Auke
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
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
-
Auke Kok -
Robi -
Thomas Bruederli