MySQL Reference

Doing some MySQL work over the past couple of days, I googled a couple topics I needed help with, and both times I ended up at the same place.

• Redhat Enterprise Linux (RHEL) Install and Configure MySQL Database Server
• How Do I Enable Remote Access To MySQL Database Server?

So thanks, nixCraft, for the assist!!

Upgrading Debian

Upgrading from Squeeze to Wheezy

Why? Why not!!

Actually, it's because of the whole google-chrome-stable and gconf-blah-blah business. It's scrolled off my screen, but it's all over the internets.

Mainly I'm following the steps I found here at HowtoForge.

Updated my sources.list, just replacing squeeze with wheezy

Did an update and an upgrade, started to do a dist-upgrade, but got this error:

E: Could not perform immediate configuration on 'openjdk-6-jre'. Please see man 5 apt.conf under APT::Immediate-Configure for details. (2)

Did this to continue:

sudo apt-get remove default-jre
sudo apt-get remove openjdk-6-jre

Now it's running... we'll see what happens next!

How about being WAN'd in via SSH and my end goes sleepy or wonky? Yikes!! But I did a:

sudo dpkg --configure -a

and the dist-upgrade is chugging along again.

A word of advice to whoever is responsible for configuration files: It sure would be nice if I could resolve all of the config conflicts either before or after the upgrade. Having the upgrade pause for me to Z and cp and blah blah blah, that's annoying.

And it's done. Now to fix the above:

sudo apt-get install default-jre
sudo apt-get install google-chrome-stable

Ta-da! It works! Even Chrome is back!!

Starting Oracle

This is what happens when I don't write stuff down. Fortunately I was able to piece together what I needed to remember when starting up my database after a reboot. And now I'm writing it down!

$ cd install-area/oracle11/software
$ setenv ORACLE_HOME `pwd`

$ setenv ORACLE_SID orcl

$ ./bin/sqlplus 'sys/password as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 21 06:35:36 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
.
.
.

$ ./bin/lsnrctl start

Filed under note-to-self and let's hope next time I remember there is a note!

Debian Console Mode?

I got myself stuck in VNC full-screen mode and like any good monkey just started pressing random key combinations. And I actually stumbled onto something magical and useful!

Debian Wireless (solved)

I was struggling quite a bit with the Wi-Fi on the TiBook. Then for some reason I rebuilt Debian and had a chance to start over.

My Apache setup

What, no notes to self about my previous Apache installation? Well how about I do that this time...

Debian on the TiBook!

I've got Debian on my TiBook!!

Firefox already running? Not.

Dear Me,

Next time Firefox won't start and complains of "Firefox is already running but is not responding..."

I have a new favorite OS!

I have a new favorite OS - spoiler alert, it's Debian!

Where the streets have node names

Have you ever googled your email address? If you do, you'll find all kinds of things you've posted on the internets. And for once I'm not using that word sarcastically!

Samsung 923NW Screws

Got a Samsung 923NW? Did you take the stand off and lose the screws? And now you want them back?

TightVNC selection sharing

With RealVNC you use vncconfig, but according to this post by a guy named Thomas, this is what you'll put in your xstartup for tightvnc:

autocutsel -s PRIMARY -fork

Thanks, Thomas from the Internets!

Reverting iTunes to 10.6.3 -- yes, you can!!

Do you hate iTunes 11 as much as I do? Are you so angry with Apple that you're ready to throw your Mac through a window? Please, open the window first and make sure there is nobody on the ground below.

OR... (better yet, DON'T INSTALL ITUNES 11!! -- I hope somebody reads this before it's too late)

VNC keymap swap

Ahhhhhhhhhh! (that's the choir of angels sound)

I switched to tightvncserver hoping that my vnc crashing will go away ::fingers crossed::

MySQLdb ≠ autocommit

Something else I've learned recently is that MySQLdb disables autocommit.

Permission and PSP Import

If you have a PSP page and you're trying to import a custom module and you get an error like this:

ImportError: No module named mymodule

Getting older sucks!!

;;(mouse-set-font "-misc-fixed-medium-r-normal--13-*-*-*-c-70-iso8859-1" "7x13")

(mouse-set-font "-misc-fixed-medium-r-normal--15-*-*-*-c-90-iso8859-1" "9x15")

Trot Diamond, 2005-2012

Trot has gone to herd the chickens in heaven. He was born with fifteen years of love inside him, but used them up in only seven. 

113 hours

I just finished with a project I've had on my list for the longest time. I watched all seven seasons of The West Wing, my favorite TV show of all time. It only took me 40 days to watch 154 episodes, about 113 hours running time. And no, I have no idea how I managed that!

Android Calendar tip

I stumbled onto a useful feature in the Android Calendar this morning.

I'd been trying without any luck to find a way to make Agenda the default tab. I'd long given up wondering why the Week view wasn't available anymore.

Then mostly out of frustration, I long-pressed the Agenda icon and all of a sudden I was looking at this screen:

So it turns out you can choose which Calendar views to choose from and which order they appear in at the bottom of the Calendar screen. Yay!