Community Wiki

From (mt) Community Wiki

Overview

The default configuration of the (dv) Dedicated-Virtual Server 4.0 product line lacks php-sqlite packages. This is because the (dv) 4.0 ships with SQLite 3.x (required for RPM) and the PHP packages were built for SQLite2.x.

Solutions

The following options are available for customers that want to use SQLite with their PHP applications:

Option 1

Use the PHP PDO extensions (PHP PDO methods and functions) to create/open SQLite databases. To do this, please consult the PHP PDO documentation relating to SQLite:

• http://www.php.net/manual/en/pdo.drivers.php
• http://www.php.net/manual/en/ref.pdo-sqlite.php

Option 2

Install SQLite 2.x and PHP SQLite RPM packages:

wget http://rpms.famillecollet.com/enterprise/5/remi/x86_64/sqlite2-2.8.17-2.el5.remi.x86_64.rpm
wget http://rpms.famillecollet.com/enterprise/5/remi/x86_64/php-sqlite-5.3.5-1.el5.remi.1.x86_64.rpm

RPM -ivh sqlite2-2.8.17-2.el5.remi.x86_64.rpm
RPM -Uvh php-sqlite-5.3.5-1.el5.remi.1.x86_64.rpm

service httpd restart

Option 2 is possible. This is because the SQLite 3.x package installs its files (libraries and binaries) as sqlite3, while the SQLite 2.x installs its packages as sqlite.

After a successful installation of SQLite 2.x and the php-sqlite package, your phpinfo() should have the SQLite section added to it. See Figure 1:

Figure 1: SQLite is now listed on your phpifo.php.

Resources

• SQLite Documentation