[root@VM-0-5-centos /root]#sudo dnf update -y

[root@VM-0-5-centos /root]#sudo dnf install -y epel-release redhat-rpm-config

[root@VM-0-5-centos /root]#sudo dnf -qy module disable postgresql

[root@VM-0-5-centos /root]#sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

#查看 PHP 版本

php -v

# 查看 PostgreSQL 版本

psql --version

# 查看 PostGIS 版本

rpm -qa | grep postgis

[root@VM-0-5-centos /root]#sudo useradd -d /srv/nominatim -s /bin/bash -m nominatim

[root@VM-0-5-centos /root]#sudo passwd nominatim

[root@VM-0-5-centos /root]#export USERNAME=nominatim

[root@VM-0-5-centos /root]#export USERHOME=/srv/nominatim

[root@VM-0-5-centos /root]#chmod a+x $USERHOME

[root@VM-0-5-centos /root]#sudo /usr/pgsql-12/bin/postgresql-12-setup initdb

[root@VM-0-5-centos /root]#sudo systemctl enable postgresql-12

fsync = off

full_page_writes = off

[root@VM-0-5-centos /root]#sudo systemctl restart postgresql-12

[root@VM-0-5-centos /root]#sudo -u postgres createuser -s $USERNAME

[root@VM-0-5-centos /root]#sudo -u postgres createuser apache

[root@VM-0-5-centos /root]#su nominatim

[nominatim@VM-0-5-centos /root]$

[nominatim@VM-0-5-centos /root]$cd $USERHOME

[nominatim@VM-0-5-centos /srv/nominatim]$wget https://nominatim.org/release/Nominatim-3.7.1.tar.bz2

[nominatim@VM-0-5-centos /srv/nominatim]$tar xf Nominatim-3.7.1.tar.bz2

[nominatim@VM-0-5-centos /srv/nominatim]$mkdir $USERHOME/build

[nominatim@VM-0-5-centos /srv/nominatim]$cd $USERHOME/build

[nominatim@VM-0-5-centos /srv/nominatim/build]$cmake $USERHOME/Nominatim-3.7.1

[nominatim@VM-0-5-centos /srv/nominatim/build]$make

[nominatim@VM-0-5-centos /srv/nominatim/build]$sudo make install

[nominatim@VM-0-5-centos /srv/nominatim/build]$cmake $USERHOME/Nominatim-3.7.1

-- The C compiler identification is GNU 8.3.1

-- The CXX compiler identification is GNU 8.3.1

-- Detecting C compiler ABI info

-- Detecting C compiler ABI info - done

-- Check for working C compiler: /usr/lib64/ccache/cc - skipped

-- Detecting C compile features

-- Detecting C compile features - done

-- Detecting CXX compiler ABI info

-- Detecting CXX compiler ABI info - done

-- Check for working CXX compiler: /usr/lib64/ccache/c++ - skipped

-- Detecting CXX compile features

-- Detecting CXX compile features - done

-- Building osm2pgsql 1.4.2

-- Building in C++11 mode

-- Found Git: /usr/bin/git (found version "2.27.0")

-- Looking for include file termios.h

-- Looking for include file termios.h - found

-- Looking for include file unistd.h

-- Looking for include file unistd.h - found

-- Found ZLIB: /usr/lib64/libz.so (found version "1.2.11")

-- Looking for pthread.h

-- Looking for pthread.h - found

-- Performing Test CMAKE_HAVE_LIBC_PTHREAD

-- Performing Test CMAKE_HAVE_LIBC_PTHREAD - Failed

-- Looking for pthread_create in pthreads

-- Looking for pthread_create in pthreads - not found

-- Looking for pthread_create in pthread

-- Looking for pthread_create in pthread - found

-- Found Threads: TRUE

-- Found Protozero: /srv/nominatim/Nominatim-3.7.1/osm2pgsql/contrib/protozero/include (found suitable version "1.7.0", minimum required is "1.6.3")

-- Found EXPAT: /usr/lib64/libexpat.so (found version "2.2.5")

-- Found BZip2: /usr/lib64/libbz2.so (found version "1.0.6")

-- Looking for BZ2_bzCompressInit

-- Looking for BZ2_bzCompressInit - found

-- Found Osmium: /srv/nominatim/Nominatim-3.7.1/osm2pgsql/contrib/libosmium/include (found suitable version "2.16.0", minimum required is "2.15.6")

-- Found Boost: /usr/include (found suitable version "1.66.0", minimum required is "1.50") found components: system filesystem

-- Found PostgreSQL: /usr/lib64/libpq.so (found version "12.6")

-- Found proj_api.h

-- Found Proj [API 4] /usr/lib64/libproj.so

-- Libraries used to build: /usr/lib64/libboost_system.so;/usr/lib64/libboost_filesystem.so;/usr/lib64/libpq.so;/usr/lib64/libz.so;-lpthread;/usr/lib64/libexpat.so;/usr/lib64/libbz2.so;/usr/lib64/libproj.so

