Why MySQL does not start

The other day I was provided with a new Ubuntu server with a large data drive. It seemed a good idea to move (among other things) the mysql data folder onto this drive.

[code language=”bash”]

sudo mv /var/lib /var/media/lib
sudo ln -s /var/media/lib /var

[/code]

However when trying to start MySQL it will no longer start:

[code language=”bash”]

service mysql start
start: Unable to connect to system bus: Failed to connect to socket /var/run/dbus/system_bus_socket: No such file or directory

[/code]

The whole reason I did use a symbolic link was to avoid issues like this. What to do? It turns out AppArmor does not allow mysql to read out of the new /var/media/lib location, as noted in the my.conf file:

[code language=”bash”]

# * IMPORTANT
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.

[/code]

Simply open the mentioned file, duplicate the /var/lib/mysql lines and correct the path to the new locations. Restart AppArmor (or reboot) and Mysql can be started. Verify this by running:

[code language=”bash”]
ps -ef | grep mysql
[/code]

July 30, 2011 at 6:15 AM in SQL

Currently Playing #1

Currently playing:

  1. Kard Combat (http://www.kardcombat.com/)
  2. Wooords (http://toucharcade.com/2011/07/25/wooor … word-game/)
  3. Reckless Getaway (http://www.polarbit.com/our-games/reckless-getaway/)
  4. Shake Spears! (http://www.gamezebo.com/games/shake-spears/review)

Or apps wise:

  1. Due (http://www.dueapp.com/)
  2. Air Video (http://www.inmethod.com/air-video/index.html)
  3. Kik (http://kik.com/)
  4. ShoppingList (http://itunes.apple.com/us/app/shopping … 58413?mt=8)
  5. InstaCast (http://vemedio.com/products/instacast)

July 28, 2011 at 10:44 AM in iOS

Host Editor 7 – Hassle free host editing for Win7-XP

I was fedup with the poor experience of editing my host file, which is often needed when developing websites. So I quickly created an AutoHotkey script for the purpose.

15:03:50 – me: anyone knows a host editor app that works under windows 7
15:04:51 – me: fed up trying to first find the hosts file, then not being able to save because I again forgot to run notepad with admin privileges.

Download @ Host Editor 7 – Hassle free host editing for Win7-XP – DonationCoder.com.

July 18, 2011 at 3:32 PM in HostEditor, Windows

Rupert Murdoch facing BSkyB defeat as parties unite in call to drop takeover

Rupert Murdoch will today face the humiliation of the Commons issuing a unanimous all-party call for his scandal-ridden News Corporation to withdraw its £8bn bid for BSkyB, the great commercial prize he has been pursuing to cement his dominance of the British media landscape.

In an extraordinary volte-face, David Cameron will disown the media tycoon by leading his party through the lobbies to urge him to drop the bid. Murdoch can defy parliament and press ahead with the bid, prompting a Competition Commission inquiry, but he risks finding himself ostracised by a political class that once scrambled to bend to his wishes.

I’m sure it has nothing to do with MPs no longer wishing to be associated with a news organisation that might give them certain favours. I still have yet to find a convincing argument on BSkyB being related to the phone hacking scandal. Until then there must be other, presently unknown, reasons for this change in direction.

via The Guardian.

July 13, 2011 at 9:08 AM in Technology

iPhone Home Screen

iPhone Home Screen July 2011It’s always fun to discover new apps, and a good way to see which apps are used most is to look at the first home screen. So here’s mine, where is yours?

The apps you can see are (apart from the built in Apple ones):

  1. Captio – Send yourself a quick note with just one tap.
  2. Simplenote – An easy way  to keep notes, lists, ideas, and more.
  3. Action Lists – Getting Things Done made easy.
  4. moneyStrands – Personal finance software.
  5. UK & ROI – navFree navigation software.
  6. ShoppingList – The shopping tool for your iPhone or iPod touch.
  7. Dropbox – Bring your photos, docs, and videos anywhere and share them easily.
  8. Due – The missing reminder app fit for your homescreen (multiple alarms)
  9. Instacast – Instant access to podcast subscriptions, stream or download episodes wirelessly, follow show notes and enjoy audio and video podcasts on-the-go.
  10. Tiny Tower – Tower people management game

July 9, 2011 at 3:58 PM in iOS