gem mysql on windows problem

J

jason joo

[Note: parts of this message were removed to make it a legal post.]

hi guys
I used to running ruby apps on ubuntu but someone else would running them on
win32.
recently I find a problem in gem "mysql" on ruby 1.9.2.
I connect, query, query.
but it seems that the connection aborts when the first query completes and
then the second query ends with error "not connected".

this issue seems to exist on win32 only.


is there any solution?


thanks
jason
 
L

Luis Lavena

[Note:  parts of this message were removed to make it a legal post.]

hi guys
I used to running ruby apps on ubuntu but someone else would running themon
win32.
recently I find a problem in gem "mysql" on ruby 1.9.2.
I connect, query, query.
but it seems that the connection aborts when the first query completes and
then the second query ends with error "not connected".

this issue seems to exist on win32 only.

is there any solution?

On Linux you compile everything, on Windows there are binary gems
provided, so:

Specifically what version of Ruby (ruby -v) are you talking about?

What version of mysql gem did you installed?

Is the MySQL server local? What version of MySQL is?

Have you copied libmysql.dll into Ruby\bin as described by
RubyInstaller tutorials?

http://github.com/oneclick/rubyinstaller/wiki/Tutorials

If so, what version of libmysql.dll have you copied?

Help us help you.
 
J

jason joo

[Note: parts of this message were removed to make it a legal post.]

yeah, it works !
thanks a lot
though I have used the one-click-installer the "libmysql.dll" is not
contained in it
so I feel confused that why not publishing the installer with it if the bin
file require a centain version one?

thanks again
jason

2010/9/15 Luis Lavena said:
[Note: parts of this message were removed to make it a legal post.]

hi guys
I used to running ruby apps on ubuntu but someone else would running them on
win32.
recently I find a problem in gem "mysql" on ruby 1.9.2.
I connect, query, query.
but it seems that the connection aborts when the first query completes and
then the second query ends with error "not connected".

this issue seems to exist on win32 only.

is there any solution?

On Linux you compile everything, on Windows there are binary gems
provided, so:

Specifically what version of Ruby (ruby -v) are you talking about?

What version of mysql gem did you installed?

Is the MySQL server local? What version of MySQL is?

Have you copied libmysql.dll into Ruby\bin as described by
RubyInstaller tutorials?

http://github.com/oneclick/rubyinstaller/wiki/Tutorials

If so, what version of libmysql.dll have you copied?

Help us help you.
 
L

Luis Lavena

[Note:  parts of this message were removed to make it a legal post.]

yeah, it works !
thanks a lot
though I have used the one-click-installer the "libmysql.dll" is not
contained in it
so I feel confused that why not publishing the installer with it if the bin
file require a centain version one?

No MySQL libraires are included in the installers, is up to you.

The libmysql.dll used with mysql binary gem needs to be 5.0.x, attempt
to use 5.1.x versions of the DLL will results in segfaults due
internal MySQL changes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,969
Messages
2,570,161
Members
46,710
Latest member
bernietqt

Latest Threads

Top