[pgrouting-users] Could not load library librouting.dll error

Mon Aug 10 09:01:27 PDT 2015

Thank you Regina

It would be good to test that.  Will the binaries also be available from winnie.postgis.net?  We operate behind a firewall and cannot use the stack builder.

Ross

-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Paragon Corporation
Sent: 10 August 2015 16:14
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

I had to upgrade  the gcc I am using for building with PostgreSQL 9.2 and also they made a change in PostgreSQL 9.2 micros around 9.2.5 or so that is incompatible with older postgresql 9.2 that forced a recompile of some things.

I'll build a new PostgreSQL 9.2 and pgRouting 2.0.0 and test with latest 9.2 64-bit.  If it goes well I'll push to application stack builder (PostgreSQL
9.2 PostGIS 2.1.8 and pgRouting 2.0.0)

Let me spin up a 9.2 64-bit to test with and see what's up.

Thanks,
Regina

-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org
[mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 10:59 AM
To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

Thanks for the reply, Dave

I've tried with the PATH set to both:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\PostgreS
QL\9.2\lib

And:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext

I wonder if it is something to do with the way PostgreSQL, PostGIS and PgRouting are compiled?  Looking at http://winnie.postgis.net/download/windows/pg92/buildbot/ there are versions compiled with GCC4.8 and others with something else.  I've tried all the 64bit binary versions there with no luck.

Ross

-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org
[mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of dave.potts at pinan.co.uk
Sent: 10 August 2015 15:28
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

Hi

What is the environmental variable path set to ?

You can get its value by opening a dos window and typing set

This variable lists the folders that an application will search through to find library files.

You can change its value by selecting control panel-->Adminstrative Tools-> Right click on computer  select properties-> select advanced system settings and the envrionment variable button is on the lower right hand side

The value should be a list off folders to search seperated by a ; character.

Dave

#> Hello list,
>
> I am running 64bit PostgreSQL 9.2.13 with PostGIS 2.1.7 on Windows
> Server
> 2008 R2.  I have pgRouting installed (2.0.0 build 40, hash 567ac3b,
> boost
> 1.46.1)
>
> I am getting an error when trying to use pgRouting.
>
> [ERROR: could not load library "D:/PostgreSQL/9.2/lib/librouting.dll":
> The specified procedure could not be found.
> SQL state: 58P01]
>
> SQL state error 58P01 is UNDEFINED FILE.
>
> Using dependency walker it tells me that librouting.dll cannot find
> libgcc_s_sjlj-1.dll and libstdc++-6.dll and postgres.exe.  These files
> all exist in the \bin folder of my PostgreSQL install.  The PgRouting
> files are all installed in the \lib folder.
>
> I get the error when using both the PgAdmin SQL pane and the pgRouting
> Layer plugin in QGIS.
>
> Any pointers or suggestions appreciated.
>
> Thanks
>
> Ross
>
> Ross McDonald | GIS Data Coordinator | Resources Department, IT
> Division | Angus Council, Angus House, Orchardbank Business Park,
> Forfar, DD8 1AT
> T: 01307 476419 | F: 01307 476401 | E:
> mcdonaldr at angus.gov.uk<mailto:mcdonaldr at angus.gov.uk>
>
>
>
> This message is strictly confidential. If you have received this in
> error, please inform the sender and remove it from your system. If
> received in error you may not copy, print, forward or use it or any
> attachment in any way. This message is not capable of creating a legal
> contract or a binding representation and does not represent the views
> of Angus Council. Emails may be monitored for security and network
> management reasons. Messages containing inappropriate content may be
> intercepted. Angus Council does not accept any liability for any harm
> that may be caused to the recipient system or data on it by this
> message
or any attachment.
> _______________________________________________
> 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

This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.
_______________________________________________
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

This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.