[Geocoding] [OSM-dev] Nominatim data import error: ERROR: DB Error: no such table

[Gabriel Rossetti]

Yes, I am using the latest version, I followed those instructions. I had 
added it (the osm2pgsql binary line) myself in the local.php file, it 
does the same thing if I comment it out. Here is the command line I am 
using (logged in as the postgres user):

./utils/setup.php --osm-file switzerland.osm --all

Here is my local.php file:

<?php
    // DB config
    @define('CONST_Database_DSN', 'pgsql://@/nominatim');
    // Paths
    @define('CONST_Postgresql_Version', '9.1');
    @define('CONST_Path_Postgresql_Contrib', 
'/usr/share/postgresql/'.CONST_Postgresql_Version.'/contrib');
    @define('CONST_Path_Postgresql_Postgis', 
CONST_Path_Postgresql_Contrib.'/postgis-1.5');
    //@define('CONST_Osm2pgsql_Binary', '/usr/bin/osm2pgsql');
    //@define('CONST_Osm2pgsql_Binary', 
'/opt/Nominatim/osm2pgsql/osm2pgsql');
    @define('CONST_Osmosis_Binary', '/usr/bin/osmosis');
    // Website settings
    @define('CONST_Website_BaseURL', 'http://localhost/nominatim/');

So, currently the only version of osm2pgsql that I have is the one I got 
from GIT using the instructions you have referred to.

Thanks,
Gabriel

On 07/15/2012 09:12 PM, datendelphin wrote:
> The path to osm2pgsql should be set correctly in the newest version of 
> nominatim. Are you using the most recent from git? Did you follow the 
> instructions on 
> http://wiki.openstreetmap.org/wiki/Nominatim/Installation? maybe post 
> the commandline you used and the local.php config file.
>
> also, I moved it to the geocoding mailing list.
>
> On 15.07.2012 18:27, Gabriel Rossetti wrote:
>> Yes, I tried that too, I uninstalled the APT installed version and 
>> modified the settings/local.php entry to point to the compiled 
>> version. Only difference is it says:
>>
>> osm2pgsql SVN version 0.80.0 (64bit id space)
>>
>> instead of:
>>
>> osm2pgsql SVN version 0.80.0 (32bit id space)
>>
>> but it still gives me the same error.
>>
>> On 07/15/2012 06:08 PM, Simon Poole wrote:
>>> You should be installing osm2pgsql from source, most recent version.
>>>
>>> See 
>>> http://wiki.openstreetmap.org/wiki/Nominatim/Installation#Compiling_the_Required_Software
>>>
>>> Simon
>>>
>>> Am 15.07.2012 17:37, schrieb Gabriel Rossetti:
>>>> Hi All,
>>>>
>>>> I was told to post my issue here. The original post is here:
>>>>
>>>> http://help.openstreetmap.org/questions/14238/nominatim-data-import-error-error-db-error-no-such-table
>>>>
>>>> When I try to import map data for Nominatim, I get the following error:
>>>>
>>>> ...
>>>> INSERT 0 1
>>>> INSERT 0 1
>>>> INSERT 0 1
>>>> INSERT 0 1
>>>> INSERT 0 1
>>>> INSERT 0 1
>>>> COMMIT
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> CREATE TABLE
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> SET
>>>> CREATE TABLE
>>>> ALTER TABLE
>>>> Import
>>>> Usage error. For further information see:
>>>>         osm2pgsql -h|--help
>>>> osm2pgsql SVN version 0.70.5
>>>>
>>>> ERROR: DB Error: no such table
>>>> DB Error: no such table
>>>>
>>>>
>>>> I get the same thing with osm2pgsql SVN version 0.80.0 (32bit id 
>>>> space). The 0.70.5 version is the one installed from Ubuntu's repos 
>>>> and the 0.80.0 version was intalled using the 
>>>> kakrueger/openstreetmap PPA as described here: 
>>>> http://wiki.openstreetmap.org/wiki/Osm2pgsql. Does anyone know why 
>>>> I get this?
>>>>
>>>> I'm running Ubuntu 12.04 64bit Server.
>>>>
>>>> Thanks,
>>>> Gabriel
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> dev mailing list
>>>> dev at openstreetmap.org
>>>> http://lists.openstreetmap.org/listinfo/dev
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> dev mailing list
>>> dev at openstreetmap.org
>>> http://lists.openstreetmap.org/listinfo/dev
>>
>>
>>
>>
>> _______________________________________________
>> dev mailing list
>> dev at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/dev


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120715/07fb64ff/attachment.html>