Skip to main content

The problem with MC

  • Aug 19, 2014 5:37 PM UTC
  • 6 replies
  • 23 views
Igor_Trosko
Forum|alt.badge.img+2
I have two databases on two different clusters under one MC. For one database operates as described in the documentation and for the other part of the functions work and some do not. 
On the Database and clusters page no performance graphs, on page Activity instead of useful information I see the message: "Monitoring Activities requires the database user have 
the DBADMIN role. See your database administrator for more details" 
and on Database designer's page I see the message: "Database Designer functionality requires the database user have the DBDUSER role. See your database administrator for more details".  User permissions are identical at different clusters the same. 

Advise me please, what do I check in MC parameters.

    6 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • Aug 23, 2014 7:10 AM UTC

    Hello Igor,

     

    There is a defect on Vertica and MC 7.01 that when MC and vertica clusters are on different networks, and if user imported the cluster using public IP of the cluster, Management Concole may not work correctly.  Is this your case?  This issue has been fix in 7.1.

     

    If you install management console, as a test, on one of the node of the clusters themselves (one MC per cluster), will you have same issue?

     

    Regards,

    Han

    Igor_Trosko
    Forum|alt.badge.img+2
    • Igor_Trosko
    • Author
    • Participating Frequently
    • Aug 25, 2014 6:53 PM UTC
    Hi, Han,

    You're right, we use MC 7.0.1 release. Thanks very much!

    BR
    Igor
    maria_2
    • maria_2
    • Participating Frequently
    • Sep 16, 2014 2:14 AM UTC
    Hi Igor I installed vertica-console-7.1.0-0 in one of our servers and imported our production database. I am getting the same error. Is there a work around on this to resolve the issue?
    Igor_Trosko
    Forum|alt.badge.img+2
    • Igor_Trosko
    • Author
    • Participating Frequently
    • Sep 17, 2014 12:22 AM UTC
    Hi Maria

    We use to 7.0 release  now and we are waiting upgrade to 7.1. If you 'll have information about a work around, do you inform about it? Thanks in advance.

    BW, Igor
    hchau8
    • hchau8
    • New Participant
    • Jan 17, 2018 11:54 PM UTC

    I install Vertica-console 9 and have the same issues when the Activity and Designer pages. I verify the user ID in vertica database has dbadmin role [show role('userID', 'dbadmin)]. The same ID is used to configure MC and login to MC. Any suggestion.

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • Jan 18, 2018 2:00 PM UTC

    Hi,

    Can you verify that the dbadmin role is a default role for your user?

    select all_roles, default_roles from users where user_name = 'userID';

    Also, make sure that the Vertica agent is running on each node.The MC needs at least one agent to be running in order to validate/secure a connection to the database, but I always make sure its running on each node.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement