Installing MySQL Workbench 6.0.9 on Ubuntu 12.10

Installing MySQL Workbench from the Ubuntu Software Center of Ubuntu 12.10 (quantal) will give you a very old version 5.4.0 that's buggy - when you exit the app, it freezes. After a bit of trial and error, here's how I installed the latest (as of the date of this writing, at version 6.0.9) -

1. Downloaded the deb file for Ubuntu 12.04 (as there was no deb package for 12.10) from the MySQL downloads page
2. Downloaded the libctemplate0_0.97-1_i386.deb file. This package is a dependency of the MySQL Workbench 6, and isn't in Ubuntu 12.10 by default. I got this tip about the flaw from the good people of the MySQL Workbench community.
3. Go in terminal and install the packages - 

sudo dpkg -i libctemplate0_0.97-1_i386.deb

sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1204-i386.deb

The output goes:

Selecting previously unselected package mysql-workbench-community.
(Reading database ... 247682 files and directories currently installed.)
Unpacking mysql-workbench-community (from mysql-workbench-community-6.0.9-1ubu1204-i386.deb) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libpcrecpp0 (>= 7.7); however:
  Package libpcrecpp0 is not installed.
 mysql-workbench-community depends on libtinyxml2.6.2; however:
  Package libtinyxml2.6.2 is not installed.
 mysql-workbench-community depends on python-paramiko; however:
  Package python-paramiko is not installed.
 mysql-workbench-community depends on python-pysqlite2; however:
  Package python-pysqlite2 is not installed.

So the final step to resolve and fix the unmet dependencies was to issue this command:

sudo apt-get -f install

It will appear under your applications Development menu as MySQL Workbench. Those Workbench guys have really improved the UI, totally new look :-)

Audacity, and avoiding the trap in NO MP3 support, in Fedora

There are 2 versions in Fedora for Audacity install - the free and non-free.

If you want to be able to import audio in the MP3 format (there may be other formats other than MP3 that are supported), make sure you select the non-free version of Audacity in the Software list, named:
audacity-freeworld-2.0.0-1.fc18

as opposed to the free version I installed named
audacity-2.0.2-2.fc18

Correcting my mistake of installing the free version of Audacity, I first suspected to add MP3 codecs support in my system doing this (gotten from a DuckDuckGo search):

su -
yum install gstreamer-plugins-bad gstreamer-plugins-ugly

Yes, it did find some packages to download, and yes, it did install.  This probably worked because I already installed the RPMFusion package beforehand (see my earlier post).
 
But it didn't fix the problem: going back to Audacity and attempting a MP3 import still produced the error message, "This version of Audacity was not compiled with mp3 support."

This fixed the problem, based on a tip found in the Fedora Forums.

su - 

yum remove audacity
yum install audacity-nonfree

Fedora, Skype, and my fave resource site

Before I forget, the site if not true then false deserves much of my admiration. This guy has helped me through all my Fedora installation struggles.

For the latest Fedora release, installing Skype proved easier by following his instructions.

Only thing missing from his Skype-Fedora guide was that right before step 1.3, I had to also do a "yum install wget" in the terminal, as I didn't have the wget app in the fresh Fedora installation.

Fedora 18, cinnamon desktop, play some music

My, how time flies. I didn't realize this would be my first post for 2013. Maybe life presents itself outside Linux and blogging more days now than before. Installation notes on Fedora 18:

1. Using a Samsung netbook (without the benefit of a built-in or portable DVD reader), I download the live 32 bit of this distro and also the Windows USB creator.

Links: Gnome 32 bit Fedora 18 liveusb creator

2. Burned the ISO on USB, using the liveUSB creator tool of Fedora, and booted the netbook with the USB.

3. After the installation, which proceeded with incident, I installed my fave apps from the software utility of Fedora (e.g. Gimp, Phatch)

4. Also using the Software app of Fedora (you would think they would come up with a more imaginative name like Fedora Download Center, or something)

