Subscribe
Accepted Solution

WFA Datasource problem to access OnCommand

Hi,

we have OC version 5.0.1 i can't login to DFM.

Created a db user as described on:

https://kb.netapp.com/support/index?page=content&id=1013466

Can't run wfa_oc5setup.sh script, had some java issues.

Here is the error message when I aquire the data source:

SQL Anywhere Error -121: Permission denied: you do not have permission to select from "hosts"

Password is correct, when i enter a wron get following:

java.sql.SQLWarning: SQL Anywhere Error -103: Invalid user ID or password

Best wishes,

Markus.

Re: WFA Datasource problem to access OnCommand

Hi Markus,

Thanks for the referral to the KB article.

Actually it is not needed. Running oc5setup.sh is enough and is the right thing to do.

Unfortunately, you did not provide more information about the issue you faced. Can you share the message?

It is good for helping us understand what's wrong and fix it.

The errors you faced later make sense:

Since oc5setup creates a user through which WFA will pull information, you can't connect as the user was

not created. Did you remember to setup your data source with the user/pass combo oc5setup is creating?

(wfa/Wfa123).

Best,

Yaron Haimsohn

WFA team

Re: WFA Datasource problem to access OnCommand

Hi Yaron,

I tried to run the script on linux get following message:

./wfa_oc5setup.sh /opt/NTAPdfm

Verifying archive integrity... All good.

Uncompressing WFA OnCommand-5 Setup...

./setup.sh: line 4: /opt/NTAPdfm/java/bin/java: No such file or directory

But would also be nice to know when a customer wants to set up manually the db access.

Best wishes,

Markus.

Re: WFA Datasource problem to access OnCommand

Markus,

is OnCommand installed at the path listed in the error message? Do these directories exist? If not, maybe you can fool the tool with a temporary symlink pointing to the right path?

You can't set this up manually as the tool interacts directly with the OnCommand database. The process described in the KB you've posted only creates a user with access to a very small portion of the DFM database that we make available. WFA needs more than that.

Regards

Hendrik

Re: WFA Datasource problem to access OnCommand

Hi Hendrik,

it must be an issue with the paths or with java. but i think I know the issue. seems that I tested on a old OM 4.01.

ls2280:/tmp # java -version

java version "1.4.2_16"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_16-b05)

Java HotSpot(TM) Client VM (build 1.4.2_16-b05, mixed mode)

ls2280:/tmp #

ls2280:/tmp # ./wfa_oc5setup.sh /opt/NTAPdfm/

Verifying archive integrity... All good.

Uncompressing WFA OnCommand-5 Setup...

./setup.sh: line 4: /opt/NTAPdfm//java/bin/java: No such file or directory

ls2280:/tmp #

dfm version

dfm 4.0.1 (4.0.1)

May be it makes sense, that the script check for a corect OC version.

Now I could run the script on OC 5.0.2 but can't conect with WFA

Having new issues:

vml3853:/tmp # dfm version

dfm 5.0.2 (5.0.2)

vml3853:/tmp # ./wfa_oc5setup.sh /opt/NTAPdfm/

Verifying archive integrity... All good.

Uncompressing WFA OnCommand-5 Setup...

>>> Connecting to database

<<< Connected

*** Dropped existing 'wfa' user

=== Created user 'wfa'

>>> Granting access

<<< Granted access

vml3853:/tmp # dfm database user list

There are no database users or the specified database user does not exist.

Is the wfa user a hidden?

When I aquire I get following:

JZ006: IOException: java.net.UnknownHostException: null wurde abgefangen

I am running:

WFA 1.1.1.22.5

Built 7752

Best wishes,

Markus.

Re: WFA Datasource problem to access OnCommand

Markus,

yes, the user created by the oc5setup tool is not a user created by the regular "dfm database " means so its doesn't show up.

The screenshot shows that you didn't enter a hostname, which is explains the "UnknownHostException" error message :-)

Regards

Hendrik

Re: WFA Datasource problem to access OnCommand

Hi Hendrik,

that was a stupid misstake from my side. Thank you. Now it works. :-)

Just 2 Ideas which should be implemented:

- script should have the capabliity to define the password for the wfa user

- prechecks for for correct OnCommand version

Best wishes,

Markus