Site Sponsors:
Installing MySQL Server & Workbench 
In a previous article we praised the innovative way Red Had allows us to rapidly install things like MySQL.

For the new learner however, note that at the time of this writing that only the MySQL Client (mysql-client) toolset will be installed.

Service, Please

If you are looking to do some R&D on your local host (we use a Virtual Box), then one will want to also install the MySQL Server tools (mysql-server), as well:

yum install mysql-server

Thereafter (*) we can start the locus via:

service mysqld start

As well as subsequently begin the MySQL console interface simply by typing
at the console interface.

MySQL Workbench

For those of us who absolutely love Microsoft SQL Server's SQL Management Studio (SSMS), note that MySQL has a must-have graphical tool set, as well. Formerly known as "MySQL Administrator", we now call it the "Workbench."

No matter what we call it however, the Community Edition of the GUI is the very next item most R&D folks will want to download.

Again at the time of this writing however, there is often an installation caveat. Before installation, try
yum install ... x86_64.rpm
if you run into problems whilst doing something like
yum install mysql-workbench-community-6.1.7-1.el6.x86_64.rpm
Once installed, merely enter
at the console to get things rolling.

Google Fodder

Installing the MySQL Server will resolve error message such as:
Error: Package: mysql-workbench-community-6.1.7-1.el6.x86_64 (/mysql-workbench-community-6.1.7-1.el6.x86_64) Requires:

[ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

-as well as:
mysqld: unrecognized service

or someday perhaps even:
mysqld: unrecognised service  ;-)

Ubuntu & Elsewhere

(*) Note that Ubuntu learns will want to use
sudo apd-get install mysql-server
sudo service mysqld start
rather than
yum ...
. Otherwise, everything else in this post will work the same.

[ view entry ] ( 1632 views )   |  permalink  |  related link
Ubuntu 10.04 LTS & LibreOffice 
Collected from various sources, please allow me to consolidate my notes on how to REPLACE the default version of OpenOffice - as included with Ubuntu 10.04 LTS - with LibreOffice.

Removing OpenOffice

In order to avoid crippling programs that require spell-checking (like FireFox), one needs to be very selective in choosing what we remove:

sudo apt-get purge uno-libs3 ure

Installing LibreOffice

In order to install LibreOffice, the default repositories have to be added:

sudo apt-get install python-software-properties
sudo apt-add-repository ppa:libreoffice/libreoffice-4-0
Ignore the "gpg: no ultimately trusted keys found."


sudo apt-get update
sudo apt-get install libreoffice
sudo apt-get upgrade

BONUS: If yours is a new install and / or you want to install Java (not required), then while working at that command-line terminal here is the best way to install Oracle Java:

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer

Next, simply select "Applications | Ubuntu Software Center" to search for & install LibreOffice:

To verify all has worked properly, check to see that the menu shortuts have been created.

OF course the trouble with OpenOffice is that since Oracle has far-outsourced the R&D of the project overseas (just like Microsoft Office - Completely ignored CUA!), it no longer works properly. Unlike OpenOffice, I have yet to crash LibreOffice under Ubuntu when (for example) converting documents between the Open and Microsoft Formats.

See: ... rg-in.html


[ view entry ] ( 2543 views )   |  permalink
Installing Ubuntu on the iMac G3 PowerPC (PPC) 
There is something truly wonderful about keeping those old computers doing useful things. -So as everyone from Apple to Microsoft encourages us to chum our old hardware into the ocean by dropping support, I find more and more reasons to convert them from Windows, OS 9, or OS X, to Linux.

Indeed, as feature-bloat & patches make proprietary operating systems slower and slower each day, many have discovered that even 12-year-old hardware can do some pretty mainframe-worthy operations. All due to the lightweight machine requirement of Linux!

Dusting off a few G3s today, here is the process:

(1) Create a bootable CD from the ISO. Because I prefer the long-time support versions (LTS), we used Lucid Lynx (Version 10.04.) A CD-R worked fine.

(2) Start the computer, then insert the CD into that iMac (or any Apple PowerPC.)

(3) Re-start the computer, afterward holding down the 'c' key until the CD boots.

(4) Use the 'live' video option, as mentioned at the boot prompt. (i.e boot: video=ofonly)

(5) When the install complains, use the default low-res setting for a "this boot only" option.

(6) Once the graphical Ubuntu screen shows, wait a few minutes to cancel the package management prompting. -While this step is optional, it makes things a whole lot easier to understand.

(7) Click on the install icon, and install as prompted / desired.

(*) Note that once Ubuntu is installed, that the disk will automatically eject. If you abort the installation, remember that holding the mouse button down after the "wall-(e) sound" will eject the CD during the early stages of a re-boot. You can also try this.

(*) Once the Ubuntu GUI is running (visible or not), note also that pressing ctrl-option-F1 will give us a command prompt. When the live boot is in pester, starting a terminal session using this combination might take a couple of tries... but it works just fine.

(8) Finally, to disable that incessant request to change your password each and every time you run a command-prompt (is your date / time battery not holding a charge?), then change the '0' to being completely empty in the last-date-change field. -That field will be the 3rd field on the line containing your login name in the /etc/shadow file. More information can be had via the `man shadow` page. If you are new to Linux, then the `man passwd` page is also worth a read.

If and when you get tired of manually asserting the default video mode, rumor has it that the "video-ofonly" is in yaboot.conf. -Someone else mentioned that you could also try adding nomodeset to the kernel command line. (Since I use the G3s as non-gui servers, I have not been too concerned about X11. While you can use apt-get to remove the GUI entirely, you can also edit the /etc/rc.local script to fix-in a shell. We can then use startx whenever we want to GUI.)

If you do not want a GUI, note that there are ever more creative ways to stop the GNOME Display Manager (gdm) from starting. Take a Google to find out how...



(p.s. If you like those magic Apple key-combinations, then here is a nice list of them.)

[ view entry ] ( 2740 views )   |  permalink

<<First <Back | 1 | 2 | 3 | Next> Last>>