5. The core of this post, though, is making my audio (music) files in my iPod to play using Fedora's Rhythmbox app. It kept asking for MP3 codecs that were unfortunately not part of the default installation.

5.1 It seemed simple enough, after mistakenly trying to install an older (i.e. Fedora 16 package) of RPM Fusion. Luckily going to their site, I saw that the packages for the Fedora 18 distro was available. Clicked on the free and non-free packages, each download not saved as files, but executed (in Firefox) with Open with -> Software Install (default) option.

5.2 Then after that, open a terminal, type "su -" for root access, then enter the root password.

5.3 Then type "yum install vlc".

5.4 Still when I play music directly using Rhythmbox, it complains needing MP3 codecs. So I click on the Search button, and let Fedora do its thing downloading and installing the necessary packages.

Now enjoying the music! ;-)

Xubuntu 12.04

Nov. 8, 2012 marks the day I switched to Xubuntu. Simpler than Ubuntu's Unity, and a bit prettier than Lubuntu.

Messengers running on Android (2.3) and memory footprint

1. Catfiz - running in memory = 9.2MB, installed size = 3.12MB
2. imo - running 16MB, installed 8.65MB
3. nimbuzz - running 20mb (!) yuck.
4. fb messenger - 11MB memory; 10.55MB file size
5. kik - 18MB memory; 3.06MB file size

Openproj

MS Project open source alternative for Linux. This works for Ubuntu 11.04

wget http://nchc.dl.sourceforge.net/sourceforge/openproj/openproj_1.4-2.deb && sudo dpkg -i openproj_1.4-2.deb

Credits goes to this source.

Update 3 Nov. 2012
Installing in Ubuntu 12.04 (Xubuntu, to be exact), produced dependencies issues, even though I do distinctly remember putting in the xubuntu-restricted-extras package during 12.04 installation.

These are the additional packages needing to be installed:

ca-certificates-java icedtea-7-jre-jamvm java-common libatk-wrapper-java libatk-wrapper-java-jni openjdk-7-jre openjdk-7-jre-headless openjdk-7-jre-lib ttf-dejavu-extra tzdata-java

So I try fixing it in the terminal:

sudo apt-get -f install

But it takes a long time (shame on my broadband provider!) I had to try also changing the server for the repos (in Synaptic) several times, then eventually going back to my country's server.
After numerous alt-c on the terminal, and repeating this:

sudo apt-get install ca-certificates-java icedtea-7-jre-jamvm java-common libatk-wrapper-java libatk-wrapper-java-jni openjdk-7-jre openjdk-7-jre-headless openjdk-7-jre-lib ttf-dejavu-extra tzdata-java

I finally got all the packages downloaded and installed. After which, going to Synaptic and with the filter set to Broken packages, completely removed OpenProj, and reinstalled with the wget... from my original post.
Running it finally caused an error:

To fix this error, I modified the ~/.openproj/run.conf file by changing the line:

JAVA_OPTS="-Xms128m -Xmx768m"

to:

JAVA_OPTS="-Djava.vendor=Sun -Xms128m -Xmx768m"

