4:00 Git Clone into current directory, you can just add " . " to the end of the statement as a reference to the current folder/directory, otherwise it will create a folder with the same name as the repo'. Note: Only if the current folder is empty, otherwise it will error. Alternatively: after "mkdir ninja", you could have cloned to that empty folder by just adding " ninja" to the end of the clone statement directing it to clone to that empty folder instead of the default behaviour.
Hi, I have the problem that I cannot choose German or English language and the right currencies after first logging in to invoiceninja. I just get the arabic, bulgarian and stuff like that. Does anyone has the same problem? Thanks a lot :)
It sounds like the cache may be incomplete, you can refresh it by loading /update?secret=[secret from .env file], Note: this problem should be resolved in the latest version of the app.
18:20 Looking over the GitHub page it shows: To ensure folder permissions are correct when the container comes up for the first time it is important that you set the correct folder permissions on the docker folder. From the terminal run chmod 755 docker/app/public sudo chown -R 1500:1500 docker/app the second command is what is missing as you do not want to run the app folder/container as root. I came across a caching bug advises to run /update?secret=secret to reset the caching issue
Email Sending - Struggled for a long time with email not sending out. MAIL_MAILER=log must be changed to MAIL_MAILER=smtp , otherwise NO email will be send out , but just logged. 😆, No Idea why anyone would want to keep it at "log" as no invoices will be sent to clients...
Great video, thanks for the time and effort you have put into making it. I'm trying to install on a synology NAS but after following all of the steps and running docker-compose up -d it cannot start the service db. It looks like the prerequisites for running invoice ninja are mysql:8 and nginx. Are these installed as part of the docker-compose up -d command or should they be installed prior to running? Both of the above show in docker under Image but not as containers. Any help appreciated. Thanks
I managed to figure this out and got things working. It turns out there are two folders missing from the git clone. Inside the docker folder there should be a folder called mysql and within this a folder called data. Initially these are just empty folders which are populated when the database is created so they can just be created manually. As mentioned in the video, viewing the portainer logs for each of the 3 containers, after they have been created is important. This shows if the database has created properly, it's linking with the app and that the server is running correcty. Also please note that after creating the containers it took about 20mins before I could access the web interface. I noticed on the app portainer log it took some time to create the tables etc. Hope this helps anyone having the same problem.
Hey. If you self host Invoice ninja, can you then use the apps on Mac or IOS normally as you would with the paid service? Do you know if this way it is fully free or is there a subscription for anything? Have a great day!
I was working for 3 hours before coming across this video, then I watched the video and tried to follow it as best I can. After 4 and a half hours, I still have no running application that I can access. Can't get to webpage, can't even get to the application at all. Docker container states it's running, yet I have no idea how to access it, and it doesn't appear to be working. I can't stand Docker, this is my experience every time I try, I've been through trainings, videos, still can't seem to get containers running. The only thing I was able to get working was a Plex container and a Dockge container. Everything else fails, just like this. Would love to try this application out, would love to be able to use this for invoicing, but I can't even get the thing running.
11:26 I paused and enter this comment. proxmox backup is mentioned. please make a video about how to tweak and use proxmox backup method too. now back to video.
I had a similar thing happen, but I don't like to suggest 777 as it causes people to poop their pants lol. It's why I said that people would have to try some things for themselves to see what works :)
Looking over the GitHub page it shows: To ensure folder permissions are correct when the container comes up for the first time it is important that you set the correct folder permissions on the docker folder. From the terminal run chmod 755 docker/app/public sudo chown -R 1500:1500 docker/app the second command is what is missing as you do not want to run the app folder/container as root. I came across a caching bug advises to run /update?secret=secret to reset the caching issue
I tried many times and kept getting this error from the apps In Connector.php line 70: SQLSTATE[HY000] [2002] Connection refused 2022-11-18T00:34:10Z [ERROR] [Entrypoint]: Error connecting to DB 2022-11-18T00:34:28Z [INFO] [Entrypoint]: Initialising Invoice Ninja... INFO Configuration cached successfully. INFO Caching the framework bootstrap files. config .......................................................... 143ms DONE routes .......................................................... 335ms DONE In Connection.php line 760: SQLSTATE[HY000] [1044] Access denied for user 'ninja'@'%' to database 'ninj a' (SQL: select * from information_schema.tables where table_schema = ninja and table_name = accounts and table_type = 'BASE TABLE') In Connector.php line 70: SQLSTATE[HY000] [1044] Access denied for user 'ninja'@'%' to database 'ninj a' 2022-11-18T00:34:40Z [ERROR] [Entrypoint]: Error connecting to DB 2022-11-18T00:34:56Z [INFO] [Entrypoint]: Initialising Invoice Ninja... INFO Configuration cached successfully.
There's a problem with your user connecting to the database. If you're using a password with a special character in it, you'll want to wrap the password in quotes, though I don't recall immediately if it's a single or doubl quote. So I would try that. Or just try a password with no special characters and see if that gets you going.
@@DBTechYT Aloysius Chan No change to the DB password as stated in the env file. I also added the PUID and PGID as recommended but it still doesnt work for me.
I've been waiting for an updated video on this. Thank you!
I've been waiting for my brain to work well enough to make this video! 🤪🤪
Goof how to and thankyou for putting it up. Just one thing, every tutorial should include a list of the ALL the pre req's/
4:00 Git Clone into current directory, you can just add " . " to the end of the statement as a reference to the current folder/directory, otherwise it will create a folder with the same name as the repo'.
Note: Only if the current folder is empty, otherwise it will error.
Alternatively: after "mkdir ninja", you could have cloned to that empty folder by just adding " ninja" to the end of the clone statement directing it to clone to that empty folder instead of the default behaviour.
What is extra_hosts used for?
Hi, I have the problem that I cannot choose German or English language and the right currencies after first logging in to invoiceninja. I just get the arabic, bulgarian and stuff like that. Does anyone has the same problem? Thanks a lot :)
It sounds like the cache may be incomplete, you can refresh it by loading /update?secret=[secret from .env file], Note: this problem should be resolved in the latest version of the app.
18:20 Looking over the GitHub page it shows: To ensure folder permissions are correct when the container comes up for the first time it is important that you set the correct folder permissions on the docker folder.
From the terminal run
chmod 755 docker/app/public
sudo chown -R 1500:1500 docker/app
the second command is what is missing as you do not want to run the app folder/container as root.
I came across a caching bug advises to run /update?secret=secret to reset the caching issue
Thanks for this, I'm hoping you can do an updated one for the official akaunting image
Thanks for watching!! I'll add Akaunting to my todo list!
Email Sending - Struggled for a long time with email not sending out. MAIL_MAILER=log must be changed to MAIL_MAILER=smtp , otherwise NO email will be send out , but just logged. 😆, No Idea why anyone would want to keep it at "log" as no invoices will be sent to clients...
Have you actually tried to use Cloudflare tunnels, in order not to open up ports at home?
I've been using Cloudflare tunnels exclusively for 2 years
Thank you 😊
Are you able to run this without the built in nginx?
This gets it running but many of the buttons in the UI don't work. Did you actually log in and create invoices/quotes? I can't create any.
I would submit an issue on their GitHub
Anyone know why im getting a 500 - Server error? i followed this to the t
There should be more details about the error in storage/logs or the web server error logs
Thnx a lot Davod! I was struggling this week with the older setup.
Is it possible to do this setup in a stack?
You could if you wanted to figure out how to put all of the contents of the ENV file into the stack
@@DBTechYT I'am gonna take some time 🙂
Great video, thanks for the time and effort you have put into making it.
I'm trying to install on a synology NAS but after following all of the steps and running docker-compose up -d it cannot start the service db.
It looks like the prerequisites for running invoice ninja are mysql:8 and nginx. Are these installed as part of the docker-compose up -d command or should they be installed prior to running?
Both of the above show in docker under Image but not as containers.
Any help appreciated. Thanks
I managed to figure this out and got things working.
It turns out there are two folders missing from the git clone. Inside the docker folder there should be a folder called mysql and within this a folder called data. Initially these are just empty folders which are populated when the database is created so they can just be created manually.
As mentioned in the video, viewing the portainer logs for each of the 3 containers, after they have been created is important. This shows if the database has created properly, it's linking with the app and that the server is running correcty.
Also please note that after creating the containers it took about 20mins before I could access the web interface. I noticed on the app portainer log it took some time to create the tables etc.
Hope this helps anyone having the same problem.
For some reason it's not letting me generate an app key, and it's driving me slightly nuts. I should stick to cars, lol.
Are you seeing a specific error? If it's a permissions issue it may help to run the artisan command using sudo.
I am using Docker on my Synology. Should I install like this video outlines or use the Synology Gui?
The Synology GUI is only going to get you so far. The CLI method shown in this video will be easier
@@DBTechYT TQ
Hey. If you self host Invoice ninja, can you then use the apps on Mac or IOS normally as you would with the paid service? Do you know if this way it is fully free or is there a subscription for anything? Have a great day!
If you're self-hosting the app you can freely use all of the desktop (Windows, macOS, Linux) and mobile (iOS, Android) apps.
Can it be deploy in a raspberry pi??
I believe it can. I actually talk about the settings for that in the video when we look at the docker-compose.
can i install it in a computer in my ofice?
As long as that computer has docker on it
I was working for 3 hours before coming across this video, then I watched the video and tried to follow it as best I can. After 4 and a half hours, I still have no running application that I can access. Can't get to webpage, can't even get to the application at all. Docker container states it's running, yet I have no idea how to access it, and it doesn't appear to be working. I can't stand Docker, this is my experience every time I try, I've been through trainings, videos, still can't seem to get containers running. The only thing I was able to get working was a Plex container and a Dockge container. Everything else fails, just like this. Would love to try this application out, would love to be able to use this for invoicing, but I can't even get the thing running.
i hit the bell:)
thanks!!
try Crater Invoices
I don't think InvoiceNinja understands the purpose of docker-compose or how it is supposed to work. Just silly all around.
11:26 I paused and enter this comment. proxmox backup is mentioned. please make a video about how to tweak and use proxmox backup method too. now back to video.
I covered the basics here: czcams.com/video/ksvoWpyWHUY/video.html
this isnt self hosted why
What do you mean this isn't self-hosted?
I had to "chmod -R 777 app/" , wouldn't let me only with 755.
I had a similar thing happen, but I don't like to suggest 777 as it causes people to poop their pants lol. It's why I said that people would have to try some things for themselves to see what works :)
Looking over the GitHub page it shows: To ensure folder permissions are correct when the container comes up for the first time it is important that you set the correct folder permissions on the docker folder.
From the terminal run
chmod 755 docker/app/public
sudo chown -R 1500:1500 docker/app
the second command is what is missing as you do not want to run the app folder/container as root.
I came across a caching bug advises to run /update?secret=secret to reset the caching issue
I tried many times and kept getting this error from the apps
In Connector.php line 70:
SQLSTATE[HY000] [2002] Connection refused
2022-11-18T00:34:10Z [ERROR] [Entrypoint]: Error connecting to DB
2022-11-18T00:34:28Z [INFO] [Entrypoint]: Initialising Invoice Ninja...
INFO Configuration cached successfully.
INFO Caching the framework bootstrap files.
config .......................................................... 143ms DONE
routes .......................................................... 335ms DONE
In Connection.php line 760:
SQLSTATE[HY000] [1044] Access denied for user 'ninja'@'%' to database 'ninj
a' (SQL: select * from information_schema.tables where table_schema = ninja
and table_name = accounts and table_type = 'BASE TABLE')
In Connector.php line 70:
SQLSTATE[HY000] [1044] Access denied for user 'ninja'@'%' to database 'ninj
a'
2022-11-18T00:34:40Z [ERROR] [Entrypoint]: Error connecting to DB
2022-11-18T00:34:56Z [INFO] [Entrypoint]: Initialising Invoice Ninja...
INFO Configuration cached successfully.
There's a problem with your user connecting to the database. If you're using a password with a special character in it, you'll want to wrap the password in quotes, though I don't recall immediately if it's a single or doubl quote. So I would try that. Or just try a password with no special characters and see if that gets you going.
@@DBTechYT Aloysius Chan
No change to the DB password as stated in the env file. I also added the PUID and PGID as recommended but it still doesnt work for me.
same issue here, special character passwords are wrapped. No Go