Rails - May 2009 - migration failure> mysql gem issues > xCode install -HELP!!

please help

i am running Mac os x 10.5.7 - have mysql 64 bit installed - ruby
1.8.6 - rails 2.2.2.  All ruby and rails functions seemed to be
working fine until I tried to do a simple rake db:migrate last night
and got errors that seemed to indicate mysql gem needed to be
installed (is this true?), I tried to install it and got ruby header
errors (amongst others) wich indicated i needed to install xCode (from
OS dvd), so i installed that and then was (i think) able to get the
mysql gem on but the migrate still throws funky errors:

dyld: lazy symbol binding failed: Symbol not found: _mysql_init
  Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/
mysql.bundle
  Expected in: dynamic lookup

and does not work! Now I am not sure where I stand and after much
googling it seems many people are going through this and there are
various fixes and advice but all of them different.

I now have like 9 GB worth of xCode on my system (for a reason I don''t
grasp) - may or may not have the mysql gem installed - and still cant
migrate.

can someone tell me if this situation is common?  what the correct fix
is?  Do I need xCode?  How do i uninstall xCode if I don''t?

Rails/mySQL/Mac is about as common a marriage there is, so I cant
imagine I am alone.

pretty sure I can back out the huge xCode install and uninstall the
mySQL driver to start over if someone can walk me through the correct
resolution.

thanks

hi,

did you created the rails project using like
rails -d mysql <projectname>

then install gem install mysql.. if error comes copy the particular dll from
mysql then copy to c:\ruby\bin folder
then  use rake db:migrate

try may be help




On 5/20/09, agilehack
<jason.rabolli-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
>
>
> please help
>
> i am running Mac os x 10.5.7 - have mysql 64 bit installed - ruby
> 1.8.6 - rails 2.2.2.  All ruby and rails functions seemed to be
> working fine until I tried to do a simple rake db:migrate last night
> and got errors that seemed to indicate mysql gem needed to be
> installed (is this true?), I tried to install it and got ruby header
> errors (amongst others) wich indicated i needed to install xCode (from
> OS dvd), so i installed that and then was (i think) able to get the
> mysql gem on but the migrate still throws funky errors:
>
> dyld: lazy symbol binding failed: Symbol not found: _mysql_init
> Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/
> mysql.bundle
> Expected in: dynamic lookup
>
> and does not work! Now I am not sure where I stand and after much
> googling it seems many people are going through this and there are
> various fixes and advice but all of them different.
>
> I now have like 9 GB worth of xCode on my system (for a reason I
don''t
> grasp) - may or may not have the mysql gem installed - and still cant
> migrate.
>
> can someone tell me if this situation is common?  what the correct fix
> is?  Do I need xCode?  How do i uninstall xCode if I don''t?
>
> Rails/mySQL/Mac is about as common a marriage there is, so I cant
> imagine I am alone.
>
> pretty sure I can back out the huge xCode install and uninstall the
> mySQL driver to start over if someone can walk me through the correct
> resolution.
>
> thanks
> >
>

-- 
Velmurugan

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

On May 20, 6:02 am, agilehack
<jason.rabo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> please help
>
> i am running Mac os x 10.5.7 - have mysql 64 bit installed - ruby
> 1.8.6 - rails 2.2.2.  All ruby and rails functions seemed to be
> working fine until I tried to do a simple rake db:migrate last night
> and got errors that seemed to indicate mysql gem needed to be
> installed (is this true?), I tried to install it and got ruby header
> errors (amongst others) wich indicated i needed to install xCode (from
> OS dvd), so i installed that and then was (i think) able to get the
> mysql gem on but the migrate still throws funky errors:
>
> dyld: lazy symbol binding failed: Symbol not found: _mysql_init
>   Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/
> mysql.bundle
>   Expected in: dynamic lookup
>
You want the 32bit version of mysql (or at the very least you need to
compile the mysql gem against the 32bit version of mysql) since the
ruby executable is 32bit and in Mac OS X a 32bit executable cannot
load a 64bit library.

Fred
> and does not work! Now I am not sure where I stand and after much
> googling it seems many people are going through this and there are
> various fixes and advice but all of them different.
>
> I now have like 9 GB worth of xCode on my system (for a reason I
don''t
> grasp) - may or may not have the mysql gem installed - and still cant
> migrate.
>
> can someone tell me if this situation is common?  what the correct fix
> is?  Do I need xCode?  How do i uninstall xCode if I don''t?
>
> Rails/mySQL/Mac is about as common a marriage there is, so I cant
> imagine I am alone.
>
> pretty sure I can back out the huge xCode install and uninstall the
> mySQL driver to start over if someone can walk me through the correct
> resolution.
>
> thanks

ah - that seems to make perfect sense.  I shouldn''t have pushed the
envelope with the 64 bit mySQL and I knew it at the time.

ok so with 32 bit mySQL I should have none of these issues and
therefore don''t even need the xCode for ruby header files etc I guess

with that in mind, can anyone help me with how to completely uninstall
the mySQL version I have now (64 bit) so I can then go get the 32 bit
clean

and

how to uninstall the entire xCode tools package I installed cleanly?

thanks for the help guys... live and learn

On May 20, 2:58 am, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> On May 20, 6:02 am, agilehack
<jason.rabo...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
>
>
>
>
> > please help
>
> > i am running Mac os x 10.5.7 - have mysql 64 bit installed - ruby
> > 1.8.6 - rails 2.2.2.  All ruby and rails functions seemed to be
> > working fine until I tried to do a simple rake db:migrate last night
> > and got errors that seemed to indicate mysql gem needed to be
> > installed (is this true?), I tried to install it and got ruby header
> > errors (amongst others) wich indicated i needed to install xCode (from
> > OS dvd), so i installed that and then was (i think) able to get the
> > mysql gem on but the migrate still throws funky errors:
>
> > dyld: lazy symbol binding failed: Symbol not found: _mysql_init
> >   Referenced from: /Library/Ruby/Gems/1.8/gems/mysql-2.7/lib/
> > mysql.bundle
> >   Expected in: dynamic lookup
>
> You want the 32bit version of mysql (or at the very least you need to
> compile the mysql gem against the 32bit version of mysql) since the
> ruby executable is 32bit and in Mac OS X a 32bit executable cannot
> load a 64bit library.
>
> Fred
>
>
>
> > and does not work! Now I am not sure where I stand and after much
> > googling it seems many people are going through this and there are
> > various fixes and advice but all of them different.
>
> > I now have like 9 GB worth of xCode on my system (for a reason I
don''t
> > grasp) - may or may not have the mysql gem installed - and still cant
> > migrate.
>
> > can someone tell me if this situation is common?  what the correct fix
> > is?  Do I need xCode?  How do i uninstall xCode if I don''t?
>
> > Rails/mySQL/Mac is about as common a marriage there is, so I cant
> > imagine I am alone.
>
> > pretty sure I can back out the huge xCode install and uninstall the
> > mySQL driver to start over if someone can walk me through the correct
> > resolution.
>
> > thanks

agilehack wrote:
[...]
> 
> how to uninstall the entire xCode tools package I installed cleanly?
If you mean the Developer Tools package, leave it in.  It contains C 
compilers and a bunch of other things you''ll likely need.  That goes 
double if you ever try to install anything through Fink or Macports.

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org
-- 
Posted via http://www.ruby-forum.com/.