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

[carlo mecozzi]

on ubuntu 8.04.1 i386 I get This error launching mapnik-osm-updater.sh :

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@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@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

[Joerg Ostertag (gpsdrive Tettnang/Germany)]

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@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@...
> http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

--
Jörg Ostertag (Tettnang)
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive