Blog on Programming

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 hav...

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 r...