0

I was able to use osm2pgrouting tool successfully on Windows with PostgreSQL version 11.9 and pgRouting version 3.1.0. I successfully generated my "ways" file in a PostGIS conection in QGIS 3.10.3.Now I want to test a Dijkstra algorithm with the pgRouting Layer plugin, but I constantly get a Python error, as follows:

File "C:/Users/jorge/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pgRoutingLayer\pgRoutingLayer.py", line 1255, in openHelp
          db = self.actionsDb[dbname].connect()
         KeyError: ''

I am already connected to my postgres DB through DB Manager of QGIS but in my pgRouting Layer dialogue box, I am never "shown as connected" to my postgres DB as shown in following figure. I tried to press refresh button and drop down list many times but no use. I've also saved my user and password in my DB connection, but it haven't solved my problem.

enter image description here

Improve this question
5
  • All your software versions look very much outdated, many of them not supported anymore. I would strongly suggest you to first try newer versions!
    – dkastl
    Commented Aug 29, 2020 at 3:43
  • With what user are you trying to connect?
    – Iman Rosstin
    Commented Aug 29, 2020 at 20:23
  • @lman the user I tried to connect is "postgres"
    – Jorge Fuenzalida Izquierdo
    Commented Aug 30, 2020 at 0:43
  • @dkastl I'm sorry, I misspelled the versions. My postgis version is 3.0.2 and my pgrouting version is 3.1.0. My PostgreSQL version is 11.9
    – Jorge Fuenzalida Izquierdo
    Commented Aug 30, 2020 at 0:57
  • As per the help center it is OK to try and reproduce software problems in a Q&A here, but if you think this is a bug then be sure to submit it to the pgRoutingLayer development team. Please post a link to the bug report here.
    – underdark
    Commented Oct 4, 2020 at 14:34

1 Answer 1

Reset to default
1

I was facing similar issue at my end. System Specification: Ubuntu 18.04, QGIS version - 3.14.16-Pi, Installed pgRouting Layer plugin version - 3.0.0

Now, after installing the latest release (3.0.1) of pgRouting Layer Plugin, it is working perfectly. I am also able to execute and visualize the resulting layer obtained by pgr_dijkstraCost function.

How I installed pgRouting Layer plugin's v3.0.1?

  1. Download zip for the 3.0.1 release.
  2. Select 'Install from ZIP' option followed by selecting downloaded ZIP file under 'Manage and Install Plugin' in QGIS.
  3. Restarting pgRouting Layer plugin from 'Database' tab.

Hope this helps!

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.