Clearing the MySql Logs

mysql> show master logs;

+------------------+------------+
| Log_name         | File_size  |
+------------------+------------+
| mysql-bin.000023 | 1074039776 |
| mysql-bin.000024 | 1023334365 |
| mysql-bin.000025 | 1073742100 |
| mysql-bin.000026 | 4254255    |
| mysql-bin.000027 | 117        |
| mysql-bin.000028 | 98         |
+------------------+------------+
6 rows in set (0.00 sec)

mysql> purge master logs to 'mysql-bin.000028';
Query OK, 0 rows affected (10.35 sec)

mysql> show master logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000028 | 98        |
+------------------+-----------+
1 row in set (0.00 sec)

mysql>

VNC server : Fatal server error: could not open default font ‘fixed’

Trying to run vnc-server recently on a debian system, I ran into the following issue:

cat .vnc/debian-dev\:1.log
14/08/09 14:40:01 Xvnc version 3.3.7 - built Dec 30 2006 12:50:35
14/08/09 14:40:01 Copyright (C) 2002-2003 RealVNC Ltd.
14/08/09 14:40:01 Copyright (C) 1994-2000 AT&T Laboratories Cambridge.
14/08/09 14:40:01 All Rights Reserved.
14/08/09 14:40:01 See http://www.realvnc.com for information on VNC
14/08/09 14:40:01 Desktop name 'X' (debian-dev:1)
14/08/09 14:40:01 Protocol version supported 3.3
14/08/09 14:40:01 Listening for VNC connections on TCP port 5901
Font directory '/usr/share/fonts/truetype/' not found - ignoring

Fatal server error:
could not open default font 'fixed'


I solved the issue with some apt-get for dependancies as per below

apt-get install xutils xbase-clients xfonts-base xfonts-75dpi xfonts-100dpi

Ref:  http://www.debianhelp.org/node/5720

QuickSilver-esque shortcuts application on Ubuntu Debian GNU/Linux

Some of my colleagues have Apple Macs and use an application called ‘Quick Silver’ for managing frequently use application/scripts/text files/notes/ims/etc.

I was impressed with what one could do with it and began looking for something similar on Ubuntu.

