Linux goes Zen

This here is a simple cheat sheet of CLI commands to move or migrate directories and sql databases from one machine to another: Dump a database table from MySQL: $ mysqldump -u <db-username> -<db-password> –opt –quote-names –allow-keywords –complete-insert <db-name> <db-table> > <output-file> Slurp a database table back into MySQL: $ mysql -u <db-username> –password=<db-password> -D [...]

If you see an error in your Apache2 logs “mod_fcgid: HTTP request length 131198 (so far) exceeds MaxRequestLen (131072)” The defaults for fcgi have changed from Lenny (was 1GB) to Squeeze (is now 128KB) Solution is: Go to /etc/apache2/mods-available/fcgid.conf and add (here for 2GB): <IfModule mod_fcgid.c> … … # 2GB FcgidMaxRequestLen 2147483648 </IfModule> via Simple [...]

Ok, read: http://www.g-loaded.eu/2007/08/10/ssl-enabled-name-based-apache-virtual-hosts-with-mod_gnutls/ http://forceping.com/2010/03/18/mod_gnutls-sorgt-fur-namebased-ssl-virtualhosts/ http://www.outoforder.cc/projects/apache/mod_gnutls/docs/#example then install $ apt-get install libapache2-mod-gnutls then run $ a2enmod gnutls check if anything is configured in these files that would prevent apache2 from working with gnutls: nano /etc/apache2/httpd.conf nano /etc/apache2/apache.conf configure your virtual hosts, refer to the manual mentioned above on how to do that nano /etc/apache2/sites-enabled/000-default Possibly your [...]

If you, like me, get many “temporarily rejected RCPT <mail@example.com>: remote host address is the local host” messages in exim’s /var/log/exim4/mainlog log, then here’s what I found out to be the solution. So you’ve freshly installed exim or got a fresh install with Debian Squeeze? You did not tinker with the config files manually but [...]

If you want to trim, cut, chop or in any way edit a video on the command line, these commands here help you to get simple editing done with ffmpeg: Editing a section out from the middle of a video: $ ffmpeg -i <input> -ss hh:mm:ss.000 -t hh:mm:ss.000 -sameq <output> (-ss seek to position, -t [...]

Here’s how to convert a video to a series / sequence of jpeg images, effectively converting every still frame into a jpg, with numbering, using the magic of ffmpeg: ffmpeg -i <input_video> -f image2 <output_name>%03d.jpg a more verbose variant: ffmpeg -i <input>.avi -r 1 -s WxH -f image2 <output>-%03d.jpeg To create a video from a [...]

Recently, on a very fresh install of Debian Squeeze I’ve noticed that on boot, the log said “Activating Swap… FAILED”. A look into /etc/fstab brought up nothing helpful: UUID=xyz none  swap    sw 0 0 seemed okay. So as it seems there was an error with the volume that was listed as swap. Then, listing partitions [...]

Go to the start page dctp.tv, and find the URI of the video you want to download. From the Flash caroussell, the links are a little hard to extract. Look at the source and look for URLs starting with “/filme/”. You’ll also find the cloud front URL there, or visit: http://dctptvv2.appspot.com/streaming_servers/   Then visit the [...]

Installing the newest generation of Wacom Bamboo, Bamboo P&T (Pen & Touch), Bamboo Pen, CTL-470, CTH-470, etc. tablets under Linux can be a pain. We hear that in kernel 3.3 they are supported out-of-the-box, but that’s in 2013! Until then, here’s how to do it under Ubuntu 10.10+, current Debian etc. Forget all other guides. [...]

Switch on debugging and depending on your swfupload version it tells you either “Invalid function name: StartUpload” or “Call to StartUpload failed“. Even more strange, it sometimes happens, sometimes doesn’t, depending on if the page was loaded or reloaded. The solution is: it’s caused by the swfupload element, the button, being inside a DOM element [...]