ERPNext Docker deployment using an external database without root privileges

Install / Update Deployment
1

Hey guys,

I’m trying to deploy ERPNext via the docker installation method using an external mariadb host. I don’t have root access to this database but I can have the admin create a DB and user for ERPNext with all privileges. Can anyone tell me how I can set this up?

2

anyone?

3

Check this frappe_docker/site-operations.md at main · frappe/frappe_docker · GitHub

Specify the DB_ROOT_USER and MYSQL_ROOT_PASSWORD

example:

DB_ROOT_USER=frappe
MYSQL_ROOT_PASSWORD=secret

Or,

  • create site locally
  • take backup
  • ask admin to restore the .sql backup
4

Thanks for the reply.

First option is not possible without root DB access right? Since the user will not have access to create a new db.

Second option sounds better but where do I define db host ip in the compose file?
Is there a specific varaible for this?

5

Use env variable MARIADB_HOST

6

Thank you!

So
DB_ROOT_USER=frappe
MYSQL_ROOT_PASSWORD=secret
will have to be the credentials for the user with only db write privileges right?

7

@revant_one Can I also define the DB Name using an env variable?

8

No.

Use bench helper command instead.

bench new-site --no-mariadb-socket

Don’t forget --no-mariadb-socket

something like this AWS EKS Fargate ERPNext · GitHub