and now it works. Got this tip (somewhat, didn't follow completely his instructions) here.

Installing Remote desktop protocol (RDP) to access Windows PCs in Fedora 16

su - 

yum install remmina
yum install remmina-plugins-rdp

Installing Citrix Receiver in Fedora 16

go root

su -

yum install libXp

Download openmotif from here.

rpm -i openmotif-2.3.3-1.el5.3.i386.rpm

Installing Simple Scan package in Fedora 16 (LXDE edition)

In terminal mode -

su -

yum install simple-scan libsane-hpaio

Using VPN in Fedora and gaining access to Windows machines remotely

Install openvpn package

su -
yum install openvpn

Download VPN credentials and copy the files in /etc/openvpn

Run openvpn

openvpn --auth-nocache --config lavezarez@208.41.22.10.ovpn

Install and run remote desktop

yum install rdesktop
rdesktop -ulavezarez -dmydomain 10.41.1.1

Debian 6 LXDE basic stuff

open a terminal as root, then -


dpkg -i <name of package> [,<more packages>] :installs a downloaded DEB file, like google chrome

dpkg -r <name of package> [,<more packages>] :removes installed packages

apt-get update :update packages

apt-get upgrade :perform upgrades

Apps checklist for Ubuntu 11.10

Other apps I installed after upgrades and gnome-shell tasks, all available and searchable from the Ubuntu Software Center app:
1. 7z - better than Zip
2. Gimp - alternate opensource to Adobe Photoshop; handles layers and effects equally well

And some installed via CLI:
1. Image Resizer - reduces file size of images, integrated in the right-click context menu of the file manager (from a previous post)

sudo apt-get install nautilus-image-converter

sudo killall nautilus

back to ubuntu. version 11.10

1. install from CD
2. command-line mode

sudo apt-get update && sudo apt-get dist-upgrade

3. restart
4. install codecs, flash support

sudo apt-get install ubuntu-restricted-extras

5. install gnome 3 shell, as a replacement to Unity

sudo apt-get install gnome-shell

6. logout, and pick gnome as your session, login again
7. install the gnome tweak took and the shell extension, download some gnome themes you like, change the theme, etc. - mostly taken from this Tech Drive-in link
The Tech Drive-in link is also where I got to install some cool Gnome-shell themes, and the Faenza icon theme. 8. put the window controls (maximize, close) to the right instead of the default left position (link) -

gconftool-2 --set "/apps/metacity/general/button_layout" --type string "menu:minimize,maximize,close"

9. Install Chromium Web Browser from the Ubuntu Software Center app. Same look and feel as the Google Chrome browser.
10. Install Ubuntu Tweak - yes, a release version is now available. But I notice the version for 11.10 doesn't have as much features as previous versions for older Ubuntu releases like 10.04 LTS.

Fedora 16 now!

Release 16 aka Verne of Fedora Gnome 3.2.1

First lesson - how do I install Google Chrome via command line?
Answer: Followed instructions here
But before I finished the first lesson, I had to grapple with some questions, such as:
1. How do I go as root in the terminal? Answer:

su -

2. What editor can I use, as there is no nano installed? Answer: gedit
Got these answers from this source
Still as root, add the virtualbox repo to yum
[root@lave ~]# gedit /etc/yum.repos.d/virtualbox.repo
And now attempting to install Virtualbox -
su -

yum install dkms

Successfully installs the pre-requisite dkms package

Unlike in Ubuntu, installing dkms does not include the gcc package, so need to install that as well

yum install gcc

Then add the virtualbox repo to yum -
[root@lave ~]# gedit /etc/yum.repos.d/virtualbox.repo
The contents of the file from the virtualbox site here
Then download the rpm file for Fedora, and perform this as root as well:

yum install VirtualBox-4.1-4.1.6_74713_fedora16-1.i686.rpm

The complete virtualbox installation for Fedora I used can be found here.

Installing Gimp goes like this:

yum install gimp

And installing Flash is a bit more involved, but level of difficulty (or ease) is the same as Ubuntu's, in my opinion. The steps for installing Adobe Flash is here.

Gnome 3 on Ubuntu 11.04 (natty narwhal)

Tried the new Gnome desktop in Ubuntu 11.04 (because I am not really fond of Unity, Ubuntu's own interface):

sudo apt-get dist-upgrade

Final output in the terminal window showing the other packages that were held back:

Setting up sound-theme-freedesktop (0.7-0ubuntu1) ...
Setting up libcanberra0 (0.28-0ubuntu7~natty1) ...
Setting up libcanberra-pulse (0.28-0ubuntu7~natty1) ...
Setting up liblaunchpad-integration-3.0-1 (0.1.51) ...
Setting up libgnome-keyring0 (3.0.3-1~natty1) ...
Setting up gvfs (1.8.2-1~natty1) ...
Setting up gvfs-fuse (1.8.2-1~natty1) ...
Setting up gvfs-backends (1.8.2-1~natty1) ...
Setting up libgck0 (3.0.3-2ubuntu1~natty3) ...
Setting up libgcr-3-0 (3.0.3-2ubuntu1~natty3) ...
Setting up libcap2-bin (1:2.20-1) ...
Setting up gnome-keyring (3.0.3-2ubuntu1~natty3) ...
Installing new version of config file /etc/xdg/autostart/gnome-keyring-secrets.desktop ...
Installing new version of config file /etc/xdg/autostart/gnome-keyring-ssh.desktop ...
Installing new version of config file /etc/xdg/autostart/gnome-keyring-pkcs11.desktop ...
Setting up brasero-common (3.0.0-1ubuntu4~natty1) ...
Setting up libbrasero-media3-1 (3.0.0-1ubuntu4~natty1) ...
Setting up brasero-cdrkit (3.0.0-1ubuntu4~natty1) ...
Setting up brasero (3.0.0-1ubuntu4~natty1) ...
Setting up libgtksourceview-3.0-common (3.0.5-0ubuntu1~natty1) ...
Setting up libgtksourceview-3.0-0 (3.0.5-0ubuntu1~natty1) ...
Setting up libpeas-common (1.1.1.really.1.1.0-0ubuntu1~natty1) ...
Setting up libpeas-1.0-0 (1.1.1.really.1.1.0-0ubuntu1~natty1) ...
Setting up gedit-common (3.0.6-0ubuntu1~natty1) ...
Setting up gir1.2-peas-1.0 (1.1.1.really.1.1.0-0ubuntu1~natty1) ...
Setting up gedit (3.0.6-0ubuntu1~natty1) ...
update-alternatives: using /usr/bin/gedit to provide /usr/bin/gnome-text-editor (gnome-text-editor) in auto mode.
Setting up libcryptui0a (3.0.2-0ubuntu2~natty1) ...
Setting up seahorse (3.0.2-0ubuntu2~natty1) ...
Setting up libgtkhtml-4.0-common (4.0.2-0ubuntu1~natty1) ...
Setting up libgtkhtml-4.0-0 (4.0.2-0ubuntu1~natty1) ...
Setting up libgtkhtml-editor-4.0-0 (4.0.2-0ubuntu1~natty1) ...
Setting up libunique-3.0-0 (3.0.0-1ubuntu1~natty1) ...
Setting up libevolution (3.0.3-0ubuntu1~natty1) ...
Setting up evolution (3.0.3-0ubuntu1~natty1) ...
Installing new version of config file /etc/xdg/autostart/evolution-alarm-notify.desktop ...
Setting up libavahi-ui-gtk3-0 (0.6.30-3ubuntu1~natty1) ...
Setting up gnome-utils-common (3.0.1-0ubuntu3~natty1) ...
Setting up gnome-system-log (3.0.1-0ubuntu3~natty1) ...
Setting up gnome-search-tool (3.0.1-0ubuntu3~natty1) ...
Setting up gnome-screenshot (3.0.1-0ubuntu3~natty1) ...
Setting up baobab (3.0.1-0ubuntu3~natty1) ...
Setting up libclutter-gst-1.0-0 (1.3.14-1~natty1) ...
Setting up libclutter-imcontext-0.1-0 (0.1.4-1ubuntu1) ...
Setting up libcluttergesture-0.0.2-0 (0.0.2.1-2ubuntu1) ...
Setting up libmx-1.0-2 (1.1.3-0ubuntu4) ...
Setting up cheese-common (3.0.2-0ubuntu1~natty1) ...
Setting up libcheese1 (3.0.2-0ubuntu1~natty1) ...
Setting up libclutter-gtk-1.0-0 (1.0.2-0ubuntu2~natty1) ...
Setting up libcheese-gtk20 (3.0.2-0ubuntu1~natty1) ...
Setting up gnome-video-effects (0.3.0-4~natty2) ...
Setting up cheese (3.0.2-0ubuntu1~natty1) ...
Setting up empathy-common (3.0.2-0ubuntu1~natty~build1) ...
Setting up nautilus-sendto-empathy (3.0.2-0ubuntu1~natty~build1) ...
Setting up eog (3.0.2-1ubuntu2~natty1) ...
Setting up evince-common (3.0.2-0ubuntu4~natty1) ...
Setting up evolution-plugins (3.0.3-0ubuntu1~natty1) ...
Setting up nautilus-data (1:3.0.2-0ubuntu2~natty1) ...
Setting up nautilus (1:3.0.2-0ubuntu2~natty1) ...
Setting up file-roller (3.0.2-0ubuntu1~natty1) ...
Setting up gcalctool (6.0.2-0ubuntu1~natty1) ...
Setting up gconf-editor (3.0.0-1ubuntu1~natty1) ...
Setting up gir1.2-gtksource-3.0 (3.0.5-0ubuntu1~natty1) ...
Setting up gir1.2-totem-plparser-1.0 (2.32.6-1~natty1) ...
Setting up libtotem0 (3.0.1-0ubuntu5~natty1) ...
Setting up gir1.2-totem-1.0 (3.0.1-0ubuntu5~natty1) ...
Setting up libgdu-gtk0 (3.0.2-1ubuntu1~natty1) ...
Setting up gnome-disk-utility (3.0.2-1ubuntu1~natty1) ...
Installing new version of config file /etc/xdg/autostart/gdu-notification-daemon.desktop ...
Setting up libgnome-media-profiles-3.0-0 (3.0.0-0ubuntu1~natty1) ...
Setting up gnome-media (2.91.2-2ubuntu1~natty1) ...
Setting up gnome-nettool (3.0.0-0ubuntu2~natty1) ...
Setting up libgtkmm-3.0-1 (3.0.1-1~natty1) ...
Setting up libwnck-3-common (3.0.2-1ubuntu1~natty2) ...
Setting up libwnck-3-0 (3.0.2-1ubuntu1~natty2) ...
Setting up gnome-system-monitor (3.0.1-1ubuntu1~natty2) ...
Setting up libvte-2.90-9 (1:0.28.2-0ubuntu2~natty1) ...
Setting up gnome-terminal-data (3.0.1-0ubuntu2~natty1) ...
Setting up gnome-terminal (3.0.1-0ubuntu2~natty1) ...
Setting up gtk3-engines (2.91.1-0ubuntu1~build2) ...
Setting up gnome-themes-selected (3.0.0-0ubuntu1~build2) ...
Setting up gnome-user-share (3.0.0-2ubuntu3~natty1) ...
Installing new version of config file /etc/xdg/autostart/gnome-user-share.desktop ...
Setting up gtk3-engines-unico (0.1.0+r69-0ubuntu1~natty1) ...
Setting up libgucharmap-2-90-7 (1:3.0.1-0ubuntu1~natty1) ...
Setting up gucharmap (1:3.0.1-0ubuntu1~natty1) ...
Setting up libgcr0 (3.0.3-2ubuntu1~natty3) ...
Setting up libgvnc-1.0-0 (0.4.3-2ubuntu2~natty1) ...
Setting up libgtk-vnc-1.0-0 (0.4.3-2ubuntu2~natty1) ...
Setting up libgtk-vnc-2.0-0 (0.4.3-2ubuntu2~natty1) ...
Setting up libgucharmap7 (1:3.0.1-0ubuntu1~natty1) ...
Setting up light-themes (0.1.8.15~natty1) ...
Setting up nautilus-sendto (3.0.1-0ubuntu1~natty1) ...
Setting up totem-common (3.0.1-0ubuntu5~natty1) ...
Setting up totem (3.0.1-0ubuntu5~natty1) ...
Setting up totem-plugins (3.0.1-0ubuntu5~natty1) ...
Setting up totem-mozilla (3.0.1-0ubuntu5~natty1) ...
Setting up vinagre (3.0.1-0ubuntu1~natty1) ...
Setting up yelp (3.0.3-0ubuntu2~natty1) ...
Setting up zenity-common (3.0.0-1~natty1) ...
Setting up zenity (3.0.0-1~natty1) ...

Some screenshots: A new panel on top -

A new dashboard called Activities -

Installing LAMP on Ubuntu 11.04

Followed the instructions in this link to install LAMP.
If you get this message while restarting apache - “apache2: Could not determine the server’s fully qualified domain name, using 127.0.0.1 for localhost”
Type this in the terminal to fix the problem:

echo "ServerName localhost" | sudo tee /etc/apache2/conf.d/fqdn

and reload apache

sudo /etc/init.d/apache2 reload

Back in Ubuntu 11.04 and loving it

After about a month and a half of Lubuntu (11.04) in my test notebook, the new shiny Intel core i3 HP ProBook 4230s, I decided to test Ubuntu 11.04 64-bit Desktop edition.

Having made sure there was a way to disable Unity, and revert back to the classic Ubuntu, I took the plunge yesterday.

It's really quite refreshing and liberating to be back in the Gnome interface.  LXDE has lost its allure for me - for now.

Everything just works: Huawei broadband modem (model E153) for the Internet, Bluetooth starts up, Weather indicator, having windows that actually remember my view settings, and yes - guilty as charged - my hunger for eye-candy is back with wobbly windows, transparent menus (care of Ubuntu Tweak), and some fancy wallpaper.

Question: Why did I choose 11.04 over the 10.04 LTS (long term support) version?
Answer: video resolution.

Testing the live CD of 10.04 ran Ubuntu with a resolution of 1024 x 768.
Testing the live CD of 11.04 produced a higher resolution - 1280 x 800.

I notice this pattern consistent with Linux distros (Centos, Fedora, OpenSuse, Debian...) based on kernel version 2.6.32 and 2.6.38, with the latter capable of producing the higher resolution when running the live CDs.

Some video to audio to mobile music player stuff

Having a video file downloaded from the Internet as mp4

Objective: to make it simply as an audio file, to be able to play in my phone.

Packages needed: handbrake-gtk, audacity

1. Open the mp4 file with handbrake (screenshot example)

2. Go over the Audio tab and change the following values:
Codec -> MP3 (lame)
Bitrate -> 320
3. Click the Start button to begin conversion to m4v (MPEG-4 video) format.
4. When the conversion completes, close handbrake app, open audacity.
5. Click File - Import - Audio
6. Select the m4v file created. Importing completes (screenshot example)

7. Click File - Export
8. Select the M4A (AAC) Files (FFmpeg) format, then click Save.
9. Exit audacity, no need to save the project.

Here are the sample files, notice difference in file types and sizes (screenshot example).

Proceed to upload the m4a file to your phone.

Bluetooth in Lubuntu 11.04

Man, all the while I thought there was a problem with this notebook's wifi Atheros driver, it turns out Lubuntu 11.04 doesn't install the Bluetooth apps, much less show it in the taskbar, by default.

Here it is:
1. First install the bluetooth package

sudo apt-get install bluetooth

2. Then install the personal file sharing thingy (this is needed for the bluetooth device - i.e. my phone - to be able to send files, and for the laptop to receive those files)

sudo apt-get install gnome-user-share

3. Then in the Preferences - Desktop Session Settings, put a tick mark on Bluetooth Manager. To make sure bluetooth service starts on every boot-up.