hi, i just installed roundcube 0.1-rc2 and tried it out. system is debian etch with lighttpd as webserver and php5 via fcgi. i chose sqlite as database and set everything up. but if i try to login this happens:
[02-Nov-2007 11:40:38 +0100] DB Error: DB Error: unknown error Query: 14 ** INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), 'imaptest@****', '****', '', 'de_DE') [nativecode=sqlite_query() [
function.sqlite-query]: unable to open database file] in /var/www/****/mail/program/include/rcube_db.inc on line 505
[02-Nov-2007 11:40:38 +0100] PHP Error: Failed to create new user in /var/www/****/mail/program/include/main.inc on line 740
[02-Nov-2007 11:40:38 +0100] DB Error: DB Error: unknown error Query: 14 ** INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('f8f45432ba3ee2d632c26b8191f6f9ae', 'user_lang|s:5:"de_DE";auth_time|i:1194000038;temp|b:1;', '81.169.183.122', now(), now()) [nativecode=sqlite_query() [
function.sqlite-query]: unable to open database file] in /var/www/****/mail/program/include/rcube_db.inc on line 505
config is:
$rcmail_config['db_dsnw'] = 'sqlite://./sqlite2.db';
serv:/var/www/****/mail# ls -lh sqlite2.db
-rw-rw-rw- 1 www-data www-data 27K Nov 2 00:10 sqlite2.db
the roundcube root is in the same directory.
if i change the config to:
$rcmail_config['db_dsnw'] = 'sqlite://sqlite2.db?mode=0646';
its:
[02-Nov-2007 11:48:59 +0100] DB Error: DB Error: insufficient permissions in /var/www/****/mail/program/include/rcube_db.inc on line 105
imap login is ok. sqlite version is 2.8.17. php runs as user www-data. has anybody an idea? thanks!