[pgrouting-users] error on routing_dd.sql

Thu Aug 18 04:56:14 EDT 2011

Hi Jules,

In your terminal window run

bash path/to/create_template.sh

Because I only used this on Ubuntu/Debian so far, you need to check if your
OS lets you run commands as super user with "sudo".
If you're working as root user you can remove the "sudo" from the script.
If you get permission errors you may need to allow access in ph_hba.conf.

Daniel

On Thu, Aug 18, 2011 at 4:49 PM, Jules Kouadio <sekedoua at gmail.com> wrote:

> 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
>>
>>
>
>
> --
> *
> *
>
>
>
> _______________________________________________
> 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/dc49bca2/attachment-0001.html