Can`t connect to MySQL Database with Netbeans 6 for RoR ?

Hello,

I am just yes fighting is the right word through the Netbeans 6.0 for
RoR guidance:

[quote]1.gem install mysql
2.Choose the win32 build.
3.Install MySQL and put its /bin directory on your path.[/quote]
did the first 2 steps but what means step 3 ???

Your path? What is my path and which path?

The connection to the MySQL database is also not working, why? what do
i wrong? Please help :slight_smile:

[img]http://img153.imageshack.us/img153/9611/test1ro5.gif[/img]

I get that exception?

[img]http://img86.imageshack.us/img86/8841/test2rm4.gif[/img]

3.Install MySQL and put its /bin directory on your path.[/quote]
did the first 2 steps but what means step 3 ???

To find if mysql is already in your path do:

which mysql

If you get nothing, then it's not.

To find it by searching the whole system you can run the find command:

find / -type f -name mysql -print

Mine shows up as /usr/bin/mysql for example.

Your path? What is my path and which path?

Assuming bash..

To see your current PATH environment variable:

echo $PATH

To add to your path you do

export PATH="/path/to/your/mysql/bin:$PATH"

Pel, you don't need to follow the instructions at the top of the
database.yml. As long as mysql is running as a service on your box you
should be able to get to it.

Try typing mysql into a command prompt window or go to c:\program
files\mysql\bin\ and type mysql there. If you can't log in it means mysql is
not running.

the path c:\program files\mysql\bin\ does not exist so which path must
I add to the environment variable?

How can i start the mysql server without going to the command prompt
for example from within the Netbeans IDE ?

looks this image is from 2 days ago when i installed netbeans and the
mysql driver with "gem install mysql" so mysql should be installed -
where i dont know- but how can i start it and is mysql a system
service? i thought its a driver...

thats the mysql image i forgot above to paste...

http://666kb.com/i/au3w8t0x4lplm6tb8.gif

thats the mysql image i forgot above to paste...

http://666kb.com/i/au3w8t0x4lplm6tb8.gif

I have now downloaded this: http://dev.mysql.com/downloads/mysql/5.0.html#win32

and extraced to c:/mysql is that ok?

I have now downloaded this: http://dev.mysql.com/downloads/mysql/5.0.html#win32

and extraced to c:/mysql is that ok?

I have now downloaded this: http://dev.mysql.com/downloads/mysql/5.0.html#win32

and extraced to c:/mysql is that ok?

For an easy life, download and install InstantRails:

http://rubyforge.org/projects/instantrails/

then point NetBeans to InstantRails.

Let me know how it goes.

Regards

Walter

[quote]

http://rubyforge.org/projects/instantrails/

then point NetBeans to InstantRails.

Let me know how it goes.[/quote]

Instant Rails is no longer being maintained and has been replaced by
the [BitNami RubyStack]. - and RubyStack is crap... because i dont
have a GUI.

[quote]
Ok, if you've extracted it to c:/mysql you should now have mysql
installed
try typing "mysql" in the command prompt and see what comes up. I
thought
you would've had mysql installed.

You shouldn't need the mysql gem.

The mysql service should be running automatically if that's what you
selected in your mysql setup. [/quote]

I have extracted it to c:\mysql yes but that does not mean that mysql
is installed right? Extracting an application does not mean it is
installed in my understanding.

i thought the mysql GEM is the connection between Netbeans and the
mysql driver?

run automactially? Where can i select that? I dont see any mysql
setup, I just can enter "mysql" at the command prompt for some
commands...

[quote]

http://rubyforge.org/projects/instantrails/

then point NetBeans to InstantRails.

Let me know how it goes.[/quote]

Instant Rails is no longer being maintained and has been replaced by
the [BitNami RubyStack]. - and RubyStack is crap... because i dont
have a GUI.

[quote]
Ok, if you've extracted it to c:/mysql you should now have mysql
installed
try typing "mysql" in the command prompt and see what comes up. I
thought
you would've had mysql installed.

You shouldn't need the mysql gem.

The mysql service should be running automatically if that's what you
selected in your mysql setup. [/quote]

I have extracted it to c:\mysql yes but that does not mean that mysql
is installed right? Extracting an application does not mean it is
installed in my understanding.

i thought the mysql GEM is the connection between Netbeans and the
mysql driver?

run automactially? Where can i select that? I dont see any mysql
setup, I just can enter "mysql" at the command prompt for some
commands...

can i integrate mongrel server anyhow into my Netbeans IDE , because
WEBrick seems outdated too?

can i integrate mongrel server anyhow into my Netbeans IDE , because
WEBrick seems outdated too?

Chill dude. Only trying to help. InstantRails is still available for
download. It's reasonably current (if not current). It works well.
And it will get you out of the mess you seem to have got yourself into
and have no idea of how you're going to get out of. Ask yourself the
question: how do you want to spend your life -- diagnosing how to
integrate MySQL with Netbeans or writing Ruby on Rails applications.
I suggest you choose the latter since you don't even know where your
'Path' is located.

can i integrate mongrel server anyhow into my Netbeans IDE , because
WEBrick seems outdated too?
>

Yes, you can, simply install mongrel gem...

gem install mongrel

And Netbeans will work with mongrel... (in my Linux workstation it works
!!!)

A little suggestion: set NetBeans 6 to work with native Ruby (instead of
JRuby), so you can work with mysql and debug application too...)
(Tools/Options/Ruby set Ruby interpreter...)

Good luck !

Yes, you can, simply install mongrel gem...

gem install mongrel

And Netbeans will work with mongrel... (in my Linux workstation it works
!!!)

I knew it somehow it would not work the first try as everything with
ruby...

look: [img]http://666kb.com/i/au4uvbtvctkbttpy1.gif[/img]

is it possible at all to get a working ruby/rails/mongrel/mysql
without instantrails ? whatever I do i get only error messages that
makes me sick.

Yes, you can, simply install mongrel gem...

gem install mongrel

And Netbeans will work with mongrel... (in my Linux workstation it works
!!!)

I knew it somehow it would not work the first try as everything with
ruby...

look: [img]http://666kb.com/i/au4uvbtvctkbttpy1.gif[/img]

is it possible at all to get a working ruby/rails/mongrel/mysql
without instantrails ? whatever I do i get only error messages that
makes me sick.

Yes, you can, simply install mongrel gem...

gem install mongrel

And Netbeans will work with mongrel... (in my Linux workstation it works
!!!)

I knew it somehow it would not work the first try as everything with
ruby...

look: [img]http://666kb.com/i/au4uvbtvctkbttpy1.gif[/img]

is it possible at all to get a working ruby/rails/mongrel/mysql
without instantrails ? whatever I do i get only error messages that
makes me sick.

When i need to install the fastthread dependeny why the heck do i
have the choice to install the dependency or not? whatever i choose i
get an error but thats ... no word for this!

When i need to install the fastthread dependeny why the heck do i
have the choice to install the dependency or not? whatever i choose i
get an error but thats ... no word for this!