[ gpsdrive ] ERROR while running 'sudo -u osm /usr/bin/osm2pgsql --database

[gpsdrive at ostertag.name]

Am Freitag, 12. September 2008 13:57 schrieb carlo mecozzi:
> on ubuntu 8.04.1 i386 I get This error launching mapnik-osm-updater.sh :

please run as user root not with sudo. (This still needs fixing as I remember)
which options did you specify?
	'sudo -u osm /usr/bin/osm2pgsql --database
sounds incomplete.
Recomended usage would look like:
	su - bash
	/usr/bin/osm2pgsql --all-planet-geofabrik=europe/germany

Please also read this part of --help:
	!!! Warning: This Script is for now a quick hack to make setting up
	!!! Warning: My databases easier. Please check if it really works for you!!
	!!! Warning: Especially when using different Database names or username, ...
	!!! Warning: not every combination of values except the default is tested.
	
	    This script tries to install the mapnik database.
	    For this it first creates a new user osm on the system
	    and mirrors the current planet to his home directory.
	    Then this planet is imported into the postgis Database from a 
	    newly created user named osm
	
	    This script uses sudo. So you either have to have sudo right or you'll 
	    have to start the script as root. The users needed will be postgres and 	
	    osm
    


> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> ----- Create Database-user 'osm'
>
> ----- Grant rights on Database 'gis' for 'osm'
> ERROR:  la relazione "geometry_columns" non esiste
> ERROR:  la relazione "spatial_ref_sys" non esiste
> Create DB User for every USER
> all_users: nobody
> carlo
> osm
> 	Create DB User for carlo
> createuser: creation of new role failed: ERROR:  role "carlo" already
> exists
> -------- GRANT Rights to every USER
> Granting rights to users: ' carlo'
> Granting all rights to user 'carlo' for Database 'gis'
> ERROR:  la relazione "geometry_columns" non esiste
> ERROR:  la relazione "spatial_ref_sys" non esiste
> ERROR:  la relazione "planet_osm_line" non esiste
> ERROR:  la relazione "planet_osm_point" non esiste
>
> --------- Unpack and import /home/osm/osm/planet/italy.osm.bz2
> osm2pgsql SVN version 0.55-20080910 $Rev: 10464 $
>
> Using projection SRS 900913 (Spherical Mercator)
> Setting up table: planet_osm_point
> SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT',
> 2 );
>  failed: ERROR:  la funzione addgeometrycolumn(unknown, unknown,
> integer, unknown, integer) non esiste
> LINE 1: SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, ...
>                ^
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
>
> Error occurred, cleaning up
> !!!!!!!! ERROR while running 'sudo -u osm /usr/bin/osm2pgsql --database
> gis /home/osm/osm/planet/italy.osm.bz2'
> Creation with for Database gis from planet-file
> '/home/osm/osm/planet/italy.osm.bz2' with '/usr/bin/osm2pgsql' Failed
> see Logfile for more Information:
> less /var/log/osm2pgsql_postgis-gis.log
> carlo at ubuntu-desktop:~$
>
> this is /vat/log/osm2pgsql_postgis-gis.log
>
> Import started: ven set 12 08:58:23 CEST 2008
> ven set 12 08:58:24 CEST 2008: Import With Error 1:
> -rw-r--r-- 1 root root 29785420 2008-09-12
> 04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
> Import started: ven set 12 09:04:27 CEST 2008
> ven set 12 09:04:27 CEST 2008: Import With Error 1:
> -rw-r--r-- 1 osm root 29785420 2008-09-12
> 04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
> Import started: ven set 12 09:06:42 CEST 2008
> ven set 12 09:06:42 CEST 2008: Import With Error 1:
> -rw-r--r-- 1 osm root 29785420 2008-09-12
> 04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
> Import started: ven set 12 09:18:40 CEST 2008
> ven set 12 09:18:40 CEST 2008: Import With Error 1:
> -rw-r--r-- 1 osm root 29785420 2008-09-12
> 04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
> Import started: ven set 12 13:47:37 CEST 2008
> ven set 12 13:47:37 CEST 2008: Import With Error 1:
> -rw-r--r-- 1 osm root 29785420 2008-09-12
> 04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
> Import started: ven set 12 13:50:37 CEST 2008
> ven set 12 13:50:37 CEST 2008: Import With Error 1:
> -rw-r--r-- 1 osm root 29785420 2008-09-12
> 04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
>
>
> thanks
>
>
> _______________________________________________
> GPSdrive mailing list
> GPSdrive at lists.gpsdrivers.org
> http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

-- 
Jörg Ostertag (Tettnang)