How can i fix the message "Monitoring Activities requires the database user have the DBADMIN role"

HyeontaeJu

today, i log-in to the vertica management console using dbadmin. and i got a this message "Monitoring Activities requires the database user have the DBADMIN role"

How do i fix it?

Jim_Knicely

MC needs at least one agent to be running in order to validate/secure a connection to the database.

If you need to restart the agent on the Vertica nodes, run:
/etc/init.d/vertica_agent restart

If you are using Red Hat Enterprise Linux/CentOS 7, use the following command instead:
/opt/vertica/sbin/vertica_agent restart

HyeontaeJu

but,, i don't understand why do i need to restart vertica_agent? There was no such problem before.

Jim_Knicely

I was just guessing at your issue

Check the status of the agents:

[dbadmin@localhost ~]$ /opt/vertica/sbin/vertica_agent status
use_agent=true
true
Vertica Agent: sh (pid 389240) is running...

Jim_Knicely

But make sure the user you are logged into MC as has the appropriate MC Database Privileges:

https://www.vertica.com/docs/latest/HTML/Content/Authoring/ManagementConsole/ManagingUsersandPrivileges/MCDatabasePrivileges.htm

And that you've mapped your MC to user to a Vertica DB user with the required privileges:

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/ManagementConsole/ManagingUsersandPrivileges/GrantingDatabaseAccessToMCUsers.htm