Docker on TrueNAS Scale

Would anyone know how to launch InvoiceNinja on TrueNAS Scale as a docker? or even another way?
I’ve been trying but always get a database connection error regardless of what I try.
I have another MySQL docker installed also, and can’t get invoice ninja to connect to it

Hi,

Are you seeing a specific error?

yes, hers is the log output:

2022-02-18 05:09:07.692509+00:002022-02-18T05:09:07Z [INFO] [Entrypoint]: Initialising Invoice Ninja…
2022-02-18 05:09:07.848223+00:00Configuration cache cleared!
2022-02-18 05:09:07.859185+00:00Configuration cached successfully!
2022-02-18 05:09:07.990572+00:00Configuration cache cleared!
2022-02-18 05:09:08.004810+00:00Configuration cached successfully!
2022-02-18 05:09:08.005024+00:00Route cache cleared!
2022-02-18 05:09:08.032220+00:00Routes cached successfully!
2022-02-18 05:09:08.032242+00:00Files cached successfully!
2022-02-18 05:09:08.368842+00:002022-02-18T05:09:08.368842941Z
2022-02-18 05:09:08.371186+00:00In Connection.php line 712:
2022-02-18 05:09:08.371206+00:002022-02-18T05:09:08.371206377Z
2022-02-18 05:09:08.371215+00:00SQLSTATE[HY000] [2002] Address not available (SQL: select * from informatio
2022-02-18 05:09:08.371218+00:00n_schema.tables where table_schema = ninja and table_name = accounts and ta
2022-02-18 05:09:08.371222+00:00ble_type = ‘BASE TABLE’)
2022-02-18 05:09:08.371226+00:002022-02-18T05:09:08.371226987Z
2022-02-18 05:09:08.371229+00:002022-02-18T05:09:08.371229997Z
2022-02-18 05:09:08.371241+00:00In Connector.php line 70:
2022-02-18 05:09:08.371251+00:002022-02-18T05:09:08.371251777Z
2022-02-18 05:09:08.371263+00:00SQLSTATE[HY000] [2002] Address not available
2022-02-18 05:09:08.371270+00:002022-02-18T05:09:08.371270677Z
2022-02-18 05:09:08.371273+00:002022-02-18T05:09:08.371273167Z
2022-02-18 05:09:08.376214+00:002022-02-18T05:09:08Z [ERROR] [Entrypoint]: Error connecting to DB

@david any thoughts on the error?

Yes looks like a DB connection issue, i’m not that familiar however with this configuration.

I’m trying to launch invoice ninja as a docker on truenas scale.
Been trying to figure out how to set it up. but can’t really find the info for it.
Would you know how to run it as a docker on truenas scale?

This is hosted with Docker on TrueNAS Scale
I got the DB to connect and got it to load. However, the logs show that its running and ready. but when I type in the IP address nothing loads.

@netspeario

It sounds like you may need to reach your installation on a different port? You should see the ports that are configured in the docker configuration for your web server.

What EV would I use to set the port?

I’m not sure how TrueNAS handles any of this, but the symptoms you are describing indicate that the webserver port is not open for invoice ninja.