Setting up geonode

This is the fast install from GeoNode.org Quickstart. Full install instructions, including installation of PostGIS, can be found in this Admin tutorial

Install from PPA in Ubuntu 12.04 -> see http://docs.geonode.org/en/latest/intro/install.html
- sudo add-apt-repository ppa:geonode/release . Note, if add-apt does not work (command not found) then do first sudo apt-get update && sudo apt-get install python-software-properties
- sudo apt-get update
- sudo apt-get install geonode (before I could run this I had do to do sudo apt-get install libtomcat7-java so that Tomcat6 will be removed and then I could install tomcat7 - which was needed to for GeoServer - used by GeoNode)
Set the IP address and create a superuser (also described here: http://docs.geonode.org/en/latest/deploy/production.html)
- sudo geonode-updateip 127.0.0.1 (Use the real IP if you have one)
- geonode createsuperuser.
- set GeoServer ProxyURL as described in the geonode install instructions. Use user admin with geoserver.
- If starting up Apache results in the following message: "Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName.", Then do this
Import data

Read the admin docs and also OSGeo Live DVD Quickstart tutorial

note, for assiging geoserver tomcat memory, do it for tomcat7 as described for tomcat6 (see OSGeo VM) using setenv.sh but in /usr/share/tomcat7/bin

Notes on installing PostGIS

To check if postgres exists, use which psql which should return the path. Then with the path I did /usr/bin/psql --version

to retrieve the version installed.

So, Postgres 9.1 was installed, but when I executed "psql" I got this: psql: FATAL: role "ssteinig" does not exist
Hence, I first had to creating my account as a user using sudo -u postgres createuser -s $USER (got this from here).
Now I could create a db using createdb mygeodb, and connect via commandline with psql -d mygeodb
Finally I spatially enabled the db with CREATE EXTENSION postgis; and CREATE EXTENSION postgis_topology;
- However, for CREATE EXTENSION postgis; I got the following error: "ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/postgis.control": No such file or directory".
- This may be solved using the install instructions from here: http://wiki.postgresql.org/wiki/Apt
- However, I followed now what is written here: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt
- the stuff described below did not work either, I think:
  - echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" | sudo tee /etc/apt/sources.list.d/postgis.list
  - sudo apt-get update
  - sudo apt-get install postgresql-9.3 pgadmin3
  - and then...., I got again an error: update-alternatives: error: alternative pg_basebackup.1.gz can't be slave of psql.1.gz: it is a slave of postmaster.1.gz, which send me to this page: http://www.postgresql.org/message-id/20130508192711.GA9243@msgid.df7cb.de
then add a Postgres/postgis port forwarding rule for port 5432

modify settings in "/etc/geonode/local_settings.py" (before first use of db)
the changes may require to run geonode syncdb --noinput --all (and perhaps a tomcat7/apache2 restart?) to sync
if the db contains data/layers already (e.g. geonodegisb93 > schemata > public > tables), and those should be visible again from GeoNode, then
- each table/layer needs to be published (re-loaded) in GeoServer and
- geonode updatelayers command needs to be run.

create user: sudo su - postgres
and: createuser -d -E -i -l -P -r -s sstein
to access via terminal use psql -U sstein -d geonode -h localhost
to access via pgAdmin:
- edit the file /etc/postgresql/9.1/main/postgresql.conf and /etc/postgresql/9.1/main/pg_hba.conf , see http://www.glom.org/wiki/index.php?title=Initial_Postgres_Configuration
- restart postgres as follows: sudo /etc/init.d/postgresql restart

quit psql: \q
connecting: psql -U geonode93 -d geonodegisdb93 -h localhost -p 5432
listing of dbs: psql -l -p 5432<code> or <code>\l(including spec of port, as the PostGIS VM has postgres 9.1 (:9434) and 9.3 (:9432) installed)
- or alternatively: SELECT datname FROM pg_database WHERE datistemplate = false;
adding / removing users createuser and dropuser e.g.: dropuser geonode -p 5434 but needs to be done as "sudo su - postgres"
creating /removing dbs createdb and dropdb e.g.: createdb geonodegisdb93
listing of tables: \dt : but this will only list the table from the database currently connected to
- to see at least something (if nothing added yet) it can also be done using: SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;

The original documention on how to do this is here: http://docs.geonode.org/en/latest/deploy/customize.html. However, some things have changed for GeoNode v 2.0. So we have to do the following:

The static web documents are in /var/www/geonode/static/geonode. And CSS and images are in the subfolders /css and /img.
Create a new logo file. The original logo file is called logo.png and has a dimension of 127x29 px.
Create a subfolder in /etc/geonode/media/ => so we have now the folder /etc/geonode/media/geonode/img/
Make this img subfolder accessible for ftp (e.g. using chmod 777)
copy the new logo into the etc/.../img subfolder
run sudo geonode collectstatic -v0
this should copy the new logo image into /var/geonode/static/geonode/img/.