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(a)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