Subscribe
Accepted Solution

WFA 2.0 Can't log into MySQL database

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.

Re: WFA 2.0 Can't log into MySQL database

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.

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

Re: WFA 2.0 Can't log into MySQL database

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

Re: WFA 2.0 Can't log into MySQL database

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

Re: WFA 2.0 Can't log into MySQL database

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.

Re: WFA 2.0 Can't log into MySQL database

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

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

Re: WFA 2.0 Can't log into MySQL database

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

Re: WFA 2.0 Can't log into MySQL database

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

..- Hendrik

Re: WFA 2.0 Can't log into MySQL database

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