wiki:ethercalc

Maintaining ethercalc

We are running ethercalc (a spreadsheet/wiki web software) at https://calc.mayfirst.org/.

It depends on node.js.

It was installed by running, as the calc user on mchesney (and in the /home/calc):

npm install ethercalc

That created a directory structure in /home/calc/node_modules.

The init script is handled by runit and is located in /etc/sv/ethercalc. The run file is:

#!/bin/bash

exec 2>&1
exec chpst -e ./env -u calc:calc /usr/bin/nodejs /home/calc/node_modules/ethercalc/bin/ethercalc --basepath https://calc.mayfirst.org

And in the env directory, there is a file called NODE_ENV with the contents: production

We running apache which passed through traffic to ethercalc. The apache file (in site-enabled) has the following content:

<VirtualHost 209.234.253.233:443>
        # web config for calc.mayfirst.org
        ServerName calc.mayfirst.org
        # ServerAlias www.calc.mayfirst.org

        <Proxy *>
          Order deny,allow
          Allow from all
        </Proxy>

        #SSL Stuff
        SSLEngine On
        SSLProxyEngine On
	SSLCertificateFile /etc/letsencrypt/live/calc.mayfirst.org/fullchain.pem
        SSLCertificateKeyFile /etc/letsencrypt/live/calc.mayfirst.org/privkey.pem
        ProxyPreserveHost On
        ProxyRequests off
        ProxyPass / http://localhost:8000/
        ProxyPassReverse / http://localhost:8000/
</VirtualHost>

To update to the latest version of ethercalc, run the following command in /home/calc as the ethercalc user:

npm update

Then, restart ethercalc (as root):

sv restart ethercalc && systemctl restart apache2

Note: the current version of ethercalc only works because of a patch described here. If updated, you may need to edit the specified file by hand.

Last modified 3 years ago Last modified on Dec 5, 2016, 6:08:38 PM