Posts

Showing posts from December, 2010

Installing MySQL 5.5 on Mac OS X 10.6

Or should I say "unable to install MySQL 5.5 on Mac OS X".  My first attempt at installing MySQL on Mac was with MySQL 5.1 on Snow Leopard.  That worked as expected and without any issues.  MySQL 5.5, however, was a bit tricky. After the install, I got this error on start up: 101224  9:50:00 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. MySQL is not started at this point, so running mysql_upgrade also fails (not that there is anything to upgrade, it's a fresh install). Viva la Google!  After a little digging on Google (ok, a lot of digging), I found this article in the MySQL forums: MySQL Forums :: Install :: Unable to install MySQL 5.5.8 on MacOS 10.6 http://forums.mysql.com/read.php?11,399397,399606#msg-399606 Worked like a charm! So, the complete steps: Download the dmg and install per the reference manual:   http://dev.mysql.com/doc/refman/5.5/en/macosx-installation-pkg.html Edit: /usr/local/mysql/support-files/m

Identifying Datastores Configured in VMware Server 2.0

I ran into the need to start a VMware Server 2.0 virtual machine from the command line.  The vmrun command uses the data store name to locate the vmx file. Unfortunately, the system documentation wasn't readily available, so I needed to determine what stores were configured. There are a few ways to do this: At the command line as root: vmware-vim-cmd hostsvc/datastore/listsummary This will list all datastores in inventory on the host.  And... vmware-vim-cmd vmsvc/getallvms ... will list all vms in inventory on the host, noting the datastore name and path to the vmx file. The caveat to that is you need to be running the command as root.  If you're security conscious like I am, then ssh (how I was connecting the the headless host) doesn't allow root access, even doing an "su" won't work.  So unless you've given permissions to a non-root user to access the certificates and configs, the command line utility won't work.  So now what?  Well, thankfull