Hi,
Does anyone have any pointers as how to use SQLite as the databse backend?
I changed the line in db.inc.php to:
$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
But all it does when I try and log-in is... wait.. wait...
Cheers,
Robert
Hi,
Are you sure the current directory is writable ? Try to use the /tmp directory by using something like: $rcmail_config['db_dsnw'] = 'sqlite:///tmp/sqlite.db';
Olivier
Le Samedi 15 Octobre 2005 19:30, Robert Smithson a écrit :
Hi,
Does anyone have any pointers as how to use SQLite as the databse backend?
I changed the line in db.inc.php to:
$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
But all it does when I try and log-in is... wait.. wait...
Cheers,
Robert
Hi,
It's a good question :-)
I tried to use your code and got:
*"Warning*: touch(): Unable to create file tmp/sqlite.db because No such file or directory in */usr/share/php/DB/sqlite.php* on line *117* *DB Error in /var/www/roundcube/program/include/rcube_db.inc (63):* DB Error: not found
*Fatal error*: Call to undefined function: query() in */var/www/roundcube/program/include/rcube_db.inc* on line *119"
*Hmmm... perhaps it doesn't like leaving its document root. I'll play with permissions and see if that works.
Cheers,
Robert
Slaanesh wrote:
Hi,
Are you sure the current directory is writable ? Try to use the /tmp directory by using something like: $rcmail_config['db_dsnw'] = 'sqlite:///tmp/sqlite.db';
Olivier
Le Samedi 15 Octobre 2005 19:30, Robert Smithson a écrit :
Hi,
Does anyone have any pointers as how to use SQLite as the databse backend?
I changed the line in db.inc.php to:
$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
But all it does when I try and log-in is... wait.. wait...
Cheers,
Robert
Sorry I wanted to write (it lacks a slash): $rcmail_config['db_dsnw'] = 'sqlite:////tmpsqlite.db?mode=0646';
Le Samedi 15 Octobre 2005 19:52, Robert Smithson a écrit :
*"Warning*: touch(): Unable to create file tmp/sqlite.db because No such file or directory in */usr/share/php/DB/sqlite.php* on line *117* *DB Error in /var/www/roundcube/program/include/rcube_db.inc (63):* DB Error: not found
Hmmm! I'm not having much luck this evening.
Right: I made the change you suggested, but found that I was still getting a permissioning error. So I chamged the permissions on the roundcube base directory to allow www-data to write to it.
Where upon I now get the error:
*Fatal error*: Call to undefined function: sqlite_exec() in */var/www/roundcube/program/include/rcube_db.inc* on line *249
*(This happens before I get to the log-in screen.)
I see that sqlite_exec is PHP5 only, and I'm running PHP4 -- is this the end? Or could I use sqlite_query instead?
Cheers,
Robert
Slaanesh wrote:
Sorry I wanted to write (it lacks a slash): $rcmail_config['db_dsnw'] = 'sqlite:////tmpsqlite.db?mode=0646';
Le Samedi 15 Octobre 2005 19:52, Robert Smithson a écrit :
*"Warning*: touch(): Unable to create file tmp/sqlite.db because No such file or directory in */usr/share/php/DB/sqlite.php* on line *117* *DB Error in /var/www/roundcube/program/include/rcube_db.inc (63):* DB Error: not found
Le Samedi 15 Octobre 2005 20:18, Robert Smithson a écrit :
Right: I made the change you suggested, but found that I was still getting a permissioning error. So I chamged the permissions on the roundcube base directory to allow www-data to write to it.
This is not very secure but I suppose you know what you are doing...
*Fatal error*: Call to undefined function: sqlite_exec() in */var/www/roundcube/program/include/rcube_db.inc* on line *249 I see that sqlite_exec is PHP5 only, and I'm running PHP4 -- is this the end? Or could I use sqlite_query instead?
I am afraid this is the end...You have to have sqlite support in your installed php version....if you can not upgrade to php5 you will have to use another database driver...
Olivier