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

Self-Hosted Main

21 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.

you are viewing a single comment's thread
view the rest of the comments
[–] 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.