Sorry,We Will Be Back Soon

Dear Friends,help!
i have set up a production in google cloud and it was running well until i tried to add the host name.I initially made mistake in the site config host naming which i have corrected.All effort to follow all instructions in the forum to use the domain name to open erpnext instance proved abortive.I have done the bench setup the production,restarted the ngnix,and the supervisor.
But here is the output of restarting the supervisor:
sudo supervisorctl restart all
frappe-bench-workers:frappe-bench-frappe-schedule: stopped
frappe-bench-web:frappe-bench-node-socketio: stopped
frappe-bench-redis:frappe-bench-redis-queue: stopped
frappe-bench-redis:frappe-bench-redis-cache: stopped
frappe-bench-redis:frappe-bench-redis-socketio: stopped
frappe-bench-workers:frappe-bench-frappe-default-worker-0: stopped
frappe-bench-workers:frappe-bench-frappe-long-worker-0: stopped
frappe-bench-workers:frappe-bench-frappe-short-worker-0: stopped
frappe-bench-web:frappe-bench-frappe-web: stopped
frappe-bench-workers:frappe-bench-frappe-schedule: started
frappe-bench-workers:frappe-bench-frappe-default-worker-0: started
frappe-bench-workers:frappe-bench-frappe-long-worker-0: started
frappe-bench-workers:frappe-bench-frappe-short-worker-0: started
frappe-bench-web:frappe-bench-frappe-web: started
frappe-bench-web:frappe-bench-node-socketio: started
frappe-bench-redis:frappe-bench-redis-queue: started
frappe-bench-redis:frappe-bench-redis-cache: started
frappe-bench-redis:frappe-bench-redis-socketio: started
Kindly help me out
When bench updated,here is the result
yncing help database…
Wrote css/frappe-web.css - 65.05 KB
Wrote js/frappe-web.min.js - 131.06 KB
Wrote js/control.min.js - 58.93 KB
Wrote js/dialog.min.js - 105.78 KB
Wrote css/desk.min.css - 292.07 KB
Wrote css/frappe-rtl.css - 32.37 KB
Wrote js/libs.min.js - 842.41 KB
Wrote js/desk.min.js - 453.79 KB
Wrote js/d3.min.js - 380.17 KB
Wrote css/module.min.css - 2.08 KB
Wrote css/form.min.css - 4.47 KB
Wrote js/form.min.js - 193.67 KB
Wrote css/list.min.css - 14.43 KB
Wrote js/list.min.js - 140.25 KB
Wrote css/report.min.css - 7.89 KB
Wrote js/report.min.js - 259.99 KB
Wrote js/web_form.min.js - 247.22 KB
Wrote css/web_form.css - 24.42 KB
Wrote js/print_format_v3.min.js - 23.39 KB
Wrote css/erpnext.css - 7.87 KB
Wrote js/erpnext-web.min.js - 3.73 KB
Wrote js/erpnext.min.js - 133.58 KB
Wrote js/item-dashboard.min.js - 7.66 KB
INFO:bench.utils:sudo supervisorctl restart frappe-bench-workers: frappe-bench-web:
frappe-bench-workers:frappe-bench-frappe-schedule: stopped
frappe-bench-workers:frappe-bench-frappe-default-worker-0: stopped
frappe-bench-workers:frappe-bench-frappe-long-worker-0: stopped
frappe-bench-workers:frappe-bench-frappe-short-worker-0: stopped
frappe-bench-web:frappe-bench-node-socketio: stopped
frappe-bench-web:frappe-bench-frappe-web: stopped
frappe-bench-workers:frappe-bench-frappe-schedule: started
frappe-bench-workers:frappe-bench-frappe-default-worker-0: started
frappe-bench-workers:frappe-bench-frappe-long-worker-0: started
frappe-bench-workers:frappe-bench-frappe-short-worker-0: started
frappe-bench-web:frappe-bench-frappe-web: started
frappe-bench-web:frappe-bench-node-socketio: started
Help pls

Seems like your update failed. Run bench update again and share your trace.

