I did the patching and installed the drivers and whatnot.. but on the installer page, i see the following:
Check configured database settings DSN (write): OK DB Schema: NOT OK(Cannot read the schema file: ../SQL/pdoSqlite.initial.sql)
I cannot find this pdoSqlite.initial.sql
I made my database with sqlite -init SQL/sqlite.initial.sql sqlite.db
and I get this error in my logs.
[05-May-2010 19:42:16 +0200]: DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='ldnu9ca02d5mtrj1ngtp341e03'] [Native code: 00000] in /usr/local/apache2/htdocs/roundcube/program/include/rcube_mdb2.php on line 630 (GET /) [05-May-2010 19:42:37] PHP Warning: PDO::query(): SQLSTATE[HY000]: General error: mode must be an integer in /usr/local/apache2/htdocs/roundcube/program/lib/MDB2/Driver/pdoSqlite.php on line 572 [05-May-2010 19:42:37] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='ldnu9ca02d5mtrj1ngtp341e03'] [Native code: 00000]
[05-May-2010 19:42:37 +0200]: DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='ldnu9ca02d5mtrj1ngtp341e03'] [Native code: 00000] in /usr/local/apache2/htdocs/roundcube/program/include/rcube_mdb2.php on line 630 (GET /)
any ideas?
Jason
List info: http://lists.roundcube.net/users/
On Thu, 06 May 2010 11:48:47 -0400, Jason Welsh jason@monsterjam.org wrote:
DB Schema: NOT OK(Cannot read the schema file: ../SQL/pdoSqlite.initial.sql)
I cannot find this pdoSqlite.initial.sql
you can just rename sqlite.initial.sql file to pdoSqlite.initial.sql
I made my database with sqlite -init SQL/sqlite.initial.sql sqlite.db
and I get this error in my logs.
All because we don't support pdoSqlite driver. You'll need to add 'pdosqlite' driver name in some places in rcube_mdb2 class. Search for 'sqlite' string.
On 05/06/10 11:56, A.L.E.C wrote:
All because we don't support pdoSqlite driver. You'll need to add 'pdosqlite' driver name in some places in rcube_mdb2 class. Search for 'sqlite' string.
ugh, that looks like it might be more that i can figure out (unless you can tell me specifically which ones).. I was trying to use sqlite3, because when using the recommended 2.8 version, the database would somehow quit working after using roundcube for like a day or so, and cause the main roundcube page to not load. I would see the following in the apache error logs... [Thu Mar 18 13:15:26 2010] [notice] child pid 27301 exit signal Segmentation fault (11) [Thu Mar 18 13:15:26 2010] [notice] child pid 27335 exit signal Segmentation fault (11) [Thu Mar 18 13:15:26 2010] [notice] child pid 27336 exit signal Segmentation fault (11)
If I reinitialized the sqlite2 database, the main roundcube page would work fine again.
btw, this is on a 64-bit rhel 5.3 distro.. [root@cube-brew logs]# uname -m x86_64
I have the same apache/sqlite2 setup on 32-bit linux rhel 4.x machines that have no issues with pretty much the same setup. but we would like to standardize on the 64-bit machines going forward.
regards, Jason
On 05/06/10 11:56, A.L.E.C wrote:
On Thu, 06 May 2010 11:48:47 -0400, Jason Welsh jason@monsterjam.org wrote:
DB Schema: NOT OK(Cannot read the schema file: ../SQL/pdoSqlite.initial.sql)
I cannot find this pdoSqlite.initial.sql
you can just rename sqlite.initial.sql file to pdoSqlite.initial.sql
I made my database with sqlite -init SQL/sqlite.initial.sql sqlite.db
and I get this error in my logs.
All because we don't support pdoSqlite driver. You'll need to add 'pdosqlite' driver name in some places in rcube_mdb2 class. Search for 'sqlite' string.
but I thought the patch was supposed to take care of all of those? [root@cube-brew htdocs]# grep rcube_mdb2 patch.txt --- program/include/rcube_mdb2.php.orig 2009-08-04 08:22:41.000000000 +0000 +++ program/include/rcube_mdb2.php 2009-09-15 13:24:48.143636844 +0000 @@ -100,7 +100,7 @@ class rcube_mdb2 @@ -249,7 +249,7 @@ class rcube_mdb2 @@ -535,6 +535,9 @@ class rcube_mdb2 @@ -690,10 +693,19 @@ class rcube_mdb2 [root@cube-brew htdocs]#
maybe this was for the older vers of roundcube.. i.e. not the 0.3
regards, Jason
List info: http://lists.roundcube.net/users/
-
A.L.E.C -
Jason Welsh