cache with CHI DBI driver and SQLite

I want to use CHI with SQLite backend for my app.
Tested in cgi environment it worked ok, but under mod_perl
it croaks in CHI DBI driver when trying to create the tables with
mysterious "no error" error.


I think my problem is identical to the one I found described here:

http://lists.scsys.co.uk/pipermail/dbd-sqlite/2010-March/000 159.html

Anyone has an idea how to fix it?


Thank you,
Jiri

Re: cache with CHI DBI driver and SQLite

2010/4/27 Jiøí Pavlovsk=FD :
> I want to use CHI with SQLite backend for my app.
> Tested in cgi environment it worked ok, but under mod_perl
> it croaks in CHI DBI driver when trying to create the tables with mysteri=
ous
> "no error" error.

Try running a small piece of code that opens a SQLite database and
writes to it from mod_perl. If that doesn't work then you may need to
re-compile DBD::SQLite with the same perl that you compiled mod_perl
with.

- Perrin

Re: cache with CHI DBI driver and SQLite

On 27.4.2010 20:39, Perrin Harkins wrote:
> 2010/4/27 Jiøí Pavlovsk=FD:
>> I want to use CHI with SQLite backend for my app.
>> Tested in cgi environment it worked ok, but under mod_perl
>> it croaks in CHI DBI driver when trying to create the tables with myst=
erious
>> "no error" error.
>
> Try running a small piece of code that opens a SQLite database and
> writes to it from mod_perl. If that doesn't work then you may need to
> re-compile DBD::SQLite with the same perl that you compiled mod_perl
> with.


I found the problem: DBD::SQLite comes with bundled sqlite code and=20
doesn't use the system sqlite.