topic Re: Web-based access to WFA cache database in Active IQ Unified Manager Discussions

Web-based access to WFA cache database

hland — Thu, 05 Jun 2025 06:36:10 GMT

Accessing the WFA cache DB can be useful for developing filters and testing SQL queries directly on the database as well as for quickly verifying contents in the cache DB. As I was unhappy with switching between the web-based WFA interface and a RDP session to the server for using SQLyog or similar tools, I assembled a small solution to provide web-based access to the database. So now I can access the database in another tab of my browser.

The solution is completely based on free tools (NGINX webserver, PHP, Chive MySQL tool). It is portable so you can quickly deploy it on the WFA server without any installation - and removing it is just a matter of deleting one directory.

If anybody is interested: Get ftp://ftp.netapp.com/pub/home/hland/nginx_chive.zip and unzip it to 'c:\' on your WFA server while keeping the folder structure in the ZIP file intact. You should have the following path in the end: c:\nginx\start-server.vbs

Run the start-server.vbs (it will run in the background so you won't see anything), then point your browser to http://<wfa-server>:8888 You will see a login page, leave the server as 'localhost' and then enter username and password of a database user (WFA 1.1 will have a read-only user account that you can use). You can now browse all tables and run SQL queries. See screenshots below.

Hope this is useful

Hendrik

Re: Web-based access to WFA cache database

f_duranti — Tue, 31 Jan 2012 15:19:38 GMT

Hi Hendrik, is the ftp public or internal only? I'm not able to download the file.

Regards

Francesco

Re: Web-based access to WFA cache database

hland — Tue, 31 Jan 2012 16:02:35 GMT

Hi Francesco,

It's public but it seems that the forum insisted on making it http:// instead of ftp://. Please try again. If it doesn't work I'll attach the file directly to the post.

Regards

Hendrik

Re: Web-based access to WFA cache database

f_duranti — Tue, 31 Jan 2012 17:01:54 GMT

Yeah it worked, did not saw the http:// in the address bar

Re: Web-based access to WFA cache database

yakobi — Thu, 01 Mar 2012 08:31:06 GMT

Thanks Hendrick - this is awesome!

Re: Web-based access to WFA cache database

ahohl — Thu, 01 Mar 2012 08:36:33 GMT

Excellent stuff.

Re: Web-based access to WFA cache database

fenton — Thu, 01 Mar 2012 09:04:44 GMT

Sweet - top work fella

Re: Web-based access to WFA cache database

yaronh — Mon, 21 May 2012 11:12:39 GMT

Thanks!! Great stuff!

Re: Web-based access to WFA cache database

slair — Thu, 13 Jun 2013 19:35:11 GMT

I'm running WFA 2.0.1.23.8-13393

I can log into the database, but all i see is the information_schema.

What username & pwd should i be using?

Re: Web-based access to WFA cache database

shailaja — Fri, 14 Jun 2013 08:00:46 GMT

Please also refer to the post: https://communities.netapp.com/message/109987#109987

There's a Read-only user to the DB that allows you to test your queries on the cache schema and see it's contents.

Use "wfa/Wfa123" as username/password for access.

Thanks,

Shailaja

Re: Web-based access to WFA cache database

raovolvoadmin — Sat, 15 Jun 2013 05:19:14 GMT

Hi Hendrik,

Thanks.Useful stuff.I am new to this tool.Can you plz give me one example how to use this?. or do we have any document?.

Regards,

Srinivas.

Re: Web-based access to WFA cache database

abhit — Mon, 17 Jun 2013 10:28:14 GMT

Can you plz give me one example how to use this?. or do we have any document?.

[Abhi] Hi Srinivas, sorry I did not get the question, what examples are you looking for?