<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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):<br>
<br>
<font face="Courier New">./utils/setup.php --osm-file
switzerland.osm --all</font><br>
<br>
Here is my local.php file:<br>
<br>
<font face="Courier New"><?php<br>
// DB config<br>
@define('CONST_Database_DSN', 'pgsql://@/nominatim');<br>
// Paths<br>
@define('CONST_Postgresql_Version', '9.1');<br>
@define('CONST_Path_Postgresql_Contrib',
'/usr/share/postgresql/'.CONST_Postgresql_Version.'/contrib');<br>
@define('CONST_Path_Postgresql_Postgis',
CONST_Path_Postgresql_Contrib.'/postgis-1.5');<br>
//@define('CONST_Osm2pgsql_Binary', '/usr/bin/osm2pgsql');<br>
//@define('CONST_Osm2pgsql_Binary',
'/opt/Nominatim/osm2pgsql/osm2pgsql');<br>
@define('CONST_Osmosis_Binary', '/usr/bin/osmosis');<br>
// Website settings<br>
@define('CONST_Website_BaseURL', '<a
class="moz-txt-link-freetext"
href="http://localhost/nominatim/">http://localhost/nominatim/</a>');</font><br>
<br>
So, currently the only version of osm2pgsql that I have is the one
I got from GIT using the instructions you have referred to.<br>
<br>
Thanks,<br>
Gabriel<br>
<br>
On 07/15/2012 09:12 PM, datendelphin wrote:<br>
</div>
<blockquote cite="mid:5003161C.1070106@osm.datendelphin.net"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
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 <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://wiki.openstreetmap.org/wiki/Nominatim/Installation">http://wiki.openstreetmap.org/wiki/Nominatim/Installation</a>?
maybe post the commandline you used and the local.php config file.<br>
<br>
also, I moved it to the geocoding mailing list.<br>
<br>
On 15.07.2012 18:27, Gabriel Rossetti wrote:
<blockquote cite="mid:5002EF58.6090205@swissopt.ch" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">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:<br>
<br>
<font face="Courier New">osm2pgsql SVN version 0.80.0 (64bit
id space)<br>
<br>
</font>instead of:<font face="Courier New"><br>
<br>
</font><font face="Courier New">osm2pgsql SVN version 0.80.0
(32bit id space)</font><br>
<br>
but it still gives me the same error.<br>
<br>
On 07/15/2012 06:08 PM, Simon Poole wrote:<br>
</div>
<blockquote cite="mid:5002EAE4.50902@poole.ch" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">You should be installing
osm2pgsql from source, most recent version.<br>
<br>
See <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://wiki.openstreetmap.org/wiki/Nominatim/Installation#Compiling_the_Required_Software">http://wiki.openstreetmap.org/wiki/Nominatim/Installation#Compiling_the_Required_Software</a><br>
<br>
Simon<br>
<br>
Am 15.07.2012 17:37, schrieb Gabriel Rossetti:<br>
</div>
<blockquote cite="mid:5002E3D2.9090709@swissopt.ch"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Hi All,<br>
<br>
I was told to post my issue here. The original post is here:<br>
<br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://help.openstreetmap.org/questions/14238/nominatim-data-import-error-error-db-error-no-such-table">http://help.openstreetmap.org/questions/14238/nominatim-data-import-error-error-db-error-no-such-table</a><br>
<br>
When I try to import map data for Nominatim, I get the
following error:<br>
<br>
<font face="Courier New">...<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
COMMIT<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
CREATE TABLE<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
SET<br>
CREATE TABLE<br>
ALTER TABLE<br>
Import<br>
Usage error. For further information see:<br>
osm2pgsql -h|--help<br>
osm2pgsql SVN version 0.70.5<br>
<br>
ERROR: DB Error: no such table<br>
DB Error: no such table</font><br>
<br>
<br>
I get the same thing with <font face="Courier New">osm2pgsql
SVN version 0.80.0 (32bit id space)</font>. 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: <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://wiki.openstreetmap.org/wiki/Osm2pgsql">http://wiki.openstreetmap.org/wiki/Osm2pgsql</a>.
Does anyone know why I get this?<br>
<br>
I'm running Ubuntu 12.04 64bit Server.<br>
<br>
Thanks,<br>
Gabriel<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
dev mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/dev">http://lists.openstreetmap.org/listinfo/dev</a>
</pre>
</blockquote>
<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
dev mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/dev">http://lists.openstreetmap.org/listinfo/dev</a>
</pre>
</blockquote>
<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
dev mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/dev">http://lists.openstreetmap.org/listinfo/dev</a>
</pre>
</blockquote>
</blockquote>
<br>
<br>
</body>
</html>