13

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?

1
  • here's a great tutorial on how to enble sqlite in a linkyx environment: exteon.ro/en/articles/php. Hope it helps!
    – Dinu
    May 21, 2011 at 22:48

4 Answers 4

14

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

7
  • apt-get seems to be a debian thing, there are workarounds (susewiki.org/index.php?title=Install-apt4suse) but I'm looking for the simplest solution here, there must be some way to just download and reference a sqlite library in Suse. Jun 28, 2009 at 22:30
  • yum is the simple way
    – freiheit
    Jun 28, 2009 at 23:09
  • ok so I converted my VPS from Suse to Debian Linux 4.0 Standard 32-Bit. I type "apt-get install php5-sqlite" and it says "reading packge lists, building dependency tree...couldn't find package php5-sqlite". In /etc/php5/conf.d there are 8 other .ini files but not sqlite.ini. How come it couldn't find the package do I need to run that from a specific directory? (I type "yum" and it says "-bash: yum: command not found".) Jun 29, 2009 at 0:25
  • Debian uses apt-get, Suse offers yum (and maybe zypper). If apt-get can't find the package, check that it exists and check which repositories you have in /etc/apt/sources.list and /etc/apt/sources.list.d.
    – jldugger
    Jun 29, 2009 at 1:31
  • in /etc/apt/sources.list.d I have one file called "debian.list" but no others, can I just download the library from somewhere and reference it in php.ini as on Windows, or does it need to be downloaded and installed somehow? Jun 29, 2009 at 5:38
5

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
1
  • +1: whatever package looked right Apr 2, 2013 at 22:38
1

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

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
  • You can replace natty in the URL with your version's name, like trusty. May 24, 2017 at 13:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.