EanderAlx.org

Linux, Virtualization and whatever I find interesting ...

User Tools


Site Tools


linux:sqlite_ubuntu12_04

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
linux:sqlite_ubuntu12_04 [23.03.2013 20:14] – removed eanderalxlinux:sqlite_ubuntu12_04 [06.06.2013 15:25] (current) – [Get sqlite2] eanderalx
Line 1: Line 1:
 +====== Sqlite2 for BlogTNG on Ubuntu 12.04 ======
 +
 +I recently installed a <nowiki>DokuWiki</nowiki> on Ubuntu 12.04 Server Edition.
 +But after adding [[https://www.dokuwiki.org/plugin:blogtng|BlogTNG]] I only get an Error 500
 +~~READMORE~~
 +<code>
 +PHP Fatal error:  Call to undefined function sqlite_open() in /lib/plugins/blogtng/helper/sqlite.php on line 44
 +</code>
 +After some searching I find out that:
 +
 +"//The plugin creates a blogtng.sqlite file which is currently a SQLite2 database and will not work with sqlite3 installed//"((https://www.dokuwiki.org/plugin:blogtng))
 +
 +but it seems Ubuntu 12.04 no longer has sqlite2.
 +
 +<code>
 +ii  libaprutil1-dbd-sqlite3          1.3.12+dfsg-3              Apache Portable Runtime Utility Library - SQLite3 Driver
 +ii  libsqlite0                       2.8.17-7fakesync1build1    SQLite shared library
 +ii  libsqlite3-0                     3.7.9-2ubuntu1.1           SQLite 3 shared library
 +ii  php5-sqlite                      5.3.10-1ubuntu3.5          SQLite module for php5
 +ii  sqlite3                          3.7.9-2ubuntu1.1           Command line interface for SQLite 3
 +</code>
 +
 +These are the package versions. No v2!
 +
 +===== Get sqlite2 =====
 +
 +[[http://www.chrisge.org/blog/2012-07-11/kurztipp_sqlite_unter_ubuntu_12.04|Here]] I found a solution. A little bit dirty but working. The documentation mostly worked for me only the path for the .so file I had to ajust. Here my documentation perhaps if someone else have the Problem the solution will be found faster.
 +
 +We are manipulating libraries I think you know: This changes have to be done as root user (or with sudo). And pleas be careful don't damage your installation
 +
 +You have to get an older sqlite package from a prior Ubuntu.\\
 +**x64**<code>wget http://security.ubuntu.com/ubuntu/pool/main/p/php5/php5-sqlite_5.3.5-1ubuntu7.11_amd64.deb</code>
 +**x32**<code>wget http://security.ubuntu.com/ubuntu/pool/main/p/php5/php5-sqlite_5.3.5-1ubuntu7.11_i386.deb</code>
 +
 +After this extract it<code bash>
 +cd /tmp
 +mkdir sqlite
 +dpkg -x php5-sqlite_5.3.5-1ubuntu7.11_i386.deb sqlite
 +</code>
 +And copy the library to the others<code bash>
 +cp -iv sqlite/usr/lib/php5/20090626+lfs/sqlite.so /usr/lib/php5/20090626+lfs
 +</code>
 +Now you have to create an ini file witch activates the new module<code bash /etc/php5/conf.d/sqlite.ini>
 +; configuration for php SQLite module
 +extension=sqlite.so
 +</code>
 +And finaly restart your apache<code>service apache2 restart</code>
 +
 +Now <nowiki>BlogTNG</nowiki> should work.
 +
 +===== Links =====
 +
 +http://www.chrisge.org/blog/2012-07-11/kurztipp_sqlite_unter_ubuntu_12.04
  
linux/sqlite_ubuntu12_04.txt · Last modified: 06.06.2013 15:25 by eanderalx