Proposed Architecture
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 addhost 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
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
...