Error on ERPNext - Ubuntu 18.04 LTS Installation

Thank you!!

1 Like

@warsmith

Welcome aboard !!!

You have been here only a short time and already you have added to the community.

Thank you immensely.

BKM :sunglasses:

i was big time lurking first VPS install i actually did was with your sudo -h technique so i jumped at the opportunity of helping you. i hope your install is up and running. They should sticky this topic.

It just completed successfully!!

Thank you again. I will post back here in a short while with the exact steps I used (including your work-around) to get to a successful system.

BKM

1 Like

i was planning to do that, but i trust you will do it better, as you have much more experience on here.

EDIT UPDATE
The browser that was using to create posts did not work well in the edit mode and it has created improper use of dashes in some of my posts. I have since re-edited this post with a different browser to fix this issue. I will not be using the conflicting browser in the future. Thank you to @jannis for pointing out the errors.

*EDIT Update *
This post has been updated to reflect additional steps needed after the successful completion of the install. These steps are important in order to get to the login page and start the system AFTER the install.

Ok, as promised, here are the steps I used to get the installation to complete on my Ubuntu 18.10 VPS host:

On a fresh Ubuntu host do the following:

  • Login as root and run the following commands:

apt-get update
apt-get upgrade

This will get the server up to the latest packages.

  • While still logged in as root, create the use r name account that you want to use for installing the ERPNext system (in my case it was “def_user”). then add then to the sudo group so they can execute commands without having to login as root user. Use these commands:

adduser [def_user]
usermod -aG sudo [def_user]

  • Then logout of the system and log back in as the new user

From there the following commands will get you a completed v12 install:

sudo -H apt-get install python3-minimal
sudo -H apt-get install python3-setuptools
sudo -H apt-get install build-essential
sudo -H apt-get install redis-server
wget https://raw.githubusercontent.com/frappe/bench/master/playbooks/install.py
sudo -H python3 install.py --production --user [def_user]

At this point you will probably have encountered the error that ends with “exit status 2”

So do the following to complete the installation:

cd /tmp/.bench/playbooks/roles/nodejs/tasks
sudo mv main.yml main_yml.orig
cd ~
sudo apt-get install nodejs
sudo -H python3 install.py --production --user [def_user]

This time your installation should complete without errors.
However, you are not yet finished. The next steps will get your system ready to login for the first time:

sudo npm install -g yarn
cd frappe-bench
bench update

At this point you are probably still waiting for the bench update to complete. It takes a long time because it rebuilds just about everything in the process. Once the bench update is done, you can open a browser and login to the system as the Administrator and let the startup wizard finish setting up the database and configuring the system for you.

One additional note…

The Setup Wizard that runs during your first Administrator login, will sometimes take to long to complete and it may timeout. If that happens, do not be alarmed, just click on the “Retry” link in the timeout message and it should be able to finish it’s work and get you into the system to start your work.

Hope this helps someone else. I was stuck for a while today. This may only be necessary for a short while as we hope the original playbooks problems are fixed soon.

BKM

14 Likes

Off topic

Did you know there’s directory stack commands available (if not pre-installed) for linux?

Instead of …

cd /tmp/.bench/playbooks/roles/nodejs/tasks
sudo mv main.yml main_yml.orig
cd ~
sudo apt-get install nodejs

… you can do …

pushd /tmp/.bench/playbooks/roles/nodejs/tasks
sudo mv main.yml main_yml.orig
popd;
sudo apt-get install nodejs
1 Like

Yup. I know they are available.

However, they do not exist by default is every VPS starting image. In fact sometimes there are simple things like some core python libraries that are also not included. Many of the VPS server images are minimalistic to allow the user to configure their OS for optimum performance and disk usage.

To that end, I always try to write my instructions with bash commands that are the most likely to be available to even the most minimal of systems. Otherwise I run the risk of alienating some of the newest users that might not have enough experience with Linux to know these things.

So, yes there are shortcuts, but I will ALWAYS default to the commands that I know should work without stranding the newbie user.

It is just good forum practice in my view.

Plus, trying to educate a newbie user on the concept of the stack is not the simplest thing in the world. That is why the original HP calculators were abandoned in the 1970’s. They were very efficient at their calculating abilities for complex equations, but people could not grasp the concept of the ordered stack. So the simple scientific calculator model was born.

BKM :grin:

BKM

1 Like

Yeah. I had TI-59. I didn’t care about math, but writing programs and saving on those magnetic strips – that was cool.

As usual, @bkm to the rescue!!! Everytime there’s an issue with installation you could always trust he would find a way out! Been relying on your installation solutions since v10!!! Thanks to your hardwork i can finally get my instance running after nearly two weeks of trying!

