this post was submitted on 09 Nov 2023
1 points (100.0% liked)

Self-Hosted Main

515 readers
1 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

For Example

We welcome posts that include suggestions for good self-hosted alternatives to popular online services, how they are better, or how they give back control of your data. Also include hints and tips for less technical readers.

Useful Lists

founded 1 year ago
MODERATORS
communick@selfhosted.forum
1
MariaDB + pgAdmin? (alien.top)
submitted 1 year ago by notdoreen@alien.top to c/main@selfhosted.forum
8 comments fedilink hide all child comments
 

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.

top 8 comments
sorted by: hot top controversial new old
[–] skbo@lu.skbo.net 2 points 1 year ago

So, to be clear, you are trying to use a PostgreSQL administration tool to access a MariaDB server, and you’re asking why it’s not working?

[–] GolemancerVekk@alien.top 1 points 1 year ago (2 children)

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.

[–] tschloss@alien.top 2 points 1 year ago

The „pg“ in pgAdmin has a meaning?

[–] notdoreen@alien.top 1 points 1 year ago

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@alien.top 1 points 1 year ago

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
[–] ElevenNotes@alien.top 1 points 1 year ago (1 children)

Here, the last DB GUI you'll ever need: DBeaver

[–] notdoreen@alien.top 1 points 1 year ago (1 children)

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.

[–] ElevenNotes@alien.top 1 points 1 year ago

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.