WFA 2.0 Can't log into MySQL database

[TIMHOIBERG]

I was wondering if any changes were made to accessing the MySQL database in WFA 2.0. I just upgraded to 2.0 from 1.1.1 and noticed that I can't log into the database. For reference I'm using MySQL Workbench 5.2 CE and using the same settings as I was previously. However, instead of a dialog box asking for the password I get the error message: "Your connection attempt failed for user 'wfa' from you host to server vbnewfa4001:3306:"

Settings I'm using:

Username: wfa

Hostname: vbnewfa4001 (Our WFA server)

Port: 3306

This configuration worked fine on WFA 1.1.1. Any help would be much appreciated.

[sinhaa · Accepted solution]

You can try this:

1. Stop your NetApp WFA Database service

2. Go to NetApp/WFA/mysql folder and open file my.ini using any editor (notepad)

3. The bottom line will be "bind-address=localhost". Comment this line out by placing a # in the beginning

4. Start the NetApp WFA Database service and WFA Server service.

Now attempt to login.

[TIMHOIBERG]

Thanks sinhaa I can now log in, although it doesn't require a password anymore.

[yaronh]

Hi Tim,

Just to add to the former reply:

Due to security scrutiny we decided to block remote-access to the database by default.

As suggested by Sinha, this block can be overridden for customers who wish it so.

Best,

Yaron Haimsohn

WFA Team

[TIMHOIBERG]

Hi Yaron,

Is there a particular application for accessing the database you can suggest? As mentioned I'm using MySQL Workbench 5.2 CE but I couldn't find a 64-bit version and the 32-bit version seems to be quite buggy on my WFA server.

[sinhaa]

If I may answer to you Tim,

     I am using DbVisulizer 9.0.1 which is a good Database client tool. Its freely downloadable from : http://www.dbvis.com/

There is a licensed enterprise edition too.

Another powerful ( but licensed)  DB tool is SQLyog Enterprise - MySQL GUI

[yaronh]

Hi Tim,

I am using SQLYog from www.webyog.com. Not sure what their pricing scheme though but I understood it's quite affordable.

They have a month long trial if you like.

I checked the DbVisualizer and it seems great for viewing data and running queries, but the free version can't edit data (Which might be useful).

Another option I used once is Navicat. They are also quite nice and once had a free version. http://www.navicat.com/

Googling, also found this one - http://www.mysqlajaxtableeditor.com
which seems really cool

Yaron

[hland]

There's also a pre-configured package of open-source components available from this post: https://communities.netapp.com/message/72997#72997

..- Hendrik

[mhofstet]

This has fixed my issue. But still, on the WFA server I still can't loging with the "localhost" settings with the bind-address settings...

but the #bind-address has fixed it.

Marc