rails 3 connect to mysql db

其实很简单，不过自己 没有弄明白罢了


首先
jruby -S gem install active_record

jruby -S gem install activerecord-jdbcmysql-adapter


一般你装 rails 得时候yong bundle 就会装一坨东西了。 呵呵
然后 在你得 Gemfile  （ Rails application in /somewhere）

platforms :jruby do
  gem 'activerecord-jdbc-adapter', :require => false

end

# Production
group :production do
  platforms :jruby do
    gem 'jdbc-mysql'
  end
  platforms :ruby do
    gem 'mysql2'
  end
end

最后 database.yml （ Rails application in /somewhere/config/)
production:
  pool: 5
  timeout: 5000
  username: username
  password: password
   socket: /var/run/mysqld/mysqld.sock
   driver: com.mysql.jdbc.Driver
   url: jdbc:mysql://127.0.0.1:3306/hello_development
  adapter: mysql
  encoding: utf8
  reconnect: false

  database: depot_production

注意红色得一定要写对了 我自己得 socket 是在这个位置你的可能不一样
找找是下面哪个
ls -l  试试 就能找到了 或者你用 find 找找。

conn[:socket] = Pathname.glob(%w[
  /opt/local/var/run/mysql5/mysqld.sock
  /tmp/mysqld.sock
  /tmp/mysql.sock
  /var/mysql/mysql.sock
  /var/run/mysqld/mysqld.sock
]).find { |path| path.socket? }.to_s


我之前 没有写对 host 报错：

jruby -S rake db:migrate RAILS_ENV="production" --trace
(in /home/chenjing/Myrails/depot)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
The driver encountered an unknown error: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
/home/chenjing/jruby-1.6.0/lib/ruby/gems/1.9/gems/activerecord-jdbc-adapter-1.1.1/lib/arjdbc/jdbc/connection.rb:93:in `initialize'
/home/chenjing/jruby-1.6.0/lib/ruby/gems/1.9/gems/activerecord-jdbc-adapter-1.1.1/lib/arjdbc/jdbc/adapter.rb:31:in `initialize'
/home/chenjing/jruby-1.6.0/lib/ruby/gems/1.9/gems/activerecord-jdbc-adapter-1.1.1/lib/arjdbc/mysql/adapter.rb:392:in `initialize'
/home/chenjing/jruby-1.6.0/lib/ruby/gems/1.9/gems/activerecord-jdbc-adapter-1.1.1/lib/arjdbc/jdbc/connection_methods.rb:6:in `jdbc_connection'
/home/chenjing/jruby-1.6.0/lib/ruby/gems/1.9/gems/activerecord-jdbc-adapter-1.1.1/lib/arjdbc/mysql/connection_methods.rb:18:in `mysql_connection'
org/jruby/RubyBasicObject.java:1671:in `__send__'
org/jruby/RubyKernel.java:2063:in `send'
/home/chenjing/jruby-1.6.0/lib/ruby/gems/1.9/gems/activerecord-3.0.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:229:in `new_connection'


后来改好了：

chenjing@chenjing-laptop:~/Myrails/depot$ jruby -S rake db:setup RAILS_ENV="production" --trace
(in /home/chenjing/Myrails/depot)

** Invoke db:setup (first_time)
** Invoke db:create (first_time)
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute db:create
"cj mysql"
"{\"pool\"=>5, \"timeout\"=>5000, \"username\"=>\"username\", \"password\"=>\"password\", \"host\"=>\"127.0.0.1\", \"adapter\"=>\"mysql\", \"encoding\"=>\"utf8\", \"reconnect\"=>false, \"socket\"=>\"/var/run/mysqld/mysqld.sock\", \"database\"=>\"depot_production\"}"










depot_production already exists
** Invoke db:schema:load (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:schema:load
-- create_table("carts", {:force=>true})
   -> 0.1520s
   -> 0 rows
-- create_table("line_items", {:force=>true})
   -> 0.0670s
   -> 0 rows
-- create_table("orders", {:force=>true})
   -> 0.0340s
   -> 0 rows
-- create_table("products", {:force=>true})
   -> 0.0200s
   -> 0 rows
-- create_table("users", {:force=>true})
   -> 0.0790s
   -> 0 rows
-- initialize_schema_migrations_table()
   -> 0.0260s
-- assume_migrated_upto_version(20110401055529, "db/migrate")
   -> 0.0120s
** Invoke db:seed (first_time)
** Invoke db:abort_if_pending_migrations (first_time)
** Invoke environment
** Execute db:abort_if_pending_migrations
** Execute db:seed
** Execute db:setup