Skip to content

WebVH endorser: unauthorized user when querying tables #357

Description

@esune

The WebVH endorser is having issues connecting to the database via the APIs: the message seems to indicate an error with user permissions on the schema/tables:

{
  "detail": "(sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.InsufficientPrivilegeError'>: permission denied for table allowedlogentry\n[SQL: SELECT allowedlogentry.scid, allowedlogentry.domain, allowedlogentry.namespace, allowedlogentry.identifier, allowedlogentry.version, allowedlogentry.log_updates, allowedlogentry.details, allowedlogentry.allowed_log_entry_id, allowedlogentry.created_at, allowedlogentry.updated_at \nFROM allowedlogentry \nWHERE true \n LIMIT $1::INTEGER OFFSET $2::INTEGER]\n[parameters: (10, 0)]\n(Background on this error at: https://sqlalche.me/e/20/f405)"
}
 

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Fields

No fields configured for Bug.

Projects

Status
In Progress

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions