Configure GeoNode to use postgis and fix permission problems

[ingenieroariel]

Jeff Johnson provided a guide in ​https://gist.github.com/jj0hns0n/6058788

# set to use sqlite by default, cant create superuser cuz read-only db
# use postgres
sudo su - postgres
createuser geonode
psql -c "alter user geonode with encrypted password 'geonode';"
createdb -O geonode geonode
sudo vi /etc/postgresql/9.1/main/pg_hba.conf 
# change local access to password
sudo /etc/init.d/postgresql restart
 
# setup local_settings.py
cd /usr/lib/python2.7/dist-packages/geonode/
sudo wget https://raw.github.com/GeoNode/geonode/master/geonode/local_settings.py.sample
sudo mv local_settings.py.sample local_settings.py
sudo /etc/init.d/apache2 restart
 
# syncdb
django-admin syncdb --settings=geonode.settings --all
 
# create a superuser (one from fixtures doesnt seem to work)
django-admin createsuperuser --settings=geonode.settings
 
# change to port 8082 in settings.py
 
django-admin updatelayers --settings=geonode.settings
 
# make the uploaded dir
sudo mkdir /usr/lib/python2.7/dist-packages/geonode/uploaded
sudo chown user:user /usr/lib/python2.7/dist-packages/geonode/uploaded
 
# run updatelayers
django-admin updatelayers --settings=geonode.settings
 
# this will have created the dirs under uploaded to be owned by user 
# chown them to apache
sudo chown -R www-data:www-data /usr/lib/python2.7/dist-packages/geonode/uploaded
 
# collectstatic
django-admin collectstatic --settings=geonode.settings
 
# change apache entry to static_root
# line 21 change to static root
sudo vi /etc/apache2/sites-available/geonode
 
 
# bounce apache for good measure
sudo /etc/init.d/apache2 restart
 
#cp some shapefiles to your home dir to test upload
cp /usr/share/pyshared/django/contrib/gis/tests/data/interstates/* .
 
# test upload in browser

[kalxas]

(In [10493]) trying to fix #1168

[kalxas]

Trac should not close tickets automatically IMO

[kalxas]

This is now fixed in [10502]

TODO: run the following in the install_geonode.sh after bringing up GeoServer (the way Cartaro does)

django-admin updatelayers --settings=geonode.settings --ignore-errors

[kalxas]

GeoServer startup during build added in [10509]

TODO:

1. Add start/stop scripts to GeoNode and link on desktop.
2. Create a group in XFCE menu to include GeoNode launchers.

[kalxas]

start/stop scripts added in [10511]

[kalxas]

Launchers confirmed to work in build 10513

Actually we now use curl in geonode-start.sh to detect if GeoServer is up, something that Cartaro could now use in their script too.

#!/bin/bash
STAT=\`curl -s "http://localhost:8082/geoserver/ows" | grep 8082\`
if [ "\$STAT" = "" ]; then
    $GEOSERVER_PATH/bin/startup.sh &
    (sleep 2; echo "25"; sleep 2; echo "50"; sleep 2; echo "75"; sleep 2; echo "100") | zenity --progress --auto-close --text "GeoNode is starting GeoServer"
fi
firefox http://geonode/

[kalxas]

moving launcher group to another ticket