koji

#2100 permission denied for relation user_krb_principals
Closed: Invalid by ignatenkobrain. Opened by ignatenkobrain.

Closed: Invalid
Reopen Issue 
Mar 24 18:19:04 koji kojira[3127]: xmlrpclib.Fault: <Fault 1: 'Traceback (most recent call last):\n  File "/usr/share/koji-hub/kojixmlrpc.py", line 236, in _wrap_handler\n    response = handler(environ)\n  File "/usr/share/koji-hub/kojixmlrpc.py", line 279, in handle_rpc\n    return self._dispatch(method, params)\n  File "/usr/share/koji-hub/kojixmlrpc.py", line 316, in _dispatch\n    ret = koji.util.call_with_argcheck(func, params, opts)\n  File "/usr/lib/python2.7/site-packages/koji/util.py", line 263, in call_with_argcheck\n    return func(*args, **kwargs)\n  File "/usr/lib/python2.7/site-packages/koji/auth.py", line 825, in krbLogin\n    return context.session.krbLogin(*args, **opts)\n  File "/usr/lib/python2.7/site-packages/koji/auth.py", line 347, in krbLogin\n    user_id = self.getUserIdFromKerberos(login_principal)\n  File "/usr/lib/python2.7/site-packages/koji/auth.py", line 644, in getUserIdFromKerberos\n    c.execute(q, locals())\n  File "/usr/lib/python2.7/site-packages/koji/db.py", line 139, in execute\n    ret = self.cursor.execute(operation, parameters)\nProgrammingError: permission denied for relation user_krb_principals\n\n'>

I have been running 1.18.1 and upgraded to 1.20.1 and ran migrations 1.18→1.19 and 1.19→1.20 and now I get this error.

Best guess: you ran the migration script as the wrong user and the new tables it added are owned by a different user than the hub is accessing as.

Metadata Update from @mikem:
- Custom field Size adjusted to None

More readable traceback:

Traceback (most recent call last):
  File "/usr/share/koji-hub/kojixmlrpc.py", line 236, in _wrap_handler
    response = handler(environ)
  File "/usr/share/koji-hub/kojixmlrpc.py", line 279, in handle_rpc
    return self._dispatch(method, params)
  File "/usr/share/koji-hub/kojixmlrpc.py", line 316, in _dispatch
    ret = koji.util.call_with_argcheck(func, params, opts)
  File "/usr/lib/python2.7/site-packages/koji/util.py", line 263, in call_with_argcheck
    return func(*args, **kwargs)
  File "/usr/lib/python2.7/site-packages/koji/auth.py", line 825, in krbLogin
    return context.session.krbLogin(*args, **opts)
  File "/usr/lib/python2.7/site-packages/koji/auth.py", line 347, in krbLogin
    user_id = self.getUserIdFromKerberos(login_principal)
  File "/usr/lib/python2.7/site-packages/koji/auth.py", line 644, in getUserIdFromKerberos
    c.execute(q, locals())
  File "/usr/lib/python2.7/site-packages/koji/db.py", line 139, in execute
    ret = self.cursor.execute(operation, parameters)
ProgrammingError: permission denied for relation user_krb_principals

Oh, this is quite possible.. Any idea how to recover from this state?

Indeed, my fault.

Metadata Update from @ignatenkobrain:
- Issue close_status updated to: Invalid
- Issue status updated to: Closed (was: Open)

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/2100

Please continue any further discussion there.
Metadata
None
None
None
None
Low
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.