jaux.net wishes you have a happy holiday!
Merry Christmas!
Reply
Monthly Archives: December 2008
SQLite3: Unable to Open Database File
Recently, I’m working on my Skypiea project which is powered by SQLite3 and Python (as CGI script). Yesterday I encountered a program: When the web server ran a CGI script which would update the database, I got an error message said “sqlite3.OperationalError: unable to open database file“.
I searched the web and Google told me I need to specify the full path (no ~ or $HOME etc.) of the database file and the web server needs the write permission to the file. Sure, I actually had done both before the exception occurred.
Having being pissed for a while, I finally figured out what was wrong here: The web server needs the write permission to not only the database file, but also the containing directory of that file.
Yea, just simple like that.
Simple Weather Script for Conky
Wanna Conky to show your local weather? You might had found tons of solutions already on the web, but here comes a simpler one: SimpleWeather.
Requirement:
- Python >= 2.5
How to use it:
- Download weather.py.
- Edit the file, fill in required parameters (read CONFIGURATION first).
- Add ${execi 3600 python the_path_to/weahter.py} to your .conkyrc.
I’m Back
jaux.net had a happy moving! This site is now powered by WordPress 2.7 and is hosted on Slicehost!
As predicted in the previous post, moving and upgrading WordPress was easy, fast and pleasant.
However, one thing hit me during the process was the memory consumption of Apache. Currently, my 256MB slice has only the OS, Apache and sshd running, but there is almost no free memory left. It will probably be a serious problem later on, so I’m going to take a look at some lightweight web servers. The candidates so far are: lighttpd, Cherokee and Nginx.
Moving and Upgrading
jaux.net is going down this weekend in order to move to Slicehost and upgrade to WordPress 2.7. The process will not take too long, in theory.
See you next week!