Invoice ninja - Open Source, Self Hosted Invoicing with incredible feature, and powerful accounting.

[@hiddenpcmaster]

Another slam dunk, Thank you Brian for this needed way to self host my small computer repair business. This has been my missing link. Much appreciated! I have so much to learn.

[@AwesomeOpenSource]

Super glad it helped.

[@Jetta4TDIR]

Hi Brian, ive been subbed for a while now and I'm generally a quiet subscriber but genuinely want to thank you for sharing your knowledge, your channel has been an invaluable resource for my homelab progress, so thank you very much. Keep it coming! 😅

[@AwesomeOpenSource]

It is absolutely my pleasure!

[@Jetta4TDIR]

@@AwesomeOpenSource i realize that you've covered it already, but i could really use some help with nextcloud, ive tried everything, but i just cant get it installed without tons of errors regarding https or get smtp working for mail. To be honest I've given up trying at this point until i come across a solution. I have to be honest, im new to Docker, but since trying out casaos (running on top of linux mint... Yeah i know i have a thing for gui's) im starting to appreciate the docker environment. I use nginx proxy manager with letsencrypt and all the https settings enabled and everything is going through cloudflare with all the required settings and i still get a heap of error messages regarding HTTPS... Super frustrating 😂

[@dualbeardedtech]

Dude, I really enjoy watching your videos. I've been using Linux for years and every time I watch, I learn something new! Cheers!

[@AwesomeOpenSource]

Great to hear!

[@surgical_17]

Important To Point Out there is two different Frontends you can use, Flutter or React. Both look and work a bit different.

[@alexeycherkashin6251]

Thank you for the heads up. Which one works best for what case from your point of view?

[@AwesomeOpenSource]

Great tip, thank you. I didn't see any documentation on how to change it in the docker files.

[@Steven_nevetS]

Excellent software and great video on how to setup. Thank you

[@AwesomeOpenSource]

My pleasure.

[@northpoint1039]

I have been running IN for probably over 10 years? Has it been that long? Well, Anyways I do not run it in docker or anything like that. I run it in a Virtualbox VM. Reason being is that you have much more control over the whole setup. Backups are quite easy as I backup the whole VM. I do also run a normal backup of IN. Also, When you run it from either in a regular install or in a VM you learn much more on how it all fits together. Should you have a problem then its easier and quicker to fix issues because your well versed in the setup of everything. I have over 100 clients for my business and I payed for the white label also. Its very nice software when you compare it to something like intuit (yuck!). Mine runs on Linux and I couldnt be happier.

[@AwesomeOpenSource]

I understand your stance completely. I think the benefit of docker is that it's built with making sure everything is running to start with. Sure you have to know what environment variables to change, keep, etc. but other than that, the container is made to work.

[@build.aiagents]

Needed this!! Thank you 🙏🏽

[@AwesomeOpenSource]

You're so welcome!

[@khalidelgazzar]

Great video. Thank you!

[@AwesomeOpenSource]

You are welcome!

[@cattivello]

Hi Brian, thank you for this very complete video for InvoiceNinja. It works and I need to study it a bit now. I am always concerned about security. How can we implement 2fa? The option is there but I dont see how to implement it?

[@cig_in_mouth3786]

It is amazing no doubt, but every invoice i generated it said generated via invoice ninja and if you dont want that you have use their instance 😢.

[@toxiccan175]

Open that source code, search for “generated via invoice ninja,” remove that sucker, and build from source lmao

[@jeffreywolfe6313]

He talks about it here in the video: kzbin.info/www/bejne/i6eUYomGhZmLhpYsi=ptKP2gqqOy4pqlb3&t=2104 I looked it up and it is $30 per year for self-hosting white label.

[@AwesomeOpenSource]

Yes, full white-labelling (meaning all your logos and informationonly, is their way offunding ongoing development.

[@zerobambiro]

there must be someone who already cracked this stuff

[@randy90001]

Brian, Can you provide some insight on how to integrate Invoice Ninja with AWS s3 storage to use as the default storage? Also, how to persist changes so that the changes are not rolled back when the docker is restarted? Thanks, Randall

[@neo778]

Please fix the timestamps in your video description here! There‘s a space missing.

[@AwesomeOpenSource]

Fixed, sorry about that,. I don't know why sometimes KZbin decides to strip out the return character in my timestamps or links.

[@paganini9643]

I would say self hosted for advanced or some kind of new gen self hosters, had a hard time with it a year ago

[@AwesomeOpenSource]

I also struggled with it a while back, but this version is much easier, and the documentation was much more clear for me.

[@jeffherdz]

Brian, Does this take Credit Card information ? And can you setup so payments are directed to your bank? As this would be a huge security issue In today's world. And last question.... Can you use a remote MYSQL server instead of the one that is installed with this? Great video as always !

[@allferryrocha2698]

It integrates with payments systems such as Stripe which handles the cards stuff

[@AwesomeOpenSource]

@allferryrocha2698 said it correctly. It integrates with payment systems like Stripe, so nothing specific to your bank is ever in Invoice Ninja.

[@匿名-x5m]

Please upload a video on how to edit the source code and build invoice ninja. I could not edit the source when running from their docker build.

[@AwesomeOpenSource]

I wouldn't even know where to begin to do that.

[@TheAverageCraftsman]

I've been banging my head against the wall for a couple hours. I just cannot get this thing running. MySQL container keeps restarting. If I try and go into the container to look at logs I am in there for maybe 20 seconds and the session ends because the container is restarting. I started with a brand new DO vps. Only thing I did that Brian didn't was install Portainer. Even tried bringing Portainer down and it's still didn't work. I've tried various different settings in the compose and env file. Scrapped all the files and started from scratch and nothing. Anyone have any ideas at all?

[@AwesomeOpenSource]

Instead of looking at the logs in the container, try 'docker compose logs -f mysql" or whatever the service name is in docker compose. Maybe that will make it easier to get them on the screen.

[@TheAverageCraftsman]

@@AwesomeOpenSourceI ended up getting this working by first doing a standalone mariadb container. I then removed all the db stuff from the IN compose file. Fired it up and it worked fine.

[@ydiadi_]

is there any video you did to setup smtp server brian , thankyou

[@AwesomeOpenSource]

I have one on mail-in-a-box. It's a full email solution with SMTP. It's pretty hard to find a VPS that will allow you to set it up these days though.

[@ydiadi_]

​@@AwesomeOpenSourcethen invoice ninja hold no purpose for people who cannot setup smtp ?

[@jforbush]

I *really* wanted to like and use this app, but there are 2 major limitations….no “services” option and no way to create product subcategories ;(

[@AwesomeOpenSource]

Maybe worth an enhancement request on their github page.

[@ScottPlude]

I have built this THREE TIMES and every time I get "These credentials do not match our records" when I login.

[@AwesomeOpenSource]

Very weird. When you build it, are you first deleing the original mapped volume. The folder on the left side of the volume mappings in the docker compose file? If not, bring down your docker compose file. Delete those volumes using the command docker volume prune then verify you want to do it. Then try again to bring it up. It sounds like it's got old values from a previous database stuck somewhere.

[@ScottPlude]

@@AwesomeOpenSource Thanks for the fast response! I figured out that most changes in the "env" file can be changed after install. I went back and rebuilt and changed the app key, the url, and db password. I left user blank to pick up the default. Everything worked. I am wondering if my password generator created a character that the docker compose didn't like?

[@ScottPlude]

@@AwesomeOpenSource Now I am wondering if it is possible to remove the invoice ninja branding on the invoices. Lots of work to do on google! thank you so much for your content!

[@laukhengsoon]

thanks for the tutorial as always. I do face some issue when I set up the DB: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed:Try again (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine', table_collation as `collation` from information_schema.tables where table_schema = 'ninja' and table_type = 'BASE TABLE' order by table_name) I tried both images: mysql:5 and image: mysql:8, but still no luck. I really appreciate any help you can provide.

[@Mikesco3]

Ask in Brian's rocket chat server, the link is in his bio or show notes

[@AwesomeOpenSource]

First, you might just bring everything down with "docker compose down", then delete the entire folder completely, and re-clone it from git. Then make your changes to .env and make sure that your db values all match perfectly in both sections in the env file. Once you run it, some of those values are cached, and the easiest way to fix it is to just bring it down, delete, re-clone, and try again. If you don't want to have to re-edit the docker compose and env files, copy those out before you delete, then re-clone, and copy them back in. Be sure to double check all your env values.

[@schmekis1]

Any chance this works with flutter web app?

[@AwesomeOpenSource]

Yes, you can opt to switch to the flutter version in the self hosted setup.

[@richledbetter2123]

I ended up having issues with the database connection the where there was no permission for the username I made. To fix I need to go into the docker container for the sql server and add and give permissions manually. Just a heads up for anyone else who runs into this issue :)

[@AwesomeOpenSource]

Strange. Did you try to bring up the container with different information initially by any chance?

[@richledbetter2123]

@@AwesomeOpenSource I'm not sure I tried it on my own computer and it worked. maybe it's just my homelab being a little weird. I'll keep digging and if I find anything I'll leave it as another reply.

[@nothingtoseehere5760]

It's NOT open source if it inserts ads and wants you to pay to brand it. It is FREE. NOT OPEN SOURCE.

[@AwesomeOpenSource]

@@nothingtoseehere5760 you can go and get the source code and build it, modify it, and do whatever you like. It is indeed open source. The prebuilt version they provide does not have to include easy ways to rebrand or modify it.

[@匿名-x5m]

@@AwesomeOpenSource It is open source, but we have to pay to remove the branding. We could change the source code to remove the branding, but it would break the licence agreement, which can be troublesome for businesses. Right?

[@toddselby443]

I use this to send fake invoices to large corporations. Some will pay without question. Great side hustle !

[@AwesomeOpenSource]

Awwww, don't make me sad by using Open Source for evil.

[@toddselby443]

@@AwesomeOpenSource Just a joke.

[@rokello]

Hi i ge this error when i run the last command db-1 | 2024-04-07T16:58:43.745650Z 0 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory. db-1 | 2024-04-07T16:58:43.746668Z 0 [ERROR] [MY-012894] [InnoDB] Unable to open './#innodb_redo/#ib_redo16' (error: 1000). db-1 | 2024-04-07T16:58:44.747787Z 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 13 in a file operation. db-1 | 2024-04-07T16:58:44.747872Z 0 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory.

[@AwesomeOpenSource]

Looks like a permission issue on the mapped volume for the MySQL database. Check who owns it and the permissions on it.

[@bbenouarets]

Please Plane.so at next time.

[@AwesomeOpenSource]

I don't understand Plane.so?