Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

add a Mojo DBViewer app, useful for development #55

Closed
bschmalhofer opened this issue May 29, 2020 · 2 comments
Closed

add a Mojo DBViewer app, useful for development #55

bschmalhofer opened this issue May 29, 2020 · 2 comments
Milestone
OTOBO 10.0.1

Comments

@bschmalhofer
Copy link
Contributor

bschmalhofer commented May 29, 2020 •
edited
Loading

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 added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: add CPAN modules for Mojolicous
27efef6
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: added stub for the dbviewer app.
a1a8e27 
Generated with: mojo generate lite_app dbviewer.pl
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: get rid of hardcoded /opt/otobo
7732df5 
Just like in bin/cgi-bin/index.pl
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: Add PDO. Load the Kernel::Config.
f62a9f0 
Also remove the not needed stuff in __DATA__.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: actually read the database setting from the config
6e4a44c
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: add the DBViewer plugin.
6fd6613 
Ignore exceptions from plugin, e.g. when the connect is not possible.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: a neater message when the connect fails
1e6e39d
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: Do the admin check in own middleward
f4f142d 
As Plack::Middleware::Auth::Basic asked for a password.
Also fix a broken string terminator: ' => "
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: rewrite PATH_INFO
bf93b23
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 30, 2020
@bschmalhofer
Issue RotherOSS#55: added a TODO comment
3682618 
no check yet whether the user is an admin
@bschmalhofer
Copy link
Contributor Author

TODO: limit access to admins

@bschmalhofer bschmalhofer changed the title Docker: for development add a little DBViewer app add a Mojo DBViewer app, useful for development May 30, 2020
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 31, 2020
@bschmalhofer
Issue RotherOSS#55: remove the unused variable $BrowserHasCookie
f7fe76a
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 31, 2020
@bschmalhofer
Issur RotherOSS#55: specify charset=utf-8 for the /hello route
42c5078 
The globe wasn't displayed correctly in Firefox
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 31, 2020
@bschmalhofer
Issue RotherOSS#55: tentatively add code that checks permissions
c5a14f1 
Won't work because the cookie is in a different path.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 31, 2020
@bschmalhofer
Issue RotherOSS#55: mount dbviewer below /otobo
5995aae 
Because the cookie has the path /otobo
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: set the environment vars REMOTE_ADDR and HTTP_USE…
d9411d6 
…R_AGENT.

As they are used in the AuthSesssion modules
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: Fix PATH_INFO.
c70987f 
The DBViewer is now at /otobo/dbviewer instead of /dbviewer.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: avoid warning about missing var/stats
71cae50
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: avoid the warning about using the default secret
8b36339 
Avoiding the warning is OK, as secrets are not used in dbviewer.
Add the config file dbviewer.conf that only contains a dummy secret.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: avoid a warning when $UID is not set
612376b
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: otobo.psgi is watched implicitly
d28d24c
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: tentatively add a 'join' declaration
f7ca3dc 
Not really helpful as the joined data is not displayed.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: avoid a warning from lc
6c28d69 
lc has apparently higher priority than ||
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 2, 2020
@bschmalhofer
Issue RotherOSS#55: missunderstood the logic of -z
4be3486
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue Jun 3, 2020
@bschmalhofer
Issue RotherOSS#55: add a redirect to the login page when access denied
ece7871 
Does not work yet, as the RequesteURL only supports the query string.
No redirects outside of index.pl are supported.
svenoe added a commit that referenced this issue Jun 3, 2020
@svenoe
Merge pull request #66 from bschmalhofer/issue-55-dbviewer_take_3
2c7771f 
Issue #55: add a redirect to the login page when access denied
@bschmalhofer
Copy link
Contributor Author

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.

@bschmalhofer bschmalhofer added this to the OTOBO 10.0 milestone Jul 22, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
OTOBO 10.0.1
Development

No branches or pull requests
1 participant
@bschmalhofer