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

[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.

[TurkerTunali]

@bkm

bench init --frappe-branch version-13 frappe-bench

returned

Setting Up Environment
$ /usr/bin/python3 -m venv env
The virtual environment was not created successfully because ensurepip is not
available.  On Debian/Ubuntu systems, you need to install the python3-venv
package using the following command.

    apt install python3.8-venv

After

apt install python3.8-venv

it worked.

[TurkerTunali]

I think installation procudure can be summarized as

• Install required apps (mariadb, redis, nginx, etc…)
• Install bench and frappe
• Install erpnext
• setup production
• dns, site, ssl post configurations.

These are independent actions I believe.

So I think we need clear steps for each action. It would also help anyone if we can identify which step they have trouble.

We can create something like this for each step I think.

[marvindmv]

Excelente tutorial despues de muchos intentos hasta ahora, por fin logre instalarlo con exito … Gracias BKM

[flexy2ky]

There is currently an issue at this step:

bench init --frappe-branch version-13 frappe-bench

This error comes up:

The virtual environment was not created successfully because ensurepip is not
available. On Debian/Ubuntu systems, you need to install the python3-venv
package using the following command.

apt install python3.8-venv

You may need to use sudo with that command. After installing the python3-venv
package, recreate your virtual environment.

The fix is to run:

apt install python3.8-venv

And the installation will continue afterwards.

[anupd]

@bkm

pip3 install frappe-bench

I am getting an error after this line.

sammy@localhost:~$ pip3 install frappe-bench
Traceback (most recent call last):
File “/usr/bin/pip3”, line 11, in
load_entry_point(‘pip==20.0.2’, ‘console_scripts’, ‘pip3’)()
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 486, in load_entry_point
return get_distribution(dist).load_entry_point(group, name)
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 2867, in load_entry_point
return ep.load()
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 2471, in load
return self.resolve()
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 2477, in resolve
module = import(self.module_name, fromlist=[‘name’], level=0)
File “/usr/lib/python3/dist-packages/pip/_internal/cli/main.py”, line 10, in
from pip._internal.cli.autocompletion import autocomplete
File “/usr/lib/python3/dist-packages/pip/_internal/cli/autocompletion.py”, line 9, in
from pip._internal.cli.main_parser import create_main_parser
File “/usr/lib/python3/dist-packages/pip/_internal/cli/main_parser.py”, line 7, in
from pip._internal.cli import cmdoptions
File “/usr/lib/python3/dist-packages/pip/_internal/cli/cmdoptions.py”, line 24, in
from pip._internal.exceptions import CommandError
File “/usr/lib/python3/dist-packages/pip/_internal/exceptions.py”, line 10, in
from pip._vendor.six import iteritems
File “/usr/lib/python3/dist-packages/pip/_vendor/init.py”, line 65, in
vendored(“cachecontrol”)
File “/usr/lib/python3/dist-packages/pip/_vendor/init.py”, line 36, in vendored
import(modulename, globals(), locals(), level=0)
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/CacheControl-0.12.6-py2.py3-none-any.whl/cachecontrol/init.py”, line 9, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/CacheControl-0.12.6-py2.py3-none-any.whl/cachecontrol/wrapper.py”, line 1, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/CacheControl-0.12.6-py2.py3-none-any.whl/cachecontrol/adapter.py”, line 5, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/requests-2.22.0-py2.py3-none-any.whl/requests/init.py”, line 95, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/urllib3-1.25.8-py2.py3-none-any.whl/urllib3/contrib/pyopenssl.py”, line 46, in
File “/usr/lib/python3/dist-packages/OpenSSL/init.py”, line 8, in
from OpenSSL import crypto, SSL
File “/usr/lib/python3/dist-packages/OpenSSL/crypto.py”, line 1553, in
class X509StoreFlags(object):
File “/usr/lib/python3/dist-packages/OpenSSL/crypto.py”, line 1573, in X509StoreFlags
CB_ISSUER_CHECK = _lib.X509_V_FLAG_CB_ISSUER_CHECK
AttributeError: module ‘lib’ has no attribute ‘X509_V_FLAG_CB_ISSUER_CHECK’
Error in sys.excepthook:
Traceback (most recent call last):
File “/usr/lib/python3/dist-packages/apport_python_hook.py”, line 72, in apport_excepthook
from apport.fileutils import likely_packaged, get_recent_crashes
File “/usr/lib/python3/dist-packages/apport/init.py”, line 5, in
from apport.report import Report
File “/usr/lib/python3/dist-packages/apport/report.py”, line 32, in
import apport.fileutils
File “/usr/lib/python3/dist-packages/apport/fileutils.py”, line 12, in
import os, glob, subprocess, os.path, time, pwd, sys, requests_unixsocket
File “/usr/lib/python3/dist-packages/requests_unixsocket/init.py”, line 1, in
import requests
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/requests-2.22.0-py2.py3-none-any.whl/requests/init.py”, line 95, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/urllib3-1.25.8-py2.py3-none-any.whl/urllib3/contrib/pyopenssl.py”, line 46, in
File “/usr/lib/python3/dist-packages/OpenSSL/init.py”, line 8, in
from OpenSSL import crypto, SSL
File “/usr/lib/python3/dist-packages/OpenSSL/crypto.py”, line 1553, in
class X509StoreFlags(object):
File “/usr/lib/python3/dist-packages/OpenSSL/crypto.py”, line 1573, in X509StoreFlags
CB_ISSUER_CHECK = _lib.X509_V_FLAG_CB_ISSUER_CHECK
AttributeError: module ‘lib’ has no attribute ‘X509_V_FLAG_CB_ISSUER_CHECK’

Original exception was:
Traceback (most recent call last):
File “/usr/bin/pip3”, line 11, in
load_entry_point(‘pip==20.0.2’, ‘console_scripts’, ‘pip3’)()
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 486, in load_entry_point
return get_distribution(dist).load_entry_point(group, name)
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 2867, in load_entry_point
return ep.load()
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 2471, in load
return self.resolve()
File “/usr/local/lib/python3.8/dist-packages/pkg_resources/init.py”, line 2477, in resolve
module = import(self.module_name, fromlist=[‘name’], level=0)
File “/usr/lib/python3/dist-packages/pip/_internal/cli/main.py”, line 10, in
from pip._internal.cli.autocompletion import autocomplete
File “/usr/lib/python3/dist-packages/pip/_internal/cli/autocompletion.py”, line 9, in
from pip._internal.cli.main_parser import create_main_parser
File “/usr/lib/python3/dist-packages/pip/_internal/cli/main_parser.py”, line 7, in
from pip._internal.cli import cmdoptions
File “/usr/lib/python3/dist-packages/pip/_internal/cli/cmdoptions.py”, line 24, in
from pip._internal.exceptions import CommandError
File “/usr/lib/python3/dist-packages/pip/_internal/exceptions.py”, line 10, in
from pip._vendor.six import iteritems
File “/usr/lib/python3/dist-packages/pip/_vendor/init.py”, line 65, in
vendored(“cachecontrol”)
File “/usr/lib/python3/dist-packages/pip/_vendor/init.py”, line 36, in vendored
import(modulename, globals(), locals(), level=0)
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/CacheControl-0.12.6-py2.py3-none-any.whl/cachecontrol/init.py”, line 9, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/CacheControl-0.12.6-py2.py3-none-any.whl/cachecontrol/wrapper.py”, line 1, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/CacheControl-0.12.6-py2.py3-none-any.whl/cachecontrol/adapter.py”, line 5, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/requests-2.22.0-py2.py3-none-any.whl/requests/init.py”, line 95, in
File “”, line 991, in _find_and_load
File “”, line 975, in _find_and_load_unlocked
File “”, line 655, in _load_unlocked
File “”, line 618, in _load_backward_compatible
File “”, line 259, in load_module
File “/usr/share/python-wheels/urllib3-1.25.8-py2.py3-none-any.whl/urllib3/contrib/pyopenssl.py”, line 46, in
File “/usr/lib/python3/dist-packages/OpenSSL/init.py”, line 8, in
from OpenSSL import crypto, SSL
File “/usr/lib/python3/dist-packages/OpenSSL/crypto.py”, line 1553, in
class X509StoreFlags(object):
File “/usr/lib/python3/dist-packages/OpenSSL/crypto.py”, line 1573, in X509StoreFlags
CB_ISSUER_CHECK = _lib.X509_V_FLAG_CB_ISSUER_CHECK
AttributeError: module ‘lib’ has no attribute ‘X509_V_FLAG_CB_ISSUER_CHECK’

Is this because of recent update of frappe framework to v14 ?

[bkm]

@anupd

Is this because of recent update of frappe framework to v14 ?

That seems very likely. V14 uses a newer python distribution. Now that v14 is the standard release, this tutorial will likely fail since it will try to get the v14 packages to do the install.

In order to install the v13 packages you will likely have to alter the ‘bench init’ command to go after the v13 version specifically. A similar edit will probably also be required for ‘bench get-app’ command.

I will not be doing anything for v14 anytime soon, but there are already other tutorials for setting up v14.

BKM

[anupd]

@bkm

you will likely have to alter the ‘bench init’

Yes, would do that if I could get past this line which seems to give the error.

@bkm

pip3 install frappe-bench