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?
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
- 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
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?
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