[pgrouting-users] error on routing_dd.sql

Jules_Kouadio · August 16, 2011, 3:36pm

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

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 .

Stephen_Woodbridge1 · August 16, 2011, 5:48pm

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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Jules_Kouadio · August 17, 2011, 10:53am

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

dkastl · August 17, 2011, 11:04am

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@gmail.com> wrote:

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Jules_Kouadio · August 17, 2011, 11:50am

I have compile it myself.

Centos 5. 5 (Linux version 2.6.18-238.19.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50))

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

dkastl · August 17, 2011, 11:55am

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@gmail.com> wrote:

I have compile it myself.

Centos 5. 5 (Linux version 2.6.18-238.19.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50))

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Jules_Kouadio · August 17, 2011, 3:20pm

Thanks Daniel
How can I know that pgrouting is correctly inslalled
Jules ?

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

I have compile it myself.

Centos 5. 5 (Linux version 2.6.18-238.19.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50))

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

dkastl · August 17, 2011, 10:44pm

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@gmail.com> wrote:

Thanks Daniel
How can I know that pgrouting is correctly inslalled
Jules ?

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

I have compile it myself.

Centos 5. 5 (Linux version 2.6.18-238.19.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50))

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Jules_Kouadio · August 18, 2011, 7:49am

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

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

Thanks Daniel
How can I know that pgrouting is correctly inslalled
Jules ?

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

I have compile it myself.

Centos 5. 5 (Linux version 2.6.18-238.19.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50))

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

dkastl · August 18, 2011, 8:56am

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@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@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@gmail.com> wrote:

Thanks Daniel
How can I know that pgrouting is correctly inslalled
Jules ?

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

I have compile it myself.

Centos 5. 5 (Linux version 2.6.18-238.19.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50))

2011/8/17 Daniel Kastl <daniel@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@gmail.com> wrote:

Sorry but i get always the same error.
Thanks

2011/8/16 Stephen Woodbridge <woodbri@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de