IQ Cockpit and Multiplex

[marco_antonini]

Hi,

I migrated 2 nodes multiplex from 15.3 up to 16 SP08 PL30 version and I used the "create multiplex server" command line to create the environment

I didn't face any problem and it has been running good since several months

Now I'd like to monitor the MPX env using the cockpit but when I log on from the cockpit console to the coordinator node I see the server as simplex and the multiplex server folder  is empty.

I registered the agent and authenticated : OK; then exploring looks fine but everything is treated as single server.

The OS is Linux

If I try to add a secondary server definition (just like I was creating the multiplex ....) from the cockpit it tells me that the catalog path (about reader node) already exists..... and it is true.

The MPX has been already created fine "manually" and I think I need just to config the cockpit in order to see the MPX env.

But HOW ?

What I have to modify ?

Thanks

Reagrds

Marco

[tayeb_hadjou · Accepted solution]

Hi Marco,

You may need restart IQCockpit service.

Make sure the cockpit user connected to IQ system fits the required privileges:

3.1.2 Multiplex Privilege Summary

http://help.sap.com/Download/Multimedia/zip-iq1608/iqcockpit.pdf

Also check related messages in Cockpit log files (agent.log, gateway.log, repository.log)  located in $SYBASE/COCKPIT-4/log

Regards,

Tayeb.

[marco_antonini · Accepted solution]

Hi Tayeb,

I restarted the IQ cockpit service and added the following to the DBA user I'm using to log on:

cockpit_admin role, cockpit_monitor_role, all required privilegies as showed in doc at section 3.2.1

but I see the same behaviour

The agent log shows that "Technical user store cannot be located" but I don't know if this is just warning or fatal error

Attached log files .....

thank you

Regards

Marco

agent_log.txt.zip

gateway_log.txt.zip

[marco_antonini · Accepted solution]

Hi, two more log files attached

repository_log.txt.zip

sqlanywhere-server_log.txt.zip

[tayeb_hadjou · Accepted solution]

Do users COCKPIT_MONITOR and COCKPIT_ADMIN exist in IQ database?

SELECT * FROM sys.sysuser WHERE user_name in ('COCKPIT_MONITOR', 'COCKPIT_ADMIN') ;

If yes, do they have the required privileges as defined in sql script

/$SYBASE/COCKPIT-4/plugins/IQ-CMAP/cockpit_monitor_role_based_privileges_setup.sql

[marco_antonini · Accepted solution]

Hi,

Yes, they exist and have the required privileges.

I executed as a first step the sql script

..../cockpit_monitor_role_based_privileges_setup.sql

No errors at all

[tayeb_hadjou · Accepted solution]

To check whether something is wrong in the repository database, backup and re-initialize it:

• - stop IQcockpit
• - do a full respository offline backup: move  repository.db and repository.log to repository_bck.db and repository_bck.log
• - restart IQcockpit
• Track IQcopit connection ID (ConnHandle) in IQ server, via sp_iqconnection
• Enably IQ full tracing for that connection. Example:

CALL sa_server_option( 'RequestLogFile', 'file_name_zr.out');

CALL sa_server_option( 'RequestLogging', 'ALL');

CALL sa_server_option( 'RequestFilterConn', connection-id )

• For more details about IQ sql tracing, review KBA 270379 and 1955732
• Test actions in question with IQcockpit
• disable IQ tracing
  

You can also proceed in two steps if you prefer: in first step enable iq tracing without repository initialization and test, then if iq tracing doesn't show relevant info, then follow steps above..

Regards,

Tayeb.

[marco_antonini · Accepted solution]

Hi Tayeb,

good suggestion .

After the action "re-initialize of the repository" now I see the multiplex !!

Also I could create the technical user and no error at all.

Now I can go ahead to configure the collection jobs ............

Many thanks

Regards

Marco