2012-12-16 08:33 PM
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:
Hostname: vbnewfa4001 (Our WFA server)
This configuration worked fine on WFA 1.1.1. Any help would be much appreciated.
Solved! SEE THE SOLUTION
2012-12-16 10:49 PM
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.
2012-12-17 03:55 AM
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.
2012-12-17 04:42 PM
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.
2012-12-18 12:17 AM
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
2012-12-18 02:10 AM
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
2013-01-22 05:37 AM
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.