Unable to run Digital Ocean installation

Hello All,

I have been struggling for 2 days to run the ERPNext one click installation.

I followed the steps:

1- Created the droplet
2- Logged in as root
3- switch user to frappe
4- Change Administrator password: bench --site site1.local set-admin-password {new_password}
5- Change Mariadb root password: mysqladmin -u root password {new_password}
6- Getting the following error when changing the DB password:
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@‘localhost’ (using password: NO)’
7- wen to the public IP
8- tried to login as admin, but always returning wrong password
tried the username: admin, root & frappe
while using the password i setup in step 4

Anyone can help?

Check the password in password.txt file inside frappe-bench directory

it is root i tried it didnt work as well

@samersemaan

Did you try to install bench with easyinstall script ?

What is OS version you are using.

If you are using ubuntu <= 18.04 then I would suggest following steps :

  1. Create a fresh droplet.
  2. login in as root
  3. add erpnext user :
adduser *Your_USERNAME*
usermod -aG sudo *Your_USERNAME*

  1. Get this install.py
wget https://raw.githubusercontent.com/frappe/bench/develop/install.py
  1. Installing bench/erpnext
sudo python3 install.py --production --user  *Your_USERNAME*  -verbose
  1. Follow on the screen instruction. It will ask for Mariadb root user password and Bench Administrator password, enter them.

  2. wait for the installation to complete. Can take a while so be patient.

  3. Login to your erpnext user you have created.

su *Your_USERNAME*
  1. go to frappe bench folder
cd /frappe-bench
  1. restart the bench. (to check if all has gone well)
bench restart
  1. Once bench restart is successful access it via your static ip / domain if any …

Hope this will help you to get through the installation.

sudo bench use
sudo set-admin-password password
sudo bench start

i have tried this and passwprd changed successfully.
image

1 Like

–shift user

root@debian:/home/bitnami# su frappe
frappe@debian:/home/bitnami:~/frappe-bench$ sudo su

change root user password

root@debian:/home/bitnami# sudo passwd root
new password : urpassword
reenter password : urpassword

–change mariadb password

sudo /etc/init.d/mysql stop

sudo mysqld_safe --skip-grant-tables &

mysql -uroot

use mysql;

update user set authentication_string=PASSWORD(“admindb”) where User=‘root’;

flush privileges;

quit

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start

–Change ERPNext Admin Password

bench --site [your site] set-admin-password [new password]

image

if you have any query. please let me know

Try running that command as root user instead

use
username: Administrator
while using the password you setup in step 4