Java & MySQL on Fedora 8

• Fedora 8

Check the default JRE environment,


[austin@localhost ~]$  java -version


If the version is 1.7.0, remove it.


[root@localhost ~]$ rpm -qa | grep java
java-1.5.0-gcj-1.5.0.0-l7.fc8
java-1.7.0-icedtea-1.7.0.0-0.l9.b21-snapshot.fc8

[root@localhost ~]$ rpm -e java-1.7.0-icedtea-1.7.0.0

• Java

Go to Sun's website, you could find two linux jdk files:



• jdk-1_5_0_14-linux-i586-rpm.bin


• jdk-1_5_0_14-linux-i586.bin

For installing one of above,


[austin@localhost ~]$ chmod +x jdk-1_5_0_14-linux-i586~.bin
[austin@localhost ~]$ ./jdk-1_5_0_14-linux-i586~.bin


If you install non-rpm file, just follow the instructions. The jdk folder will install on your current location.
On the other hand, if you choose the rpm file, you will get jdk-1.5.0_14-linux-i586.rpm.


[root@localhost ~]$ rpm -ivh jdk-15.0_14-linux-i568.rpm



The JDK will install on /usr/java/jdk1.5.0_14


Next, we will edit the environment variables.


[austin@localhost ~]$ vi .bashrc



In .bashrc, increase three lines below:



export JAVA_HOME=/usr/java/jdk1.5.0_14
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$PATH:$JAVA_HOME/bin\



Save it and re-login.


[austin@localhost ~]$ export | more



Check if there are "JAVA_HOME", "CLASSPATH" and "PATH" existed.




• Eclipse

Download the eclipse-jee-europa-fall2-linux-gtk.tar.gz from Eclipse official Site. Just extract it and execute eclipse/eclipse.


• MyEclipse

Download MyEclipse_6_0_1GA_E3_3_1_Installer.bin from MyEclipse.



[root@localhost ~]$ chmod +x MyEclipse_6_0_1GA_E3_3_1_Installer.bin
[root@localhost ~]$ ./MyEclipse_6_0_1GA_E3_3_1_Installer.bin



And then error occured.

java: xcb_xlib.c:50: xcb_xlib_unlock: Assertion `c->xlib.lock' failed
Aborted.

To solve it,


[root@localhost ~]$ yum --enablerepo=development update libxcb
[root@localhost ~]$ export LIBXCB_ALLOW_SLOPPY_LOCK=true
[root@localhost ~]$ ./MyEclipse_6_0_1GA_E3_3_1_Installer.bin





• MySQL




1. mysql-libs-5.0.45-4.fc8.i386.rpm -> Fedora 8 DVD


2. perl-DBI-1.58-2.fc8.i368.rpm -> Fedora 8 DVD


3. mysql-5.0.45-4.fc8.i386.rpm -> Fedora 8 DVD


4. perl-DBD-MySQL-4.005-2.fc8.i386.rpm -> Fedora 8 DVD


5. mysql-server-5.0.45-4.fc8.i368.rpm -> Fedora 8 DVD





[root@localhost ~]$ /etc/rc.d/init.d/mysqld start


We could use "setup" to config system services and let mysql start as booting.


[root@localhost ~]$ setup


Download mysql-gui-tools-5.0r12-fc5-i386.tar.gz from MySQL.com
Extract it.



1. mysql-gui-tools-5.0r12-1fc5.i386.rpm
2. mysql-administrator-5.0r12-1fc5.i386.rpm
3. gtkhtml3-3.16.1-1.fc8.rpm -> from rpm.pbone.net
   
4. mysql-query-browser-5.0r12-1fc5.i386.rpm



If you need to connect MySQL from other hosts, remember to open the firewall on Port 3306.