<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>FAQ Book &#187; Ruby</title>
	<atom:link href="https://blog.faq-book.com/?cat=216&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>https://blog.faq-book.com</link>
	<description>Some SOP,Note,Learned Article of IT  關於IT資訊界的筆記和學習紀錄</description>
	<lastBuildDate>Sun, 27 Mar 2022 12:25:43 +0000</lastBuildDate>
	<language>zh-TW</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=</generator>
<xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" />
	<atom:link rel='hub' href='https://blog.faq-book.com/?pushpress=hub'/>
		<item>
		<title>Rails 101 安裝問題排除 &amp; 移除相關安裝</title>
		<link>https://blog.faq-book.com/?p=2092</link>
		<comments>https://blog.faq-book.com/?p=2092#comments</comments>
		<pubDate>Sat, 18 Jun 2011 02:01:59 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[Ruby]]></category>
		<category><![CDATA[Rails 101]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=2092</guid>
		<description><![CDATA[<h3><span style="color: #800080"> 後記</span></h3>
<p>其實這些問題的處理方式都是按照錯誤時產生的參考執行的這裡僅稍微紀錄並提供大家參考若有任何錯誤歡迎指教</p>
<p>&nbsp;</p>
<p>這篇紀錄是因為在決定好好從頭玩一次RoR之前機器已經照著網路的散落的教學文章亂裝機器導致環境有點混亂所以把相關移除的紀錄和照著XDite大步驟安裝時遇到的問題紀錄一下 另外在安裝ImageMagick時的錯誤請參考 <a href="http://%20http://blog.faq-book.com/?p=2077">另一篇</a></p>
<h3><span style="color: #daa520"><span class="Apple-style-span" style="font-family: arial,sans-serif">移除rvm</span><br />
</span></h3>
<blockquote><p><span class="Apple-style-span" style="font-family: arial,sans-serif;color: #000000">1. rvm implode<br />
</span><span class="Apple-style-span" style="font-family: arial,sans-serif;color: #000000">2. gem uninstall rvm<br />
</span><span class="Apple-style-span" style="font-family: arial,sans-serif;color: #000000">3. rm -Rf /etc/rvmrc ~/.rvmrc</span></p></blockquote>
<p>&nbsp;</p>
<div style="font-family: arial,sans-serif;font-size: 83%;margin: 0px;overflow: hidden;background-color: #ffffff;color: #000000">
<div>
<p>查看下面檔案中是否存在 activate RVM 的指令,有的刪除即可 就是安裝時加入的那串</p>
<blockquote><p>- .bashrc<br />
- .profile<br />
- .bash_profile</p></blockquote>
<p>&nbsp;</p>
<h2><strong><span style="color: #a52a2a">移除brew</span></strong></h2>
<h3><a href="https://github.com/mxcl/homebrew/wiki/The-brew-command">相關指令查詢</a>   <a href="http://superuser.com/questions/203707/how-to-uninstall-homebrew-osx-packet-manager">參考資料</a></h3>
<p>&nbsp;</p>
<div>
<blockquote><p>
</p><pre class="crayon-plain-tag">$&gt; cd `brew --prefix`
$&gt; rm -rf Cellar
$&gt; brew prune
$&gt; rm -rf Library .git .gitignore bin/brew README.md share/man/man1/brew</pre><p>$&gt; rm -rf ~/Library/Caches/Homebrew</p></blockquote>
</div>
<p>&nbsp;</p>
</div>
</div>
<p>&nbsp;</p>
<h3><span style="color: #006400">移除pow </span></h3>
<p><strong><a href="http://pow.cx/manual.html#section_1.2">Pow官網</a></strong></p>
<p>&nbsp;</p>
<blockquote><p>
</p><pre class="crayon-plain-tag"><code>$&gt; curl get.pow.cx/uninstall.sh | sh </code></pre><p>
</p></blockquote>
<h3><strong><span style="color: #daa520">執行<span class="Apple-style-span" style="font-family: monospace;line-height: 18px;font-weight: normal">mysql_install_db 馬上先Error</span></span></strong></h3>
<p>FATAL ERROR: Could not find ./bin/my_print_defaults</p>
<p>解決辦法如下</p>
<p>&nbsp;</p>
<blockquote><p>
</p><pre class="crayon-plain-tag">mysql_install_db --verbose --user=`whoami` \
--basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql \
--tmpdir=/tmp

註：user的地方請帶入自己的使用者帳號</pre><p>
</p></blockquote>
<p>&nbsp;</p>
<h3><span style="color: #0000cd">安裝 gem install mysql 時Error</span></h3>
<p>curl: (7) couldn&#8217;t connect to host</p>
<p>原因：pidof 相依套件網址連不到，<a href="https://github.com/AndyYou/ANdyRuby">這裡</a> 提供我剛好有下載的壓縮擋</p>
<blockquote><p>$&gt; brew edit pidof      #pidof 可改打入無法連結該網址的套件名稱</p></blockquote>
<p>出現如下</p>
<p>&nbsp;</p>
<blockquote><p>class Pidof &lt; Formula</p>
<p>url &#8216;http://www.nightproductions.net/downloads/pidof_source.tar.gz</p>
<p>homepage &#8216;http://www.nightproductions.net/cli.htm&#8217;</p>
<p>md5 &#8217;663763ee1feb0596fa3731aafa7e1880&#8242;</p>
<p>version &#8217;0.1.4&#8242;</p>
<p>&nbsp;</p>
<p>def install</p>
<p>system &#8220;make all&#8221;</p>
<p>man1.install gzip(&#8220;pidof.1&#8243;)</p>
<p>bin.install &#8220;pidof&#8221;</p>
<p>end</p>
<p>end</p></blockquote>
<p>把url 換成  下載下來的檔案路徑   ex   :   &#8216;file:///~/Library/Caches/Homebrew/pidof_source.tar.gz&#8217;</p>
<p>在執行一次安裝即可</p>
<p>brew 失敗時請善用 brew doctor 和brew missing 會告訴你該怎麼處理</p>
<p>附上查詢Mysql版本指令 mysql -V</p>
<h3><strong><span style="color: #008000">繼續Error</span></strong></h3>
<p>&nbsp;</p>
<p>Enter current password for root (enter for none):</p>
<p>/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation: line 85: .my.cnf.4387: Permission denied</p>
<p>/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation: line 86: .my.cnf.4387: Permission denied</p>
<p>/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation: line 87: .my.cnf.4387: Permission denied</p>
<p>/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation: line 89: .my.cnf.4387: Permission denied</p>
<p>/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation: line 58: .mysql.4387: Permission denied</p>
<p>/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation: line 60: .mysql.4387: No such file or directory</p>
<p>處理：一般權限問題 就斟酌把/usr/local/Cellar/mysql/5.5.10/bin/  目錄權限開一下</p>
<p>&nbsp;</p>
<p>後續安裝總算都被炸完了LOL</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>

<div class="wp_rp_wrap  wp_rp_pinterest" id="wp_rp_first"><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-2077" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2077" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]安裝 ImageMagick Error" /></a><a href="https://blog.faq-book.com/?p=2077" class="wp_rp_title">[問題紀錄]安裝 ImageMagick Error</a></li><li data-position="1" data-poid="in-1719" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1719" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]Rubygem mysql 問題" /></a><a href="https://blog.faq-book.com/?p=1719" class="wp_rp_title">[問題紀錄]Rubygem mysql 問題</a></li><li data-position="2" data-poid="in-1712" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]Ruby安裝dbi錯誤 on Mac" /></a><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_title">[問題紀錄]Ruby安裝dbi錯誤 on Mac</a></li><li data-position="3" data-poid="in-44" data-post-type="none" ><a href="https://blog.faq-book.com/?p=44" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Linux 忘了mysql的root密碼" /></a><a href="https://blog.faq-book.com/?p=44" class="wp_rp_title">Linux 忘了mysql的root密碼</a></li><li data-position="4" data-poid="in-2212" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2212" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Linux實用刪除檔案指令 " /></a><a href="https://blog.faq-book.com/?p=2212" class="wp_rp_title">Linux實用刪除檔案指令 </a></li><li data-position="5" data-poid="in-5962" data-post-type="none" ><a href="https://blog.faq-book.com/?p=5962" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/10/Install-VMware-tools-for-Linux.jpg" alt="Install VMware tools for Linux" /></a><a href="https://blog.faq-book.com/?p=5962" class="wp_rp_title">Install VMware tools for Linux</a></li><li data-position="6" data-poid="in-5222" data-post-type="none" ><a href="https://blog.faq-book.com/?p=5222" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/07/GIT.jpg" alt="於 CentOS 6.2 安裝 Git, Gitolite 及 Gitlab" /></a><a href="https://blog.faq-book.com/?p=5222" class="wp_rp_title">於 CentOS 6.2 安裝 Git, Gitolite 及 Gitlab</a></li><li data-position="7" data-poid="in-2448" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2448" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Nginx 安裝時常見的問題" /></a><a href="https://blog.faq-book.com/?p=2448" class="wp_rp_title">Nginx 安裝時常見的問題</a></li><li data-position="8" data-poid="in-1917" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1917" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]發生找不到 mysql.sock 的處理方法" /></a><a href="https://blog.faq-book.com/?p=1917" class="wp_rp_title">[問題紀錄]發生找不到 mysql.sock 的處理方法</a></li><li data-position="9" data-poid="in-2571" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2571" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Nginx 安裝時常見的問題 2" /></a><a href="https://blog.faq-book.com/?p=2571" class="wp_rp_title">Nginx 安裝時常見的問題 2</a></li></ul></div></div>
<div class='yarpp-related-rss'>
<h3>相關文章:</h3>
<div class="yarpp-thumbnails-horizontal">
<a class='yarpp-thumbnail' href='https://blog.faq-book.com/?p=2077' title='[問題紀錄]安裝 ImageMagick Error'>
<span class="yarpp-thumbnail-default"><img src="http://blog.faq-book.com/wp-content/plugins/yet-another-related-posts-plugin/default.png"/></span><span class="yarpp-thumbnail-title">[問題紀錄]安裝 ImageMagick Error</span></a>
</div>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=2092</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>[問題紀錄]安裝 ImageMagick Error</title>
		<link>https://blog.faq-book.com/?p=2077</link>
		<comments>https://blog.faq-book.com/?p=2077#comments</comments>
		<pubDate>Fri, 17 Jun 2011 01:53:56 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[Ruby]]></category>
		<category><![CDATA[Error]]></category>
		<category><![CDATA[ImageMagick]]></category>
		<category><![CDATA[ImageMagick Error]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=2077</guid>
		<description><![CDATA[<p>問題 ： 使用&nbsp;<span class="Apple-style-span" style="color: rgb(11, 34, 163); font-family: Helvetica; "><a href="http://github.com/mxcl/homebrew">Homebrew&nbsp;</a></span>安裝ImageMagick 失敗</p>
<p>錯誤訊息 ：&nbsp;Error: Failed executing: make install</p>
<p>系統提示：</p>
<p>&nbsp;</p>
<blockquote>
<p>Also try:</p>
<p>&nbsp; <code>brew doctor</code> to check your setup for common problems.</p>
<p>&nbsp; <code>brew missing</code> to check installed packages for missing deps.</p>
</blockquote>
<p>原因：安裝過其他的程式有&nbsp;/usr/bin/pkg-config , 可能是python等等 在這裡我被炸的原因是因為安裝了 Mono Framework &nbsp; （Orz）</p>
<p>解決辦法：</p>
<p>1. 依照提示使用 brew doctor 指令</p>
<p>&nbsp;</p>
<blockquote>
<p>/usr/bin is in your PATH before Homebrew&#39;s bin. This means that system-</p>
<p>provided programs will be used before Homebrew-provided ones. This is an</p>
<p>issue if you install, for instance, Python.</p>
</blockquote>
<p>2. 系統提供的解決方案&nbsp;</p>
<p>&nbsp; &nbsp; &nbsp; A . &nbsp;考慮 將paths 中的/usr/local/bin 置於 /usr/bin 之前 &nbsp;以Mac來說 路徑在/etc/paths &nbsp;記得sudo 修改順序。由於本人並非深厚Unix like 系統使用者，所以不清楚這樣修改會衍伸什麼問題，不過經過測試，的確可以解決問題。</p>
<p>&nbsp; &nbsp; &nbsp; B. &nbsp;處理系統提示其他&nbsp;pkg-config 以遭遇到的問題來說可以選擇移除 Mono Framework</p>
<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 將&nbsp;/Library/Frameworks/Mono.framework &nbsp;整個砍掉即可，在/usr/bin/pkg-config的連結會一並被移除。</p>
<p>&nbsp;</p>
<p>3. 系統提供的其他解決方案</p>
<p>&nbsp; &nbsp;To resolve this issue, re-brew pkg-config with:</p>
<p>&nbsp; &nbsp;brew rm pkg-config &amp;&amp; brew install pkg-config</p>
<p>	不過因為該檔案權限被保護之類的關係，實際測試結果無法解決問題。</p>
<p>&nbsp;</p>
<p>由於覺得目前的解決辦法實在不是最佳的答案，如果有相關更好的解決辦法歡迎分享指教。</p>
<p><meta charset="utf-8" /><meta charset="utf-8" /></p>
<p> <a href="https://blog.faq-book.com/?p=2077#more-2077" class="more-link">繼續閱讀 &raquo;</a></p>

<div class="wp_rp_wrap  wp_rp_pinterest" ><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-1719" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1719" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]Rubygem mysql 問題" /></a><a href="https://blog.faq-book.com/?p=1719" class="wp_rp_title">[問題紀錄]Rubygem mysql 問題</a></li><li data-position="1" data-poid="in-2529" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2529" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/031.jpg" alt="Nginx安裝教學 (Nginx1.0.4+PHP5.3.6+MySQL5.5.14)" /></a><a href="https://blog.faq-book.com/?p=2529" class="wp_rp_title">Nginx安裝教學 (Nginx1.0.4+PHP5.3.6+MySQL5.5.14)</a></li><li data-position="2" data-poid="in-2092" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2092" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Rails 101 安裝問題排除 &amp; 移除相關安裝" /></a><a href="https://blog.faq-book.com/?p=2092" class="wp_rp_title">Rails 101 安裝問題排除 &amp; 移除相關安裝</a></li><li data-position="3" data-poid="in-4514" data-post-type="none" ><a href="https://blog.faq-book.com/?p=4514" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/06/Wordpess-%E5_%BA%E7_%BE-ERROR.jpg" alt="Wordpess 出現 [ERROR] Database error User &#8216;dbname&#8217; has exceeded the &#8216;max_questions&#8217; resource (current value: 2000)" /></a><a href="https://blog.faq-book.com/?p=4514" class="wp_rp_title">Wordpess 出現 [ERROR] Database error User &#8216;dbname&#8217; has exceeded the &#8216;max_questions&#8217; resource (current value: 2000)</a></li><li data-position="4" data-poid="in-1712" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]Ruby安裝dbi錯誤 on Mac" /></a><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_title">[問題紀錄]Ruby安裝dbi錯誤 on Mac</a></li><li data-position="5" data-poid="in-2516" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2516" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Mail Server Status of SMTP " /></a><a href="https://blog.faq-book.com/?p=2516" class="wp_rp_title">Mail Server Status of SMTP </a></li><li data-position="6" data-poid="in-2214" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2214" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="開啟Virtual Box 外連服務" /></a><a href="https://blog.faq-book.com/?p=2214" class="wp_rp_title">開啟Virtual Box 外連服務</a></li><li data-position="7" data-poid="in-7281" data-post-type="none" ><a href="https://blog.faq-book.com/?p=7281" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/06/DocPad.jpg" alt="DocPad 快速入門" /></a><a href="https://blog.faq-book.com/?p=7281" class="wp_rp_title">DocPad 快速入門</a></li><li data-position="8" data-poid="in-3177" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3177" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Smokeping 錯誤訊息 : ERROR opening  No such file or directory" /></a><a href="https://blog.faq-book.com/?p=3177" class="wp_rp_title">Smokeping 錯誤訊息 : ERROR opening  No such file or directory</a></li><li data-position="9" data-poid="in-19" data-post-type="none" ><a href="https://blog.faq-book.com/?p=19" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Meta範例+註解" /></a><a href="https://blog.faq-book.com/?p=19" class="wp_rp_title">Meta範例+註解</a></li></ul></div></div>
<div class='yarpp-related-rss'>
<h3>相關文章:</h3>
<div class="yarpp-thumbnails-horizontal">
<a class='yarpp-thumbnail' href='https://blog.faq-book.com/?p=1719' title='[問題紀錄]Rubygem mysql 問題'>
<span class="yarpp-thumbnail-default"><img src="http://blog.faq-book.com/wp-content/plugins/yet-another-related-posts-plugin/default.png"/></span><span class="yarpp-thumbnail-title">[問題紀錄]Rubygem mysql 問題</span></a>
<a class='yarpp-thumbnail' href='https://blog.faq-book.com/?p=1712' title='[問題紀錄]Ruby安裝dbi錯誤 on Mac'>
<span class="yarpp-thumbnail-default"><img src="http://blog.faq-book.com/wp-content/plugins/yet-another-related-posts-plugin/default.png"/></span><span class="yarpp-thumbnail-title">[問題紀錄]Ruby安裝dbi錯誤 on Mac</span></a>
</div>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=2077</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>[問題紀錄]Rubygem mysql 問題</title>
		<link>https://blog.faq-book.com/?p=1719</link>
		<comments>https://blog.faq-book.com/?p=1719#comments</comments>
		<pubDate>Tue, 31 May 2011 01:50:26 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[Ruby]]></category>
		<category><![CDATA[Error]]></category>
		<category><![CDATA[mysql]]></category>
		<category><![CDATA[Rubygem]]></category>
		<category><![CDATA[Rubygem mysql]]></category>
		<category><![CDATA[問題紀錄]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=1719</guid>
		<description><![CDATA[<p><meta charset="utf-8" /><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif"><font color="#3d85c6" size="2">環境</font><br />
	ruby 1.9.2p180 (2011-02-18 revision 30909) [x86_64-darwin10.7.0]<br />
	mysql2 (0.2.7)<br />
	Rails 3.0.7</p>
<p>	<font color="#3d85c6">問題</font><br />
	啥都還沒做光把資料庫預設為mysql 指令rails new webstie -d mysql<br />
	開完controller 馬上出現下面</font></span></p>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif"><br />
	</font></span></p>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif"><font color="#cc0000">Error</font></font></span></div>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif"><font color="#cc0000"><br />
		</font><font color="#e06666">TypeError&nbsp;<br />
		can&#39;t convert Fixnum into String</font></p>
<p>		<font color="#3d85c6">原因</font>：因為你的Mysql 密碼是數字！ （驚）</p>
<p>		<font color="#3d85c6">解決辦法</font></font></span></div>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif"><br />
		1.&nbsp;<font color="#93c47d">修改mysql 密碼 （治標）</font><br />
		mysqladmin -h localhost -u root password</p>
<p>		2.&nbsp;<font color="#93c47d">更改Gem程式碼（治本）</font>&nbsp;<br />
		Git上討論的解法<br />
		<a href="https://github.com/krekoten/mysql2/commit/68795e295e64faee357a56947b5cf09a2de397c1">https://github.com/krekoten/mysql2/commit/68795e295e64faee357a56947b5cf09a2de397c1</a><br />
		<font color="#6fa8dc">中文步驟</font><br />
		<font color="#e06666">編輯&nbsp;</font></font></span></div>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif"><font color="#e06666">lib/mysql2/client.rb （+增加該行程式碼 &#8211; 刪除）</font></font></span></p>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif">Mac的話在~/.rvm/gems/ruby-1.9.2-p180/gems/ 底下<br />
			<font color="#6fa8dc">ssl_set(*opts.values_at(:sslkey, :sslcert, :sslca, :sslcapath, :sslciper))</font></p>
<p>			<font color="#6fa8dc">user = opts[:username]</font><br />
			<font color="#c27ba0">- pass = opts[:password]</font><br />
			<font color="#93c47d">+ pass = opts[:password] ? opts[:password].to_s : nil</font><br />
			<font color="#6fa8dc">host = opts[:host] || &#39;localhost&#39;</font><br />
			<font color="#6fa8dc">port = opts[:port] || 3306</font></p>
<p>			<font color="#e06666">spec/mysql2/client_spec.rb &nbsp;備註：＋號不要放啊 第一行 那是程式 不用怕XD</font></font></span></div>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><font face="verdana, sans-serif"><br />
			<font color="#6fa8dc">}.should raise_error(Mysql2::Error)</font><br />
			<font color="#6fa8dc">end</font><br />
			<font color="#6fa8dc">end</font><br />
			<font color="#93c47d">+&nbsp;<br />
			+ it &#39;should convert password to string&#39; do<br />
			+ lambda do<br />
			+ client = Mysql2::Client.new(:password =&gt; 12345)<br />
			+ end.should_not raise_error(TypeError, &quot;can&#39;t convert Fixnum into String&quot;)<br />
			+ end</font></p>
<p>			<font color="#6fa8dc">it &quot;should accept connect flags and pass them to #connect&quot; do</font><br />
			<font color="#6fa8dc">klient = Class.new(Mysql2::Client) do</font><br />
			<font color="#6fa8dc">database = opts[:database]</font></font></span></div>
</p></div>
</div>

<div class="wp_rp_wrap  wp_rp_pinterest" ><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-2077" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2077" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]安裝 ImageMagick Error" /></a><a href="https://blog.faq-book.com/?p=2077" class="wp_rp_title">[問題紀錄]安裝 ImageMagick Error</a></li><li data-position="1" data-poid="in-4514" data-post-type="none" ><a href="https://blog.faq-book.com/?p=4514" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/06/Wordpess-%E5_%BA%E7_%BE-ERROR.jpg" alt="Wordpess 出現 [ERROR] Database error User &#8216;dbname&#8217; has exceeded the &#8216;max_questions&#8217; resource (current value: 2000)" /></a><a href="https://blog.faq-book.com/?p=4514" class="wp_rp_title">Wordpess 出現 [ERROR] Database error User &#8216;dbname&#8217; has exceeded the &#8216;max_questions&#8217; resource (current value: 2000)</a></li><li data-position="2" data-poid="in-44" data-post-type="none" ><a href="https://blog.faq-book.com/?p=44" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Linux 忘了mysql的root密碼" /></a><a href="https://blog.faq-book.com/?p=44" class="wp_rp_title">Linux 忘了mysql的root密碼</a></li><li data-position="3" data-poid="in-324" data-post-type="none" ><a href="https://blog.faq-book.com/?p=324" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/111.jpg" alt="Mysql phpMyAdmin  安全性設定" /></a><a href="https://blog.faq-book.com/?p=324" class="wp_rp_title">Mysql phpMyAdmin  安全性設定</a></li><li data-position="4" data-poid="in-1712" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]Ruby安裝dbi錯誤 on Mac" /></a><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_title">[問題紀錄]Ruby安裝dbi錯誤 on Mac</a></li><li data-position="5" data-poid="in-1527" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1527" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/139.jpg" alt="WordPress優化MySQL(WP-optimize)" /></a><a href="https://blog.faq-book.com/?p=1527" class="wp_rp_title">WordPress優化MySQL(WP-optimize)</a></li><li data-position="6" data-poid="in-2092" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2092" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Rails 101 安裝問題排除 &amp; 移除相關安裝" /></a><a href="https://blog.faq-book.com/?p=2092" class="wp_rp_title">Rails 101 安裝問題排除 &amp; 移除相關安裝</a></li><li data-position="7" data-poid="in-6725" data-post-type="none" ><a href="https://blog.faq-book.com/?p=6725" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/11/Nginx-yum-install.jpg" alt="Nginx 安裝教學(Nginx1.2.5+PHP5.3.19+MySQL5.5.27)" /></a><a href="https://blog.faq-book.com/?p=6725" class="wp_rp_title">Nginx 安裝教學(Nginx1.2.5+PHP5.3.19+MySQL5.5.27)</a></li><li data-position="8" data-poid="in-6706" data-post-type="none" ><a href="https://blog.faq-book.com/?p=6706" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/11/Nginx-yum-install.jpg" alt="Nginx yum 安裝教學-完整版 (Nginx1.2.5+PHP5.4.9+MySQL5.5.28)" /></a><a href="https://blog.faq-book.com/?p=6706" class="wp_rp_title">Nginx yum 安裝教學-完整版 (Nginx1.2.5+PHP5.4.9+MySQL5.5.28)</a></li><li data-position="9" data-poid="in-2529" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2529" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/031.jpg" alt="Nginx安裝教學 (Nginx1.0.4+PHP5.3.6+MySQL5.5.14)" /></a><a href="https://blog.faq-book.com/?p=2529" class="wp_rp_title">Nginx安裝教學 (Nginx1.0.4+PHP5.3.6+MySQL5.5.14)</a></li></ul></div></div>
<div class='yarpp-related-rss'>
<h3>相關文章:</h3>
<div class="yarpp-thumbnails-horizontal">
<a class='yarpp-thumbnail' href='https://blog.faq-book.com/?p=1712' title='[問題紀錄]Ruby安裝dbi錯誤 on Mac'>
<span class="yarpp-thumbnail-default"><img src="http://blog.faq-book.com/wp-content/plugins/yet-another-related-posts-plugin/default.png"/></span><span class="yarpp-thumbnail-title">[問題紀錄]Ruby安裝dbi錯誤 on Mac</span></a>
<a class='yarpp-thumbnail' href='https://blog.faq-book.com/?p=324' title='Mysql phpMyAdmin  安全性設定'>
<span class="yarpp-thumbnail-default"><img src="http://blog.faq-book.com/wp-content/plugins/yet-another-related-posts-plugin/default.png"/></span><span class="yarpp-thumbnail-title">Mysql phpMyAdmin  安全性設定</span></a>
<a class='yarpp-thumbnail' href='https://blog.faq-book.com/?p=44' title='Linux 忘了mysql的root密碼'>
<span class="yarpp-thumbnail-default"><img src="http://blog.faq-book.com/wp-content/plugins/yet-another-related-posts-plugin/default.png"/></span><span class="yarpp-thumbnail-title">Linux 忘了mysql的root密碼</span></a>
</div>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=1719</wfw:commentRss>
		<slash:comments>2</slash:comments>
		</item>
		<item>
		<title>[問題紀錄]Ruby安裝dbi錯誤 on Mac</title>
		<link>https://blog.faq-book.com/?p=1712</link>
		<comments>https://blog.faq-book.com/?p=1712#comments</comments>
		<pubDate>Sun, 29 May 2011 01:03:40 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[Ruby]]></category>
		<category><![CDATA[on Mac]]></category>
		<category><![CDATA[安裝dbi錯誤]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=1712</guid>
		<description><![CDATA[<p>錯誤訊息：.rvm/gems/ruby-1.9.2-p180/gems/dbi-0.4.3/lib/dbi/utils/date.rb:57:in <code>&lt;class:Date&gt;&#39;: undefined method </code>deprecate&#39; for DBI::Date:Class (NoMethodError)</p>
<div><meta charset="utf-8" /><meta charset="utf-8" />透過Rubygem 安裝dbi</div>
<div>&nbsp;</div>
<div>請補上 sudo&nbsp;gem install dbd-mysql</div>
<p>&nbsp;</p>
<p>測試用rb</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<blockquote>
<p># simple.rb &#8211; simple MySQL script using Ruby DBI module</p>
<p>require &quot;dbi&quot;</p>
<p>begin</p>
<p>&nbsp; &nbsp; # connect to the MySQL server</p>
<p>&nbsp; &nbsp; dbh = DBI.connect(&quot;dbi:Mysql:mysql:localhost&quot;, &quot;root&quot;, &quot;&quot;)</p>
<p>&nbsp;</p>
<p>&nbsp; &nbsp; # get server version string and display it</p>
<p>&nbsp; &nbsp; row = dbh.select_one(&quot;SELECT VERSION()&quot;)</p>
<p>&nbsp; &nbsp; puts &quot;Server version: &quot; + row[0]</p>
<p>rescue DBI::DatabaseError =&gt; e</p>
<p>&nbsp; &nbsp; puts &quot;An error occurred&quot;</p>
<p>&nbsp; &nbsp; puts &quot;Error code: #{e.err}&quot;</p>
<p>&nbsp; &nbsp; puts &quot;Error message: #{e.errstr}&quot;</p>
<p>ensure</p>
<p>&nbsp; &nbsp; # disconnect from server</p>
<p>&nbsp; &nbsp; dbh.disconnect if dbh</p>
<p>end</p>
<div>&nbsp;</div>
</blockquote>
<p>執行&nbsp;$ ruby test.rb &nbsp;出現下列訊息即成功</p>
<p>Server version: 5.1.51</p>
<div>&nbsp;</div>
<p>&nbsp;</p>
<p><meta charset="utf-8" /></p>

<div class="wp_rp_wrap  wp_rp_pinterest" ><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-2288" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2288" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/123935212.jpg" alt="當程式語言變成車！？" /></a><a href="https://blog.faq-book.com/?p=2288" class="wp_rp_title">當程式語言變成車！？</a></li><li data-position="1" data-poid="in-1719" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1719" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]Rubygem mysql 問題" /></a><a href="https://blog.faq-book.com/?p=1719" class="wp_rp_title">[問題紀錄]Rubygem mysql 問題</a></li><li data-position="2" data-poid="in-2077" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2077" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]安裝 ImageMagick Error" /></a><a href="https://blog.faq-book.com/?p=2077" class="wp_rp_title">[問題紀錄]安裝 ImageMagick Error</a></li><li data-position="3" data-poid="in-2092" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2092" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Rails 101 安裝問題排除 &amp; 移除相關安裝" /></a><a href="https://blog.faq-book.com/?p=2092" class="wp_rp_title">Rails 101 安裝問題排除 &amp; 移除相關安裝</a></li><li data-position="4" data-poid="in-5955" data-post-type="none" ><a href="https://blog.faq-book.com/?p=5955" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/10/Install-VMware-tools-for-Windows.jpg" alt="Install VMware tools for Windows" /></a><a href="https://blog.faq-book.com/?p=5955" class="wp_rp_title">Install VMware tools for Windows</a></li><li data-position="5" data-poid="in-5222" data-post-type="none" ><a href="https://blog.faq-book.com/?p=5222" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/07/GIT.jpg" alt="於 CentOS 6.2 安裝 Git, Gitolite 及 Gitlab" /></a><a href="https://blog.faq-book.com/?p=5222" class="wp_rp_title">於 CentOS 6.2 安裝 Git, Gitolite 及 Gitlab</a></li><li data-position="6" data-poid="in-2877" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2877" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Mac Pow + Html5 應用" /></a><a href="https://blog.faq-book.com/?p=2877" class="wp_rp_title">Mac Pow + Html5 應用</a></li><li data-position="7" data-poid="in-7281" data-post-type="none" ><a href="https://blog.faq-book.com/?p=7281" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/06/DocPad.jpg" alt="DocPad 快速入門" /></a><a href="https://blog.faq-book.com/?p=7281" class="wp_rp_title">DocPad 快速入門</a></li><li data-position="8" data-poid="in-1678" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1678" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/121.jpg" alt="Cacti 監控系統介紹與安裝" /></a><a href="https://blog.faq-book.com/?p=1678" class="wp_rp_title">Cacti 監控系統介紹與安裝</a></li><li data-position="9" data-poid="in-3086" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="JSON與JSON NET" /></a><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_title">JSON與JSON NET</a></li></ul></div></div>
<div class='yarpp-related-rss yarpp-related-none'>
<h3>相關文章:</h3>
<p>沒有相關文章</p>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=1712</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
