Hi jason! Yes have double checked that and it's defiantly right and pointing to the right place, still no joy :(<div><br></div><div>Jim - while I could do that, I work as part of a team, so I'm not sure it great idea to change the gem set so it will work on this one machine. Which also makes me think it is the rails set up is the issue as I have the project installed and running perfectly on other machines.</div>
<div><br></div><div>Unless the version of mysql it's running? or maybe a config I've missed for mysql?<br><br><div class="gmail_quote">On 17 January 2011 13:37, Jason Green <span dir="ltr"><<a href="mailto:jason.green@nogeek.org">jason.green@nogeek.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div style="word-wrap:break-word">Have you checked that the path to your mysql config exists and that is the correct one that which mysql is pointing to?<div>
<br></div><font color="#888888"><div>Jason Green</div><div><a href="http://www.dynamic50.com" target="_blank">http://www.dynamic50.com</a></div></font><div><div></div><div class="h5"><div><br><div><div>On 17 Jan 2011, at 13:31, Adrian Stainforth wrote:</div>
<br><blockquote type="cite">Thanks, but I believe that only works with rails3, doesn't it? I'm trying to get it to work with rails 2.3.8 for old sites.<br><br><div class="gmail_quote">On 17 January 2011 13:23, Jim Myhrberg <span dir="ltr"><<a href="mailto:contact@jimeh.me" target="_blank">contact@jimeh.me</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>
<div>
<span>I'm not sure what version of Rails you're using, but with the latest version of Rails uses the mysql2 gem, which is faster and better in every possible way from what I've read. Also, it installs and compiles perfectly fine on OSX.</span></div>
<div><span><br></span></div><div><span>Check the GitHub repo for more info:</span></div><div><span><a href="https://github.com/brianmario/mysql2" target="_blank">https://github.com/brianmario/mysql2</a></span></div><div>
<span><br>
</span></div><div><span><br></span></div><div><span><a href="https://github.com/brianmario/mysql2" target="_blank"></a>-jim<br>
</span><div><div></div><div>
<span><br><div><br></div><div><br></div></span><p style="color:#a0a0a0">On Monday, January 17, 2011 at 13:05, Adrian Stainforth wrote:</p>
</div></div><blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px">
<span><div><div><div></div><div><div>Can anyone help me, I'm struggling with an RVM install with mysql.<div><br></div><div>I'm on Mac OSX 10.6 64bit and have installed rvm fine with 1.8.7 and rails 2.3.8 and then installed mysql server which is also 64bit.</div>
<div><br></div><div>I then tried to install the mysql gem using:</div><div><br></div><div><div>env ARCHFLAGS="-arch x86_64" rvm gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config</div></div>
<div><br></div><div>but then once I run rake db:setup or db:migrate I get the following error: </div><div><br></div><div><div>** Invoke db:setup (first_time)</div><div>** Invoke db:create (first_time)</div><div>** Invoke db:load_config (first_time)</div>
<div>** Invoke rails_env (first_time)</div><div>** Execute rails_env</div><div>** Execute db:load_config</div><div>** Execute db:create</div><div>Couldn't create database for {"reconnect"=>false, "encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql", "database"=>"tabascopizza_development", "pool"=>5, "password"=>nil}, charset: utf8, collation: utf8_unicode_ci (if you set the charset manually, make sure you have a matching collation)</div>
<div>** Invoke db:schema:load (first_time)</div><div>** Invoke environment (first_time)</div><div>** Execute environment</div><div>** Execute db:schema:load</div><div>-- create_table("enters", {:force=>true})</div>
<div>rake aborted!</div><div>uninitialized constant MysqlCompat::MysqlRes</div><div><br></div><div>I've tried googling and most of them go on about making sure mysql and ruby are 64bit which they are because I check with 'which ruby' & 'which mysql'</div>
<div><br></div><div>Does anyone have any ideas on why it is failing?</div><div><br></div><div>Thanks</div><div><br></div>-- <br>Kind Regards<br>Adrian Stainforth<br><br>Front-end Developer<br><br>
</div>
</div></div></div><div>_______________________________________________<br>Chat mailing list<br><a href="mailto:Chat@lists.lrug.org" target="_blank">Chat@lists.lrug.org</a><br><a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
</div></div></span>
</blockquote>
<div>
<br>
</div>
</div>
</div><br>_______________________________________________<br>
Chat mailing list<br>
<a href="mailto:Chat@lists.lrug.org" target="_blank">Chat@lists.lrug.org</a><br>
<a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Kind Regards<br>Adrian Stainforth<br><br>Front-end Developer<br>Mobile: +447740069109<br><br>
_______________________________________________<br>Chat mailing list<br><a href="mailto:Chat@lists.lrug.org" target="_blank">Chat@lists.lrug.org</a><br><a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
</blockquote></div><br></div></div></div></div><br>_______________________________________________<br>
Chat mailing list<br>
<a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br>
<a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Kind Regards<br>Adrian Stainforth<br><br>Front-end Developer<br>Mobile: +447740069109<br><br>
</div>