(Resending from the right address...)

Yeah this actually didn't work for me either! I thought it did but I'm getting other weird problems. I found it interesting that no one has chimed in to say that they have sqlite actually working... Can the developers actually speak to these problems? I likely won't have time to debug this myself for a couple of days at least. (Yes, I really really really don't want to use MySQL. It seems like over kill.)

BTW, there's a missing semicolon from the end of my patch..

BTW2, php5 has sqlite 2 compiled into it and uses that to create the database. If you want to inspect the database created by roundcube then you have install sqlite 2 command line tools.

Your exact message appears to actually be related to permissions. Does the user that your web server run as have write access to this directory?

On OS X the web server (appache 1.3) runs as www. So I had to:

"sudo chown www:www ."

You'd have to do the analogous to home/roundcube.

Still waiting for someone to say they have a working sqlite install... :-)

Adhamh

On 10/31/05 7:39 PM, "Robi" rob.markovic@gmail.com wrote:

Adhamh,

I found your sql session table patch and added it to my sqlite3 db, but I'm still having problems getting it running..

Here are the error I get once I press login:

Warning: touch(): Unable to create file home/roundcube/rcube.db because No such file or directory in /home/roundcube/program/lib/DB/sqlite.php on line 209 DB Error in /home/roundcube/program/include/rcube_db.inc (63): DB Error: not found

Fatal error: Call to undefined function: query() in /home/roundcube/program/include/rcube_db.inc on line 124

--

any ideas?

I'm running php 4.4, and have pear and pear::db and php4-sqlite packages on ubuntu installed..

thanks,

-- Robi

Adhamh Findlay wrote:

I found it interesting that no one has chimed in to say that they have sqlite actually working...

SQLite works for me. I have caching disabled.

Adhamh Findlay wrote:

Could you post some more details?

I should first point out that I'm not running the latest one. My index.php says it is version 0.1-20051007.

What version of php are you using? Apache?

I'm using php 4.3.10-16 (debian stable) and php4-sqlite 1.0.2-7 (ditto). I don't use Apache; I'm using lighttpd 1.3.16 and running PHP as CGI. SQLite is 2.8.16 (debian stable).

What is the sqlite information from phpinfo()?

SQLite support => enabled PECL Module version => 1.0 $Id: sqlite.c,v 1.62.2.16 2004/01/17 00:29:37 edink E xp $ SQLite Library => 2.8.16 SQLite Encoding => UTF-8

Directive => Local Value => Master Value sqlite.assoc_case => 0 => 0

Could you post your config files? The db.inc.php

$rcmail_config['db_dsnw'] = 'sqlite://./temp/round.db?mode=0646';

and main.inc.php after

the only changes I made were: $rcmail_config['enable_caching'] = FALSE; $rcmail_config['default_host'] = 'localhost'; $rcmail_config['default_port'] = 143; $rcmail_config['timezone'] = -7;

Someone else asked me:

Did you disable caching because it was causing problems?

Caching was causing problems, yes. But I turned it off because I don't need it; my IMAP server and webmail server are on the same box. FWIW, I don't think caching should be on by default. I would be surprised if there are very many people running a pre-alpha webmail client in a high-volume tiered server setup.

I had to make a change to some file, I forget which now, because turning caching off didn't actually turn it all the way off. Perhaps this has been fixed in current sources, I don't know. It was resulting in an INSERT that sqlite didn't like.

-- Justus

This doesn't matter. SQLite 2 is compiled into php5. The only issue is that you don't have the tools to manually inspect the sqlite database on the command line. Other than that if you have installed php5 you don't need any sqlite installation.

Adhamh

On 11/1/05 2:24 PM, "Robi" rob.markovic@gmail.com wrote:

Justus,

Great detail, thank you. Now the only variable I have is that I've only installed sqlite v3.2.1. I'm wondering if the php sqlite libs work with v3.x or only v2.x.

-- Robi p.s. can the list owner set the reply-to header on the list.. should ease the reply procedure.

php5 does not support sqlite3 at all. See php.net for details.

You'd have to port roundcube to use http://php-sqlite3.sourceforge.net/pmwiki/pmwiki.php which doesn't support everything.

Adhamh

On 11/1/05 6:54 PM, "Robi" rob.markovic@gmail.com wrote:

But I don't want to use sqlite v2. It's abysmal compared to v3. Hence I already have v3 installed, and the php db stuff should work. I don't have php5 either, and neither did Justus.

-- Robi

On 11/1/05, Adhamh Findlay roundcube@adhamh.com wrote:

...

This doesn't matter. SQLite 2 is compiled into php5. The only issue is that you don't have the tools to manually inspect the sqlite database on the command line. Other than that if you have installed php5 you don't need any sqlite installation.

Adhamh

On 11/1/05 2:24 PM, "Robi" rob.markovic@gmail.com wrote:

...

Justus,

Great detail, thank you. Now the only variable I have is that I've only installed sqlite v3.2.1. I'm wondering if the php sqlite libs work with v3.x or only v2.x.

-- Robi p.s. can the list owner set the reply-to header on the list.. should ease the reply procedure.