Bug 48476 - Admin Diary: UMC Module
Admin Diary: UMC Module
Status: CLOSED FIXED
Product: UCS
Classification: Unclassified
Component: Admin Diary
UCS 4.4
Other Linux
: P5 normal (vote)
: UCS 4.4
Assigned To: Dirk Wiesenthal
Johannes Keiser
: interim-1
Depends on: 48341 48631
Blocks: 48933 48934 48972
  Show dependency treegraph
 
Reported: 2019-01-15 17:25 CET by Dirk Wiesenthal
Modified: 2019-03-12 15:21 CET (History)
2 users (show)

See Also:
What kind of report is it?: Development Internal
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number: 2019020621000509, 2019020621000492, 2019020621000518
Bug group (optional):
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dirk Wiesenthal univentionstaff 2019-01-15 17:25:21 CET
We need a UMC module as a graphical frontend for the Admin Diary Backend
Comment 1 Florian Best univentionstaff 2019-02-06 12:34:27 CET
Error handling should be fixed:
You can look it up in I guess the pkgdb module, which already handles postgresql errors, iirc.



Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/base.py", line 253, in execute
    function.__func__(self, request, *args, **kwargs)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 318, in _response
    result = _multi_response(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 192, in _response
    return function(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 440, in _response
    return list(function(self, iterator, *nones))
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 286, in _fake_func
    yield function(self, *args)
  File "%PY2.7%/univention/management/console/modules/admindiary/__init__.py", line 69, in options
    return options()
  File "%PY2.7%/univention/admindiary/backend.py", line 173, in _postgresql_options
    with cursor(psycopg2) as cur:
  File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
    return self.gen.next()
  File "%PY2.7%/univention/admindiary/backend.py", line 62, in cursor
    with connection(module) as conn:
  File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
    return self.gen.next()
  File "%PY2.7%/univention/admindiary/backend.py", line 54, in connection
    conn = module.connect(dbname='admindiary', user='admindiary', host=dbhost, password=password)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: konnte nicht mit dem Server verbinden: Verbindungsaufbau abgelehnt
	Läuft der Server auf dem Host »localhost« (::1) und akzeptiert er
	TCP/IP-Verbindungen auf Port 5432?
konnte nicht mit dem Server verbinden: Verbindungsaufbau abgelehnt
	Läuft der Server auf dem Host »localhost« (127.0.0.1) und akzeptiert er
	TCP/IP-Verbindungen auf Port 5432?


Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/base.py", line 253, in execute
    function.__func__(self, request, *args, **kwargs)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 318, in _response
    result = _multi_response(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 192, in _response
    return function(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 440, in _response
    return list(function(self, iterator, *nones))
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 286, in _fake_func
    yield function(self, *args)
  File "%PY2.7%/univention/management/console/modules/admindiary/__init__.py", line 69, in options
    return options()
  File "%PY2.7%/univention/admindiary/backend.py", line 173, in _postgresql_options
    with cursor(psycopg2) as cur:
  File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
    return self.gen.next()
  File "%PY2.7%/univention/admindiary/backend.py", line 62, in cursor
    with connection(module) as conn:
  File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
    return self.gen.next()
  File "%PY2.7%/univention/admindiary/backend.py", line 54, in connection
    conn = module.connect(dbname='admindiary', user='admindiary', host=dbhost, password=password)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: FATAL:  Passwort-Authentifizierung für Benutzer »admindiary« fehlgeschlagen
FATAL:  Passwort-Authentifizierung für Benutzer »admindiary« fehlgeschlagen



Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/base.py", line 253, in execute
    function.__func__(self, request, *args, **kwargs)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 318, in _response
    result = _multi_response(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 192, in _response
    return function(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 440, in _response
    return list(function(self, iterator, *nones))
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 286, in _fake_func
    yield function(self, *args)
  File "%PY2.7%/univention/management/console/modules/admindiary/__init__.py", line 69, in options
    return options()
  File "%PY2.7%/univention/admindiary/backend.py", line 174, in _postgresql_options
    cur.execute("SELECT DISTINCT UNNEST(tags) FROM entries")
ProgrammingError: FEHLER:  Relation »entries« existiert nicht
ZEILE 1: SELECT DISTINCT UNNEST(tags) FROM entries
                                           ^
Comment 2 Dirk Wiesenthal univentionstaff 2019-02-12 13:37:41 CET
The UMC module is implemented in
  univention-admin-diary 1.0.0-15A~4.4.0.201902121332

To install:
  univention-install univention-admin-diary-*
  univention-admin-diary-entry-create --event USER_CREATED --arg "john.doe"
Comment 3 Dirk Wiesenthal univentionstaff 2019-02-14 23:34:03 CET
(In reply to Dirk Wiesenthal from comment #2)
> To install:
>   univention-install univention-admin-diary-*
>   univention-admin-diary-entry-create --event USER_CREATED --arg "john.doe"

Since a few moments:
  univention-admin-diary-entry-create --event USER_CREATED --arg "username=john.doe"
Comment 4 Johannes Keiser univentionstaff 2019-03-04 09:05:25 CET
OK: Installation
~OK: SearchPage (Data, message, Event, Source, Author)
     -substring search does not work for the target of diary entries
OK: comments
OK: detailpage
Comment 5 Florian Best univentionstaff 2019-03-11 14:35:30 CET
There is no changelog entry in changelog-4.4-0.xml.
Comment 6 Dirk Wiesenthal univentionstaff 2019-03-11 14:51:43 CET
Added
Comment 7 Florian Best univentionstaff 2019-03-12 13:40:31 CET
UCS 4.4 has been released:
 https://docs.software-univention.de/release-notes-4.4-0-en.html
 https://docs.software-univention.de/release-notes-4.4-0-de.html

If this error occurs again, please use "Clone This Bug".