json

Oracle slowly skewering MySQL?

In Linux, MySQL on August 23, 2012 at 1:18 pm

Recent Oracle behaviour on MySQL releases have baffled quite a number of MySQL followers. According to this:

http://techcrunch.com/2012/08/18/oracle-makes-more-moves-to-kill-open-source-mysql/

a recent version: mysql-5.5.25, does not have the usual regression testing scripts available.   These scripts have been part and parcel of MySQL since 1999 and not having these for the first time is a real surprise for active MySQL developers.

So how important are these scripts? well it turns out they are very important as it contains a compilation of old and new scripts that verify the new MySQL version a)  does not have the old bugs identified with previous versions and b) contains the fixes for newer bugs.

In other words, a missing regression testing script means, the quality of this version is suspect.  Probably just what the powers that be in Oracle wants to happen.  As of this writing Oracle has already released 5.5.27, I wonder if that and .26 also have those scripts missing.

More than two years ago, I wrote about how Oracle only “committed” to a parallel release of the free version of MySQL up to 5 years from the closing of the purchase (of Sun and its bag of goodies) transaction.  After that it’s anybody’s guess. Five years hence is January 28, 2015.   Two and a half years to go, but before then I suspect we’ll see more reasons to ‘doubt’ the open future of MySQL.

VirtualBox: Installing Fedora 17 as guest OS in MacOSX host

In Linux, Mac OSX on August 17, 2012 at 9:33 am

Here’s a quick howto to install Fedora (in my case F17) in MacOSX Lion.

1) Download the Virtualbox from

https://www.virtualbox.org/wiki/Downloads

2) Download Fedora live media installer from

http://fedoraproject.org/get-fedora

3) Install virtualbox.

4) To install the downloaded OS, run Virtualbox and add a new OS, set the name to ‘Fedora’ or whatever, select the memory (the default of 768MB for most apps) then ‘Continue’, select ‘Create new hard disk’, then VirtualBox Disk image or ‘VDI’ for the virtual HD type, choose ‘Dynamically allocated’ next,  then finally set the storage size then ‘Create’. This should create the empty OS instance in your Virtualbox.

5) Right click on your OS Instance and select ‘Settings’. Then select ‘Storage’ and then click on the ‘Empty’ IDE icon. On the right panel, click on the CDROM icon and choose the Fedora ‘iso’ file. Click on OK.

6) Run the installation process, by right-clicking on the OS instance and selecting ‘Start’.  Continue with the usual OS installation.

7) After installation remove the settings done in step 5, so the virtual CD-DRIVE is empty (and so it will not be included in the boot options).

If all goes well, install the VirtualBox add-ons so you can properly resize the guest OS’ windows dynamically, enable cut-and-paste between OS’s and enable ‘Shared Folders’ etc.. To do so do the following:

1) Download the VirtualBox Guest Additions from

http://download.virtualbox.org/virtualbox/

Note for F17 and VBox 4.1.8 users: choose VBoxGuestAdditions 4.2.0.RC1.iso as the 4.1.8 version has incompatibilities with the latest kernel which will be installed below.

2) Update your fedora with the latest  kernel, headers and compilers which is needed by the VBoxGuestAdditions installer (got this from http://www.sysprobs.com/install-fedora-16-virtualbox-guest-additions-get-working-gnome-shell-inside-virtual-machine)

yum -y update kernel
yum -y install kernel-devel kernel-headers dkms gcc gcc-c++

then restart linux guest.

3) Using the VirtualBox Manager, right click on the OS instance and click on ‘Settings’ then ‘Storage’, click on the ‘Empty’ IDE controller and click on the CD icon on the ‘CD/DVD’ drive on the right panel and choose ‘Choose a virtual CD/DVD disk file’ and choose the downloaded ‘VBoxGuestAdditions.x.x..iso’ file.  This should now make the file the content of the virtual CD drive within the fedora guest.

4) Go to the linux guest, open a terminal, su to root and cd to the CD drive and run “./VBoxLinuxAdditions.run“. Restart the linux guest.  After the restart you should be able to resize your guest OS window (with aspect changing dynamically) and be able to do ‘Full screen’ (that would be “command – F”).

5) Finally to create a ‘Shared folder’ between the Host and Guest OS, click on the ‘folder’ icon at the lower right window frame of the guest OS and add a folder in the host OS to share.  I shared my ‘Downloads’ folder in my Mac Host and called the share as ‘Downloads’ as well.

In the guest OS, create a directory where to mount the shared folder in e.g. mkdir /mnt/Downloads.

6) In the guest OS you can mount the shared folder interactively:

sudo mount -t vboxsf -o rw,uid=1000 Downloads /mnt/Downloads/
umount -f -a -t vboxsf

Note: if you’re thinking of putting something like this in /etc/fstab in the guest OS:

Downloads   /mnt/Downloads   vboxsf     rw,uid=1000    1    1

dont! it’ll hang your system. I suspect its the drivers not being loaded yet when the kernel runs mount on startup.

Installing DB2 in Linux

In Database, Fedora, Linux on August 17, 2012 at 9:18 am

here’s the lowdown on setting up a db2 database in your linux box:

1) Download db2 Express from

http://www-01.ibm.com/software/data/db2/express/download.html

2) As root, extract the installer:

tar cvf db2_v101_linuxia32_expc.tar.gz

this should create a directory called “expc“.

3) do a ‘cd expc‘ and run the installer “./db2setup“. This will run the installer and ask you to create 3 different types of users, the admin, user and a fenced user.. take note of the names (you can use the defaults) and passwords.  Note that DB2 will create these users in your linux system.

4) After creating the users start the db2 server by  logging in as the db2 administrator (use the administrator username as defined in db2) or do an ‘su db2admin’ assuming db2admin is the admin user.

5) type ‘db2admin start‘.  This should start the db2 instance.

6) To add a new database, log in as the db2 user (you can also do an ‘su db2user1′, assuming db2user1 is the user username just make sure you do a ‘cd ~db2user1′ after as db2 requires the current user to be on a writeable directory).

7) Once you’ve logged on as the db2 user you can now begin creating your database. To create login to the db2 server:

db2 <enter>

this should give you the “db2 =>” prompt.

8) First create the database:

db2=> start database manager
db2=> create database test

db2 => activate database test
db2 => connect to test
db2 => create table employee ( Empno smallint, Name varchar(30),hiredate date)
db2 => select * from employee
db2 => quit

hope this helps.

Follow

Get every new post delivered to your Inbox.