Before I changed over to using squid3 for my transparent proxy I was using apt-cacher-ng to proxy my debian and kubuntu repositories. The issue I had was that at work there was no apt-cacher-ng proxy, just a transparent squid proxy. Remembering to change the details between home and work became too hard so I went in search of a solution. I really battled to find one, but did eventually come upon this article. ...
There are various ways you can backup sqlite. One of the ways is to use the sqlite3 command line utility: /usr/bin/sqlite3 ~/.local/share/akonadi/akonadi.db SQLite version 3.8.6 2014-08-15 11:46:33 Enter ".help" for usage hints. sqlite> .backup /tmp/akonadi.db sqlite> .quit This will create a backup of akonadi.db in /tmp. Sqlite also comes with a backup API - see https://www.sqlite.org/backup.html. As python tends to be my scripting language of choice I was looking for something that I could use in python. ...
On both my home PC and work laptop I use kontact for my email, calendaring, etc. I didn’t want to use mysql for the underlying database (I don’t particular like it) so decided to use sqlite instead. Generally I have found this to work well, with one or two exceptions. However, searching for how to automate sqlite backups gives numerous results. The easiest way is to stop whatever is writing to it, in this case akonadi, and then copy the database. ...
The other day I upgraded my laptop from Kubuntu 14.04 to 14.10 and after it had completed I found that I had no icons or emoticons in all my GTK applications - including Firefox and Pidgin. Eventually tracked it down to the fact that a particular cache wasn’t available. To fix it you need to run the following command: gdk-pixbuf-query-loaders > /usr/lib/x86_64-linux-gnu/gdk-pixbuf-2.0/2.10.0/loaders.cache If gdk-pixbuf-query-loaders in not installed you need to install the following package: ...