Proposed Architecture for Single Instance
Current Architectures as of 14-Dec-2017
Proposed Architectures
...
192.168.100.48
...
141.142.209.83
...
192.168.100.50
...
141.142.209.92
...
192.168.100.49
...
141.142.209.91
...
192.168.100.42
...
141.142.211.207
...
192.168.100.43
...
141.142.211.213
...
192.168.100.44
...
141.142.211.215
...
192.168.100.51
...
141.142.209.94
...
192.168.100.36
...
141.142.210.210
...
192.168.100.37
...
141.142.210.220
...
192.168.100.52
...
141.142.209.95
...
Development Timeline
...
141.142.209.176
...
Install Postgres and postgis
create/import database
create medici role and grant priviledges
...
- As Ubuntu user:
- sudo apt-get update
- sudo apt-get install postgresql postgresql-contrib
sudo apt-get install postgresql-9.5-postgis-2.2
- sudo -u postgres createuser --interactive
- medici
- superuser?: n
- create dbs?: n
- create new roles?: n
sudo -u postgres createdb geostream
sudo -u postgres psql -d geostream -c 'GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO medici;'
sudo -u postgres psql -d geostream -c 'GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO medici;'
copy over small db from local (change role of db to medici)
sudo -u postgres psql geostream < geostream_one_greon.sql
/etc/postgresql/9.5/main/postgres.conf add
listen_addresses = '*'
/etc/postgresql/9.5/main/pg_hba.conf add
host all all 0.0.0.0/0 md5
...
- create user gltgdev and grant permissions
- createuser gltgdev
ALTER USER gltgdev WITH ENCRYPTED PASSWORD 'password';
psql -h 141.142.209.176 -U gltgdev -d geostream
connect gltg-dev to gltg-postgres
in custom.conf (yay, it works)
postgres.user="gltgdev"
postgres.host="141.142.209.176"
postgres.password="*****"
...
sudo -u postgres createuser --interactive (add clowder)
sudo -u postgres psql -d geostream -c 'GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO clowder;'
sudo -u postgres psql -d geostream -c 'GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO clowder;'
...
- 141.142.209.172
- 141.142.209.173
- 141.142.209.174
...
- on gltg-dev
sudo mongodump --out /home/marcuss/backup/test_mongo_dump/test1
scp to target server
on gltg-mongo-1
sudo /var/lib/mongodb-mms-automation/mongodb-linux-x86_64-3.4.9/bin/mongorestore -d gltg --drop /home/ubuntu/test1/gltg
171027 - remember to use primary mongo shell
opening mongo shell gives warnings:
171102 - checked with rob - he's fixing stuff
...
- 141.142.210.210
...
chmod 755 cache/ clowder/
sudo chown :users cache clowder
...
sudo apt-get install default-jre
...
- copy /lib/systemd/system/clowder-service from gltg-dev
...
- not sure about - paticularly dmongouppate and dpostgresupdate:
ExecStart=/home/clowder/clowder/bin/clowder -DMONGOUPDATE=1 -DPOSTGRESUPDATE=1 -Dhttp.port=9001 -Dhttp.netty.maxInitialLineLength=8192 -Dapplication.context=/clowder/
...
- copy update_clowder.sh from gltg-dev
- run script by hand (line by line in shell)
...
Connecting to : mongodb://127.0.0.1:27017/clowder which makes sense as there is no local mongo - need to set custom connection to gltg-mongo-(1,2,3)
...
- made sure all clowder directory permissions are consistent with gltg-dev
- use ips install of domain names
./clowder -DMONGOUPDATE=1 -Dhttp.port=9001 -DPOSTGRESUPDATE=1 -Dhttp.netty.maxInitialLineLength=8192 -Dapplication.context=/clowder/
...
runs at http://141.142.210.210:9001/
seems not connected correctly to mongo
...
- in custom.conf changed to
...
- 141.142.210.220
...
- adduser clowder
- copy script 'update-geodashboard.sh' from gltg-dev and do in command line
- sudo apt-get install default-jre
- run geodashboard
...
- runs but not connected to clowder
...
- 141.142.209.19
...
- installed nginx
- played with config for proxy
- able to redirect to clowder - but no styling
- not able to set paths right yet
Subdomain
...
/var/www/html/test/test.html
Notes meeting Rob 171027
mongo - need to run commands in primary instance?
illinois - separate clowder and geodashboard servers, separate postgres and mongo databases on same servers
...