Active IQ Unified Manager Discussions

Where is the WFA Cache database located?

korns
4,928 Views

I need to look at the contents of a dictionary table I've acquired by creating a dictionary, scheme, and data source. It appears to have been successfully acquired according to Data Source Acquire Now saying Successful. I'd like to view the table to see if it contains what I expect. I've downloaded a SQL tool (called SQL MDF Viewer) onto the WFA system. I am now trying to find where the WFA Cache database is and am searching throughout C:\Program Files\NetApp\WFA... but can not find any .MDF files which is what the tool opens

6 REPLIES 6

shailaja
4,928 Views

Could you please refer to the following posts and see if it helps you. There are references to tools in these posts:

https://communities.netapp.com/message/96988#96988

https://communities.netapp.com/message/72997#72997

Thanks,

Shailaja

korns
4,928 Views

I can try another tool but won't I still have the question: Where is the database .MDF file located?

sinhaa
4,928 Views

Isn't .MDF files the data base files for Microsoft SQL server? WFA Database server is mysql.

You can use mysql workbench, SQL Yog or DB visualizer to connect to WFA DB.

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

korns
4,928 Views

Thanks Sinhaa,  (duh, yeah. MDF is MsSQL, not MySQL, my bad 🙂 ... but admittedly new to both.

Okay, I switched to DbVisualizer and installed it directly on my WFA server. I get error messages indicated that the user/pswd I'm using are proper credentials (user: wfa, pswd: Wfa123) but I still am prompted for the database name and I'm guessing at it. I have tried 'wfa', 'cache' and 'playground'. Noether 'wfa' nor 'cache' seem to (error: Access denied for user 'wfa'@'%' to database 'wfa') work but when I entered 'playground' as database name it actually seems to connect to something. But I am not interested in the playground. I'm wanting to look at a dictionary I have added which as I understand is in the normal WFA Cache database. What concept am I missing?

korns
4,928 Views

OKay, answered my own question:

c:> mysql --user=wfa --password=Wfa123

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| cm_performance     |

| cm_storage         |

| jp                 |

| performance        |

| playground         |

| storage            |

| vc                 |

+--------------------+

8 rows in set (0.02 sec)

mysql>

... the schemes map to databases

sinhaa
4,928 Views

If you like using Powershell then I have this Powershell module that works quite good for connecting to WFA Mysql db. You'll need to install Mysql .Net Connector from here: http://dev.mysql.com/downloads/file.php?id=450594

Download the attached file and save it in some location i.e. C:\fakepath

Now import this module and it connects to the WFA mysql server using wfa/Wfa123 and executes your query. It returns a list of objects which can be use conveniently in you powershell code.

If you modify the profile.ps1 located at NetApp\WFA\PoSH with Import-module for this, you can now use it directly in WFA commands just like another cmdlet.

sinhaa

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