Cannot start Invoiceninja - MySQL connection refused

[flyguy729]

Hello. After installing InvoiceNinja, the docker does not start. So i changed the UnraidIP:port manually because it doesnt start, to my physical unraid IP for the DB and App_URL and then it starts. However, webui doesnt work. LOG has this sql error connection refused.

How do i solve this? Thank you!

text error warn system array login

2024-06-27T16:53:25Z [INFO] [Entrypoint]: Initialising Invoice Ninja...

INFO Configuration cached successfully.

INFO Caching framework bootstrap, configuration, and metadata.

config ........................................................ 46.07ms DONE events ......................................................... 1.96ms DONE routes ........................................................ 98.90ms DONE views .............................................................. 1s DONE

INFO Discovering packages.

imdhemy/laravel-purchases ............................................. DONE intervention/image .................................................... DONE invoiceninja/inspector ................................................ DONE laravel/slack-notification-channel .................................... DONE laravel/socialite ..................................................... DONE laravel/tinker ........................................................ DONE laravel/ui ............................................................ DONE livewire/livewire ..................................................... DONE nesbot/carbon ......................................................... DONE nunomaduro/termwind ................................................... DONE nwidart/laravel-modules ............................................... DONE sentry/sentry-laravel ................................................. DONE socialiteproviders/manager ............................................ DONE turbo124/beacon ....................................................... DONE

In Connection.php line 813:

SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select t
able_name as name, (data_length + index_length) as size, table_comment
as comment, engine as engine, table_collation as collation from infor
mation_schema.tables where table_schema = 'ninja' and table_type in ('BASE
TABLE', 'SYSTEM VERSIONED') order by table_name)

In Connector.php line 65:

SQLSTATE[HY000] [2002] Connection refused

I've enable this in Docker settings as well but still connection refused :

Host access to custom networks:

[kiwimato]

@flyguy729 this container does not have MySQL built in, you have to point it to another container where MySQL runs and provide the IP, port & credentials. Did you already do that?