|
Chris@0
|
1
|
|
Chris@0
|
2 SQLITE REQUIREMENTS
|
|
Chris@0
|
3 -------------------
|
|
Chris@0
|
4
|
|
Chris@0
|
5 To use SQLite with your Drupal installation, the following requirements must be
|
|
Chris@0
|
6 met: Server has PHP 5.3.10 or later with PDO, and the PDO SQLite driver must be
|
|
Chris@0
|
7 enabled.
|
|
Chris@0
|
8
|
|
Chris@17
|
9 If you have not pdo_sqlite available depending on your system there are different ways to install it.
|
|
Chris@17
|
10
|
|
Chris@17
|
11 Windows
|
|
Chris@17
|
12 -------
|
|
Chris@17
|
13 Read more about it on http://www.php.net/manual/en/pdo.installation.php
|
|
Chris@17
|
14
|
|
Chris@17
|
15 Linux
|
|
Chris@17
|
16 -----
|
|
Chris@17
|
17
|
|
Chris@17
|
18 sudo apt-get install php-sqlite3
|
|
Chris@17
|
19
|
|
Chris@0
|
20 SQLITE DATABASE CREATION
|
|
Chris@0
|
21 ------------------------
|
|
Chris@0
|
22
|
|
Chris@0
|
23 The Drupal installer will create the SQLite database for you. The only
|
|
Chris@0
|
24 requirement is that the installer must have write permissions to the directory
|
|
Chris@0
|
25 where the database file resides. This directory (not just the database file) also
|
|
Chris@0
|
26 has to remain writeable by the web server going forward for SQLite to continue to
|
|
Chris@0
|
27 be able to operate.
|
|
Chris@0
|
28
|
|
Chris@0
|
29 On the "Database configuration" form in the "Database file" field, you must
|
|
Chris@0
|
30 supply the exact path to where you wish your database file to reside. It is
|
|
Chris@0
|
31 strongly suggested that you choose a path that is outside of the webroot, yet
|
|
Chris@0
|
32 ensure that the directory is writeable by the web server.
|
|
Chris@0
|
33
|
|
Chris@0
|
34 If you must place your database file in your webroot, you could try using the
|
|
Chris@0
|
35 following in your "Database file" field:
|
|
Chris@0
|
36
|
|
Chris@0
|
37 sites/default/files/.ht.sqlite
|
|
Chris@0
|
38
|
|
Chris@0
|
39 Note: The .ht in the name will tell Apache to prevent the database from being
|
|
Chris@0
|
40 downloaded. Please check that the file is, indeed, protected by your webserver.
|
|
Chris@0
|
41 If not, please consult the documentation of your webserver on how to protect a
|
|
Chris@0
|
42 file from downloading.
|
