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

[McDonaldR]

Hello Dave

With the updated PATH variable the Dependency Walker finds the correct DLLs that were missing before but now there are 5 more that appear in the list related to LIBSTDC++-6.dll:

IESHIMS.dll
MF.dll
MFPLAT.dll
MFREADWRITE.dll
WLANAPI.dll

The database service has been restarted.

I've also rebooted.

I still get the librouting.dll not found error.

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 16:16
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

How did you restart the database ?

The way that windows works means that an changed envronmential variable is only available after its been changed.

So a new dos window will the changed value.

If your running your database as a service, it will not see the changed envronmential variable util its restarted.  Perhaps you need to changed the value then do a reboot?

> 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:\Window
> s\System32
> \WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\Po
> stgreSQL\9.2\lib
>
> And:
>
> Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Window
> s\System32 \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.