[pgrouting-users] error on routing_dd.sql

Wed Aug 17 18:44:03 EDT 2011

Hi Jules,

First of all you shouldn't get errors when loading the pgRouting functions.
This here is a script to make a PostGIS and based on that a pgRouting
template database:
https://github.com/pgRouting/workshop/blob/master/bin/create_templates.sh

It's only tested on Ubuntu, so on CentOS you might have to adjust the paths
at the beginning.
And you can remove the "--quiet" flags to be able to read the full console
log.

Daniel

On Thu, Aug 18, 2011 at 12:20 AM, Jules Kouadio <sekedoua at gmail.com> wrote:

> Thanks Daniel
> How can I know that pgrouting is correctly inslalled
> Jules ?
>
>
> 2011/8/17 Daniel Kastl <daniel at georepublic.de>
>
>> You could also try the package of the ELGIS repository:
>> http://elgis.argeo.org/
>>
>> And if you want to compile yourself, take a look into the .spec file that
>> is inside the .src package:
>> http://elgis.argeo.org/repos/testing/5/elgis/SRPMS/repoview/pgrouting.html
>>
>> Hope that helps,
>>  Daniel
>>
>>
>>
>> On Wed, Aug 17, 2011 at 8:50 PM, Jules Kouadio <sekedoua at gmail.com>wrote:
>>
>>> I have compile it myself.
>>>
>>> Centos 5. 5 (Linux version 2.6.18-238.19.1.el5 (
>>> mockbuild at builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat
>>> 4.1.2-50))
>>>
>>>
>>> 2011/8/17 Daniel Kastl <daniel at georepublic.de>
>>>
>>>> Hi Jules,
>>>>
>>>> Can you make sure that CGAL is installed at the right place?
>>>> If you have compiled pgRouting yourself, which OS and architecture do
>>>> you use?
>>>>
>>>> Daniel
>>>>
>>>>
>>>> On Wed, Aug 17, 2011 at 7:53 PM, Jules Kouadio <sekedoua at gmail.com>wrote:
>>>>
>>>>> Sorry but i get always the same error.
>>>>> Thanks
>>>>>
>>>>>
>>>>> 2011/8/16 Stephen Woodbridge <woodbri at swoodbridge.com>
>>>>>
>>>>>> On 8/16/2011 11:36 AM, Jules Kouadio wrote:
>>>>>>
>>>>>>> Hi . Can someone help me ?
>>>>>>> When i execute :
>>>>>>> psql -f /usr/share/pgrouting/routing_**dd.sql routing
>>>>>>> I get this error :
>>>>>>>
>>>>>>> psql:/usr/share/pgrouting/**routing_dd.sql:27:
>>>>>>> ERROR: could not load library "/ usr / lib / pgsql /
>>>>>>> librouting_dd.so"
>>>>>>> libCGAL.so.2: Failed address (mapping) segement of the shared object:
>>>>>>> Permission denied
>>>>>>>
>>>>>>
>>>>>> This sounds like the permissions or ownership issues on the file and
>>>>>> need to set them correctly. On my Debian Lenny system I have:
>>>>>>
>>>>>> woodbri at mappy:/u/www/html/**routing/leaddog$ locate libCGAL
>>>>>> /usr/lib/libCGAL.a
>>>>>> /usr/lib/libCGAL.so
>>>>>> /usr/lib/libCGAL.so.1
>>>>>> /usr/lib/libCGAL.so.1.0.1
>>>>>> /usr/lib/libCGAL.so.2
>>>>>> /usr/lib/libCGAL.so.2.0.1
>>>>>> /usr/lib/libCGALPDB.a
>>>>>> /usr/lib/libCGALPDB.so
>>>>>> /usr/lib/libCGALPDB.so.2
>>>>>> /usr/lib/libCGALPDB.so.2.0.1
>>>>>> /usr/lib/libCGALQt.a
>>>>>> /usr/lib/libCGALQt.so
>>>>>> /usr/lib/libCGALQt.so.2
>>>>>> /usr/lib/libCGALQt.so.2.0.1
>>>>>> /usr/lib/libCGALcore++.a
>>>>>> /usr/lib/libCGALcore++.so
>>>>>> /usr/lib/libCGALcore++.so.2
>>>>>> /usr/lib/libCGALcore++.so.2.0.**1
>>>>>> /usr/lib/libCGALimageIO.a
>>>>>> /usr/lib/libCGALimageIO.so
>>>>>> /usr/lib/libCGALimageIO.so.2
>>>>>> /usr/lib/libCGALimageIO.so.2.**0.1
>>>>>> woodbri at mappy:/u/www/html/**routing/leaddog$ ls -l
>>>>>> /usr/lib/libCGAL.so*
>>>>>> lrwxrwxrwx 1 root root     16 2009-03-24 19:34 /usr/lib/libCGAL.so ->
>>>>>> libCGAL.so.2.0.1
>>>>>> lrwxrwxrwx 1 root root     16 2007-11-25 18:19 /usr/lib/libCGAL.so.1
>>>>>> -> libCGAL.so.1.0.1
>>>>>> -rw-r--r-- 1 root root 173672 2007-03-25 17:03
>>>>>> /usr/lib/libCGAL.so.1.0.1
>>>>>> lrwxrwxrwx 1 root root     16 2009-03-24 19:34 /usr/lib/libCGAL.so.2
>>>>>> -> libCGAL.so.2.0.1
>>>>>> -rw-r--r-- 1 root root 215664 2008-06-23 08:02
>>>>>> /usr/lib/libCGAL.so.2.0.1
>>>>>>
>>>>>> You should have something similar. You might try something like:
>>>>>>
>>>>>> sudo chown root.root /usr/lib/libCGAL.so*
>>>>>> sudo chmod 644 /usr/lib/libCGAL.so.2.0.1
>>>>>> sudo ldconfig
>>>>>>
>>>>>> or:
>>>>>>
>>>>>> su
>>>>>> chown root.root /usr/lib/libCGAL.so*
>>>>>> chmod 644 /usr/lib/libCGAL.so.2.0.1
>>>>>> ldconfig
>>>>>> exit
>>>>>>
>>>>>>
>>>>>> -Steve W
>>>>>>
>>>>>>  Note : all is wright for
>>>>>>>  /usr/share/pgrouting/routing_**core.sql
>>>>>>>  /usr/share/pgrouting/routing_**core_wrappers.sql
>>>>>>> /usr/share/pgrouting/routing_**topology.sql
>>>>>>> /usr/share/pgrouting/matching.**sql
>>>>>>> /usr/lib/pgsql/librouting_tsp.**so
>>>>>>> /usr/share/pgrouting/routing_**tsp.sql
>>>>>>> /usr/share/pgrouting/routing_**tsp_wrappers.sql
>>>>>>>
>>>>>>> Thanks .
>>>>>>> *
>>>>>>> *
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> ______________________________**_________________
>>>>>>> Pgrouting-users mailing list
>>>>>>> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org>
>>>>>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>>>>>
>>>>>>
>>>>>> ______________________________**_________________
>>>>>> Pgrouting-users mailing list
>>>>>> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org>
>>>>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *
>>>>> *
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Pgrouting-users mailing list
>>>>> Pgrouting-users at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Georepublic UG & Georepublic Japan
>>>> eMail: daniel.kastl at georepublic.de
>>>> Web: http://georepublic.de
>>>>
>>>> _______________________________________________
>>>> Pgrouting-users mailing list
>>>> Pgrouting-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>>
>>>>
>>>
>>>
>>> --
>>> *
>>> *
>>>
>>>
>>>
>>> _______________________________________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>>
>>>
>>
>>
>> --
>> Georepublic UG & Georepublic Japan
>> eMail: daniel.kastl at georepublic.de
>> Web: http://georepublic.de
>>
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>>
>>
>
>
> --
> *
> *
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>

-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110818/2e843cc0/attachment.html