|
1
|
|
|
2
|
SQLITE REQUIREMENTS
|
|
3
|
-------------------
|
|
4
|
|
|
5
|
To use SQLite with your Drupal installation, the following requirements must be
|
|
6
|
met: Server has PHP 5.2 or later with PDO, and the PDO SQLite driver must be
|
|
7
|
enabled.
|
|
8
|
|
|
9
|
SQLITE DATABASE CREATION
|
|
10
|
------------------------
|
|
11
|
|
|
12
|
The Drupal installer will create the SQLite database for you. The only
|
|
13
|
requirement is that the installer must have write permissions to the directory
|
|
14
|
where the database file resides. This directory (not just the database file) also
|
|
15
|
has to remain writeable by the web server going forward for SQLite to continue to
|
|
16
|
be able to operate.
|
|
17
|
|
|
18
|
On the "Database configuration" form in the "Database file" field, you must
|
|
19
|
supply the exact path to where you wish your database file to reside. It is
|
|
20
|
strongly suggested that you choose a path that is outside of the webroot, yet
|
|
21
|
ensure that the directory is writeable by the web server.
|
|
22
|
|
|
23
|
If you must place your database file in your webroot, you could try using the
|
|
24
|
following in your "Database file" field:
|
|
25
|
|
|
26
|
sites/default/files/.ht.sqlite
|
|
27
|
|
|
28
|
Note: The .ht in the name will tell Apache to prevent the database from being
|
|
29
|
downloaded. Please check that the file is, indeed, protected by your webserver.
|
|
30
|
If not, please consult the documentation of your webserver on how to protect a
|
|
31
|
file from downloading.
|
