This is an automated email from the git hooks/post-receive script.

rubund-guest pushed a commit to branch master
in repository osm-tile-server.

commit ed808d94138814d926e26f7eb27533f308c9ca62
Author: Ruben Undheim <ruben.undh...@gmail.com>
Date:   Wed Sep 2 21:41:58 2015 +0000

    Creating db
---
 debian/control                         |  4 +-
 debian/osm-tile-server-config.postinst | 76 ++++++++++++++--------------------
 2 files changed, 34 insertions(+), 46 deletions(-)

diff --git a/debian/control b/debian/control
index 08b1cdd..3e9d9f8 100644
--- a/debian/control
+++ b/debian/control
@@ -8,13 +8,13 @@ Standards-Version: 3.9.6
 Package: osm-tile-server-base
 Architecture: all
 Depends: ${shlibs:Depends}, ${misc:Depends},
-        osm-tile-server-config
+        osm-tile-server-config, openstreetmap-carto, node-carto, osm2pgsql
 Description: Common files for OSM tile server
 
 Package: osm-tile-server-config
 Architecture: all
 Depends: ${shlibs:Depends}, ${misc:Depends},
-        postgis, postgresql-contrib 
+        postgis, postgresql-contrib
 Description: This package contains the main configuration of the OSM tile 
server
 
 Package: osm-tile-server-tilelite
diff --git a/debian/osm-tile-server-config.postinst 
b/debian/osm-tile-server-config.postinst
index e7b314f..daccb1c 100644
--- a/debian/osm-tile-server-config.postinst
+++ b/debian/osm-tile-server-config.postinst
@@ -24,50 +24,38 @@ case "$1" in
     configure)
         #db_get osm-tile-server/db-name
         #DBNAME=$RET
-        #db_get osm-tile-server/db-password
-        #PASSWORD=$RET
-        #db_get osm-tile-server/db-user
-        #DBUSER=$RET
-        #db_get osm-tile-server/root-password
-        #ROOTPASSWORD=$RET
-        #RES=$(echo "select schema_name from information_schema.schemata where 
schema_name = '$DBNAME';" | mysql -h localhost -u root -p$ROOTPASSWORD mysql)
-        #if [ "$RES" = "" ] ; then
-        #    echo "Database does not exist. Creating..."
-        #    echo "create database $DBNAME;" | mysql -h localhost -u root 
-p$ROOTPASSWORD mysql
-        #    echo "grant all on ${DBNAME}.* to ${DBUSER} identified by 
'${PASSWORD}';" | mysql -h localhost -u root -p$ROOTPASSWORD mysql
-        #else
-        #    echo "Database $DBNAME exists already. Skipping setup"
-        #fi
-        #sed -i 's/DBNAME=.*$/DBNAME='$DBNAME'/' /etc/osm-tile-server.conf
-        #sed -i 's/DBUSER=.*$/DBUSER='$DBUSER'/' /etc/osm-tile-server.conf
-        #sed -i 's/DBPASS=.*$/DBPASS='$PASSWORD'/' /etc/osm-tile-server.conf
-        #sed -i 's/database =.*$/database = '$DBNAME'/' 
/etc/osm-tile-server.mysql.cnf
-        #sed -i 's/user =.*$/user = '$DBUSER'/' /etc/osm-tile-server.mysql.cnf
-        #sed -i 's/password =.*$/password = '$PASSWORD'/' 
/etc/osm-tile-server.mysql.cnf
-        #sed -i "s/\$dbuser = .*$/\$dbuser = '"$DBUSER"';/" 
/usr/share/websites/naturfakta/www/versions/mysql.php
-        #sed -i "s/\$dbpass = .*$/\$dbpass = '"$PASSWORD"';/" 
/usr/share/websites/naturfakta/www/versions/mysql.php
-        #sed -i "s/\$dbname = .*$/\$dbname = '"$DBNAME"';/" 
/usr/share/websites/naturfakta/www/versions/mysql.php
-        #sed -i "s/\$dbuser = .*$/\$dbuser = '"$DBUSER"';/" 
/usr/share/websites/naturfakta/www/edit/mysql.php
-        #sed -i "s/\$dbpass = .*$/\$dbpass = '"$PASSWORD"';/" 
/usr/share/websites/naturfakta/www/edit/mysql.php
-        #sed -i "s/\$dbname = .*$/\$dbname = '"$DBNAME"';/" 
/usr/share/websites/naturfakta/www/edit/mysql.php
-        #sed -i "s/sqldbname = .*$/sqldbname = '"$DBNAME"';/" 
/usr/lib/osm-tile-server/python/mypasswords.py
-        #sed -i "s/sqlpass = .*$/sqlpass = '"$PASSWORD"';/" 
/usr/lib/osm-tile-server/python/mypasswords.py
-        #sed -i "s/sqldbuser = .*$/sqldbuser = '"$DBUSER"';/" 
/usr/lib/osm-tile-server/python/mypasswords.py
-        #db_get osm-tile-server/enable
-        #ENABLENOW=$RET
-        #if [ "$ENABLENOW" = "true" ] ; then
-        #    echo "Enabling site now"
-        #    a2ensite naturfakta.conf
-        #    a2enmod rewrite
-        #    a2enmod ssl
-        #    a2enmod wsgi
-        #fi
-        ##db_get osm-tile-server/path
-        ##PICTUREPATH=$RET
-        ##ln -sf $PICTUREPATH /var/www/packages/bilder/www/bilder
-        #chown -R www-data:www-data /var/cache/naturfakta
-        #cp /usr/share/osm-tile-server/keys/check.php 
/usr/share/osm-tile-server/keys/.htaccess /var/lib/osm-tile-server/keys/
-        #ln -sf /usr/share/websites/naturfakta/www/versions/bimage.php 
/var/lib/osm-tile-server/images/bimage.php
+
+        if ! getent group osm >/dev/null; then
+            addgroup --system osm >/dev/null
+        fi
+    
+        if ! getent passwd osm >/dev/null; then
+            adduser \
+                --system \
+                --disabled-login \
+                --ingroup osm \
+                --home /var/lib/osm-tile-server-user \
+                --gecos "osm tile server user" \
+                --shell /bin/bash \
+                osm >/dev/null
+        fi
+
+
+        echo "Checking user:"
+        set +e
+        su postgres -c "cd /var/lib/postgresql ; psql postgres -tAc \"SELECT 1 
FROM pg_roles WHERE rolname='osm'\"" | grep -q 1
+        USEREXISTS=$?
+        set -e
+        if [ "$USEREXISTS" = "0" ] ; then
+            echo "User already exists"
+        else
+            su postgres -c "cd /var/lib/postgresql ; createuser osm"
+            su postgres -c "cd /var/lib/postgresql ; createdb -E UTF8 -O osm 
osmdb"
+            su postgres -c "cd /var/lib/postgresql ; psql -c \"CREATE 
EXTENSION hstore;\" -d osmdb"
+            su postgres -c "cd /var/lib/postgresql ; psql -c \"CREATE 
EXTENSION postgis;\" -d osmdb"
+        fi
+   
+        
     ;;
 
     abort-upgrade|abort-remove|abort-deconfigure)

-- 
Alioth's /usr/local/bin/git-commit-notice on 
/srv/git.debian.org/git/pkg-grass/osm-tile-server.git

_______________________________________________
Pkg-grass-devel mailing list
Pkg-grass-devel@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel

Reply via email to