elanbeat's wiki
UrlMarkrHowTo

url.markr


準備

インストール

データベース設定


$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.16

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE urlmarkr;
Query OK, 1 row affected (0.42 sec)

mysql> GRANT ALL PRIVILEGES ON urlmarkr.* TO username@localhost IDENTIFIED BY 'password-goes-here' WITH GRANT OPTION;
Query OK, 0 rows affected (0.37 sec)

% cp config/database.yml.orig config/database.yml
% vi config/database.yml
$ cat config/database.yml
development:
  adapter: mysql
  database: urlmarkr
  username: user
  password: password
  host: mysqlhost

% cp config/environment.rb.orig config/environment.rb
% vi config/environment.rb
% rake migrate <- revision 37ではmigrationがうまくいかず
(in /somewhere)
 CreateBookmarks: migrating ===============================================
—create_table(:bookmarks) → 0.3062s
CreateBookmarks: migrated (0.3063s) ====================================== CreateTags: migrating ====================================================
—create_table(:tags) → 0.1663s
CreateTags: migrated (0.1665s) =========================================== CreateOptions: migrating =================================================
—create_table(:options) → 0.1076s
CreateOptions: migrated (0.1078s) ======================================== CreatePreferences: migrating =============================================
—create_table(:preferences) → 0.0246s
CreatePreferences: migrated (0.0248s) ====================================

rake migrateがうまくいかないときは、
% mysql -u username -p urlmarkr < db/urlmarkr.sql

known problems