-- Looking for clang-tidy

-- Looking for clang-tidy - found /usr/bin/clang-tidy

-- Tests disabled. Set BUILD_TESTS=ON to enable tests.

-- Looking for pandoc

-- Looking for pandoc - not found

--   Manual page can not be built

-- Found PythonInterp: /usr/bin/python3 (found suitable version "3.6.8", minimum required is "3.5")

-- Using PHP binary /usr/bin/php

-- Using php-cgi binary /usr/bin/php-cgi

-- Using Python behave binary /srv/nominatim/.local/bin/behave

-- Using phpunit binary /usr/local/bin/phpunit

-- Using phpcs binary /usr/bin/phpcs

CMake Warning at CMakeLists.txt:89 (message):

  php-cgi binary not found.  nominatim tool will not provide query functions.

CMake Warning at CMakeLists.txt:156 (message):

  behave not found.  BDD tests disabled.

CMake Warning at CMakeLists.txt:165 (message):

  phpunit not found.  PHP unit tests disabled.

CMake Warning at CMakeLists.txt:174 (message):

  phpcs not found.  PHP linting tests disabled.

CMake Warning at CMakeLists.txt:183 (message):

  pylint not found.  Python linting tests disabled.

CMake Warning at CMakeLists.txt:192 (message):

  pytest not found.  Python tests disabled.

-- Configuring done

-- Generating done

-- Build files have been written to: /srv/nominatim/build

[root@VM-0-5-centos /root]#pip install -U pytest

[root@VM-0-5-centos /root]#pip install -U requests

[root@VM-0-5-centos /root]#pip install -U pytest-pythonpath

[root@VM-0-5-centos /root]#pip install -U pytest-capturelog

[root@VM-0-5-centos /root]#yum install pylint

suhosin.executor.include.whitelist = phar

[root@VM-0-5-centos /root]#wget https://phar.phpunit.de/phpunit-9.0.phar

[root@VM-0-5-centos /root]#chmod +x phpunit-9.0.phar

[root@VM-0-5-centos /root]#sudo mv phpunit-9.0.phar /usr/local/bin/phpunit

[root@VM-0-5-centos /root]#wget http://pear.php.net/go-pear.phar

[root@VM-0-5-centos /root]#php74 go-pear.phar

Below is a suggested file layout for your new PEAR installation.  To

change individual locations, type the number in front of the

directory.  Type 'all' to change all of them or simply press Enter to

accept these locations.

 1. Installation base ($prefix)                   : /opt/remi/php74/root/usr

 2. Temporary directory for processing            : /tmp/pear/install

 3. Temporary directory for downloads             : /tmp/pear/install

 4. Binaries directory                            : /opt/remi/php74/root/usr/bin

 5. PHP code directory ($php_dir)                 : /opt/remi/php74/root/usr/share/pear

 6. Documentation directory                       : /opt/remi/php74/root/usr/docs

 7. Data directory                                : /opt/remi/php74/root/usr/data

 8. User-modifiable configuration files directory : /opt/remi/php74/root/usr/cfg

 9. Public Web Files directory                    : /opt/remi/php74/root/usr/www

10. System manual pages directory                 : /opt/remi/php74/root/usr/man

11. Tests directory                               : /opt/remi/php74/root/usr/tests

12. Name of configuration file                    : /etc/opt/remi/php74/pear.conf

1-12, 'all' or Enter to continue:

[root@VM-0-5-centos /root]#source /etc/profile

[root@VM-0-5-centos /root]#pear install PHP_CodeSniffer-3.6.0

[nominatim@VM-0-5-centos /srv/nominatim/build]$mkdir $USERHOME/nominatim-project

[nominatim@VM-0-5-centos /srv/nominatim/build]$cd $USERHOME/nominatim-project

[nominatim@VM-0-5-centos /srv/nominatim/nominatim-project]$nominatim refresh --website

[nominatim@VM-0-5-centos /srv/nominatim/nominatim-project]$sudo tee /etc/httpd/conf.d/nominatim.conf << EOFAPACHECONF

<Directory "$USERHOME/nominatim-project/website">

  Options FollowSymLinks MultiViews

  AddType text/html   .php

  DirectoryIndex search.php

  Require all granted

</Directory>

Alias /nominatim $USERHOME/nominatim-project/website

EOFAPACHECONF

[root@VM-0-5-centos /root]#sudo systemctl enable httpd

[root@VM-0-5-centos /root]#sudo systemctl restart httpd

[nominatim@VM-0-5-centos /srv/nominatim/build]$sudo semanage fcontext -a -t httpd_sys_content_t "/usr/local/nominatim/lib/lib-php(/.*)?"

[nominatim@VM-0-5-centos /srv/nominatim/build]$sudo semanage fcontext -a -t httpd_sys_content_t "$USERHOME/nominatim-project/website(/.*)?"

[nominatim@VM-0-5-centos /srv/nominatim/build]$sudo semanage fcontext -a -t lib_t "$USERHOME/nominatim-project/module/nominatim.so"

