Re: Exception: ERROR: permission denied for table show
Greg Denton <gdenton@...>
toggle quoted messageShow quoted text
It sounds like either the DB_USER was created with insufficient privileges when configuring the database or there's some other problem with user/password combination when starting up cuebot. Here are a few things to verify...
1.) Make sure that steps 1 & 2 were performed as described in the "Creating the database" section of https://www.opencue.io/docs/getting-started/setting-up-the-database/
As noted in the "Important" section, if the database tables were created before altering the user privileges, you will need to run the "GRANT ALL PRIVILEGES..." command.
2.) Ensure that the DB_NAME, DB_USER, and DB_PASS environment variables are all correctly set to match the values specified when creating the database. Be sure to run the cuebot container specifying the additional "--datasource" flags used to specify the username and password as described in the "Installing and Running Cuebot" section of https://www.opencue.io/docs/getting-started/deploying-cuebot/.
3.) If you are still running into problems, check the logs for any additional error messages in the cuebot startup. See the "Verifying your install" section of https://www.opencue.io/docs/getting-started/deploying-cuebot/.
I hope that helps get you started. Please let us know if you continue to run into any issues.
On Mon, Jul 8, 2019 at 4:06 AM Tian Isaac <isaac4job@...> wrote: