can not perform installation of pgRouting module for kamap

[shilpi]

i tried to follow the steps as given in ominiverdi's wiki
i installed gual,boost,cgal with no errors
as given on this site: http://www.postlbs.org/postlbs-cms/en/node/21

but when i perform this step: PGSQL_PATH/bin/psql -f routing.sql routing
as given in step 3 of the above-mentioned link, i get the following errors:

http://rafb.net/p/tzO19J54.html


or:


# psql -f /usr/share/postgresql/8.2/contrib/routing.sql routing
psql:/usr/share/postgresql/8.2/contrib/routing.sql:22: ERROR:  relation "path_result" already exists
psql:/usr/share/postgresql/8.2/contrib/routing.sql:23: ERROR:  relation "vertex_result" already exists
psql:/usr/share/postgresql/8.2/contrib/routing.sql:33: ERROR:  could not load library "/usr/lib/postgresql/8.2/lib/routing.so": libgaul_util.so.0: cannot open shared object file: No such file or directory
psql:/usr/share/postgresql/8.2/contrib/routing.sql:44: ERROR:  could not load library "/usr/lib/postgresql/8.2/lib/routing.so": libgaul_util.so.0: cannot open shared object file: No such file or directory
psql:/usr/share/postgresql/8.2/contrib/routing.sql:53: ERROR:  could not load library "/usr/lib/postgresql/8.2/lib/routing.so": libgaul_util.so.0: cannot open shared object file: No such file or directory
psql:/usr/share/postgresql/8.2/contrib/routing.sql:63: ERROR:  could not load library "/usr/lib/postgresql/8.2/lib/routing.so": libgaul_util.so.0: cannot open shared object file: No such file or directory
psql:/usr/share/postgresql/8.2/contrib/routing.sql:74: ERROR:  could not load library "/usr/lib/postgresql/8.2/lib/routing.so": libgaul_util.so.0: cannot open shared object file: No such file or directory
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

 


i tried re compiling BOOST,GAUL,CGAL.
but the same errors sprout back..
what could be wrong ?
plz help!

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Sean Fulton]

On 2007-03-17 11:08:27 -0400, "shilpi pasricha" <ekpari84@...> said:
> i tried to follow the steps as given in ominiverdi's wiki
> i installed gual,boost,cgal with no errors
> as given on this site: http://www.postlbs.org/postlbs-cms/en/node/21
>
> but when i perform this step: PGSQL_PATH/bin/psql -f routing.sql routing
> as given in step 3 of the above-mentioned link, i get the following errors:
>
> http://rafb.net/p/tzO19J54.html

>
> i tried re compiling BOOST,GAUL,CGAL.
> but the same errors sprout back..
> what could be wrong ?
> plz help!

I had the same the problem. pgRouting has a problem in how it links
libraries. I've haven't tried to find a proper fix but I did
successfully work around it. The pgRouting library expects CGAL and
GAUL libraries to be in the directory directly above it.

For example:

- If routing.so -> /usr/lib/pgsql/routing.so
- it expects -> /usr/lib/libCGAL.so

So, create sym links in the directory above routing.so to the actual
libraries. You'll have to do this for libgaul and libgaul_util as well.

Other options are to move the libraries or fix the pgRouting build
process. I opted for the quick fix.

        Sean


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[pranjal]

thanks:)its working

regards

pranjal

Sean Fulton wrote:

On 2007-03-17 11:08:27 -0400, "shilpi pasricha" <[e-mail]> said:
> i tried to follow the steps as given in ominiverdi's wiki
> i installed gual,boost,cgal with no errors
> as given on this site: http://www.postlbs.org/postlbs-cms/en/node/21
>
> but when i perform this step: PGSQL_PATH/bin/psql -f routing.sql routing
> as given in step 3 of the above-mentioned link, i get the following errors:
>
> http://rafb.net/p/tzO19J54.html

>
> i tried re compiling BOOST,GAUL,CGAL.
> but the same errors sprout back..
> what could be wrong ?
> plz help!

I had the same the problem. pgRouting has a problem in how it links
libraries. I've haven't tried to find a proper fix but I did
successfully work around it. The pgRouting library expects CGAL and
GAUL libraries to be in the directory directly above it.

For example:

- If routing.so -> /usr/lib/pgsql/routing.so
- it expects -> /usr/lib/libCGAL.so

So, create sym links in the directory above routing.so to the actual
libraries. You'll have to do this for libgaul and libgaul_util as well.

Other options are to move the libraries or fix the pgRouting build
process. I opted for the quick fix.

        Sean


_______________________________________________
postgis-users mailing list
[e-mail]
http://postgis.refractions.net/mailman/listinfo/postgis-users