osm2pgrouting missing

[kalxas]

ldconfig deferred processing now taking place
E: Package 'osm2pgrouting' has no installation candidate
create pgrouting database with PostGIS and pgRouting
createdb: database creation failed: ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT:  Use the same encoding as in the template database, or use template0 as template.
psql: FATAL:  database "pgrouting" does not exist
psql: FATAL:  database "pgrouting" does not exist
unpack sample data
Run osm2pgrouting converter (this may take a while)
sudo: osm2pgrouting: command not found
psql: FATAL:  database "pgrouting" does not exist

[kalxas]

@hamish, welcome back :)

[dkastl]

You can get the package from this repository: ​https://launchpad.net/~georepublic/+archive/pgrouting

[kalxas]

Thanks dkastl, I copied the deb package. Testing on next nightly

[kalxas]

in [11061] :

Unpacking osm2pgrouting (from .../osm2pgrouting_2.0.0-release-ppa1~precise1_i386.deb) ...
Setting up osm2pgrouting (2.0.0-release-ppa1~precise1) ...
create pgrouting database with PostGIS and pgRouting
CREATE EXTENSION
CREATE EXTENSION
unpack sample data
Run osm2pgrouting converter (this may take a while)
sudo: osm2pgrouting: command not found
VACUUM

[dkastl]

I would really appreciate, if the person, who commented out the previous PPA for pgRouting also makes sure, that the install script still works.

It would have been quite easy then to see, that osm2pgrouting was not copied to the OSGeoLive PPA.

So possible solutions are:

• (1) Re-enable the PPA with osm2pgrouting (ppa:georepublic/pgrouting)
• (2) Copy the osm2pgrouting package to the PPA, which is used now.

(1) I can do, (2) I can't.

Regards, Daniel

For reference the relevant lines in "install_pgrouting.sh":

# TODO: Remove third party PPAs
#add-apt-repository -y ppa:georepublic/pgrouting
apt-get update -qq

# Install pgRouting packages
apt-get install -y -qq postgresql-9.3-pgrouting
	
if [ $? -ne 0 ] ; then
   echo 'ERROR: pgRouting Package install failed! Aborting.'
   exit 1
fi

# Install osm2pgrouting package
apt-get install -y -qq osm2pgrouting

[kalxas]

The problem is that the deb was copied several weeks ago and osm2pgrouting still is not picked up

​https://launchpad.net/~osgeolive/+archive/nightly/+sourcepub/3889394/+listing-archive-extra "Published on 2014-02-03"

[kalxas]

Does the ppa:georepublic/pgrouting use PostgreSQL 9.3 as a build target? If not solution (1) is not an option.

[dkastl]

It seems I found out where the problem lies: osm2pgrouting binary goes to /usr/share/bin and not /usr/bin

I will publish an updated package in the next hours.

[kalxas]

Thanks.

[dkastl]

An updated package of osm2pgrouting has been published in "ppa:georepublic/pgrouting" and can be copied into OSGeoLive nightly builds PPA.

It should fix this ticket.

[kalxas]

Files copied. Thanks. Waiting for next nightly now.

[kalxas]

Fixed in [11138]