Gem Mysql with Mysql 5.1 on Snow Leopard
I need to put together a rails app today. Its been about a year since the last time I started a new project and I am on a new laptop running snow leopard now.
After updating my gem source and installing the newest version of rails, I created my new rails project. I choose mysql as my db type and set about creating a couple migrations. When I tried to run my migrations I found that I had not installed the mysql gem. I installed the mysql gem but all was not well. Well it was less not well than it appeared but here was the output of the install command.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 | $ sudo gem install mysql Password: Building native extensions. This could take a while... Successfully installed mysql-2.8.1 1 gem installed Installing ri documentation for mysql-2.8.1... No definition for next_result No definition for field_name No definition for field_table No definition for field_def No definition for field_type No definition for field_length No definition for field_max_length No definition for field_flags No definition for field_decimals No definition for time_inspect No definition for time_to_s No definition for time_get_year No definition for time_get_month No definition for time_get_day No definition for time_get_hour No definition for time_get_minute No definition for time_get_second No definition for time_get_neg No definition for time_get_second_part No definition for time_set_year No definition for time_set_month No definition for time_set_day No definition for time_set_hour No definition for time_set_minute No definition for time_set_second No definition for time_set_neg No definition for time_set_second_part No definition for time_equal No definition for error_errno No definition for error_sqlstate Installing RDoc documentation for mysql-2.8.1... No definition for next_result No definition for field_name No definition for field_table No definition for field_def No definition for field_type No definition for field_length No definition for field_max_length No definition for field_flags No definition for field_decimals No definition for time_inspect No definition for time_to_s No definition for time_get_year No definition for time_get_month No definition for time_get_day No definition for time_get_hour No definition for time_get_minute No definition for time_get_second No definition for time_get_neg No definition for time_get_second_part No definition for time_set_year No definition for time_set_month No definition for time_set_day No definition for time_set_hour No definition for time_set_minute No definition for time_set_second No definition for time_set_neg No definition for time_set_second_part No definition for time_equal No definition for error_errno No definition for error_sqlstate |
Which seems very ominous but if you notice at the top it does actually say the gem was installed. The errors have to do with the RI and RDoc installations.
However I found that even though the gem installed correctly I could still not run my migrations. After digging around a bit and spending a couple hours trying out different suggestions from the net I finally found my magic bullet. It appears when you install mysql 5.1 on snow leopard and want to use the mysql gem you need to install specify the config location and the arch type.
So without further ado, the magic command to get mysql 5.1 working with Rails 2.3.4 on Mac OS X Snow Leopard was…
1 | sudo env ARCHFLAGS="-arch x86_64" gem install --no-rdoc --no-ri mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config |
HTH,
sim
Thanks much. The command at the bottom is exactly what I needed to build the MySQL gem.
Glad it helped Rob. I know I wasted way more time than I would have liked to on it. :)
That got me past that error, bug now my app just says:
rake aborted!
Constant MysqlCompat::MysqlRes from mysql_compat/mysql_res.rb not found
Constant MysqlRes from mysql_res.rb not found
Any ideas?
i owe you a beer, my 3 hour saga with mysql has ended.
Wow. Great job on the fix :)
+1
gem install mysql –no-ri –no-rdoc
and you are done
Thank you so much! I went to over 20 sites, and yours was the first to provide a working solution. Thank you again!
Wow, thank you very much!