#!/bin/sh
echo
echo "instala as dependencias e i3geo em uma distribuicao nova"
echo "nao rode em uma instalacao que ja contem o i3geo"
echo "sudo ./instalasw.sh"
echo "wget http://edmarmoretti.com.br/i3geo/instalsw.sh"

echo "==============================================================="

apt-get --assume-yes install apache2 apache2-doc apache2-utils

apt-get --assume-yes install cgi-mapserver mapserver-bin

apt-get --assume-yes install postgresql postgis postgresql-9.1-postgis pgadmin3

apt-get --assume-yes install sqlite

apt-get --assume-yes install r-base r-base-core r-cran-maptools

apt-get --assume-yes install libapache2-mod-php5 php5 php5-json php5-common php5-curl php5-dev php5-gd php5-mapscript php5-odbc php5-pgsql php5-ps php5-xmlrpc php5-xsl php5-sqlite php5-imagick

apt-get --assume-yes install subversion

apt-get clean

svn checkout "http://svn.softwarepublico.gov.br/svn/i3geo/subgrupos/i3geo" /var/www --username i3geosaude --password i3geosaude --non-interactive

cd /tmp

mkdir temp

svn checkout "http://svn.softwarepublico.gov.br/svn/i3geo/subgrupos/i3geosaude" /tmp/temp --username i3geosaude --password i3geosaude --non-interactive

chmod -R u=rw,g=rw,o=rw /var/www

mkdir /tmp/ms_tmp

chmod -R u=rw,g=rw,o=rw /tmp/ms_tmp

ln -s /tmp/ms_tmp /var/www/ms_tmp

chmod -R u=rw,g=rw,o=rw /var/www/ms_tmp

su postgres -c "psql -c \"ALTER USER postgres WITH PASSWORD 'postgres'\""

su postgres -c "createdb i3geosaude"

su postgres -c "createlang -d i3geosaude plpgsql"

su postgres -c "psql -d i3geosaude -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql"

su postgres -c "psql -d i3geosaude -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql"

su postgres -c "psql -d i3geosaude -c 'GRANT ALL ON geometry_columns TO PUBLIC;'"

su postgres -c "psql -d i3geosaude -c 'GRANT ALL ON geography_columns TO PUBLIC;'"

su postgres -c "psql -d i3geosaude -c 'GRANT ALL ON spatial_ref_sys TO PUBLIC;'"

/usr/bin/pg_restore --host localhost --port 5432 --username "postgres" --dbname "i3geosaude" --no-password --schema-only --list "/var/www/databasei3geosaude.backup"

/usr/bin/pg_restore --host localhost --port 5432 --username "postgres" --dbname "i3geosaude" --no-password --data-only --list "/var/www/databasei3geosaude.backup"


rm -Rf /tmp/temp