Thanks for the work you do bro! It’s much appreciated.

A little off topic, DigitalOcean essentially broke me today. They turned off my droplet cos of some “DDoS” attack coming from my droplet. I troubleshooted and couldn’t find any intrusion and they wouldn’t turn on my network so i could retrieve my data. Essentially lost one whole day of work. I had to create another instance using a backup 24 hours old. I’m dropping them and moving elsewhere.

Well, I appreciate the vote of confidence, but I was aided last night by some other knights in shining armor @MartinHBramwell and @warsmith

@warsmith was able to find the clues from a @Muzzy post that we needed to get this to work.

As for DO, I tried them once and found their customer service to be lacking. The service I use now is fairly quick to push issues up to the top problem solvers for me and I really appreciate them for it.

Good luck on your installs. :smiley:

BKM

2 Likes

This is my first support experience with them and it’s pretty awful. I’ll move over to another host over the weekend. But in the meantime, any tips on how i can set up hourly backup? I feel if i didn’t rely on daily backup i wouldn’t be in this mess.

Have you looked at this yet?

I use this to run an hourly backup of all data and and support files, then transmit them to both a second “hot spare” host and a storage host to keep multiple backups.

As for the rest of the server, I use a service that allows me to keep an image backup of a functioning server on hand. In the event of a disaster, I can open a ticket to have them restore the image to another server instance. Then I just restore one of my hourly data backups to be back online.

During the down time I just have the client switch their logins to the hot spare host until the primary host is rebuilt on new hardware.

So for example, if I have a primary host called myerpsystem.com then I would have a duplicate of that running all the time called backup.myerpsystem.com that the users can log into in the event of a major disaster. The hot spare is never more than an hour behind.

Maybe you can do something similar.

BKM

I will defintely give this a try! Thanks a lot.

What service are you currently using? I’m still on DO and always looking for a better option also thanks for posting the backup tutorial.

W.r.t Digital Ocean …

Check this out :

VPS service providers shutting down notice - #7 by MartinHBramwell

I’m so pleased with that supplier, I’m going to keep boosting them 'til someone tells me to shut up, Disclaimer: my only connection with them is as a customer for many years.

In the USA, on the east coast I am using interserver.net and on the west coast I am still experimenting with desivps.com. My west coast servers are not as robust as the east coast provider, so I may still move to another west coast provider later.

I am still looking for reliable servers in Chicago and and Texas but nothing worth mentioning yet.

BKM

1 Like

I dumped GCP over the same concerns that @flexy2ky was having with DO. I went to DO for a short while but could not get consistent customer service so I left. I think sometimes their decisions are a bit “random” and not really focused on providing the best service, but that was only my experience.

BKM

@bkm I must say a lot of research and work went into the Poor Man’s Backup System you built. It’s quite extensive and surely a better option than Dropbox backup system. However, is it possible to adapt this to say, a file storage service like S3 or something else.

Restoring to a backup server is by far the most sane and safe thing to do but in a case where i don’t want to set up backup servers but need hourly backup to restore where necessary, will it be possible to adapt this? (Disclaimer: I have migrated to AWS and i have created a snapshot of my server which i plan to update monthly). I don’t want to maintain multiple servers or keep an online snapshot which auto updates so in case something breaks, i can just restore from a snapshot and load the latest backup.

Let me know if this is at all possible. Thanks

The ony thing different between what you want to do and what I did i the poor man system is I use a live backup (and a storage site) you just want a storage site. In that case, any storage location is fine. You problem only arises in the ability to automatically sort the backup files to keep the only the most recent. S3, like Dropbox, is only a storage location and not a full linux environment, This means that you cannot run the sorting scripts and the cron jobs from within S3.

It is only a storage location that you would have to go into to sort the files yourself. They may have some rudimentary ability to delete all but the last X number of files.

The scripts on the host would remain basically the same. The only thing you would do is replace the “scp” command with whatever command you use to transfer the file to your S3 storage.

Again you woud have to work out how to keep them sorted on the S3 box.

Altenatively, you could also get yourself a very cheap OpenVZ server that only has 1gb of memory and maybe 30gb of disk It would be able to run the sorting scripts and keep very good track of your backup files (even if there is no erpnext system there to use them. It would still be just happy storing and sorting once per hour. I have a similar server that does nothing but receive the files and sort them in case I need one someday. I tink it cost me about $24 per year for that particular server. I have only ever had to recall a file from it one time in the past year, but that one file saved me 6 days of rework so that one event was worth the $24 I paid for the year.

I use this storage server to hold the backups from 4 other erpnext sites. I give each one a directory in the default user home directory and the sorting scripts take care of the rest

As always, Your mileage may vary… :sunglasses:

BKM

1 Like