Hi, I was under the impression that Roundcube now uses SQLite3 via the PDO driver but I can't seem to get it to work.
Debian 6 stable with PHP 5.3.3, Roundcube is recent git clone and the database was created with...
cat SQL/sqlite.initial.sql | sqlite3 roundcube.db
the permissions are okay but when I get to installer/index.php?_step=3 I get...
main.inc.php: OK db.inc.php: OK temp/: OK logs/: OK DSN (write): OK Fatal error: Call to undefined method rcube_db_sqlite::_get_result() in /path/to/webmail/program/lib/Roundcube/rcube_db_sqlite.php on line 123
On 12/19/2012 02:01 PM, Mark Constable wrote:
Call to undefined method rcube_db_sqlite::_get_result()
A small regression. Fixed in a8ffab3f4ff54af41c9041a30eb989954d6ffc17.
On 19/12/12 23:15, A.L.E.C wrote:
Call to undefined method rcube_db_sqlite::_get_result()
A small regression. Fixed in a8ffab3f4ff54af41c9041a30eb989954d6ffc17.
Yep, that fixed it that error but now I'm seeing a 30 second delay...
[20-Dec-2012 00:51:35 +1100]: DB Error: [5] database is locked in /path/to/webmail3/program/lib/Roundcube/rcube_db.php on line 411 (GET /webmail3/?_task=mail&_action=getunread&_remote=1&_unlock=0&_=1355925094153)
The /db/ directory below has full r/w web server and user permissions.
$rcmail_config['db_dsnw'] = 'sqlite:////path/to/webmail3/db/.htsqlite.db?mode=0646';
BTW what might be the best way to handle the installer/ directory because when I rename it and do another pull I get a new installer/ dir?
On 12/19/2012 02:58 PM, Mark Constable wrote:
Yep, that fixed it that error but now I'm seeing a 30 second delay...
[20-Dec-2012 00:51:35 +1100]: DB Error: [5] database is locked in /path/to/webmail3/program/lib/Roundcube/rcube_db.php on line 411 (GET /webmail3/?_task=mail&_action=getunread&_remote=1&_unlock=0&_=1355925094153)
This might be an issue similiar to this http://verens.com/2006/10/19/pdosqlite-gotcha/ Open a ticket.
On 12/19/2012 03:30 PM, A.L.E.C wrote:
DB Error: [5] database is locked in
/path/to/webmail3/program/lib/Roundcube/rcube_db.php on line 411
I created the ticket http://trac.roundcube.net/ticket/1488874 and tested sqlite backend. I do not observe any delays, however I'm able to reproduce the error. See the ticket for more info.
-----Opprinnelig melding----- From: A.L.E.C Sent: Wednesday, December 19, 2012 8:11 PM To: users@lists.roundcube.net Subject: Re: [RCU] SQLite with git clone
On 12/19/2012 03:30 PM, A.L.E.C wrote:
DB Error: [5] database is locked in
/path/to/webmail3/program/lib/Roundcube/rcube_db.php on line 411
I created the ticket http://trac.roundcube.net/ticket/1488874 and tested sqlite backend. I do not observe any delays, however I'm able to reproduce the error. See the ticket for more info.