Join us at SIGGRAPH for the Academy Software Foundation BoF.
Discussion around the Academy Software Foundation, open source development in the motion picture industry, Foundation overview/updates, future roadmap, benefits for open source developers and projects, and Q&A.
Invitation: ASWF Beers of a Feather #cal-invite @ Mon Jul 29, 2019 9pm - 11pm (EDT) (main@lists.aswf.io)
#cal-invite
|
||||||||||||||
|
||||||||||||||
Re: Exception: ERROR: permission denied for table show
Greg Denton <gdenton@...>
Hi, 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. Thanks, Greg On Mon, Jul 8, 2019 at 4:06 AM Tian Isaac <isaac4job@...> wrote:
|
||||||||||||||
|
||||||||||||||
Exception: ERROR: permission denied for table show
Tian Isaac
I installed cuebot and postgres in container, When I try to execute those commands: >>> import opencue >>> import outline >>> [show.name() for show in opencue.api.getShows()] I got those error: Traceback (most recent call last):File "<stdin>", line 1, in <module> File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/pycue-0.2.31-py2.7.egg/opencue/util.py", line 59, in _decorator "Server caught an internal exception. {}".format(details))) File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/pycue-0.2.31-py2.7.egg/opencue/util.py", line 44, in _decorator return grpcFunc(*args, **kwargs) File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/pycue-0.2.31-py2.7.egg/opencue/api.py", line 191, in getShows show_pb2.ShowGetShowsRequest(), timeout=Cuebot.Timeout).shows File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/grpc/_channel.py", line 533, in __call__ return _end_unary_response_blocking(state, call, False, None) File "/apps/shared/ddp/opencuelib/0.0.1/site-packages/grpc/_channel.py", line 467, in _end_unary_response_blocking raise _Rendezvous(state, None, None, deadline) opencue.exception.CueInternalErrorException: Server caught an internal exception. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT show.*,COALESCE(vs_show_stat.int_pending_count,0) AS int_pending_count,COALESCE(vs_show_stat.int_running_count,0) AS int_running_count,COALESCE(vs_show_stat.int_dead_count,0) AS int_dead_count,COALESCE(vs_show_resource.int_cores,0) AS int_cores, COALESCE(vs_show_stat.int_job_count,0) AS int_job_count FROM show LEFT JOIN vs_show_stat ON (vs_show_stat.pk_show = show.pk_show) LEFT JOIN vs_show_resource ON (vs_show_resource.pk_show=show.pk_show) WHERE 1 = 1 ]; nested exception is org.postgresql.util.PSQLException: ERROR: permission denied for table show StatementCallback; bad SQL grammar [SELECT show.*,COALESCE(vs_show_stat.int_pending_count,0) AS int_pending_count,COALESCE(vs_show_stat.int_running_count,0) AS int_running_count,COALESCE(vs_show_stat.int_dead_count,0) AS int_dead_count,COALESCE(vs_show_resource.int_cores,0) AS int_cores, COALESCE(vs_show_stat.int_job_count,0) AS int_job_count FROM show LEFT JOIN vs_show_stat ON (vs_show_stat.pk_show = show.pk_show) LEFT JOIN vs_show_resource ON (vs_show_resource.pk_show=show.pk_show) WHERE 1 = 1 ]; nested exception is org.postgresql.util.PSQLException: ERROR: permission denied for table show But when l try to run those SQL commands at the host machine directly, that works fine. Does anybody have any clues? |
||||||||||||||
|
||||||||||||||
Invitation: OpenTimelineIO BoF @ Tue Jul 30, 2019 4pm - 5pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: MaterialX BoF @ Tue Jul 30, 2019 8pm - 9pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: Open Shading Language BoF @ Tue Jul 30, 2019 7pm - 8pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: OpenColorIO BoF @ Tue Jul 30, 2019 6pm - 7pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: ACES BoF @ Tue Jul 30, 2019 5pm - 6pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: OpenCue BoF @ Tue Jul 30, 2019 3pm - 4pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: OpenEXR BoF @ Tue Jul 30, 2019 2pm - 3pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: Rez BoF @ Tue Jul 30, 2019 1pm - 2pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: OpenVDB BoF @ Tue Jul 30, 2019 12pm - 1pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Invitation: Academy Software Foundation BoF at SIGGRAPH @ Mon Jul 29, 2019 6:30pm - 7:30pm (EDT) (main@lists.aswf.io)
|
||||||||||||||
|
||||||||||||||
Updated Event: SIGGRAPH: ASWF BoF Session - Monday, 29 July 2019
#cal-invite
main@lists.aswf.io Calendar <main@...>
SIGGRAPH: ASWF BoF Session When: Where: Description: Speakers: David Morin, Epic Games, ASWF Executive Director; Rob Bredow, ILM, ASWF Board Chair; Daniel Heckenberg, Animal Logic, ASWF TAC Chair |
||||||||||||||
|
||||||||||||||
Managing calendar invites from the mailing lists
ASWF community members, As many of you know, you can access a full calendar of ASWF meetings at https://lists.aswf.io/calendar, which is a great way to find meetings and events happening within the community. LF staff, TAC, and TSC leads keep this calendar up to date ( with TSC leads cross posting TSC meetings to the TAC lists for wider visibility ). This can naturally lead to multiple meeting invites on you calendar that may or not be of interest. To help alleviate this, you can use the muting function built into groups.io to have messages with various hashtags ignored. We've hashtagged meeting invites as follows, and you go to https://lists.aswf.io/mutedhashtags to ignore ones that aren't of interest. #cal-invite - This would mute all invites to meetings #ci-working - CI working group #opencue-tsc - OpenCue TSC #ocio-tsc - OpenColorIO TSC #openexr-tsc - OpenEXR TSC #openvdb-tsc - OpenVDB TSC Let me know if you have any questions or concerns. Thank you, John Mertic Director of Program Management - Linux Foundation ASWF, ODPi, and Open Mainframe Project |
||||||||||||||
|
||||||||||||||
Re: custom ocio creation for nuke
Ravindra Korde
Im having little confusion in this, what should i do first to start making my own ocio setup.
or should i use default file to make new one. |
||||||||||||||
|
||||||||||||||
Re: custom ocio creation for nuke
Ravindra Korde
can you please explain me step by step? On Tue, May 21, 2019, 12:42 PM Arjun Thekkumadathil <3darjun@...> wrote:
|
||||||||||||||
|
||||||||||||||
Re: custom ocio creation for nuke
Arjun Thekkumadathil
You don’t have to, the config file and lut folder are there in the repo itself. Running that make.py will regenerate the luts again. Thanks Arjun On Tue, 21 May 2019 at 4:43 am, <rravindrakorde@...> wrote: Thanks Arjun!! |
||||||||||||||
|
||||||||||||||
Re: custom ocio creation for nuke
Ravindra Korde
Thanks Arjun!!
After changing the config.ocio we need to add that changes in make.py? |
||||||||||||||
|
||||||||||||||
Re: custom ocio creation for nuke
Arjun Thekkumadathil
This might be a good place to start off On Mon, 20 May 2019 at 12:18 pm, <rravindrakorde@...> wrote: Hi All, |
||||||||||||||
|