Upgrading from 10.0.12 to 10.1.1 fails due less permissions.
espocrm.log:
ERROR: (0) Failed to rebuild database schema. Rebuild database early-rebuild error.
[object] (RuntimeException(code: 0): Rebuild database early-rebuild error. at /var/www/espocrm/application/Espo/Core/Utils/Database/Schema/SchemaManager.php:163)
[previous exception] [object] (RuntimeException(code: 0): An exception occurred while executing a query: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for table pg_depend
...
...
postgresql.log:
espocrmdbuser@espocrmdb ERROR: permission denied for table pg_depend
espocrmdbuser@espocrmdb CONTEXT: SQL statement "UPDATE pg_depend
What I tried to check the permissions on Postgresql:
postgres=# \c espocrmdb espocrmdbuser
You are now connected to database "espocrmdb" as user "espocrmdbuser".
espocrmdb=> SELECT has_table_privilege('espocrmdbuser', 'pg_catalog.pg_depend', 'SELECT');
has_table_privilege
---------------------
t
espocrmdb=> SELECT * FROM pg_catalog.pg_depend LIMIT 1;
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
---------+-------+----------+------------+----------+-------------+---------
1247 | 12002 | 0 | 1259 | 12000 | 0 | i
Any hints?
espocrm.log:
ERROR: (0) Failed to rebuild database schema. Rebuild database early-rebuild error.
[object] (RuntimeException(code: 0): Rebuild database early-rebuild error. at /var/www/espocrm/application/Espo/Core/Utils/Database/Schema/SchemaManager.php:163)
[previous exception] [object] (RuntimeException(code: 0): An exception occurred while executing a query: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for table pg_depend
...
...
postgresql.log:
espocrmdbuser@espocrmdb ERROR: permission denied for table pg_depend
espocrmdbuser@espocrmdb CONTEXT: SQL statement "UPDATE pg_depend
What I tried to check the permissions on Postgresql:
postgres=# \c espocrmdb espocrmdbuser
You are now connected to database "espocrmdb" as user "espocrmdbuser".
espocrmdb=> SELECT has_table_privilege('espocrmdbuser', 'pg_catalog.pg_depend', 'SELECT');
has_table_privilege
---------------------
t
espocrmdb=> SELECT * FROM pg_catalog.pg_depend LIMIT 1;
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
---------+-------+----------+------------+----------+-------------+---------
1247 | 12002 | 0 | 1259 | 12000 | 0 | i
Any hints?
