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?
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
but,, i don't understand why do i need to restart vertica_agent? There was no such problem before.
I was just guessing at your issue
Check the status of the agents:
[dbadmin@localhost ~]$ /opt/vertica/sbin/vertica_agent status
Vertica Agent: sh (pid 389240) is running...
But make sure the user you are logged into MC as has the appropriate MC Database Privileges:
And that you've mapped your MC to user to a Vertica DB user with the required privileges: