ERPNext Docker deployment using an external database without root privileges

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?

anyone?

Check this https://github.com/frappe/frappe_docker/blob/develop/docs/site-operations.md#mariadb-site

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

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?

Use env variable MARIADB_HOST

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?

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

No.

Use bench helper command instead.

bench new-site --no-mariadb-socket

Don’t forget --no-mariadb-socket

something like this https://gist.github.com/revant/1328e3367c3042fd91c447859fb23dd1#file-create-site-yaml-L19