蘿蔔懶惰中求生存: Mysql

顯示具有 Mysql 標籤的文章。顯示所有文章

2015年11月22日星期日

Cloud9-RoR-mysql2 & rails 版本衝途

參考來源：http://stackoverflow.com/questions/22932282/gemloaderror-for-mysql2-gem-but-its-already-in-gemfile

在開新專案時遇到了版本不相容的問題，mysql2 version 0.4.x 看來是無法在 rails version 4.x.x 底下使用。

所以只好安裝特定的mysql2版本，上網查了一下0.3.18幾乎大家都推這個版本，不過我發現我之前的專案是安裝0.3.19，所以決定安裝19這版。

gem install -v 0.3.19 mysql2

如果先前已經安裝過mysql2了，這時應該會出現兩個版本，怎麼查呢？

gem list

會列出所有已安裝的gem函式庫及其版本，然後記得在Gemfile裡指定版本哦！

# Use mysql2 as the database for Active Record
gem 'mysql2', '0.3.19'

如果只有安裝一個版本，'0.3.19'的部份就可以不用寫了。

2015年9月14日星期一

Cloud9-RoR-Can't connect to MySQL server...

每次只要重新開啟專案，似乎都會出現無法連線到MySQL的錯誤

rake aborted!
Mysql2::Error: Can't connect to MySQL server on '0.0.0.0' (111)
.
.
.

這時只要重啟MySQL就行了，在指令處下

$ mysql-ctl restart

這樣就能正常連線嘍！

2015年8月13日星期四

Cloud9-RoR-mysql連結

https://docs.c9.io/docs/running-a-rails-app 本篇跟這份文件有關
開啟專案下的config/database.yml檔，將內容改成

development:
  adapter: mysql2
  encoding: utf8
  database: c9
  host: <%=ENV['IP']%>
  username: <%=ENV['C9_USER']%>
  password:
production:
  adapter: mysql2
  encoding: utf8
  database: c9
  host: <%=ENV['IP']%>
  username: <%=ENV['C9_USER']%>
  password:
test:
  adapter: mysql2
  encoding: utf8
  database: c9
  host: <%=ENV['IP']%>
  username: <%=ENV['C9_USER']%>
  password:

再打開專案下的Gemfile(就是這一步，我一直再想what is gemfile???)，增加兩行

# Use mysql as the database for Active Record
gem 'mysql2'

接著在指令處下

gem install mysql2

安裝完成

Fetching: mysql2-0.3.19.gem (100%)
Building native extensions.  This could take a while...
Successfully installed mysql2-0.3.19
1 gem installed

Run程式啦

rails s -b $IP -p $PORT

畫面可以正常出現就代表完成啦！

在連線請先確定是不是裝好mysql，才不會鬼打牆。

Cloud9-RoR-rails與apache衝途

之前先裝phpmyadmin後run程式時會跑出這一大堆哩哩扣扣，然後失敗…

