add a Mojo DBViewer app, useful for development

RotherOSS / otobo

OTOBO is one of the most flexible web-based ticketing systems used for Customer Service, Help Desk, IT Service Management. https://otobo.io/

GNU General Public License v3.0

251 stars 72 forks source link

add a Mojo DBViewer app, useful for development #55

Closed bschmalhofer closed 4 years ago

bschmalhofer commented 4 years ago

For development it would be nice to have a little viewer of the database, e.g. Mojolicious::Plugin::DBViewer. This could be added to otobo.psgi or run in a separate container.

See https://stefanorodighiero.net/writings/perl/composing-multiple-mojolicious-apps-with-plack.html and https://metacpan.org/pod/Mojolicious::Plugin::DBViewer

bschmalhofer commented 4 years ago

TODO: limit access to admins

bschmalhofer commented 4 years ago

localhost:5000/otobo/dbviewer/dbviewer/ seems to be working in the Docker use case. Authorisation is checked via the OTOBO session. The logged in user must be in the group 'admin'. There is no redirect to a login page when access is denied. That is not an essential feature.