MariaDB + pgAdmin?
reddit / selfhosted

----------------------------------------------------------------------
notdoreen · 2023-11-09 05:27

I have a couple dbs as Docker containers on my homelab and used
accross multiple applications and the main ones are PostgreSQL and
MariaDB.

I spun up a pgAdmin container in order to vizualize my dbs. PostgreSQL
worked like a breeze but for some reason MariaDB cannot be added to
pgAdmin no matter what I try. I keep getting an error saying `"Unable
to connect to server: connection to server at "IP', port 3306 failed:
received invalid response to SSL negotiation: q`

Neither container has SSL certs associated with them, and I even
removed the SSL parameter from the pgAdmin configuration.

I have been able to add this MAriaDB container to a bunch of other
aplications (nextcloud, paperless, bookstack, etc.) with no issues so
I'm not sure what the problem is with pgAdmin.

Any help would be appreciated.

----------------------------------------------------------------------
ElevenNotes · 2023-11-09 05:35

Here, the last DB GUI you'll ever need: [DBeaver](https://dbeaver.io)

----------------------------------------------------------------------
GolemancerVekk · 2023-11-09 11:20

pgAdmin only works with Postgres, that's why it refuses to connect to
MariaDB. The equivalent for Maria and MySQL is phpMyAdmin. But I also
suggest using a tool that can handle multiple types of databases, like
DBeaver, dbForge, dbSchema, Navicat, HeidiSQL etc.

----------------------------------------------------------------------
notdoreen · 2023-11-09 15:38

Thank you so much!
I asked ChatGPT if pgAdmin was meant to work with MariaDB and it kept
saying "yes. It should work" and giving me useless instructions. I
thought I was the one doing something wrong.

----------------------------------------------------------------------
thekrautboy · 2023-11-09 16:16

So maybe today you learned something about how you shouldnt ask AI
such things :)

----------------------------------------------------------------------
thekrautboy · 2023-11-09 16:18

Cloudbeaver:

    version: "3.3"

    services:
      cloudbeaver:
        container_name: cloudbeaver
        image: dbeaver/cloudbeaver:23.2.0
        restart: unless-stopped
        ports:
          - 8978:8978
        environment:
          - TZ=Europe/Berlin
          - CB_SERVER_URL=http://192.168.20.50:8978
          - CB_SERVER_NAME=Cloudbeaver
        volumes:
          - ./data:/opt/cloudbeaver/workspace
        healthcheck:
          test: "wget --no-verbose --tries=1 --spider --no-check-
certificate http://localhost:8978 || exit 1"
          start_period: 60s

----------------------------------------------------------------------
tschloss · 2023-11-09 17:16

The „pg“ in pgAdmin has a meaning?

----------------------------------------------------------------------
notdoreen · 2023-11-09 19:38

I just tried this but there doesn't seem to be a web interface to it.
I was hoping I could use it accross my network on different devices.

----------------------------------------------------------------------
notdoreen · 2023-11-09 19:38

Thank you!

----------------------------------------------------------------------
ElevenNotes · 2023-11-10 06:08

Any reason why it needs a web interface? There are multiple solutions
to work with applications from anywhere, probably the best and easiest
is VDI.

----------------------------------------------------------------------
onedr0p · 2023-11-10 23:44

Chatgpt does nothing more but makes confident guesses at what you're
asking it.