topic Re: Can't see any other database schema besides information_schema in Active IQ Unified Manager Discussions

Can't see any other database schema besides information_schema

jrpatrick — Thu, 05 Jun 2025 05:51:10 GMT

I'm using WFA 2.0.1 and when I connect to the database using MySQL workbench 5.2, I can only see the information_schema. I used the user wfa and blank password to connect. I was hoping to view the tables so I could write some custom filters and possibly use the playground schema. What am I doing wrong?

Re: Can't see any other database schema besides information_schema

abhit — Thu, 24 Oct 2013 18:22:02 GMT

Please use username/pwd wfa/Wfa123 to access playground DB.

You can refer to the workflow developers guide for more details

https://library.netapp.com/ecm/ecm_download_file/ECMP1307539

Section "What playground database is".

-Abhi

Re: Can't see any other database schema besides information_schema

jrpatrick — Thu, 24 Oct 2013 19:42:00 GMT

The doc says WFA 2.1 and I'm using 2.0.1, will this info still apply?

Re: Can't see any other database schema besides information_schema

abhit — Fri, 25 Oct 2013 03:57:44 GMT

Yes

-Abhi

Re: Can't see any other database schema besides information_schema

jrpatrick — Fri, 25 Oct 2013 14:39:17 GMT

using user wfa and password Wfa123 it tells me access denied.

Re: Can't see any other database schema besides information_schema

sinhaa — Fri, 25 Oct 2013 16:10:28 GMT

jrpatrick,

going back to your original problem, can you answer the following?

1. Is it an absolute new installation of WFA and your WFA is completely fresh?

2. When you were able to see only the information schema, what credentials were you trying?

3. Credentials wfa/Wfa123 work only when server address is localhost. By default remote DB login is disabled. You can enable it, by following

Edit 'NetApp\WFA\mysql\my.ini'
Comment the last line - "bind-address=localhost" to "#bind-address=localhost"
Save the file and close.
Restart the WFA Database Service.

Re: Can't see any other database schema besides information_schema

jrpatrick — Fri, 25 Oct 2013 16:21:21 GMT

1. Is it an absolute new installation of WFA and your WFA is completely fresh?

I think this system had version 1.1 on previously. It was removed and 2.0 installed.

2. When you were able to see only the information schema, what credentials were you trying?

userid:wfa password: blank

3. Credentials wfa/Wfa123 work only when server address is localhost. By default remote DB login is disabled.

I have mysql workbench installed on the wfa server so all the communications I have been doing is via localhost.

Re: Can't see any other database schema besides information_schema

sinhaa — Fri, 25 Oct 2013 19:00:52 GMT

I can now only see that you have been hit by a known bug whose cause is somewhat unknown. It happens on some rare occasions ( outside of netapp, you have been the first case I know ) where even after a successful installation, WFA schema tables are not created.

The only way out is to uninstall this WFA and re-install. Its should work after that given the rarity of the bug's occurrence.

Your inconvenience is regretted.

Also I suggest you can use WFA2.1 version instead of WFA2.0. Its a big jump from 2.0 to 2.1

Re: Can't see any other database schema besides information_schema

jrpatrick — Sun, 27 Oct 2013 20:51:19 GMT

Created a brand new VM, installed 2.0.1 on it, and still have the same issues.

Re: Can't see any other database schema besides information_schema

yaronh — Sun, 27 Oct 2013 21:09:05 GMT

Hi Jrpatrick,

Just to confirm several points:

1) You have created a new VM (Which OS), installed 2.0.1 (No occupied ports right?)

2) Did you try and access WFA DB directly after installation?

3) Did you restore your backup and then tried?

4) Are you accessing the DB locally or remotely? Since remote access was not available by default.

If you restored a backup prior to trying access - I suspect something in the backup is amiss.

If not - Would be very interesting to see your backup.

Can you share it here or send it directly to yaronh ** @ ** netapp.com (Please remove asterisks).

Thanks,

Yaron

Re: Can't see any other database schema besides information_schema

jrpatrick — Sun, 27 Oct 2013 21:13:14 GMT

1) You have created a new VM (Which OS), installed 2.0.1 (No occupied ports right?)

Windows 2008 R2 Ent.

2) Did you try and access WFA DB directly after installation?

Yes. All I did was configure the Data Source to the DFM server

3) Did you restore your backup and then tried?

Nope.

4) Are you accessing the DB locally or remotely? Since remote access was not available by default.

locally... MySQL Workbench loaded on that new VM.

If you restored a backup prior to trying access - I suspect something in the backup is amiss.

If not - Would be very interesting to see your backup.

Re: Can't see any other database schema besides information_schema

yaronh — Sun, 27 Oct 2013 21:24:18 GMT

Was the acquisition successful? After connecting to the DFM?

Re: Can't see any other database schema besides information_schema

jrpatrick — Sun, 27 Oct 2013 22:04:17 GMT

The acquisition was successful.

Re: Can't see any other database schema besides information_schema

kandati — Mon, 28 Oct 2013 05:00:01 GMT

When your are connecting from MySQL workbench 5.2, what value is populated in Database(s) or Default scheme field(the page where you provide the connection details)..!

Is it blank or some value is populated..!!

-Siva

Re: Can't see any other database schema besides information_schema

abhit — Mon, 28 Oct 2013 05:51:00 GMT

To further debug the issue, we have logged a defect in our defect tracking system.

Will update you about the progress of the same shortly.

-Abhi

Re: Can't see any other database schema besides information_schema

sinhaa — Mon, 28 Oct 2013 08:15:47 GMT

Jrpatrick,

Back to your original post and the problem has been found out. I was able to reproduce the issue you are facing.

This is a known bug in WFA2.0 and WFA2.0.1 that user wfa/Wfa123 is only allowed remote access and not access through localhost. So if you are using Server: localhost and credentials wfa/Wfa123 , your login will fail saying access denied.

This bug has been fixed in WFA2.1, so I suggest you upgrade to WFA2.1

But if you still want to continue with WFA2.0.1, enable remote login to your WFA db by doing the following steps:

Edit 'NetApp\WFA\mysql\my.ini'
Comment the last line - "bind-address=localhost" by adding a # i.e. #bind-address=localhost
Save the file and close.
Restart the WFA Database Service ( it will restart Server service too).

Now try to login giving IP Address of the WFA server ( and Not localhost ) and userid: wfa , Passwd: Wfa123.

This will have to work.

warm regards,

Abhishek

Re: Can't see any other database schema besides information_schema

jrpatrick — Mon, 28 Oct 2013 12:21:20 GMT

I leave default schema blank.

Re: Can't see any other database schema besides information_schema

jrpatrick — Mon, 28 Oct 2013 21:48:46 GMT

that did it! I connected with the system IP, to my original system with wfa/Wfa123 and I can see them now.