[Tutorial] How to 'manually' install ERPNext v13.11 Production on Debian 10 (w/SSL cert)

[Muzzy]

It’s failing for me as well on fresh Ubuntu 20 server with python 3.8 error. Try this manual method

How To Install an ERPNext Stack on Ubuntu 20.04 | DigitalOcean

[nomi-gee]

Not working for me as well. the issue is with the sudo. i tried with simple user and removed bench with sudo pip3 uninstall bench and then installed bench without sudo it worked well but when i tried to run it from bench it throw same error. erros seems to because of some directory issue previously bench was located in /usr/local/bin/bench and now bench have a changed directory and have /usr/bin/bench. i tried to moving /usr/bin/bench to /usr/local/bin/bench but error won’t goes away. pip version is same seems something changed or updated with in setuptools

[nomi-gee]

i fixed it by
sudo pip3 uninstall setuptools
sudo pip3 install setuptools==59.6.0
sudo pip3 install -e /home/erp/.bench/

[rareza35]

Installed step by step and works perfectly in vps hetzner with Ubuntu 20.04

[Arianguy]

The installation completed perfectly with SSL also in place.

I got stuck with setting the email ( SMTP ) setting , tried all possible ways for Gmail ( Main Password, App Password ) and all it says is Request Timed Out .

I tried other email services also but same. Any Help will be appreciated .

[why]

Thank you very much, you saved me time, as I’ve spent more than three days trying to install ERPNext on Ubuntu 20.04.
It works on Debian 11, also.

ERPNext installation issues Ubuntu 20.04

Thank you, very much! I’ve managed to install ERPNext on (currently) latest Debian 11. Hints for installing ERPNext on Debian 11: before this part (first step) → Just type: su hit enter and and enter the pass for root, as Debian 11 locks-out root access via SSH by default and if your user acc is not in sudoers or wheel group. If any command you enter is not recognized, use sudo. [ERPInstalled]

[IHackmer]

I have installed Erpnext using the following steps listed above… But I have to always run bench start when I reboot the server… I tried to modify the redis configuration files but no luck… So, How to tell Bench to automatically start when the server is rebooted???

[flexy2ky]

@IHackmer

But I have to always run bench start when I reboot the server

run bench setup production

[IHackmer]

That was the command I ran during the installation… But still it did not automatically start… While running bench start I get a warning of something called : caniuse-lite, its says to update it using some npx command… Maybe that might be the issue

[IHackmer]

I solved the error… It was indeed a Caniuse-Lite Error…

Error In installing ERPNext stack in Ubuntu 20.04 : ansible-playbook error

Fixed the error… It was indeed an NPX issue… Nginx needed to be restarted as the old(past) version had some dependencies which needed to be reloaded… For Future Reference… #In the Bench directory npm init npm update caniuse-lite browserslist yarn install yarn upgrade caniuse-lite browserlist That should particularly fix the bench start at restart problem

[Divert]

I am following your tutorial on Debian 11.

@bkm

UPDATE user SET plugin=’ ’ WHERE User = ‘root’;

This command raises the error:

ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Also notice that the table name is user but the field name is User (with capital U) .

Please help

[bkm]

It sounds like you missed the first line of that set of instructions telling you to use a different named database. Here it is again for reference:

USE mysql;
UPDATE user SET plugin=' ' WHERE user = 'root';
FLUSH PRIVILEGES;
exit

Hope this helps.
If not, then you likely have a very unusual server configuration for mysql.

BKM

[Divert]

I confirm, I was using the mysql database. The server is Debian 11

Apparently on newer versions of Mariadb you don’t just go and change the user table, instead you have to use the ALTER user command as said here

Maybe we need to update these instructions.

[bkm]

@Divert

Maybe we need to update these instructions.

No. I think not!

Maybe someone can take the time to figure out all of the differences between Debian 10 and Debian 11 and then write another guide for Debain 11.

This one is for Debian 10.

Maybe one day I will have the time to do a Debian 11 version, but that is not anytime very soon.

Thanks.

BKM

[Tri_Agung]

same bro, i try this command on mariadb 10.6 with ubuntu 22 but error.

@bkm @Divert can you help me please? whats a correct command for this? Tell me ASAP.

thanks

[Divert]

@Tri_Agung read my comment here. It will give you the hint to your answer.

Still I have not been able to install ERPNext no matter what guide I try. I am trying to set a VPS from Digital Ocean that already has ERPNext in it’s image. Just fire up the image and you have ERPNext, the problem is that it is not clear to me how to set your custom domains.

What is the difference between sites and domains in ERPNext language?

[bkm]

Unfortunately I cannot help you with this.

I am a fan of ONLY using LTS version of operating systems so as to reduce the volatility of the constantly changing support packages.

That is why I write my tutorials for only LTS versions of the OS as well. So what I spend my valuable time researching and writing about currently are Debian 10 and Ubuntu 20.04.

For any other operating systems, you are on your own. The newer OS versions take up way too much time due to the constant changes, and I still have a business to run.

BKM

[bkm]

@Divert

What is the difference between sites and domains in ERPNext language?

Sites are separate instances of ERPNext, such as you might have with a multi-tennant configuration.

Domains are the modules that focuses ERPNext into different business solutions such as Distribution, Retail Sales, Manufacturing, etc.

BKM

[bkm]

@Divert

Just fire up the image and you have ERPNext, the problem is that it is not clear to me how to set your custom domains.

In this case, are you speaking about URL domains or ERPNext business solution domains?

If it is the former, then this excerpt from the instructions should help you set your URL to the site:

@bkm

export LC_ALL=C.UTF-8
cd frappe-bench
bench config dns_multitenant on
bench setup add-domain --site site1.local [your.new.URL]
bench setup nginx (answer Y to the question about replacing the config file)
sudo service nginx restart
cd ~

Hope this helps.

BKM

[Divert]

@bkm Thanks a lot, this tutorial Works flawlessly. I just installed successfully. Thanks again…

In the steps where you ask log out and back in, I had to do a su - [USER] and averything worked fine.