[Geocoding] [Nominatim] Table search_name empty after import
Duhail
jduhail at ausy-group.com
Fri Jul 26 09:12:09 UTC 2013
Hello,
First i apologize for my poer english.
I try make work Nominatim on a server not connect to internet. I follow
this wiki : http://wiki.openstreetmap.org/wiki/Nominatim.
Compilation is ok (see make and configure at end of this mail) with some
"command not found" (don't know if it is important or not), then i
launch this command :
su - postgres -c "/usr/local/Nominatim-2.0.1/utils/setup.php --osm-file
/data/flf/72xmap/data/tilemaker/osm/bretagne-latest.osm.pbf --all
--osm2pgsql-cache 7000"
I removed osmosis-init part because server is not connect to internet,
then i do this request directly on database :
insert into import_status(lastimportdate) values('now');
When i try to make this search i not receive any result :
http://myip/nominatim/search?format=xml&q=Rennes
And when i make this one :
http://myip/nominatim/search?format=xml&q=35750
I receive theses datas :
<searchresults timestamp="Mon, 22 Jul 2013 13:27:08 CEST"
attribution="Data © OpenStreetMap contributors, ODbL 1.0.
http://www.openstreetmap.org/copyright" querystring="35750"
polygon="false" exclude_place_ids="124886"
more_url="http://devosmap/search?format=xml&exclude_place_ids=124886&accept-language=en-US,en;q=0.5&q=35750"><place
place_id="124886" place_rank="21"
boundingbox="34.941946258545,34.961950073242,-86.606893310547,-86.586885681152"
lat="34.951947612019" lon="-86.5968868394372" display_name="35750,
United States of America" class="place" type="postcode"/></searchresults>
Seems that import have work only for default us datas but not for data
inside osm files :
select count(*) from search_name;
count
-------
32388
(1 row)
select * from search_name where country_code!='us' and country_code!='ca';
place_id | search_rank | address_rank | importance | country_code |
name_vector | nameaddress_vector | centroid
----------+-------------+--------------+------------+--------------+-------------+--------------------+----------
(0 rows)
Tables planet_osm_* ara populated (but without tags, i don't know if it
is important) :
select count(*) from planet_osm_ways;
count
---------
2757773
(1 row)
select count(*) from planet_osm_ways where tags is not null;
count
-------
0
(1 row)
I continue search why all datas are not imported, but for the moment i'm
blocked :(
Thanks to all who will have any idea for any help.
Regards,
********
Server Info
RedHat 5.5 64bits
PostgreSQL 8.4.5
PHP 5.1.6
Nominatim 2.0.1
OSM2PgSQL 0.83.0 (64bit id space) avec support PBF
Configure :
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for geos-config... /usr/bin/geos-config
checking for geos libraries... checking geos/version.h usability... yes
checking geos/version.h presence... yes
checking for geos/version.h... yes
yes
checking for proj headers in /usr/include... found
checking for proj library... found
checking for proj projection library... yes
checking for pg_config... /usr/bin/pg_config
checking for PostgreSQL libraries... yes
checking if PostgreSQL version is >= 8.4... yes
checking for bzip2 headers in /usr/include... found
checking for bzip2 library... found
checking for bzip2 compression library... yes
checking for xml2-config... /usr/bin/xml2-config
checking for libxml - version >= 2.0.0... yes (version 2.6.26)
configure: creating ./config.status
config.status: creating Makefile
config.status: creating nominatim/Makefile
config.status: creating module/Makefile
config.status: creating nominatim/config.h
config.status: nominatim/config.h is unchanged
config.status: executing depfiles commands
=== configuring in osm2pgsql (/usr/local/Nominatim-2.0.1/osm2pgsql)
configure: running /bin/sh ./configure '--prefix=/usr/local'
--cache-file=/dev/null --srcdir=.
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking dependency style of gcc... gcc3
checking for sys/wait.h that is POSIX.1 compatible... yes
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for stdlib.h... (cached) yes
checking for unistd.h... (cached) yes
checking for getpagesize... yes
checking for working mmap... yes
checking for gcc option to accept ISO C99... -std=gnu99
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking for g++... yes
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for a sed that does not truncate output... /bin/sed
checking for fgrep... /bin/grep -F
checking for ld used by gcc -std=gnu99... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 98304
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking for /usr/bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for ar... ar
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/bin/nm -B output from gcc -std=gnu99
object... ok
checking for dlfcn.h... yes
checking whether we are using the GNU C++ compiler... (cached) yes
checking whether g++ accepts -g... (cached) yes
checking dependency style of g++... (cached) gcc3
checking how to run the C++ preprocessor... g++ -E
checking for objdir... .libs
checking if gcc -std=gnu99 supports -fno-rtti -fno-exceptions... no
checking for gcc -std=gnu99 option to produce PIC... -fPIC -DPIC
checking if gcc -std=gnu99 PIC flag -fPIC -DPIC works... yes
checking if gcc -std=gnu99 static flag -static works... yes
checking if gcc -std=gnu99 supports -c -o file.o... yes
checking if gcc -std=gnu99 supports -c -o file.o... (cached) yes
checking whether the gcc -std=gnu99 linker (/usr/bin/ld -m elf_x86_64)
supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for ld used by g++... /usr/bin/ld -m elf_x86_64
checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking for g++ option to produce PIC... -fPIC -DPIC
checking if g++ PIC flag -fPIC -DPIC works... yes
checking if g++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking if g++ supports -c -o file.o... (cached) yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports
shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking for lseek64... yes
checking for posix_fallocate... yes
checking for posix_fadvise... yes
checking for sync_file_range... no
checking for xml2-config... /usr/bin/xml2-config
checking for xml2 libraries... yes
checking for zlib headers in /usr/include... found
checking for zlib library... found
checking for zlib compression library... yes
checking for bzip2 headers in /usr/include... found
checking for bzip2 library... found
checking for bzip2 compression library... yes
checking for geos-config... /usr/bin/geos-config
checking for geos libraries... checking geos/version.h usability... yes
checking geos/version.h presence... yes
checking for geos/version.h... yes
yes
checking for proj headers in /usr/include... found
checking for proj library... found
checking for proj projection library... yes
checking for protobuf-c 0.14...
checking for protobuf_c headers in /usr/include... found
checking for protobuf_c library... found
checking for protobuf-c version >= 0.14...
checking for ProtobufCFieldDescriptor.packed... yes
protobuf-c >= 0.14: yes
checking for protobuf-c usability... yes
checking for protoc-c... /usr/bin/protoc-c
checking for pg_config... /usr/bin/pg_config
checking for PostgreSQL libraries... yes
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
configure: creating ./config.status
config.status: creating Makefile
config.status: creating legacy/Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
config.status: executing libtool commands
Make
Making all in osm2pgsql
make[1]: Entering directory `/usr/local/Nominatim-2.0.1/osm2pgsql'
make all-recursive
make[2]: Entering directory `/usr/local/Nominatim-2.0.1/osm2pgsql'
make[3]: Entering directory `/usr/local/Nominatim-2.0.1/osm2pgsql'
/bin/sh ./libtool --tag=CXX --mode=link g++ -g -O2 -pthread -L/usr/lib
-lz -L/usr/lib64 -lpq -lxml2 -lz -lm -L/usr/lib -lbz2 -L/usr/lib64
-L/usr/lib64 -lgeos -L/usr/lib -lproj -L/usr/lib -lprotobuf-c -o
osm2pgsql build_geometry.o input.o output-pgsql.o rb.o middle-pgsql.o
osm2pgsql.o sprompt.o UTF8sanitizer.o expire-tiles.o keyvals.o
output-null.o parse-primitive.o parse-xml2.o pgsql.o reprojection.o
middle-ram.o output-gazetteer.o text-tree.o node-ram-cache.o wildcmp.o
node-persistent-cache.o binarysearcharray.o parse-pbf.o
fileformat.pb-c.o osmformat.pb-c.o
./libtool: line 827: X--tag=CXX: command not found
./libtool: line 860: libtool: ignoring unknown tag : command not found
./libtool: line 827: X--mode=link: command not found
./libtool: line 993: *** Warning: inferring the mode of operation is
deprecated.: command not found
./libtool: line 994: *** Future versions of Libtool will require
--mode=MODE be specified.: command not found
gcc: no input files
gcc: no input files
gcc: no input files
gcc: no input files
./libtool: line 2230: X-g: command not found
./libtool: line 2230: X-O2: command not found
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 1950: X-L/usr/lib64: No such file or directory
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 1950: X-L/usr/lib64: No such file or directory
./libtool: line 1950: X-L/usr/lib64: No such file or directory
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 2399: Xosm2pgsql: command not found
./libtool: line 2404: X: command not found
./libtool: line 2411: Xosm2pgsql: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lpq: command not found
./libtool: line 2546: X-lxml2: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lm: command not found
./libtool: line 2546: X-lbz2: command not found
./libtool: line 2546: X-lgeos: command not found
./libtool: line 2546: X-lproj: command not found
./libtool: line 2546: X-lprotobuf-c: command not found
./libtool: line 2628: X-L/usr/local/Nominatim-2.0.1/osm2pgsql: No such
file or directory
./libtool: line 2546: X-lpq: command not found
./libtool: line 2546: X-lxml2: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lm: command not found
./libtool: line 2546: X-lbz2: command not found
./libtool: line 2546: X-lgeos: command not found
./libtool: line 2546: X-lproj: command not found
./libtool: line 2546: X-lprotobuf-c: command not found
./libtool: line 2628: X-L/usr/local/Nominatim-2.0.1/osm2pgsql: No such
file or directory
./libtool: line 2546: X-lpq: command not found
./libtool: line 2546: X-lxml2: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lm: command not found
./libtool: line 2546: X-lbz2: command not found
./libtool: line 2546: X-lgeos: command not found
./libtool: line 2546: X-lproj: command not found
./libtool: line 2546: X-lprotobuf-c: command not found
./libtool: line 5155: Xg++ "" "" -pthread -o @OUTPUT@ build_geometry.o
input.o output-pgsql.o rb.o middle-pgsql.o osm2pgsql.o sprompt.o
UTF8sanitizer.o expire-tiles.o keyvals.o output-null.o parse-primitive.o
parse-xml2.o pgsql.o reprojection.o middle-ram.o output-gazetteer.o
text-tree.o node-ram-cache.o wildcmp.o node-persistent-cache.o
binarysearcharray.o parse-pbf.o fileformat.pb-c.o osmformat.pb-c.o
-L/usr/local/Nominatim-2.0.1/osm2pgsql -lpq -lxml2 -lz -lm -lbz2 -lgeos
-lproj -lprotobuf-c: File name too long
./libtool: line 5156: Xg++ "" "" -pthread -o @OUTPUT@ build_geometry.o
input.o output-pgsql.o rb.o middle-pgsql.o osm2pgsql.o sprompt.o
UTF8sanitizer.o expire-tiles.o keyvals.o output-null.o parse-primitive.o
parse-xml2.o pgsql.o reprojection.o middle-ram.o output-gazetteer.o
text-tree.o node-ram-cache.o wildcmp.o node-persistent-cache.o
binarysearcharray.o parse-pbf.o fileformat.pb-c.o osmformat.pb-c.o
-L/usr/local/Nominatim-2.0.1/osm2pgsql -lpq -lxml2 -lz -lm -lbz2 -lgeos
-lproj -lprotobuf-c: File name too long
./libtool: line 5161: X: command not found
./libtool: line 5165: : command not found
/bin/sh ./libtool --tag=CC --mode=link gcc -std=gnu99 -pthread
-I/usr/include -I/usr/include/libxml2 -I/usr/include -I/usr/include
-I/usr/include -I/usr/include
-DOSM2PGSQL_DATADIR='"/usr/local/share/osm2pgsql"' -DVERSION='"0.81.0"'
-g -O2 -pthread -L/usr/lib -lz -L/usr/lib64 -lpq -lxml2 -lz -lm
-L/usr/lib -lbz2 -L/usr/lib64 -L/usr/lib64 -lgeos -L/usr/lib -lproj
-L/usr/lib -lprotobuf-c -o nodecachefilereader
node-persistent-cache-reader.o node-persistent-cache.o node-ram-cache.o
binarysearcharray.o
./libtool: line 827: X--tag=CC: command not found
./libtool: line 860: libtool: ignoring unknown tag : command not found
./libtool: line 827: X--mode=link: command not found
./libtool: line 993: *** Warning: inferring the mode of operation is
deprecated.: command not found
./libtool: line 994: *** Future versions of Libtool will require
--mode=MODE be specified.: command not found
./libtool: line 2230: X-std=gnu99: command not found
./libtool: line 2230: X-I/usr/include: No such file or directory
./libtool: line 2230: X-I/usr/include/libxml2: No such file or directory
./libtool: line 2230: X-I/usr/include: No such file or directory
./libtool: line 2230: X-I/usr/include: No such file or directory
./libtool: line 2230: X-I/usr/include: No such file or directory
./libtool: line 2230: X-I/usr/include: No such file or directory
./libtool: line 2230: X-DOSM2PGSQL_DATADIR="/usr/local/share/osm2pgsql":
No such file or directory
./libtool: line 2230: X-DVERSION="0.81.0": command not found
./libtool: line 2230: X-g: command not found
./libtool: line 2230: X-O2: command not found
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 1950: X-L/usr/lib64: No such file or directory
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 1950: X-L/usr/lib64: No such file or directory
./libtool: line 1950: X-L/usr/lib64: No such file or directory
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 1950: X-L/usr/lib: No such file or directory
./libtool: line 2399: Xnodecachefilereader: command not found
./libtool: line 2404: X: command not found
./libtool: line 2411: Xnodecachefilereader: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lpq: command not found
./libtool: line 2546: X-lxml2: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lm: command not found
./libtool: line 2546: X-lbz2: command not found
./libtool: line 2546: X-lgeos: command not found
./libtool: line 2546: X-lproj: command not found
./libtool: line 2546: X-lprotobuf-c: command not found
./libtool: line 2628: X-L/usr/local/Nominatim-2.0.1/osm2pgsql: No such
file or directory
./libtool: line 2546: X-lpq: command not found
./libtool: line 2546: X-lxml2: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lm: command not found
./libtool: line 2546: X-lbz2: command not found
./libtool: line 2546: X-lgeos: command not found
./libtool: line 2546: X-lproj: command not found
./libtool: line 2546: X-lprotobuf-c: command not found
./libtool: line 2628: X-L/usr/local/Nominatim-2.0.1/osm2pgsql: No such
file or directory
./libtool: line 2546: X-lpq: command not found
./libtool: line 2546: X-lxml2: command not found
./libtool: line 2546: X-lz: command not found
./libtool: line 2546: X-lm: command not found
./libtool: line 2546: X-lbz2: command not found
./libtool: line 2546: X-lgeos: command not found
./libtool: line 2546: X-lproj: command not found
./libtool: line 2546: X-lprotobuf-c: command not found
./libtool: line 5155: Xgcc "" -pthread "" "" "" "" "" "" "" "" "" ""
-pthread -o @OUTPUT@ node-persistent-cache-reader.o
node-persistent-cache.o node-ram-cache.o binarysearcharray.o
-L/usr/local/Nominatim-2.0.1/osm2pgsql -lpq -lxml2 -lz -lm -lbz2 -lgeos
-lproj -lprotobuf-c: No such file or directory
./libtool: line 5156: Xgcc "" -pthread "" "" "" "" "" "" "" "" "" ""
-pthread -o @OUTPUT@ node-persistent-cache-reader.o
node-persistent-cache.o node-ram-cache.o binarysearcharray.o
-L/usr/local/Nominatim-2.0.1/osm2pgsql -lpq -lxml2 -lz -lm -lbz2 -lgeos
-lproj -lprotobuf-c: No such file or directory
./libtool: line 5161: X: command not found
./libtool: line 5165: : command not found
make[3]: Leaving directory `/usr/local/Nominatim-2.0.1/osm2pgsql'
make[2]: Leaving directory `/usr/local/Nominatim-2.0.1/osm2pgsql'
make[1]: Leaving directory `/usr/local/Nominatim-2.0.1/osm2pgsql'
Making all in module
make[1]: Entering directory `/usr/local/Nominatim-2.0.1/module'
Makefile:9: warning: overriding commands for target `install'
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk:104: warning: ignoring old
commands for target `install'
chmod 755 nominatim.so
make[1]: Leaving directory `/usr/local/Nominatim-2.0.1/module'
Making all in nominatim
make[1]: Entering directory `/usr/local/Nominatim-2.0.1/nominatim'
make all-am
make[2]: Entering directory `/usr/local/Nominatim-2.0.1/nominatim'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20130726/43c06d0d/attachment-0001.html>
More information about the Geocoding
mailing list