@rmehta Dear Rmehta Thanks for response.i so much appreciate.I was trying to solve the problem and it is now compounded.As i ran the bench update the error message is alarming .So i have abandon the instance because i have a backup of yesterday.So i want to restore in a new instance.
PROBLEM:
I have wget the sql database to cd /tmp and i was told saving to ‘20170921_000302_2a2e7584_database.sql.gz?role=personal.3’. I tried to gunzip it from the the cd/ tmp folder but there is error message that the sql file does not exist.
HELP
1.From which folder do i gunzip
2.What is the path of the sql.Will it be the folder from where i gunzip?
Any other great friend can help me out .
Thanks in advance
Your true friend
Fred

1 Like

gunzip .sql.gz format file.
gunzip 20170921_000302_2a2e7584_database.sql.gz

@wahab i have done that from cd /tmp and also from frappe-bench,thereis error message that the file or directory does not exist.Under what folder do i gunzip it?

Any other help from any other friends

@nabinhait @tundebabzy @saidsl @wale @bkm @Chude_Osiegbu Great friends i cannot have you and have sleepless nights.
I want to restore a database from dropbox to a new instance in google platform.I have followed all instructions in the forum including https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup to no avail.The most detailed instruction on how to download the database and unzip in the forum is as followed and i have followed it to letter:
First of all, copy or move other website backup to here : frappe-bench/sites/[sitename]/private/backups
then go to: cd /tmp
Unzip files from here: gunzip /home/frappe/frappe-bench/sites/[sitename]/private/backups/[database.sql.gz]
now back to : cd /home/frappe/frappe-bench/
bench --site [sitename] --force restore /home/frappe/frappe-bench/sites/[sitename]/private/backups/[database.sql]

I successfully wget to the backup in the private folder of my site1.local. When i unzip,the error message is that the file or directory does not exist.Your 10mins explanation of what i am getting wrong will save me more than 48 hours.
HELP!!!

Fred1

I feel your pain. It took me a few days to figure out what I was doing wrong with gunzip.

I have been using the SSH function built into the GCP. If you log into your account on GCP and go to the Compute Engine heading to see your VM Instances, you will notice that to the far right side of the instance you are working on, there is a drop down box that says SSH. Click on that and select “Open in browser window”

  • This will open a SSH terminal window into your VM instance
  • It will automatically be opened in your default home directory
  • Click on the the little gear symbol in the upper right corner
  • This will open a menu that allows you to upload your backup
  • If you select to upload the backup it wil go straight to your home directory (and this is OK)
  • Upload it to yur home directory
  • When it is finished click Close to close the upload dialog box
  • type ls at the command prompt in the SSH window
  • This will list the files in your home directory and your backup_whatever.sql.gz shoule be there
  • While still in your own home directory type the following command:

gunzip -k backup_whatever.sql.gz

  • Of course you replace backup_whatever with the name of your file and then this command will extract the SQL file for you and place it right next to the .gz file that it came from.
  • Next type the following command (assuming you did a simple cloud install):

cd /home/frappe/frappe-bench

  • This will take you to the bench directory of your install
  • Now type the following command:

sudo bench --site [your-site-name] --force restore /home/your-home-folder/your-backup.sql

  • This will start the restore process. You will know it is working because the command line will prompt you for the Database Administrator Password. You type in the password you created during the install and press enter key.
  • When the command prompt comes back the restore is done, but you still have another step before you can start up the system.
  • at the command line type the following command:

sudo bench --site [your-site-name] migrate

  • You should see a few lins of activity and then the command prompt returns again.
  • If you also backed up any special document files you should also copy them back into the correct folder in the bench.
  • You can now close the SSH window and log into the ERPNext instance that you just restored the data into.

If you are really particular about the disk space of your VM instance, you can go back and delete the .gz and .sql files from your home folder.

This is kind of simplified, but I use this same process 2 or 3 times a week to create test instances of ERPNext in my GCP account that I can experiment with and not affect my live system.

Hope this helps

BKM

2 Likes

@bkm You are a great man and you will remain so.I followed your steps and got the result 100%.Word cannot express my appreciation.You are a friend indeed.
I thank my other numerous friends who were already preparing to help before great bkm solved the problem.
Thanks
Fred

4 Likes

That is great news! Happy to have been of assistance.
I wish you well with your future updates. :nerd_face:

BKM