I'm attempting to install roundcube 1.1.0 on OpenBSD 5.7. Hopefully I have supplied enough info. for someone to give me a hand. While following the install steps I see the following:
Check DB config
DSN (write): OK DB Schema: OK DB Write: *NOT OK*([14] unable to open database file (SQL Query: INSERT INTO "session" ("sess_id", "created", "ip", "vars") VALUES ('e1888c6202c82b43dedc3dd8e4299800', datetime('now'), '127.0.0.1', 'foo'))) DB Time: OK
and the following in the logs
[30-Jul-2015 02:32:10 +0000]: <tismr6ha> DB Error: SQLSTATE[HY000] [14] unable to open database file in /roundcubemail/program/lib/Roundcube/rcube_db.php on line 177 (GET /roundcubemail/) [30-Jul-2015 02:32:10 +0000]: <tismr6ha> DB Error: SQLSTATE[HY000] [14] unable to open database file (GET /roundcubemail/) [30-Jul-2015 03:18:46 +0000]: <tismr6ha> DB Error: [14] unable to open database file (SQL Query: INSERT INTO "users" ("created", "last_login", "username", "mail_host", "language") VALUES (datetime('now'), datetime('now'), 'edgar@pettijohn-web.com', 'localhost', 'en_US')) in /htdocs/roundcubemail/program/lib/Roundcube/rcube_db.php on line 541 (POST /?_task=login?_task=login&_action=login) [30-Jul-2015 03:18:46 +0000]: <tismr6ha> PHP Error: Failed to create new user in /htdocs/roundcubemail/program/lib/Roundcube/rcube_user.php on line 611 (POST /?_task=login?_task=login&_action=login) [30-Jul-2015 03:18:46 +0000]: <tismr6ha> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /htdocs/roundcubemail/program/include/rcmail.php on line 610 (POST /?_task=login?_task=login&_action=login) [30-Jul-2015 03:18:46 +0000]: <tismr6ha> DB Error: [14] unable to open database file (SQL Query: INSERT INTO "session" ("sess_id", "vars", "ip", "created", "changed") VALUES ('tismr6ha77vit8s6g87rihqb65', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7c2tpbnxzOjU6ImxhcnJ5Ijs=', 'x.x.x.x', datetime('now'), datetime('now'))) in /htdocs/roundcubemail/program/lib/Roundcube/rcube_db.php on line 541 (POST /?_task=login?_task=login&_action=login)
from config.inc.php
$config['db_dsnw'] = 'sqlite:////roundcubemail/db/sqlite.db?mode=0666';
I have tried every permissions setting that seems reasonable up to 0777 with no luck
# ls -l roundcubemail/db -rw-rw-rw- 1 root www 46080 Jul 29 22:09 sqlite.db
sqlite.db created as follows: # sqlite3 -init SQL/sqlite.initial.sql db/sqlite.db
Thanks in advance.
Edgar Pettijohn