(originally published 2014-11-15)
In my previous post, you may recall I connected for the first time to the new server, and logged in as Administrator. Now the Setup Wizard walks me through the setup procedure.
- Language: English
- Initial administrator user: email@example.com (I may change this some day to an SCC employee, likely Tom, Ned or Mary)
- Country, timezone and currency
- Country: Canada
- Default Currency: CAD
- Time Zone: America/Edmonton
- Company: Swift Construction Company
- Company Abbreviation: SCC
- Financial Year Start Date: 01-01-2017
- Financial Year End Date: 12-31-2017
- What does it do: “Wonderful Advances in Land and Sea Locomotion.”
- Letter and Logo images (not requested in latest version of installer)
- Taxes (not requested in latest version of installer)
- Products and Services
- Added PN 20000003 (“PCA, AIRCRAFT WIRELESS”), which is sold and purchased as described (Group: Products, UOM: Unit)
- Backup the database again (using cli, see previous post)
This seems to be enough to get things going. I need to import all the SCC parts next.
Creating and logging in as a new user seems to remove the original “Administrator” user.
For followers of this saga, I started trying to install ERPNext on bare-metal FreeBSD, but ran into errors. No solution yet, so changing course slightly. I signed up for a server on DigitalOcean. It’s a pretty good deal, for $5 a month for one CPU, 512MB RAM and a 20 GB SSD. It’s basically the same as the old desktop serving dalescott.net, or the performance of a vm running in VirtualBox under Windows on my T61 ThinkPad. I also had a $10 promo code; I still had to put in $5 of my own, but I should get 3 months for $5, pretty good. I had to pick CentOS 7 instead of FreeBSD 10 (ERPNext and DigitalOcean constraints, and chosing RH for corporate familiarity), oh well….
Here are my steps, described very briefly:
- copy my public ssh key to my DigitalOcean account (copy/paste from the PuTTYgen window, NOT the Save Public Key button!)
- create droplet: 512 MB / 1 CPU, 20 GB SSD, 1000 GB Transfer, New York server, CentOS 7.0 x64, and use my ssh key.
- connect to the new server using PuTTY on my Windows laptop
- I was emailed a password, but it doesn’t seem to work, I muddled around a bit and destroyed my first droplet, so perhaps the password is for that droplet – if the second droplet got the same IP address as the destroyed one)
- follow Easy Way in ERPNExt frappe bench README.md
- wkhtmltopdf couldn’t be installed and was skipped (too bad, I need that!)
- “pip-2.7 not found”, but reading setup_frappe.sh, this seems informational and not an issue
- point browser at the server ip address
- server produced ERPNext login screen, so it seems the basics are working.
- install wkhtmltopdf manually (appears the project has changed its hosting recently)
- got a LOT of “unable to allocate memory” error messages, but wkhtmltopdf seems OK (created test page, assuming errors are due to not being able to load some user thumbnail pics)
- Access the server from a browser (port 80), and sign into ERPNext as “Adminstrator” using the password output at the end of the setup_frappe.sh execution.
- Backup the database after completing the setup wizard.
[root@firefly ~]# wget https://raw.githubusercontent.com/frappe/bench/master/install_scripts/setup_frappe.sh
--2014-11-14 22:57:47-- https://raw.githubusercontent.com/frappe/bench/master/install_scripts/setup_frappe.sh
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 18.104.22.168
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|22.214.171.124|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11601 (11K) [text/plain]
Saving to: ‘setup_frappe.sh’
100%[============================================================>] 11,601 --.-K/s in 0s
2014-11-14 22:57:47 (37.0 MB/s) - ‘setup_frappe.sh’ saved [11601/11601]
[root@firefly ~]# sudo bash setup_frappe.sh --setup-production
Installing for centos 7 amd64 In case you encounter an error, you can post on https://discuss.frappe.io
Adding centos mariadb repo
Installing packages for centos. This might take time...
Cannot install wkhtmltodpdf. Skipping...
Configuring CentOS services
Adding frappe user
setup_frappe.sh: line 300: hash: pip-2.7: not found
Installing frappe-bench Setting up first site
Frappe/ERPNext is installed successfully and is running on port 80.
Frappe password: xxxxxxxxxxxxxxxx
MariaDB root password: xxxxxxxxxxxxxxxx
Administrator password: xxxxxxxxxxxxxxxx
The passwords are also stored at ~/frappe_passwords.txt
You can remove this file after making a note of the passwords.
[root@firefly ~]# wget http://downloads.sourceforge.net/project/wkhtmltopdf/0.12.1/wkhtmltox-0.12.1_linux-centos7-amd64.rpm
--2014-11-14 23:30:03-- http://downloads.sourceforge.net/project/wkhtmltopdf/0.12.1/wkhtmltox-0.12.1_linux-centos7-amd64.rpm
Resolving downloads.sourceforge.net (downloads.sourceforge.net)... 126.96.36.199
Connecting to downloads.sourceforge.net (downloads.sourceforge.net)|188.8.131.52|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://softlayer-dal.dl.sourceforge.net/project/wkhtmltopdf/0.12.1/wkhtmltox-0.12.1_linux-centos7-amd64.rpm [following]
--2014-11-14 23:30:03-- http://softlayer-dal.dl.sourceforge.net/project/wkhtmltopdf/0.12.1/wkhtmltox-0.12.1_linux-centos7-amd64.rpm
Resolving softlayer-dal.dl.sourceforge.net (softlayer-dal.dl.sourceforge.net)... 184.108.40.206
Connecting to softlayer-dal.dl.sourceforge.net (softlayer-dal.dl.sourceforge.net)|220.127.116.11|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 14258268 (14M) [application/octet-stream]
Saving to: ‘wkhtmltox-0.12.1_linux-centos7-amd64.rpm’
100%[=============================================================================================================>] 14,258,268 5.16MB/s in 2.6s
2014-11-14 23:30:06 (5.16 MB/s) - ‘wkhtmltox-0.12.1_linux-centos7-amd64.rpm’ saved [14258268/14258268]
[root@firefly ~]# rpm -ivh wkhtmltox-0.12.1_linux-centos7-amd64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:wkhtmltox-1:0.12.1-1 ################################# [100%]
[root@firefly ~]# yum install fontconfig libXrender libXext '*fonts*' openssl
Lots and LOTS of fonts appear to be installed, but at the end there are a LOT of "[Errno 5] [Errno 12] Cannot allocate memory"
[root@firefly ~]# wkhtmltopdf --version
wkhtmltopdf 0.12.1 (with patched qt)
[root@firefly ~]# wkhtmltopdf http://www.tecmint.com/install-eclipse-classic-in-rhel-centos-fedora/ ./install-eclipse.pdf
Loading pages (1/6)
Warning: A finished ResourceObject received a loading finished signal. This migth be an indication of an iframe taking to long to load.
Warning: A finished ResourceObject received a loading progress signal. This migth be an indication of an iframe taking to long to load.
Counting pages (2/6)
Resolving links (4/6)
Loading headers and footers (5/6)
Printing pages (6/6)
Exit with code 1 due to network error: UnknownNetworkError
systemctl status mariadb.service
mysqldump -u root -p --databases site1.local > ~/erpnextbkup/erpnext-1.sql
mysql -u root -p site1.local < ~/erpnextbkup/erpnext-1.sql
Maestro is moving from a green-field project using the Yii framework to the ERP-like Tryton framework. The Maestro SCC demo will be available again shortly.
- Includes full BoM structure for SCC Aircraft Wireless.
- Initial release to accompany blog post Serialized Workflow in OpenERP (unreleased).
- Login as admin/appleton (all other user passwords are “maestro” and their Access Rights will likely need changing before they can do much).
- New (empty) database with following Apps installed:
- Remove openerp.com bindings
- Sales Management
- Project Management
- Issue Tracker
- Base Import
- Document Management System