Page History

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;'

• 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

• adduser clowder
• create dirs
  
  • sudo su clowder; mkdir cache clowder

  • 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

  • mongodbURI="mongodb://141.142.209.172:27017,141.142.209.173:27017,141.142.209.174:27017/gltg?replicaSet=GLTG&maxpoolsize=100"

• 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

• installed nginx
• played with config for proxy
  • able to redirect to clowder - but no styling
  • not able to set paths right yet