Complete documentation and instal of CartoDB server (3.12.4+) on CentOS 7.3.1611 (x86_64) -- 2

All of the below specs have to be fulfilled in order to receive payment: Prerequisites: • You will be working on your own virtual servers (CentOS 7.3.1611 in Virtualbox or equivalent virtualisation platform) • You will be using the most recent master branch from [login to view URL] and working with CentOS 7.3 Provisioning details: • Server will be provisioned with fully operational and configured Passenger and NGINX ([login to view URL]) as proxy for cartodb server working on both http (80) and https (443) • Servers will be fully accessible at unique URL ([login to view URL] for production mode and [login to view URL] for development mode) on ports 80 / 443 from all clients without any client-side configuration. Server configuration process for secure certificates will use [login to view URL] and detail the process of acquiring and installing certificates. • The whole server stack will run under a "carto" user account, server files will be installed to /opt or /var as appropriate, configuration to /etc and log files to /var/log • The server will be configured with proper Redis persistence (as a production service) as per [login to view URL] • PostgreSQL server will be provisioned on a separate virtual server • Server will use systemctl systemd scripts for complete CartoDB stack in production mode including: (1) CartoDB editor http server (2) Carto editor background jobs (resque) (3) Maps API (windshaft) (4) SQL API (5) Redis server Systemctl scripts will successfully start up the whole server stack automatically on server reboot and save output to logfiles in /var/log. • documentation and process should detail methods of installation which work fully for development AND production mode • Carto, NGINX and passenger need to be configured so that other web-apps (using docker, rails, etc.) can be served on the same device using different subdomains Testing: Server should be "fully functional", which means: (1) working web-frontend (as in [login to view URL]) (2) with successful login for at minimum two users (including "development") and at minimum two orgs (see here: [login to view URL]); (3) successful import of: (a) geojson and csv test datasets (chosen from [login to view URL]) and (c) import and sync of ArcGIS server data set ([login to view URL]) (4) cartodb configured to work with external postgresql server on separate virtual server (rather than localhost database) with postgresql accessible via API to remote calls ([login to view URL]) (5) carto server will successfully send notification emails using custom SMTP server Work delivery: • Full documentation of workflow / configuration will be provided in markdown format. You will submit change requests using [login to view URL] ([login to view URL]) which will complete and correct the existing documentation at [login to view URL] as necessary to reproduce a successful install. • You will write two shell scripts that perform installation and configuration from scratch on CentOS server for development and production (as specified above) • You will create a set of git repositories on gitlab repo, which contains all code needed to do the full install of cartodb on centos7 (as above) without errors • All scripts and changed files will be uploaded to gitlab repo and the abovementioned install script will use those repos automatically.