sudo -u goblinartists ./bin/gmg dbupdate returns sqlalchemy.exc.ProgrammingError: (ProgrammingError) exception

[Jorge Araya Navarro]

I'm trying to deploy Postgres in my mediagoblin instance, but I have this problem.

[shackra@abrilhost mediagoblin]$ sudo -u goblinartists ./bin/gmg dbupdate
** Message: pygobject_register_sinkfunc is deprecated (GstObject)
/srv/http/goblinartists.net/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py:473: SAWarning: Unicode type received non-unicode bind param value.
Traceback (most recent call last):
  File "./bin/gmg", line 8, in <module>
    load_entry_point('mediagoblin==0.3.0.dev', 'console_scripts', 'gmg')()
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/gmg_commands/__init__.py", line 100, in main_cli
    args.func(args)
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/gmg_commands/dbupdate.py", line 93, in dbupdate
    run_dbupdate(app_config)
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/gmg_commands/dbupdate.py", line 88, in run_dbupdate
    migration_manager.init_or_migrate()
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/db/sql/util.py", line 196, in init_or_migrate
    migration_number = self.database_current_migration
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/db/sql/util.py", line 104, in database_current_migration
    if self.migration_data is None:
  File "/srv/http/goblinartists.net/mediagoblin/mediagoblin/db/sql/util.py", line 80, in migration_data
    self.migration_model).filter_by(name=self.name).first()
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2107, in first
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2001, in __getitem__
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2176, in __iter__
  File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1450, in execute
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1697, in _execute_context
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
  File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py", line 335, in do_execute
sqlalchemy.exc.ProgrammingError: (ProgrammingError) permission denied for relation core__migrations
 'SELECT core__migrations.name AS core__migrations_name, core__migrations.version AS core__migrations_version \nFROM core__migrations \nWHERE core__migrations.name = %(name_1)s \n LIMIT %(param_1)s' {'name_1': '__main__', 'param_1': 1}
[shackra@abrilhost mediagoblin]$

this could be a bug?

[Jorge Araya Navarro]

more info about the database

mediagoblin-# \du
                               List of roles
   Role name   |                   Attributes                   | Member of 
---------------+------------------------------------------------+-----------
 goblinartists |                                                | {}
 mediagoblin   |                                                | {}
 postgres      | Superuser, Create role, Create DB, Replication | {}

mediagoblin-# \dt
                 List of relations
 Schema |          Name          | Type  |  Owner   
--------+------------------------+-------+----------
 public | ascii__mediadata       | table | postgres
 public | core__attachment_files | table | postgres
 public | core__file_keynames    | table | postgres
 public | core__media_comments   | table | postgres
 public | core__media_entries    | table | postgres
 public | core__media_tags       | table | postgres
 public | core__mediafiles       | table | postgres
 public | core__migrations       | table | postgres
 public | core__tags             | table | postgres
 public | core__users            | table | postgres
 public | image__mediadata       | table | postgres
 public | video__mediadata       | table | postgres
(12 rows)

mediagoblin-#

[Jorge Araya Navarro]

just be careful and create everything (database and schemas) under the same user which is going to run the MediaGoblin instance