search

credativ / elephant-shed

PostgreSQL Management Appliance
https://elephant-shed.io
GNU General Public License v3.0
211 stars 18 forks source link

Installation-Docs are broken. Not working on Ubuntu or Centos... #23

Closed R3ITOSv87 closed 3 years ago

R3ITOSv87 commented 3 years ago

I would like to inform you that the installation instructions for Elephant-shed on Ubuntu and Centos do not work.

We have now tried seven times with Ubuntu 20.04 and three times with 18.04. Without success. The installation of Ubuntu was fresh each time and it followed their guide 1:1.

Grafana has no dashboard when invoked. Also, OmniDB sometimes doesn't work at all, sometimes it doesn't accept the password .

Are these errors known? Is there possibly a work-around?

On Centos we can not even load the repository. Credativ is not responding for E-Mails.

yum install https://packages.credativ.com/public/postgresql/yum/credativ-repo.rpm Elephant Shed for Red Hat/CentOS 8 - x86_64 3.4 kB/s | 268 B 00:00 Errors during downloading metadata for repository 'credativ-arch':

R3ITOSv87 commented 3 years ago

Debian 9:

credativ Sorry, a 404 error occurred while loading https://10.100.110.162/omnidb/. Entschuldigung, beim Zugriff auf https://10.100.110.162/omnidb/ trat ein 404-Fehler auf. Elephant Shed -- report bugs on GitHub

And again: No Dashboard in Grafana.

Everything seems to be wrong with this Elephant-Shed

heralight commented 3 years ago

About Omnidb problem a fix that work on ubuntu 20.04:

Hello credativ Team. I am facing the same issue as mentioned above. I have a clean install on ubuntu 20.04 and i cannot login to OmniDB. I'm trying to login with user admin and password admin but it says that the username or password is invalid. I did the following to make it work:

touch $HOME/.omnidb/omnidb-server/config.py
omnidb-server -C $HOME/.omnidb/omnidb-server/config.py -r
sudo systemctl restart omnidb-server.service

Originally posted by @strapsi in https://github.com/credativ/elephant-shed/issues/21#issuecomment-838351993

heralight commented 3 years ago

And for Grafana, the dashboard is under Dasboards->Manage->PostgreSQL Server Overview

R3ITOSv87 commented 3 years ago

I found the Grafana Dashboard. Thank you for mentioning. But the Dashboard shows no Data.

All Exporters in Prometheus are running after apt upgrade and a reboot.

admin/admin on OmniDB is still a problem.

mbanck commented 3 years ago

Debian 9:

credativ Sorry, a 404 error occurred while loading https://10.100.110.162/omnidb/. Entschuldigung, beim Zugriff auf https://10.100.110.162/omnidb/ trat ein 404-Fehler auf. Elephant Shed -- report bugs on GitHub

I'm afraid omnidb is not supported on stretch, there are no stretch packages for OmniDB we are ware of.

mbanck commented 3 years ago

I found the Grafana Dashboard. Thank you for mentioning. But the Dashboard shows no Data.

All Exporters in Prometheus are running after apt upgrade and a reboot.

I tried it on Debian 10/buster, and here the dashboard (once found) is working fine and is populated by data.

I will try again on Ubuntu once I find time.

admin/admin on OmniDB is still a problem.

What exactly is the problem? Do you get an OmniDB login screen and did you execute the workaround mentioned in the third comment?

df7cb commented 3 years ago

The dashboard needs input from prometheus-sql-exporter, so if it doesn't work, try restarting prometheus-sql-exporter.service, waiting a bit, and reload the grafana page. I just fixed some issues around booting that should be resolved in the upcoming 1.3.5 release.