Overview Frappe, Docker, self-hosting

Hi Revant,
Thank You for the tutorial, But when I try following the instructions I get the following after the command:

./installer.py -t develop -p 3.11.4 -n v18 -j apps.json -v

Can you please help me ?

This might be a file conversion problem between platforms.

The before-last line shows “python\r” (with a slash r), which doesn’t seem normal.

\r is newline on Mac
\n is newline on Linux
\r\n is newline on Windows

@revant_one

when i run ./installer.py -t develop -p 3.11.4 -n v18 -j apps.json -v
the u2net.onnx is not install

Hi there,
you can fix this error by changing the command to specifically run using python.
instead of this:
./installer.py -t develop -p 3.11.4 -n v18 -j apps.json -v
run this
python installer.py -t develop -p 3.11.4 -n v18 -j apps.json -v

hope it helps.

What to do with this…?
Can anyone help ?
Please reply asap!

You need to understand volume and permission for mounted location. Fix ownership permission for files and directory.

When I try to use this for ERPnext, I am facing this error

> pymysql.err.OperationalError: (1045, “Access denied for user ‘_3dd160741ec981d6’@‘172.20.0.5’ (using password: YES)”)

when I check databases from devcontainer, I don’t see database created.
site_config.json

{

“db_host”: “mariadb”,

“db_name”: “_3dd160741ec981d6”,

“db_password”: “HIDDEN”,

“db_type”: “mariadb”,

“db_user”: “_3dd160741ec981d6”

}

Try this frappe_docker/docs/troubleshoot.md at main · frappe/frappe_docker · GitHub

1 Like

@revant_one Could you guide how we can have custom app build for ERPnext?
Should it be own repo or the forked repo?

Create your custom app and use hooks

@revant_one Could you please share some material on how hooks can be useful?

Also, I have a question: should it be in its own repository or a forked one?

Documentation is helpful.

https://docs.frappe.io/framework/user/en/python-api/hooks

After fixing this error : pymysql.err.OperationalError:
(1045, “Access denied for user ‘_9b03da94e59802ed@‘172.20.0.5’ (using password: YES)”)

using frappe_docker/docs/troubleshoot.md at main · frappe/frappe_docker · GitHub , iam getting a new error :
pymysql.err.OperationalError: (1049, “Unknown database ‘_9b03da94e59802ed’”)

Hi,

Are you able to log into the backend and run: bench mariadb?

Does the “db_name” in the sites/site_config.json look correct?

i logged into MariaDb container and run :

mysql -uroot -p

Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.6.21-MariaDB-ubu2004 mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]> SHOW DATABASES;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
±------------------
4 rows in set (0.015 sec)

the database " _9b03da94e59802ed " is not present in mariadb . the database is not created.
this is my site_config.json file :
{

“db_host”: “mariadb”,

“db_name”: “_9b03da94e59802ed”,

“db_password”: “3jwywPWuu5Os8Tcq”,

“db_type”: “mariadb”,

“db_user”: “_9b03da94e59802ed”

}

This is my apps,json :
[
{
“url”: “GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)”,
“branch”: “version-15”
},
{
“url”: “GitHub - frappe/education: Open source education / school management system”,
“branch”: “version-15”
}

]

This means you don’t have db. Something is wrong with it. If by any chance you’ve a backup you’re safe. Or else you’ve to start fresh again.

I tried removing images , containers and removing frappe repository completely and strated from beginning and yet got the same error multiple times.
Every time i cheak the mariadb the db_name is missing.

Try stopping the containers, and pruning everything before re-composing. Note that this may affect other Docker objects so prune carefully.

https://docs.docker.com/engine/manage-resources/pruning/

As i said did pruning everything and started the whole process again.

  • As per my understanding the docker image should create database with the name of “db_name” in mariadb. but its happening.
  • is this happening because iam trying to install expnext and education app?