[pgrouting-users] error on routing_dd.sql

Thu Aug 18 03:49:07 EDT 2011

Hi daniel.
Can I know how to ru this file ?, I'm a new linux user.
Thanks.

2011/8/17 Daniel Kastl <daniel at georepublic.de>

> 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
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>

-- 
*
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110818/82306e1d/attachment.html