=> Booting WEBrick
=> Rails 4.2.1 application starting in development on http://0.0.0.0:8080
=> Run `rails server -h` for more startup options
=> Ctrl-C to shutdown server
[2015-08-13 09:02:25] INFO  WEBrick 1.3.1
[2015-08-13 09:02:25] INFO  ruby 2.2.1 (2015-02-26) [x86_64-linux]
Exiting
/usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/socket.rb:206:in `bind': Address already in use - bind(2) for 0.0.0.0:8080 (Errno::EADDRINUSE)
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/socket.rb:206:in `listen'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/socket.rb:461:in `block in tcp_server_sockets'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/socket.rb:232:in `each'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/socket.rb:232:in `foreach'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/socket.rb:459:in `tcp_server_sockets'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/webrick/utils.rb:70:in `create_listeners'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/webrick/server.rb:133:in `listen'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/webrick/server.rb:114:in `initialize'
        from /usr/local/rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/webrick/httpserver.rb:45:in `initialize'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/rack-1.6.1/lib/rack/handler/webrick.rb:32:in `new'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/rack-1.6.1/lib/rack/handler/webrick.rb:32:in `run'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/rack-1.6.1/lib/rack/server.rb:286:in `start'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.1/lib/rails/commands/server.rb:80:in `start'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.1/lib/rails/commands/commands_tasks.rb:80:in `block in server'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.1/lib/rails/commands/commands_tasks.rb:75:in `tap'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.1/lib/rails/commands/commands_tasks.rb:75:in `server'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.1/lib/rails/commands/commands_tasks.rb:39:in `run_command!'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.1/lib/rails/commands.rb:17:in `<top (required)>'
        from /home/ubuntu/workspace/bin/rails:8:in `require'
        from /home/ubuntu/workspace/bin/rails:8:in `<top (required)>'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/spring-1.3.6/lib/spring/client/rails.rb:28:in `load'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/spring-1.3.6/lib/spring/client/rails.rb:28:in `call'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/spring-1.3.6/lib/spring/client/command.rb:7:in `call'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/spring-1.3.6/lib/spring/client.rb:26:in `run'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/spring-1.3.6/bin/spring:48:in `<top (required)>'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/spring-1.3.6/lib/spring/binstub.rb:11:in `load'
        from /usr/local/rvm/gems/ruby-2.2.1/gems/spring-1.3.6/lib/spring/binstub.rb:11:in `<top (required)>'
        from /home/ubuntu/workspace/bin/spring:13:in `require'
        from /home/ubuntu/workspace/bin/spring:13:in `<top (required)>'
        from bin/rails:3:in `load'
        from bin/rails:3:in `<main>'

google了好久，終於在一個網站上發現解決之道(話說這個網站真的很好用，每次遇到問題幾乎都是在這個網站上找到解答滴)

http://stackoverflow.com/questions/26663967/rails-tutorial-chapter-1-rails-server-isnt-working-on-cloud9 原始網頁

下指令

lsof -i:8080

出現

COMMAND   PID   USER   FD   TYPE    DEVICE SIZE/OFF NODE NAME
apache2 15456 ubuntu    4u  IPv6 743515391      0t0  TCP *:http-alt (LISTEN)
apache2 15462 ubuntu    4u  IPv6 743515391      0t0  TCP *:http-alt (LISTEN)
apache2 15463 ubuntu    4u  IPv6 743515391      0t0  TCP *:http-alt (LISTEN)
apache2 15464 ubuntu    4u  IPv6 743515391      0t0  TCP *:http-alt (LISTEN)
apache2 15465 ubuntu    4u  IPv6 743515391      0t0  TCP *:http-alt (LISTEN)
apache2 15466 ubuntu    4u  IPv6 743515391      0t0  TCP *:http-alt (LISTEN)
apache2 17350 ubuntu    4u  IPv6 743515391      0t0  TCP *:http-alt (LISTEN)

原來是apach佔了8080port啊啊啊啊啊啊...所以停止它！

sudo /etc/init.d/apache2 stop

終於跑出頁面來了，可喜可賀~可喜可賀！
這問題搞了我一天，眼睛太用力的盯著螢幕，不酥湖，休息準備下班企…

2015年8月11日星期二

Cloud9-RoR-mysql安裝篇

在Cloud9的視窗下方，有個「bash-帳號-專案-不知名編號」的視窗，輸入下方連結的指令

https://docs.c9.io/docs/setup-a-database 官網提供的文件

安裝mysql

$ mysql-ctl install

不過本來就有安裝了，所以會先stop然後在starting，然後秀出

MySQL 5.5 database added.  Please make note of these credentials:

Root User: username
Database Name: c9

mysql的使用ip是127.0.0.1，port則是3306。

控制mysql

$ mysql-ctl cli
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>  show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| c9                 |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.15 sec)

接著就是安裝phpmyadmin了，下一篇唄。(先不做，apache會與rails衝途)

2015年11月22日 星期日