相忘于江湖

泉涸，鱼相与处于陆，相呴以湿，相濡以沫，不如相忘于江湖。《庄子.大宗师篇》

Install MySQL + Tomcat on Solaris

Tuesday Jul 10, 2007

The default MySQL (4.0.24) shipped in Solaris Nevada (build 59) doesn't support UTF-8 encoding. Following are the steps to install a new MySQL on Solaris environment.

download latest pkgs from www.sunfreeware.com
mysql-5.0.41-sol10-sparc-local.gz
openssl-0.9.8e-sol10-sparc-local.gz
libgcc-3.4.6-sol10-sparc-local.gz
with root privilege, pkgadd all pkgs
setup environment for mysql
# groupadd mysql
# useradd -g mysql mysql
# cd /usr/local/mysql
# chown -R mysql .
# chgrp -R mysql .
# bin/mysql_install_db --user=mysql
# bin/mysqld_safe --user=mysql &
create root passwd (optional), add new account 'mysql'
# bin/mysql mysql
> UPDATE user SET password=password("newpasswd") WHERE user="root";
> GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'localhost'
> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
> GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'%'
> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
> exit
# pkill -9 mysql
# bin/mysqld_safe --user=mysql &
Import database from backup
create backup in source mysql env
# mysqldump -u mysql -p --opt lunch > lunch.sql

import backup into new mysql env
# mysql -u mysql -p
> create database lunch;
> exit

# mysql -u mysql -p < lunch.sql

Here are the steps to install and deploy Tomcat.

download latest version of tomcat binaries from tomcat.apache.org
http://archive.apache.org/dist/tomcat/tomcat-5/v5.5.23/bin/apache-tomcat-5.5.23.tar.gz
install
# cd /usr/local
# gunzip < [path]/apache-tomcat-5.5.23.tar.gz | tar xvf -
# ln -s apache-tomcat-5.5.23 tomcat
install jdbc mysql connector
# cp [path]/mysql-connector-java-5.0.3-bin.jar /usr/local/tomcat/common/lib
start
# export JAVA_HOME=/usr/java
# /usr/local/tomcat/bin/startup.sh

Add MySQL and Tomcat in the startup scripts of apache2:

append following lines in /usr/apache2/bin/envvars

MYSQL=/usr/local/mysql/bin/mysqld_safe
[ -x $MYSQL ] && $MYSQL --user=mysql &

TOMCAT=/usr/local/tomcat/bin/startup.sh
[ -x $TOMCAT ] && $TOMCAT

[1] Comments