Active IQ Unified Manager Discussions

WFA 2.0 Can't log into MySQL database

TIMHOIBERG
10,572 Views

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.

1 ACCEPTED SOLUTION

sinhaa
10,572 Views

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.

View solution in original post

8 REPLIES 8

sinhaa
10,573 Views

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.

TIMHOIBERG
10,572 Views

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

yaronh
10,572 Views

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
10,572 Views

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
10,572 Views

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.

yaronh
10,572 Views

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
10,572 Views

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

..- Hendrik

mhofstet
10,572 Views

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

Public