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.

  • notdoreen@alien.topOPB
    link
    fedilink
    English
    arrow-up
    1
    ·
    8 months ago

    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.topB
      link
      fedilink
      English
      arrow-up
      1
      ·
      8 months 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.