Date   

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:
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?


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)

John Mertic
 

You have been invited to the following event.

OpenTimelineIO BoF

When
Tue Jul 30, 2019 4pm – 5pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Progress update and open discussion about OpenTimelineIO, an API and interchange format for editorial cut information used in production at a variety of studios.

Link: https://s2019.siggraph.org/?post_type=page&p=4920&id=bof_124&sess=sess314

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: MaterialX BoF @ Tue Jul 30, 2019 8pm - 9pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

MaterialX BoF

When
Tue Jul 30, 2019 8pm – 9pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Discussion of MaterialX, an open standard for the transfer of rich material and lookdev content between different DCC tools and renderers.

Link: https://s2019.siggraph.org/presentation/?id=bof_131&sess=sess315

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: Open Shading Language BoF @ Tue Jul 30, 2019 7pm - 8pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

Open Shading Language BoF

When
Tue Jul 30, 2019 7pm – 8pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
For users and contributors to Open Shading Language open source project. OSL is the leading shading language for high-end offline rendering for visual effects and animation.

Link: https://s2019.siggraph.org/presentation/?id=bof_126&sess=sess298

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: OpenColorIO BoF @ Tue Jul 30, 2019 6pm - 7pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

OpenColorIO BoF

When
Tue Jul 30, 2019 6pm – 7pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Discuss topics related to the open source project OpenColorIO, including new governance as an Academy Software Foundation hosted project, progress on OCIO version 2, and Q&A.

Link: https://s2019.siggraph.org/?post_type=page&p=4920&id=bof_110&sess=sess317

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: ACES BoF @ Tue Jul 30, 2019 5pm - 6pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

ACES BoF

When
Tue Jul 30, 2019 5pm – 6pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Join us for a briefing and conversation about the ACES roadmap and how you can join the efforts to craft an enhanced and improved ACES.

Link: https://s2019.siggraph.org/?post_type=page&p=4920&id=bof_137&sess=sess318

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: OpenCue BoF @ Tue Jul 30, 2019 3pm - 4pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

OpenCue BoF

When
Tue Jul 30, 2019 3pm – 4pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Learn more about roadmap plans for OpenCue, an open source, high-performance render manager for visual effects and animation, hosted at the Academy Software Foundation. Boxed lunches will be provided by ASWF.

Link: https://s2019.siggraph.org/?post_type=page&p=4920&id=bof_122&sess=sess297

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: OpenEXR BoF @ Tue Jul 30, 2019 2pm - 3pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

OpenEXR BoF

When
Tue Jul 30, 2019 2pm – 3pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Discuss the latest on OpenEXR, a project hosted at Academy Software Foundation, and future areas of development.

Link: https://s2019.siggraph.org/presentation/?id=bof_112&sess=sess242

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: Rez BoF @ Tue Jul 30, 2019 1pm - 2pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

Rez BoF

When
Tue Jul 30, 2019 1pm – 2pm Eastern Time - New York
Where
JW Marriott, Diamond Ballrooms 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Join us for an overview of how Method Studios integrate rez into their pipeline, followed by an overview of outstanding feature development and a conversation about the future goals of the project.

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: OpenVDB BoF @ Tue Jul 30, 2019 12pm - 1pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

OpenVDB BoF

When
Tue Jul 30, 2019 12pm – 1pm Eastern Time - New York
Where
JW Marriott, Diamond Ballroom 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Discuss topics related to the open source project OpenVDB, including new governance as an Academy Software Foundation hosted project, ideas and plans for future development, and Q&A.

Link: https://s2019.siggraph.org/presentation/?id=bof_109&sess=sess316

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Invitation: Academy Software Foundation BoF at SIGGRAPH @ Mon Jul 29, 2019 6:30pm - 7:30pm (EDT) (main@lists.aswf.io)

John Mertic
 

You have been invited to the following event.

Academy Software Foundation BoF at SIGGRAPH

When
Mon Jul 29, 2019 6:30pm – 7:30pm Eastern Time - New York
Where
JW Marriott, Diamond Ballrooms 7-10 (map)
Calendar
main@...
Who
jmertic@... - organizer
main@...
Academy Software Foundation Birds of a Feather session at SIGGRAPH 2019 in los Angeles.

Link: https://s2019.siggraph.org/presentation/?id=bof_108&sess=sess296

Going (main@...)?   Yes - Maybe - No    more options »

Invitation from Google Calendar

You are receiving this courtesy email at the account main@... because you are an attendee of this event.

To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

Forwarding this invitation could allow any recipient to send a response to the organizer and be added to the guest list, or invite others regardless of their own invitation status, or to modify your RSVP. Learn More.


Updated Event: SIGGRAPH: ASWF BoF Session - Monday, 29 July 2019 #cal-invite

main@lists.aswf.io Calendar <main@...>
 

SIGGRAPH: ASWF BoF Session

When:
Monday, 29 July 2019
3:30pm to 4:30pm
(UTC-07:00) America/Los Angeles

Where:
SIGGRAPH - JW Marriott, Diamond Ballroom 7-10

Description:

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.

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

John Mertic
 

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
Schedule time with me at https://calendly.com/jmertic


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:
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!!

After changing the config.ocio we need to add that changes in make.py?


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!!

After changing the config.ocio we need to add that changes in make.py?


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
 

On Mon, 20 May 2019 at 12:18 pm, <rravindrakorde@...> wrote:
Hi All,

I'm trying to create custom ocio file for nuke, with reference of http://opencolorio.org/.
im new at this so any help or suggestion will be appreciated.

Thanks!!! 


custom ocio creation for nuke

Ravindra Korde
 

Hi All,

I'm trying to create custom ocio file for nuke, with reference of http://opencolorio.org/.
im new at this so any help or suggestion will be appreciated.

Thanks!!! 

61 - 80 of 188