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...

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

I have now downloaded this: MySQL :: Download MySQL Community Server

and extraced to c:/mysql is that ok?

I have now downloaded this: MySQL :: Download MySQL Community Server

and extraced to c:/mysql is that ok?

I have now downloaded this: MySQL :: Download MySQL Community Server

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!