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.

  • GolemancerVekk@alien.topBEnglish
    1·
    1 year ago

    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@alien.topOPBEnglish
      1·
      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.