Install Instructions for sqlite

[loudestnoise]

I was wondering if someone could give me some direction in installing
sqlite on my server. I have installed sqlite3 via aptitude from the
CLI but I'm guessing I'm missing something else or even better I don't
even know how to make the database.

[rick c]

If you have PHP on your server, you already have SQLite installed. In
order to use it from PHP's pdo, as Habari does, your server needs to
have the pdo_sqlite extension enabled.

When you run Habari's installer, if the pdo_sqlite extension is
enabled, SQLite will appear as one of the database type options if you
are running an svn version of Habari. If you are using version 0.4.1,
you will need to verify that the extension is enabled yourself. You
can either ask your isp or create a php file and put this call in it:

<?php
phpinfo();
?>

The results is a list of everything supported by your PHP
installation.

If SQLite is enabled, the installer will create the database file for
you on a successful installation. You don't have to do anything.
However, you need to make sure the directory where your SQLite file
will be is writable by the web server.

Rick

[loudestnoise]

Ok, well I know I have PHP installed, and I see in the page that
resulted from doing phpinfo that pdo_sqlite.ini is there, so it looks
like it's working, but when I run the installer I get an error message
saying,

Installation Issue
The installer couldn't verify your settings, possibly because your
server is not correctly configured. See the manual for information on
how to correct this problem, or continue without verification.

Server Response
404 Not Found Not Found The requested URL /ajax/
check_sqlite_credentials was not found on this server. Apache/2.2.8
(Ubuntu) PHP/5.2.4-2ubuntu5 with Suhosin-Patch Server at
loudestnoise.com Port 80

I'm doing all the server setup stuff myself as I just got one of these
fancy slices from slicehost.com but I'm not sure what to do at this
point.

[rick c]

I haven't run into this, and deal little with setting up Apache, but
from what I can see in the error message, mod_rewrite may need to be
enabled on your web server. Also check that AllowOverride is set. The
remainder of that error message is

You might want to make sure <code>mod_rewrite</code> is enabled and
that <code>AllowOverride</code> is at least set to <code>FileInfo</
code> for the directory where <code>.htaccess</code> resides.

Someone who uses slicehost or knows more about Apache will be able to
tell you more.

Rick

[Chris J. Davis]

habari should make the DB for you. Make sure that your webroot is
writeable for apache.

i am not sure which version of sqlite we support. Hopefully we
support the newest version.

chris

[Chris J. Davis]

do you have mod_rewrite enabled in apache? that is required for this
to work.

[loudestnoise]

That was the issue, now I'm stuck because it tells me that SQLite
requires that the directory that holds the DB file be writable by the
web server. I apparently don't know where the directory that holds the
db file is.

[Chris J. Davis]

same location that all your files are. (index.php, scripts, etc.)

[loudestnoise]

Yipeee, Habari is up and running, I guess I had the wrong permissions
so that was the problem. Always something simple.

[rick c]

Congratulations on getting up and running! Welcome to Habari. :)

Rick