<div dir="ltr"><div>Ah, yes. After I thought it through later in the day, I realized the exception to being a vanilla 12.04 machine was the install from the PostgreSQL build team.<br><br>Best,<br>Steve<br><br><br></div></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Nov 27, 2013 at 8:20 PM, Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Steve,<div><br></div><div>You're using non-standard PostgreSQL and PostGIS, so this hasn't been tested with the packages I published on Launchpad.</div>
<div><br></div><div>The Ubuntu package defines a dependency "PostGIS", but I don't know why it didn't work in your case. This is the Debian "control" file:</div>
<div><a href="https://github.com/pgRouting/pgrouting-build/blob/master/debian/control" target="_blank">https://github.com/pgRouting/pgrouting-build/blob/master/debian/control</a><br></div><div><br></div><div>These Travis scripts build pgRouting with different versions of PostgreSQL/PostGIS:</div>
<div><a href="https://github.com/pgRouting/pgrouting/tree/master/tools/travis" target="_blank">https://github.com/pgRouting/pgrouting/tree/master/tools/travis</a></div><div><br></div><div>At the time of writing the scripts PostGIS 2.1 and PostgreSQL 9.3 were not released ye, so a few lines are commented out and PostGIS is build from source. This file defines the order the scripts are run:</div>
<div><a href="https://github.com/pgRouting/pgrouting/blob/master/.travis.yml" target="_blank">https://github.com/pgRouting/pgrouting/blob/master/.travis.yml</a><br></div><div><br></div><div>Daniel</div><div><br></div><div>
<br></div><div>
<br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Thu, Nov 28, 2013 at 1:42 AM, Worth Lutz <span dir="ltr"><<a href="mailto:wal3@mindspring.com" target="_blank">wal3@mindspring.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<u></u>
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p class="MsoNormal"><font color="blue" face="Arial" size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue">I’ve had not problems installing
pgRouting on Ubuntu 12.04 using the packages. Lucky? </span></font><font color="blue" face="Wingdings"><span style="font-family:Wingdings;color:blue">J</span></font><font color="blue" face="Arial"><span style="font-family:Arial;color:blue"><u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="blue" face="Arial" size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><u></u><font color="blue" face="Arial" size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue">Worth
Lutz</span></font><u></u><font color="blue" face="Arial"><span style="font-family:Arial;color:blue"><u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="blue" face="Arial" size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue"><u></u> <u></u></span></font></p>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">
<hr align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma">
<a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a>] <b><span style="font-weight:bold">On Behalf Of </span></b>Stephen Mather<br>
<b><span style="font-weight:bold">Sent:</span></b> Wednesday, November 27, 2013
11:33 AM<br>
<b><span style="font-weight:bold">To:</span></b> pgRouting Users List<br>
<b><span style="font-weight:bold">Subject:</span></b> Re: [pgrouting-users]
Aaargh! Building is hard... .</span></font><u></u><u></u></p>
</div><div><div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">BTW, interesting artifact
of (I think) all the machinations to build pgRouting-- now the package manager
version works... . I'm wondering if the package manager was build on a
clean build of Ubuntu, or one which may have had custom built libraries (just making
wild guesses here...).<br>
<br>
Thanks,<br>
Best,<br>
Steve<br>
<br>
<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">On Wed, Nov 27, 2013 at 11:21 AM, Stephen Mather <<a href="mailto:stephen@smathermather.com" target="_blank">stephen@smathermather.com</a>>
wrote:<u></u><u></u></span></font></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">Hi All,<br>
<br>
The package management for Ubuntu 12.04 isn't working for me (see earlier
message about this), so I decided I'm an adequate keyboard cowboy to build from
source, but alas, no such luck.<br>
<br>
</span></font><font face="Courier New"><span style="font-family:"Courier New"">steve@lion:~/Documents/github/pgrouting$
mkdir build<br>
steve@lion:~/Documents/github/pgrouting$ cd build/<br>
steve@lion:~/Documents/github/pgrouting/build$ cmake -DWITH_DD=ON ..<br>
-- The C compiler identification is GNU 4.6.3<br>
-- The CXX compiler identification is GNU 4.6.3<br>
-- Check for working C compiler: /usr/bin/gcc<br>
-- Check for working C compiler: /usr/bin/gcc -- works<br>
-- Detecting C compiler ABI info<br>
-- Detecting C compiler ABI info - done<br>
-- Check for working CXX compiler: /usr/bin/c++<br>
-- Check for working CXX compiler: /usr/bin/c++ -- works<br>
-- Detecting CXX compiler ABI info<br>
-- Detecting CXX compiler ABI info - done<br>
-- PGROUTING_GIT_TAG: pgrouting-2.0.0<br>
-- PGROUTING_GIT_BUILD: 0<br>
-- PGROUTING_GIT_HASH: d6ed2cb<br>
-- PGROUTING_GIT_BRANCH: master<br>
-- PGROUTING_VERSION_REVISION_NAME: d6ed2cb master<br>
-- PGROUTING_VERSION_REVISION_HASH: d6ed2cb<br>
-- UNIX=1<br>
-- WIN32=<br>
-- POSTGRESQL_EXECUTABLE is /usr/lib/postgresql/9.1/bin/postgres<br>
-- POSTGRESQL_PG_CONFIG is /usr/bin/pg_config<br>
-- POSTGRESQL_INCLUDE_DIR: /usr/include/postgresql/9.3/server<br>
-- POSTGRESQL_LIBRARIES: /usr/lib<br>
-- Boost version: 1.55.0<br>
-- Boost headers were found here: /usr/local/include<br>
-- POSTGRESQL_VERSION_STRING is PostgreSQL 9.3.1<br>
-- POSTGRESQL_VERSION is 9.3.1<br>
-- PGSQL_VERSION is 93<br>
-- Install directory for libraries is set to /usr/lib/postgresql/9.3/lib<br>
-- Contrib directory for SQL files is set to /usr/share/postgresql/9.3/contrib/pgrouting-2.0<br>
-- Extension directory for SQL files is set to
/usr/share/postgresql/9.3/extension<br>
-- Boost version: 1.55.0<br>
-- Found the following Boost libraries:<br>
-- thread<br>
-- Boost version: 1.55.0<br>
-- Found the following Boost libraries:<br>
-- thread<br>
-- system<br>
-- CGAL_INCLUDE_DIR=/usr/local/include<br>
-- CGAL_LIBRARIES=/usr/local/lib/libCGAL.so<br>
--
BOOST_THREAD_LIBRARIES=/usr/local/lib/libboost_thread.so;pthread;/usr/local/lib/libboost_thread.so;pthread;/usr/local/lib/libboost_system.so<br>
-- GMP_LIBRARIES=/usr/lib/x86_64-linux-gnu/libgmp.so<br>
-- Found CGAL: /usr/local/include, /usr/local/lib/libCGAL.so,
/usr/local/lib/libboost_thread.so;pthread;/usr/local/lib/libboost_thread.so;pthread;/usr/local/lib/libboost_system.so,
/usr/lib/x86_64-linux-gnu/libgmp.so<br>
-- Configuring done<br>
-- Generating done<br>
-- Build files have been written to:
/home/smathermather/Documents/github/pgrouting/build<br>
steve@lion:~/Documents/github/pgrouting/build$ make<br>
Scanning dependencies of target trsp<br>
[ 2%] Building C object src/trsp/src/CMakeFiles/trsp.dir/trsp.c.o<br>
[ 5%] Building CXX object
src/trsp/src/CMakeFiles/trsp.dir/trsp_core.cpp.o<br>
[ 8%] Building CXX object
src/trsp/src/CMakeFiles/trsp.dir/GraphDefinition.cpp.o<br>
[ 8%] Built target trsp<br>
Scanning dependencies of target astar<br>
[ 11%] Building C object src/astar/src/CMakeFiles/astar.dir/astar.c.o<br>
[ 14%] Building CXX object
src/astar/src/CMakeFiles/astar.dir/astar_boost_wrapper.cpp.o<br>
[ 14%] Built target astar<br>
Scanning dependencies of target dijkstra<br>
[ 17%] Building C object src/dijkstra/src/CMakeFiles/dijkstra.dir/dijkstra.c.o<br>
[ 20%] Building CXX object
src/dijkstra/src/CMakeFiles/dijkstra.dir/boost_wrapper.cpp.o<br>
[ 20%] Built target dijkstra<br>
Scanning dependencies of target kdijkstra<br>
[ 22%] Building CXX object src/kdijkstra/src/CMakeFiles/kdijkstra.dir/k_targets_boost_wrapper.cpp.o<br>
[ 25%] Building C object
src/kdijkstra/src/CMakeFiles/kdijkstra.dir/k_targets_sp.c.o<br>
[ 25%] Built target kdijkstra<br>
Scanning dependencies of target apsp_johnson<br>
[ 28%] Building C object src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/apsp_johnson.c.o<br>
[ 31%] Building CXX object
src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/apsp_johnson_boost_wrapper.cpp.o<br>
[ 31%] Built target apsp_johnson<br>
Scanning dependencies of target apsp_warshall<br>
[ 34%] Building C object src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/apsp.c.o<br>
[ 37%] Building CXX object
src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/apsp_boost_wrapper.cpp.o<br>
[ 37%] Built target apsp_warshall<br>
Scanning dependencies of target routing<br>
Linking CXX shared library lib/librouting.so<br>
[ 37%] Built target routing<br>
Scanning dependencies of target bd_dijkstra<br>
[ 40%] Building C object
src/bd_dijkstra/src/CMakeFiles/bd_dijkstra.dir/bdsp.c.o<br>
[ 42%] Building CXX object src/bd_dijkstra/src/CMakeFiles/bd_dijkstra.dir/bdsp_core.cpp.o<br>
[ 45%] Building CXX object
src/bd_dijkstra/src/CMakeFiles/bd_dijkstra.dir/BiDirDijkstra.cpp.o<br>
[ 45%] Built target bd_dijkstra<br>
Scanning dependencies of target bd_astar<br>
[ 48%] Building C object src/bd_astar/src/CMakeFiles/bd_astar.dir/bdastar.c.o<br>
[ 51%] Building CXX object
src/bd_astar/src/CMakeFiles/bd_astar.dir/MinHeap.cpp.o<br>
[ 54%] Building CXX object
src/bd_astar/src/CMakeFiles/bd_astar.dir/bdastar_core.cpp.o<br>
[ 57%] Building CXX object
src/bd_astar/src/CMakeFiles/bd_astar.dir/BiDirAStar.cpp.o<br>
[ 57%] Built target bd_astar<br>
Scanning dependencies of target routing_bd<br>
Linking CXX shared library lib/librouting_bd.so<br>
[ 57%] Built target routing_bd<br>
Scanning dependencies of target routing_tsp<br>
[ 60%] Building C object src/tsp/src/CMakeFiles/routing_tsp.dir/tsp2.c.o<br>
[ 62%] Building C object src/tsp/src/CMakeFiles/routing_tsp.dir/tsplib.c.o<br>
Linking C shared library ../../../lib/librouting_tsp.so<br>
[ 62%] Built target routing_tsp<br>
Scanning dependencies of target routing_ksp<br>
[ 65%] Building CXX object src/ksp/src/CMakeFiles/routing_ksp.dir/BaseGraph.cpp.o<br>
[ 68%] Building CXX object
src/ksp/src/CMakeFiles/routing_ksp.dir/BasePath.cpp.o<br>
[ 71%] Building CXX object
src/ksp/src/CMakeFiles/routing_ksp.dir/DijkstraShortestPathAlg.cpp.o<br>
[ 74%] Building CXX object src/ksp/src/CMakeFiles/routing_ksp.dir/Graph.cpp.o<br>
[ 77%] Building CXX object
src/ksp/src/CMakeFiles/routing_ksp.dir/HeaderTest.cpp.o<br>
[ 80%] Building CXX object
src/ksp/src/CMakeFiles/routing_ksp.dir/YenTopKShortestPathsAlg.cpp.o<br>
[ 82%] Building C object src/ksp/src/CMakeFiles/routing_ksp.dir/ksp.c.o<br>
[ 85%] Building CXX object
src/ksp/src/CMakeFiles/routing_ksp.dir/KSPDriver.cpp.o<br>
[ 88%] Building CXX object
src/ksp/src/CMakeFiles/routing_ksp.dir/KSPGraph.cpp.o<br>
Linking CXX shared library ../../../lib/librouting_ksp.so<br>
[ 88%] Built target routing_ksp<br>
Scanning dependencies of target routing_dd<br>
[ 91%] Building C object
src/driving_distance/src/CMakeFiles/routing_dd.dir/alpha.c.o<br>
[ 94%] Building CXX object
src/driving_distance/src/CMakeFiles/routing_dd.dir/alpha_drivedist.cpp.o<br>
[ 97%] Building CXX object
src/driving_distance/src/CMakeFiles/routing_dd.dir/boost_drivedist.cpp.o<br>
[100%] Building C object
src/driving_distance/src/CMakeFiles/routing_dd.dir/drivedist.c.o<br>
Linking CXX shared library ../../../lib/librouting_dd.so<br>
[100%] Built target routing_dd<br>
steve@lion:~/Documents/github/pgrouting/build$ sudo make install<br>
[ 8%] Built target trsp<br>
[ 14%] Built target astar<br>
[ 20%] Built target dijkstra<br>
[ 25%] Built target kdijkstra<br>
[ 31%] Built target apsp_johnson<br>
[ 37%] Built target apsp_warshall<br>
[ 37%] Built target routing<br>
[ 45%] Built target bd_dijkstra<br>
[ 57%] Built target bd_astar<br>
[ 57%] Built target routing_bd<br>
[ 62%] Built target routing_tsp<br>
[ 88%] Built target routing_ksp<br>
[100%] Built target routing_dd<br>
Install the project...<br>
-- Install configuration: ""<br>
-- Installing: /usr/lib/postgresql/9.3/lib/librouting_bd.so<br>
-- Installing: /usr/lib/postgresql/9.3/lib/librouting.so<br>
-- Installing: /usr/share/postgresql/9.3/extension/pgrouting--2.0.0.sql<br>
-- Installing: /usr/share/postgresql/9.3/extension/pgrouting.control<br>
-- Installing: /usr/share/postgresql/9.3/extension/pgrouting_legacy.sql<br>
-- Installing: /usr/share/postgresql/9.3/contrib/pgrouting-2.0/pgrouting.sql<br>
-- Installing: /usr/share/postgresql/9.3/contrib/pgrouting-2.0/pgrouting.control<br>
-- Installing:
/usr/share/postgresql/9.3/contrib/pgrouting-2.0/pgrouting_legacy.sql<br>
-- Installing: /usr/share/postgresql/9.3/extension/pgrouting_dd_legacy.sql<br>
-- Installing:
/usr/share/postgresql/9.3/contrib/pgrouting-2.0/pgrouting_dd_legacy.sql<br>
-- Installing: /usr/lib/postgresql/9.3/lib/librouting_tsp.so<br>
-- Installing: /usr/lib/postgresql/9.3/lib/librouting_ksp.so<br>
-- Installing: /usr/lib/postgresql/9.3/lib/librouting_dd.so<br>
-- Removed runtime path from
"/usr/lib/postgresql/9.3/lib/librouting_dd.so"</span></font><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">Now I create extension:<br>
<br>
</span></font><font face="Courier New"><span style="font-family:"Courier New"">CREATE
EXTENSION pgrouting;</span></font><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">And get the following
error (naturally, since librouting_dd is being removed here at the end...):<br>
<br>
</span></font><font face="Courier New"><span style="font-family:"Courier New"">ERROR:
could not load library
"/usr/lib/postgresql/9.3/lib/librouting_dd.so": libCGAL.so.10: cannot
open shared object file: No such file or directory<br>
********** Error **********<br>
<br>
ERROR: could not load library
"/usr/lib/postgresql/9.3/lib/librouting_dd.so": libCGAL.so.10: cannot
open shared object file: No such file or directory<br>
SQL state: 58P01</span></font><u></u><u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">Any idea what I'm doing
wrong?<u></u><u></u></span></font></p>
</div>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">Best<br>
Steve<u></u><u></u></span></font></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div>
</div></div><div class="MsoNormal" style="text-align:center" align="center"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">
<hr align="center" color="#aca899" noshade size="1" width="100%">
</span></font></div>
<p class="MsoNormal" color="#000000"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">No virus found in this message.<br>
Checked by AVG - <a href="http://www.avg.com" target="_blank">www.avg.com</a><br>
Version: 2014.0.4259 / Virus Database: 3629/6871 - Release Date: 11/27/13<u></u><u></u></span></font></p>
</div>
</div>
<br></div></div>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><span class="HOEnZb"><font color="#888888"><br></font></span></blockquote></div>
<span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>
eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>
</font></span></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br></div>