Home / server / Questions / 32982
Accepted
Edward Tanguay
Asked: 2009-06-29 13:54:50 +0800 CST

How do I enable SQLite on Linux/Apache/PHP?

  • 772

To enable SQLite on my Windows/Apache/PHP setup, I uncomment the following lines in the php.ini file and restart Apache:

extension=php_pdo.dll
extension=php_pdo_sqlite.dll

Now I have a VPS with Suse Linux 10.3 and Apache/PHP was set automatically. Looking through the php.ini file to make the above changes, I see that things are a little different on Linux:

  • there is no list of extensions to uncomment
  • I found "extension_dir = /usr/lib/php5/extensions" but in this directory find only:
    • pdo.so
    • pdo_mysql.so

How can I enable SQLite in this Linux environment?

linux php php.ini sqlite

4 Answers

  1. Best Answer

    i cannot tell how exactly for suse this would work. in debian world it's:

    apt-get install php5-sqlite

    this will install needed library and add /etc/php5/conf.d/sqlite.ini with

    extension=sqlite.so

    so first - use yum to see install needed package, then add to php.ini line above.

    EDIT: for php7 the command is:

    apt-get install php7.0-sqlite

    and php.ini file is located at: sudo nano /etc/php/7.0/apache2/php.ini where you have to enable the extension=sqlite.so

    • 14

  2. Short version, but might be wrong because I don't know what package repositories your system is set up with:

    yum install php5-sqlite

    Long version:

    yum search php sqlite

    Or just search for one:

    yum search sqlite

    Look at the list that comes back. Figure out what you need, then:

    yum install whatever_package_looked_right_from_the_list
    • 5

  3. SQLite support is enabled by default on a standard Linux PHP compilation starting with PHP 5.0.

    Which PHP version do you use? Did you checked the phpinfo() output to see if SQLite is enabled? SQLite will be enabled unless the 

    --disable-sqlite

    parameter is set in configure string.

    • 1

  4. Linux Mint 12 was missing sqlite and it was generating the following error:

    PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/sqlite.so' - /usr/lib/php5/20090626/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0

    Best practise for me it was to download and unpack sqlite.so to /usr/lib/php5/20090626/

    • 1