Skip to main content

The problem with MC

  • August 19, 2014
  • 6 replies
  • 17 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
    • August 23, 2014

    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
    • August 25, 2014
    Hi, Han,

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

    BR
    Igor
    maria_2
    • maria_2
    • Participating Frequently
    • September 16, 2014
    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
    • September 17, 2014
    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
    • January 17, 2018

    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
    • January 18, 2018

    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