invoiceninja / dockerfiles

Docker files for Invoice Ninja
https://hub.docker.com/r/invoiceninja/invoiceninja
GNU General Public License v2.0
418 stars 268 forks source link

Connect to database (v5)? #623

Closed pixelwave closed 1 month ago

pixelwave commented 1 month ago

Setup information Docker (Proxmox LXC Container, Debian 12.7), following the official v5 install guide.

Describe the bug I did a fresh install of InvoiceNinja (v5) Docker on my Proxmox LXC container. Everything works so far. Now I wanted to connect with phpMyAdmin (also running in the same docker as the invoice ninja in the same LXC container) and tried to connect with the default credentials.

To reproduce Credentials I tried:

Server: localhost and ip Username: root (PW: ninjaAdm1nPassword) as well as ninja (PW: ninja)

… but always get the Connection refused.

Screenshots/logs bec9dc7748f1bbd0e08def2f5988ca51a257b744

Is the database access locked somehow by default? Do I need to change something specific? I used the default env variables and changed basically nothing …

pixelwave commented 1 month ago

Could the problem be that by default the mysql database is configured as client / socket?

Output of etc/mysql/my.cnf

Screenshot 2024-10-21 at 07 47 57
pixelwave commented 1 month ago

Ok after a lot of trial and error I figured the following login credentials do work (for phpmyadmin):

server: db user: ninja pass: ninja