Week 6: Rails Passion Course - On My New Mac

1. Repeated Week 6 Homework (HW6) on my new White Mac Laptop.
2. (AL#1) Creating new project: studentapp in /Users/whitemac/NetBeansProjects directory using "Built-in JRuby 1.1.4" and "Glassfish V3".
   
3. Note the Mac experience is different from PC. Asked for Database Configurations/Accepted defaults/Continued.
   
4. Then went to "Install Rails" and I selected "Update JRuby OpenSSL Support" and it worked. Then I selected "Update Rails" (from 2.1.0) to 2.3.2.
5. Then I SKIPPED "Install Warbler" for now.
6. Selected "Finished" and it failed and asked for run "sudo gem update --system" so I did. After the "gem update" finished, I selected "OK" and it finished creating the Rails Project.
7. NOTE: Appears that MySQL is not installed on MAC, so going back to AL#0 to install MySQL on the MAC.
8. THURSDAY (Next Day): Found another article (http://sheldonconaty.com/?p=7) and followed it to use this article: http://www.hennessynet.com/blog/?p=40 about setting up .bash_profile and macports and mySQL.
   
9. Here is the log: $ sudo port install mysql5 +server (p.1)
   ---> Fetching zlib
   ---> Attempting to fetch zlib-1.2.3.tar.bz2 from http://www.zlib.net/
   ---> Verifying checksum(s) for zlib
   ---> Extracting zlib
   ---> Applying patches to zlib
   ---> Configuring zlib
   ---> Building zlib
   ---> Staging zlib into destroot
   ---> Installing zlib @1.2.3_2
   ---> Activating zlib @1.2.3_2
   ---> Cleaning zlib
   ---> Fetching openssl
   ---> Attempting to fetch openssl-0.9.8k.tar.gz from http://distfiles.macports.org/openssl
   ---> Verifying checksum(s) for openssl
   ---> Extracting openssl
   ---> Applying patches to openssl
   ---> Configuring openssl
   ---> Building openssl
   ---> Staging openssl into destroot
   ---> Installing openssl @0.9.8k_0
   ---> Activating openssl @0.9.8k_0
   ---> Cleaning openssl
   ---> Fetching ncursesw
   ---> Attempting to fetch ncurses-5.7.tar.gz from http://mirrors.ibiblio.org/pub/mirrors/gnu/ftp/gnu/ncurses
   ---> Verifying checksum(s) for ncursesw
   ---> Extracting ncursesw
   ---> Configuring ncursesw
   ---> Building ncursesw
   ---> Staging ncursesw into destroot
   ---> Installing ncursesw @5.7_0
   ---> Activating ncursesw @5.7_0
   ---> Cleaning ncursesw
   ---> Fetching ncurses
   ---> Verifying checksum(s) for ncurses
   ---> Extracting ncurses
   ---> Configuring ncurses
   ---> Building ncurses
   ---> Staging ncurses into destroot
   ---> Installing ncurses @5.7_0
   ---> Activating ncurses @5.7_0
   ---> Cleaning ncurses
   ---> Fetching readline
   ---> Attempting to fetch readline-6.0.tar.gz from http://distfiles.macports.org/readline
   ---> Verifying checksum(s) for readline
   ---> Extracting readline
   ---> Applying patches to readline
   ---> Configuring readline
   ---> Building readline
   ---> Staging readline into destroot
   ---> Installing readline @6.0.000_1
   ---> Activating readline @6.0.000_1
   ---> Cleaning readline
   ---> Fetching mysql5
   ---> Attempting to fetch mysql-5.0.77.tar.gz from http://mysql.orst.edu/Downloads/MySQL-5.0
   ---> Attempting to fetch mysql-5.0.77.tar.gz from http://mysql.mirrors.pair.com/Downloads/MySQL-5.0/
   ---> Verifying checksum(s) for mysql5
   ---> Extracting mysql5
   ---> Applying patches to mysql5
   ---> Configuring mysql5
   ---> Building mysql5
   ---> Staging mysql5 into destroot
   ---> Creating launchd control script
   ###########################################################
   # A startup item has been generated that will aid in
   # starting mysql5 with launchd. It is disabled
   # by default. Execute the following command to start it,
   # and to cause it to launch at startup:
   #
   # sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
   ###########################################################
   ---> Installing mysql5 @5.0.77_2+server
   ******************************************************
   * In order to setup the database, you might want to run
   * sudo -u mysql mysql_install_db5
   * if this is a new install
   ******************************************************
   ---> Activating mysql5 @5.0.77_2+server
   ---> Cleaning mysql5
   al-snows-macbook:~ whitemac$
   al-snows-macbook:~ whitemac$ sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
   Password:
10. Then did this:
    $ sudo -u mysql mysql_install_db5
    Password:
    Installing MySQL system tables...
    090416 20:07:40 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    090416 20:07:40 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    090416 20:07:40 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql5/ is case insensitive
    OK
    Filling help tables...
    090416 20:07:40 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    090416 20:07:40 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    090416 20:07:40 [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 al-snows-macbook.local password 'new-password'