Getting an error when trying to connect to MySQL from netbeans ruby task

[Nick]

I am running on Windows Vista with MySQL 5.0. I can connect just fine from the services tab in NetBeans, but when I try to run a database migration task I get the following error:
Access denied for user 'root'@'localhost' (using password: NO)

I've triple checked my passwords in database.yml file, but nothing seems to work. Looking for ideas. Help.

Thanks.

[Erno Mononen]

Hi Nick,

Any chance you're running the migration task under a different Rails env
than you expect, e.g. it is trying to connect to the test or prod db
when you are expecting it to connect to the dev db? Also,
additional/missing spaces in the database.yml file may cause this kind
of problems, so better to carefully check for those.

Erno

Nick wrote:

[Nick]

Erno,

Thanks for the reply. I checked that as well. I currently only have one environment all on a local dev machine. To try and troubleshoot, I have set up all of the databases and that didn't help.

I also checked the database.yml file for extra spaces and it appears to be clean. Any other ideas?

I've installed a duplicate environment on an XP box and that works fine.

Nick

[Erno Mononen]

Unfortunately I don't really have much more ideas now... I guess one
cause could be that you don't have access rights for root@localhost (the
connection in the services tab would still work if it is using 127.0.0.1
instead of localhost and you have granted rights for root@127.0.0.1, but
not root@localhost).

Erno


Nick wrote:

[Chris Kutler]

Other Vista users are having this problem.

See
http://www.nabble.com/mysql-problem-with-rake-db%3Acreate-JRuby-Vista-Rails-2.2.2-tt20941612.html#a20943969


Not sure if it is related.

Erno Mononen wrote:

[J]

I'm doing some RoR development on Mac and after checking out some
projects from svn, NB complains about a broken reference to mysql-
connector-java-5.1.6-bin.jar.

Now, this file naturally is located in
/Applications/NetBeans/NetBeans\ 6.5.app/Contents/Resources/NetBeans/
ide10/modules/ext/

In the project properties dialog where I can setup the java classpath,
the file browser only lets me navigate somewhere to '/Applications/
NetBeans/NetBeans 6.5' where it recognizes the package and does not
allow for deeper file system navigation.

Maybe thats a Mac-newbies question (I'm in fact a Mac newbie).

BTW, I found the reference in one of the project files:


project.properties:

javac.classpath=${file.reference.mysql-connector-java-5.1.6-bin.jar}


Does anybody know where file.reference.mysql-connector-java-5.1.6-
bin.jar is actually set?

Any help is deeply appreciated,

- J

[Erno Mononen]

Hi J

[J]

This did the trick Erno, thanks alot.

Now I'm facing

rake aborted!
The driver encountered an error: cannot load Java class
com.mysql.jdbc.Driver

But I thinks thats something different. Somehow the jar is found,
otherwise it wouldn't have been able to tell me about a missing
database before I think.

Thanks again,

- J


On 28.02.2009, at 12:13, Erno Mononen wrote:

[Erno Mononen]

Hi J

[J]

Hi Erno!

Yes, the reference is properly resolved and copying the jar to
jruby-1.1.4/lib also fixes the other issue.

Everything is fine now. Thanks alot.

- J

On 02.03.2009, at 09:57, Erno Mononen wrote:

[Erno Mononen]

Good to hear it's working for you now. Anyway, copying the jar shouldn't
be needed since the IDE should automatically include it in the JRuby
class path when running, so you seem to be hitting a bug of some sort --
if you like, you can file a bug for it at
http://www.netbeans.org/issues/enter_bug.cgi (the right component would
be ruby/platform).

Thanks,
Erno

J