[nominatim@VM-0-5-centos /srv/nominatim/build]$sudo restorecon -R -v /usr/local/lib/nominatim

[nominatim@VM-0-5-centos /srv/nominatim/build]$sudo restorecon -R -v $USERHOME/nominatim-project

[nominatim@VM-0-5-centos /srv/nominatim/build]$echo NOMINATIM_DATABASE_WEBUSER="apache" | tee .env

[nominatim@VM-0-5-centos /srv/nominatim]$mkdir ~/nominatim-planet

[nominatim@VM-0-5-centos /srv/nominatim]$cd ~/nominatim-planet

[nominatim@VM-0-5-centos /srv/nominatim]$export PROJECT_DIR=~/nominatim-planet

[nominatim@VM-0-5-centos /srv/nominatim/nominatim-planet]$wget https://download.geofabrik.de/asia/china-latest.osm.pbf

[nominatim@VM-0-5-centos /srv/nominatim/build]$nominatim import --osm-file /srv/nominatim/nominatim-planet/north-america-latest.osm.pbf --osm2pgsql-cache 1529 2>&1 | tee setup.log

[nominatim@VM-0-5-centos /srv/nominatim/build]$nominatim admin --check-database

[nominatim@VM-0-5-centos /srv/nominatim/build]$nominatim admin --check-database

2021-05-23 10:36:37: Using project directory: /srv/nominatim/build

2021-05-23 10:36:37: Checking database

Checking database connection ... OK

Checking for placex table ... OK

Checking for placex content ... OK

Checking that nominatim.so module is installed ... OK

Checking indexing status ... Failed

The indexing didn't finish. 39317720 entries are not yet indexed.

To index the remaining entries, run:   nominatim import --continue indexing

Checking that database indexes are complete ... Failed

           The following indexes are missing:

             idx_word_word_id

idx_place_addressline_address_place_id

idx_placex_rank_address

idx_placex_parent_place_id

idx_placex_geometry_reverse_lookuppolygon

idx_placex_geometry_reverse_placenode

idx_osmline_parent_place_id

idx_osmline_parent_osm_id

idx_postcode_postcode

idx_search_name_nameaddress_vector

idx_search_name_name_vector

idx_search_name_centroid

idx_placex_pendingsector

idx_location_area_country_place_id

idx_place_osm_unique

           Rerun the index creation with:   nominatim import --continue db-postprocess

Checking that all database indexes are valid ... OK

Checking TIGER external data table. ... not applicable

[nominatim@VM-0-5-centos /srv/nominatim/build]$nominatim import --continue db-postprocess

2021-05-23 10:41:22: Using project directory: /srv/nominatim/build

2021-05-23 10:41:22: Post-process tables

Traceback (most recent call last):

  File "/usr/local/bin/nominatim", line 11, in <module>

    exit(cli.nominatim(module_dir='/usr/local/lib64/nominatim/module',

  File "/usr/local/lib64/nominatim/lib-python/nominatim/cli.py", line 288, in nominatim

    return parser.run(**kwargs)

  File "/usr/local/lib64/nominatim/lib-python/nominatim/cli.py", line 92, in run

    return args.command.run(args)

  File "/usr/local/lib64/nominatim/lib-python/nominatim/clicmd/setup.py", line 133, in run

    database_import.create_search_indices(conn, args.config,

  File "/usr/local/lib64/nominatim/lib-python/nominatim/tools/database_import.py", line 308, in create_search_indices

    sql.run_sql_file(conn, 'indices.sql', drop=drop)

  File "/usr/local/lib64/nominatim/lib-python/nominatim/db/sql_preprocessor.py", line 103, in run_sql_file

    cur.execute(sql)

  File "/usr/local/lib64/nominatim/lib-python/nominatim/db/connection.py", line 26, in execute

    super().execute(query, args)

  File "/opt/python3.8/lib/python3.8/site-packages/psycopg2/extras.py", line 146, in execute

    return super(DictCursor, self).execute(query, vars)

psycopg2.errors.DeadlockDetected: deadlock detected

DETAIL:  Process 3512930 waits for ShareLock on relation 925313 of database 28269; blocked by process 3512886.

Process 3512886 waits for RowExclusiveLock on relation 925309 of database 28269; blocked by process 3512930.

HINT:  See server log for query details.

[nominatim@VM-0-5-centos /srv/nominatim/build]$nominatim import --continue indexing

[nominatim@VM-0-5-centos /srv/nominatim/build]$nominatim serve

http:// 你的公网 ip/nominatim/status.php

[root@VM-0-5-centos /root]#su nominatim

[nominatim@VM-0-5-centos /root]$psql

could not change directory to "/root": Permission denied

psql (12.6)

Type "help" for help.

nominatim=#

nominatim=#\c nominatim

You are now connected to database "nominatim" as user "nominatim".

nominatim=#

nominatim=#GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO apache;