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 [...]

Today, after I moved the database around on MySQL for one of my WordPress installs, I was suddenly greeted with this error after logging in: “You do not have sufficient permissions to access this page.” Following some of the guidance on the Codex’ Login Trouble page brought now resolution, some even felt simple-minded, like deactivating [...]

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 [...]

tar cf – <path or file> | 7zr a -si <output>.tar.7z tar outputs to stdout (“-”, the minus), 7-zip, here 7zr, reads from stdin (“-si”) and outputs a 7zip file – all connected by the pipe.

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 [...]

Spring Sommer 2012 has some very strong colour trends, yellow, mangenta and cobalt blue, blocked with each other and black. (c) Zara, image linked from their website This insta-glow-ish yellow top from Zara is a good example of trendy yellow SS2012. 19.99 GBP Link (c) Louis Vuitton, image linked from their website The Louis Vuitton [...]

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 [...]