Differences

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

--- blog:linux:sqlite_ubuntu12_04 [17.03.2013 19:29] – Page moved from blog:2013-03-03:sqlite_ubuntu12_04 to blog:linux:sqlite_ubuntu12_04 eanderalx
+++ linux:sqlite_ubuntu12_04 [23.03.2013 20:14] – removed 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 BlogTNG should work.
-===== Links =====
-http://www.chrisge.org/blog/2012-07-11/kurztipp_sqlite_unter_ubuntu_12.04