Sunday, November 18, 2007

MySQL macport install on Mac OS X Tiger

I have installed mysql5 macport on the MacBookPro laptop running OS X Tiger 10.4.

There are a few steps that needs to be done once the port is installed. These steps are not documented (see Ticket #12694 on macports.org). So, after reading a few blogs and analyzing mysql startup error messages, I figured out what needs to be done in order to get it running. That info might be useful to others, so I’ve decided to publish the solution here.

First of all, we need to create the initial database database

$ sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql

Here is the output of the command:


$ sudo ./mysql_install_db --user=mysql

Installing MySQL system tables...
071118 0:06:29 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql5/ is case insensitive
OK
Filling help tables...
071118 0:06:29 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql5/ is case insensitive
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin -u root -h my-computer.local password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /opt/local/lib/mysql5/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com


Next, I’ve tried to start the database and got this error message:

$ sudo /opt/local/lib/mysql5/bin/mysqld_safe
mkdir: /opt/local/var/run: No such file or directory
chown: /opt/local/var/run/mysql5: No such file or directory
chmod: /opt/local/var/run/mysql5: No such file or directory
Starting mysqld daemon with databases from /opt/local/var/db/mysql5
STOPPING server from pid file /opt/local/var/db/mysql5/mykola-dzyubas-computer-2.local.pid
071118 00:27:12 mysqld ended

I’ve created /opt/local/var/run and /opt/local/var/run/mysql5 folders:

sudo mkdir /opt/local/var/run
sudo chmod g+w /opt/local/var/run
sudo mkdir /opt/local/var/run/mysql5
sudo chown mysql /opt/local/var/run/mysql5

Once it is done, the mysql server has started successfully

$ sudo /opt/local/lib/mysql5/bin/mysqld_safe &
Starting mysqld daemon with databases from /opt/local/var/db/mysql5

Here is a quick check that the database server is up:

$ mysqladmin5 -u root -p ping
Enter password:
mysqld is alive

In case you don't have mysql binary files in your path, please edit ~/.profile and add /opt/local/bin to the path:

# Setting the path for MacPorts.
export PATH=/opt/local/bin:/opt/local/sbin:$PATH

By default all scripts refer to mysql command, however the installation package creates mysql5. To fix that, create mysql symbolic link that points to mysql5.

$ cd /opt/local/bin
$ ln -s mysql5 mysql

To improve security of the mysql server configuration, please run mysql_secure_installation5 script and configure mysql password for root, network access, etc:




$ cd /opt/local/bin
$ ./mysql_secure_installation5

mykola-dzyubas-computer-2:/opt/local/bin mykola$ ./mysql_secure_installation5




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n]
... Success!

Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n]
... Success!

By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] n
... skipping.

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n]
... Success!

Cleaning up...



All done! If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!


Thursday, November 1, 2007

How To Run Java EE 5 Tutorial Examples On Mac

I spent some time configuring Java environment on Mac. Here are a few tips on how to get it going.

The Max OS X comes with Java 5 installed. So, here are main steps:

* Download Java EE 5 Tutorial package from http://java.sun.com/javaee/5/docs/tutorial/information/download.html

* Download Sun Java System Application Server 9.1 from http://java.sun.com/javaee/downloads/. I downloaded Java EE 5 SDK Update 3 that comes with the application server.

* Use instructions posted here on how to install it

http://java.sun.com/javaee/sdk/javaee5sdk_install.jsp

Also use Application Server Installation Tips posted here: http://java.sun.com/javaee/5/docs/tutorial/doc/gexaj.html

Once the application server is installed, change permissions on the SDK/javadb, so the folder permissions allow creating a database. Here is an example on how to do that:


cd SDK
sudo chown –R your_name javadb


In general, I believe it is a good idea to change permissions to other files in SDK to some less privileged user than root.

Once I started playing with bookstore example, I’ve got some build and deployment errors. I found that I need to create a password file and point to it with the javaee.server.passwordfile property.

Create a new file app-server-psw.properties in the javaeetutorial5/examples/bp-project/ folder. Edit the file and add


AS_ADMIN_PASSWORD=admin_password


The admin_password should be the same as it was specified during the Application Server installation.
Update javaeetutorial5/examples/bp-project/app-server.properties by adding these properties:


db.vendor=javadb
javaee.tutorial.home=/Users/mykola/java/j2ee/javaeetutorial5
javaee.server.passwordfile=${javaee.tutorial.home}/examples/bp-project/app-server-psw.properties


Once that is done, the bookstore example build and deployment works fine.