There is a clone for Gnome called Gnome-Do [ http://www.gnomedo.com ] that lives up to the task pretty well from what I can gather so-far. There are some good updates in the ‘Intrepid Ibex’ release (8.10) that are not in the ‘Hardy Heron’ release (8.04), such as a more complete and useful preferences menu, more plugins and managing them individually through the applications preferences.

Try it out, after installing gnome-do, you need to set it up to launch at gnome login (easily done via the preferences in the intrepid version). Then you can invoke it with the SUPER+SPACEBAR short-cut.

Using MySql with Jahia on Debian GNU/Linux

After installing Jahia today, I wanted to use the MySql database instead of the default HyperSonic. I am currently using MySql for other purposes and want to have a look at accessing the Jahia database to re-use content.

Initially when I created the ‘jahia’ database in mysql and granted permissions to the Jahia user, Jahia reported:

"This database doesn't seem to support extended charsets."

Dropping the database and recreating it with a unicode dataset sorts this little niggle out.

mysql> create database jahia character set = utf8;

Synching you Palm Tungsten|T to J-Pilot over USB on Ubuntu Debian GNU/Linux

Ok, simple enough.

Install J-Pilot (I used apt, apt-get install jpilot !)

• Navigate the menu to File -> Preferences
• Select the “Settings’ tab”
• Enter usb: in the “Serial Port” field.
• Select “OK”
• Press the HotSync button on the cradle.
• Click the HotSync button on the left of the J-Pilot window.

Next for some plugins, watch this space!

Palm Pilot: Backing stuff up over USB on Ubuntu Debian GNU/Linux

Quite easy really. Once you have the usb connection validated (see earlier post), backing up is simply a matter of :

pilot-xfer -p usb: -b ~/my-new-palm-backup-dir

You can also do a local update (-u palm-backup-dir) or a sync (-s palm-backup-dir).

Further options are available with pilot-xfer --help

Now to have a look at J-Pilot, a GUI. (no, it’s not written in Java)

Palm Tungsten T, USB, Pilot-Link, Ubuntu Debian GNU/Linux

Couldn’t get my old Palm Tungsten T to work with pilot link. After reading around and trying various things with dev files, I eventually found this post about a bug in pilot link.

Sure enough, removing the visor module with

sudo modprobe -r visor

meant the Palm now responded to

pilot-xfer -p usb: -l

and I got a lot of output about files on the Palm when I hit the sync button on the USB cradle.

So, I have added

blacklist visor

to

/etc/modprobe.d/blacklist

so that module won’t be loaded in the future.

Hopefully this bodes well for my attempts at seamless synchronisation of my Palm Tungsten|T on Ubuntu

Want to see the date and time in the Mutt mail client when reading e-mail ?

Then add the following to your ~/.muttrc

ignore *
unignore from date subject to cc
unignore organization organisation x-mailer: x-newsreader: x-mailing-list:
unignore posted-to:

Really, you just need to add unignore date. This snippet above firstly turns everything off, then selectively decides to show the headers as listed with unignore.

I have been slightly annoyed for a while now that my Mutt configuration wasn’t displaying the send-time when i was reading emails. I had the date in the e-mail list, but nothing in the actual email.

Finally I got to look it up

Linux on USB disks : Damn Small Linux

Today I tried out installing two separate, cut-down, versions of Linux onto a USB drive.

This post details my experience with damn small linux.

Damn Small Linux

I tried getting various files, including the embedded zip file, but failed to install to
a USB disk. The idea seemed pretty simple, unzip the files onto the USB
disk, run sys linux. Go. But it just wouldn’t work. Kept reporting
missing files early in boot.

The alternative, boot into the system form the iso and install from there, also failed.

Note, in both cases I am booting into a virtual machine, not natively.

http://ftp.heanet.ie/mirrors/damnsmalllinux.org/current/dsl-4.2.5.iso

Instead of burning a CDR I booted the cd image with Qemu, a free virtual machine emulator (available in Ubuntu Debian Gnu/Linux)

qemu -k en-gb -m 512 -localtime -boot d -cdrom dsl-4.2.5.iso /dev/sdb1

I provided the USB drive as the hard-drive to the virtual machine
(/dev/sdb1) and instructed the boot drive to be the cd (‘-cdrom
cd-image.iso’) with the option ‘-boot d’.

DSL booted up into the GUI without issue.

Then
I selected the install option “USB-HDD Pendrive Install.” from the DSL Menu -> Apps -> Tools

I also tried HDD install.

Neither work. The filesystem has errors on creation. Might try again when booted native from the CD, instead of through the virtual macine.

Linux on USB disks : Puppy Linux

Today I tried out installing two separate, cut-down, versions of Linux onto a USB drive.

This post details my experience with puppy linux.

Puppy linux

I tried getting various files but ended up using the iso download file.

ftp://ibiblio.org/pub/linux/distributions/puppylinux/puppy-3.01-seamonkey.iso

Instead of burning a CDR I booted the cd image with Qemu, a free virtual machine emulator (available in Ubuntu Debian Gnu/Linux)

qemu -k en-gb -m 512 -localtime -boot d -cdrom puppy-3.01-seamonkey.iso /dev/sdb1

I provided the USB drive as the hard-drive to the virtual machine (/dev/sdb1) and instructed the boot drive to be the cd (‘-cdrom cd-image.iso) with the option ‘-boot d’.

I booted into XVESA, XORG didn’t work.
Then I selected the install option “Install to IDE flash drive.” from the puppy installer at Menu -> Setup -> Puppy Universal Installer

I shut down the virtual machine, and rebooted, this time from the newly set-up USB disk, with:

qemu -k en-gb -m 512 -localtime /dev/sdb1

Worked fine, no issues !

Previously I had tried downloading other puppy linux files from the download server, but failed to install to a USB disk (without too much trying I must admit though in fairness)