Showing posts with label openwrt. Show all posts
Showing posts with label openwrt. Show all posts

Thursday, March 14, 2013

Today is a great day ...

Just faced a problem that pushed me to the dark side. Long story short my small project tracking system on OpenWRT router doesn't work anymore cause important for it php extension sqlite can't use the database file. Some lock-ups due to newer libsqlite3 version which is not compatible with php 5.4 version for OpenWRT, but required for subversion-server. I don't know what to say more (lost at least 1-2 hours to understand what's the problem), but installed the original firmware and did the right thing - got a new 'real' server based on Ubuntu Server 12.10

Sunday, February 24, 2013

Fixing the 'SQLite compiled ...' problem on OpenWRT

Some users maybe noticed that after installing subversion server on their OpenWRT device (mine is Tp-Link TL-WR1043ND with ATTITUDE ADJUSTMENT (bleeding edge, r31214)) they cannot import or export files to it due to old libsqlite3. So, to fix it, just update the library with the following commands:
opkg update
opkg upgrade libsqlite3

Then stop and start the server with:
/etc/init.d/subversion stop
/etc/init.d/subversion start

There you go - no more sqlite error when transferring files :)

Important: It is possible to face the 'General error 5: database is locked' even when svn server is removed. Probably the reason is somewhere in PDO and usage of newer libsqlite3 version ... Doh