[Crackerjack-devel-changes] SF.net SVN: crackerjack:[936] trunk/viewsite/README

[<zn...@us...>]

Revision: 936
          http://crackerjack.svn.sourceforge.net/crackerjack/?rev=936&view=rev
Author:   znz
Date:     2009-06-24 09:13:38 +0000 (Wed, 24 Jun 2009)

Log Message:
-----------
update document

Modified Paths:
--------------
    trunk/viewsite/README

Modified: trunk/viewsite/README
===================================================================
--- trunk/viewsite/README	2009-06-24 07:42:09 UTC (rev 935)
+++ trunk/viewsite/README	2009-06-24 09:13:38 UTC (rev 936)
@@ -4,11 +4,46 @@
 == Getting Started
 1. Install rails 2.3.2 and sqlite3-ruby.
 2. Run `rake crackerjack:testcases:sibling` if you checkouted <https://crackerjack.svn.sourceforge.net/svnroot/crackerjack/trunk>.  Or run `rake crackerjack:testcases:trunk` to checkout testcases of trunk. 
-2. Run `rake db:migrate` to setup sqlite3 database.
-3. Run `ruby script/server`
-4. Open <http://localhost:3000/admin> with your browser.
+2. Run `env RAILS_ENV=production rake db:migrate` to setup sqlite3 database.
+3. Run `env RAILS_ENV=production ruby script/server`
+4. Open <http://localhost:3000/admin> with your browser.  Or use `env RAILS_ENV=production ruby script/crackerjack/import_results_tgz results-*.tar.gz`.
 5. Upload results files (results-HOSTNAME-KERNEL-VERSION.tar.gz).  These can generate by ./crackerjack --pack after ./crackerjack -x on some environments.
 6. You can change display name at <http://localhost:3000/admin/kernels> after upload.  Checkboxes (expected and actual) and others are used in old report interface (<http://localhost:3000/report>).
-7. Run `ruby script/crackerjack/load_execute_result` on console again.  This script loads results from data/results to database.
-8. Run `ruby script/crackerjack/create_compare_result`.  This script compares execute results each other.  It will take a long time if many execute results exist.
+7. Run `env RAILS_ENV=production ruby script/crackerjack/load_execute_result` on console again.  This script loads results from data/results to database.
+8. Run `env RAILS_ENV=production ruby script/crackerjack/create_compare_result`.  This script compares execute results each other.  It will take a long time if many execute results exist.
 9. Open <http://localhost:3000/cjk/> and you will see compare results.  If no results, click "All Kernels" link.
+
+== Using MySQL
+1. Connect mysql and create database and user.
+
+Example:
+ $ mysql --default-character-set=utf8 -uroot -p
+ Enter password: 
+ Welcome to the MySQL monitor.  Commands end with ; or \g.
+ Your MySQL connection id is 3750
+ Server version: 5.0.32-Debian_7etch8-log Debian etch distribution
+ 
+ Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
+ 
+ mysql> CREATE DATABASE crackerjack_production CHARACTER SET utf8;
+ Query OK, 1 row affected (0.01 sec)
+ 
+ mysql> grant all privileges on crackerjack_production.* TO 'crackerjack_p'@'loca
+ lhost' IDENTIFIED BY 'XXXXXXXX';
+ Query OK, 0 rows affected (0.22 sec)
+ 
+ mysql> \q
+
+2. Update viewsite/config/database.yml to use mysql.
+
+Example:
+ production:
+   adapter: mysql
+   encoding: utf8
+   database: crackerjack_production
+   username: crackerjack_p
+   password: XXXXXXXX
+   socket: /var/run/mysqld/mysqld.sock
+
+3. Install mysql gem and run `env RAILS_ENV=production rake db:migrate`.
+4. After `env RAILS_ENV=production ruby script/server`, see Getting Started in above.


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.