just getting started, and having problems with configuration

[FCS_ITSTORAGE]

I am just getting started with WFA. I have added my DFM server (7 mode, storage) as a data source, but the query keeps showing the error "SQL Anywhere Error - 121: Permission denied: you do not have permission to select from "backupPrimaryDirs"

Not sure how to move forward with this, but I need to get this going before I even attempt to add vCenter etc as data sources.

[abrian · Accepted solution]

Have you run wfa_ocsetup on the DFM/OnCommand server yet?  That creates the database user WFA expects to use to access SQL Anywhere.  You can find it in the bin directory of WFA under Program Files.  Copy the appropriate instance (wfa_ocsetup.sh for *nix DFM/OC platforms and wfa_ocsetup.exe for Windows DFM/OC platforms) to the DFM host and execute.

[FCS_ITSTORAGE]

That worked! thanks for the quick response. Your response is telling me that I maybe missed some really great deployment documentation... can you point me in the direction of that documentation please?

[abrian]

If you use the setup wizard, which should have launched automatically on first use, it will tell you in a dialog box.  You can also access the setup wizard from the tools menu. Other than that, I'm not sure if there is an installation/admin guide.  Searching for "setup", "dfm", or"oncommand" is in the Content area will likely pull up articles on using wfa_ocsetup. 

[yaronh]

Of course there is an Installation and Setup guide.

Kindly refer to the download page, and follow the installation instructions carefully (And, as Brian recommended, follow the instruction of the Setup Wizard for easy setup).

http://support.netapp.com/NOW/download/software/ocwfa/2.0.1/

Cheers,

Yaron

[mike090909]

Hi Yaron,

i have the same Problem .

The /wfa_oc5setup.sh Script donst solve the problem

/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

Everything looks good. But I get a this Error message in WFA

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

what is the Problem ?

Thanks

Mike

[hill]

Hi Mike,

This sounds like an issue that happened when moving from WFA 2.0.1 to WFA 2.1.  There was a new table in DFM 5.x "backupPrimaryDirs", added to WFA cache, and it is necessary to run the NEW version of wfa_oc5setup.sh on your DFM system.  It's not sufficient to simply run the older version from WFA 2.0.1 as it will not provide access to the new table.

I would advise removing the old version of wfa_oc5setup.sh from your DFM system, then pull over and run the updated version of wfa_oc5setup.sh on your DFM system.  Hopefully this will fix your issue.

Best,

Kevin.

[mike090909]

Hi Kevin,

Thanks for help !

The wfa_oc5setup.sh Script from the Orginal WFA 2.1 Setup is broken.

I Think the Script ist not in unix Format.

/wfa_ocsetup.sh

-bash: ./wfa_ocsetup.sh: /bin/sh^M: bad interpreter: No such file or directory

Do You have a Working Version of this Scipt ?

Regards

Mike

[hill]

Hi Mike,

Try this one, though I can't tell you for certain if it will work.  I don't have a Linux DFM system I can run it against.

Hope this helps,

Kevin

[mike090909]

Hi Kevin,

Thanks...

Same Problem...

The Script is Broken.

Regards Mike

Am 17.12.2013 14:45, schrieb Kevin Hill:

<https://communities.netapp.com/index.jspa>

Re: just getting started, and having problems with configuration

created by Kevin Hill<https://communities.netapp.com/people/hill> in OnCommand Workflow Automation - View the full discussion<https://communities.netapp.com/message/122511#122511>

Hi Mike,

Try this one, though I can't tell you for certain if it will work. I don't have a Linux DFM system I can run it against.

Hope this helps,

Kevin

Reply to this message by replying to this email -or- go to the message on NetApp Community<https://communities.netapp.com/message/122511#122511>

Start a new discussion in OnCommand Workflow Automation by email<mailto:discussions-community-products_and_solutions-storage_management_software-workflow--automation@communities.netapp.com> or at NetApp Community<https://communities.netapp.com/choose-container.jspa?contentType=1&containerType=14&container=2768>

--

Mit freundlichen Gr??en - Kind regards

Mike Engert

[dblackwe]

Don't try running it as it's own exacutable. Instead call it with sh

:$ sh wfa_setup.sh

Also know that even though the script makes it look like it passes wfa as the default user, it doesn't. You need to define a user.

David Blackwell, NCDA

(571) 358-5522

[mike090909]

Hi

i know

Hier the output :

sh wfa_ocsetup.sh

: command not founde 3:

: command not founde 7:

: command not founde 14:

wfa_ocsetup.sh: line 18: syntax error near unexpected token `elif'

'fa_ocsetup.sh: line 18: `elif test -x /usr/ucb/echo; then

I have a Redhat 5 System..

The old wfa_ocsetup.sh Script from wfa 2.0.1 works perfectly.

The Script has a unix enode problem

Regards Mike

Am 17.12.2013 15:15, schrieb dblackwe:

<https://communities.netapp.com/index.jspa>

Re: just getting started, and having problems with configuration

created by dblackwe<https://communities.netapp.com/people/dblackwe> in OnCommand Workflow Automation - View the full discussion<https://communities.netapp.com/message/122527#122527>

Don't try running it as it's own exacutable. Instead call it with sh

:$ sh wfa_setup.sh

Also know that even though the script makes it look like it passes wfa as the default user, it doesn't. You need to define a user.

David Blackwell, NCDA

(571) 358-5522

Reply to this message by replying to this email -or- go to the message on NetApp Community<https://communities.netapp.com/message/122527#122527>

Start a new discussion in OnCommand Workflow Automation by email<mailto:discussions-community-products_and_solutions-storage_management_software-workflow--automation@communities.netapp.com> or at NetApp Community<https://communities.netapp.com/choose-container.jspa?contentType=1&containerType=14&container=2768>

--

Mit freundlichen Gr??en - Kind regards

Mike Engert

[dblackwe]

I don’t have a 5.x rhel system to test against but I just re-grabbed and tested the 2.1.0.70.31RC1 WFA wfa_ocsetup.sh file generated for a cluster 5.2 OCUM system and it worked fine on a rhel 6.4 system.

I am attaching it in case it helps you.

David Blackwell

[mike090909]

Hi David,

Thanks a lot !

Your ZIP File is OK ! wfa_ocsetup.sh Script works !

you save my day

Regards Mike

Am 17.12.2013 15:51, schrieb dblackwe:

<https://communities.netapp.com/index.jspa>

Re: just getting started, and having problems with configuration

created by dblackwe<https://communities.netapp.com/people/dblackwe> in OnCommand Workflow Automation - View the full discussion<https://communities.netapp.com/message/122530#122530>

I don't have a 5.x rhel system to test against but I just re-grabbed and tested the 2.1.0.70.31RC1 WFA wfa_ocsetup.sh file generated for a cluster 5.2 OCUM system and it worked fine on a rhel 6.4 system.

I am attaching it in case it helps you.

David Blackwell

Reply to this message by replying to this email -or- go to the message on NetApp Community<https://communities.netapp.com/message/122530#122530>

Start a new discussion in OnCommand Workflow Automation by email<mailto:discussions-community-products_and_solutions-storage_management_software-workflow--automation@communities.netapp.com> or at NetApp Community<https://communities.netapp.com/choose-container.jspa?contentType=1&containerType=14&container=2768>

--

Mit freundlichen Gr??en - Kind regards

Mike Engert