While following

https://github.com/3liz/lizmap-pgrouting-module/blob/master/docs/configuration.md

the queries to create the nodes and edges tables are depending on having imported the line vector contained in the mentioned shapefile, but this vector is not found inside

https://demo.lizmap.com/lizmap/index.php/view/media/getMedia?repository=modules&project=pgrouting&path=/media/pgrouting.zip

That zip file contains indeed the SQL with the INSERT statements for the nodes and edges tables, but there aren't the CREATE TABLE ones to create the necessary structure for this tables.

It seems to me (correct if I'm wrong) that at the moment the module is especially targeted to use distance/length as cost.

It would be nice to support a second set of cost columns for time in minutes, or have the function compute this cost using the length column and a column that would hold the speed value.

Re-launching

php lizmap/install/configurator.php pgrouting

do not ask again the questions about the SRID, pgsql group, etc. not even if deleting beforehand the folder where the pgrouting module was installed.

For now, the symbology is hard-coded in the JS files :

It would be nice to have the possibility to override these default symbology for the Lizmap administrator.

Add a class to check the pg routing config:

1. Check that pgrouting is installed in the database, even if an error message in logs
2. Check that the project is well configured

Error 500. A technical error has occured. Sorry for this trouble.

mapBuilder/urls.xml: include file urls.xml of the module pgrouting does not exist ()

I've tried to reconfigure mapBuilder, mapBuilderAdmin and LCW but the result is the same
php configurator.php mapBuilder
Configuration migration is starting
Configuration migration is finished
Configuration is starting
All modules dependencies are ok
Configuration starts
Modules are configured
Configuration is finished

php configurator.php mapBuilderAdmin
Configuration migration is starting
Configuration migration is finished
Configuration is starting
All modules dependencies are ok
Configuration starts
Modules are configured
Configuration is finished

sudo php installer.php
Installation is starting
All modules dependencies are ok
Installation starts
Module mapBuilder upgraded to the version 2.1.1
Module mapBuilderAdmin upgraded to the version 2.1.1
All modules are installed or upgraded
Installation is finished

php configurator.php
Configuration migration is starting
Configuration migration is finished
Configuration is starting
All modules dependencies are ok
Configuration starts
Configuration of the module jelix
Configuration of the module jcommunity
Configuration of the module jacl2
Configuration of the module jacl2db
Configuration of the module master_admin
Configuration of the module jauthdb_admin
Configuration of the module jacl2db_admin
Configuration of the module admin
Configuration of the module lizmap
Configuration of the module mapBuilder
Configuration of the module mapBuilderAdmin
Configuration of the module wps
Configuration of the module pgrouting
SRID your are using? (default is '32633') >
PostgreSQL group of user to grant access on the schema pgrouting ? > lizmap
Which is the type of your database? (default is 'pgsql')
[0] mssql
[1] mysqli
[2] oci
[3] pgsql
[4] sqlite3
[5] sqlsrv

Use a PDO to connect to the database? ( 'y' or 'n', default is n) > y
For all tables accessible from this connection, are they name prefixed? ( 'y' or 'n', default is n) > n
Configuration of the module view
Configuration of the module action
Configuration of the module proj4php
Configuration of the module dynamicLayers
Configuration of the module filter
Configuration of the module dataviz
Modules are configured
Configuration is finished

Installation is starting
All modules dependencies are ok
Installation starts
All modules are installed or upgraded
Installation is finished

After road selection and deselection by refresh pgrouting button, the pointer remain holded on pgrouting mode, and switch to default pointer only after a page refresh by browser

I attach a screencast
Video del 07-03-2023 11:38:58 AM.webm

As part of the installation/configuration it is created also a "pgrouting_demo" schema, with a "edition" table in it.

This table is part of the sample projects here

https://demo.lizmap.com/lizmap/index.php/view/media/getMedia?repository=modules&project=pgrouting&path=/media/pgrouting.zip

and here

https://github.com/3liz/lizmap-pgrouting-module/tree/master/tests/lizmap/instances/pgrouting

anyway is unclear its function, as I can't see any mention in docs, and also I can't see any change in the table content when/after using lizmap/pgrouting.

Bonus question 1: what is the function of the JS file in media/js/pgrouting? is it mandatory? why its content is different here

https://demo.lizmap.com/lizmap/index.php/view/media/getMedia?repository=modules&project=pgrouting&path=/media/pgrouting.zip

and here

https://github.com/3liz/lizmap-pgrouting-module/tree/master/tests/lizmap/instances/pgrouting/media/js/pgrouting

?

Bonus question 2: what is the function of the "qgis_plugin" table also created inside the "pg_routing" schema?

Trying to follow documentation here

https://github.com/3liz/lizmap-pgrouting-module/blob/master/docs/installation.md

1. while trying to install the module without using composer an error is returned

php lizmap/install/configurator.php pgrouting
Configuration migration is starting
Configuration migration is finished

In ModuleInfos.php line 113:

  No module.xml file into /home/gmanghi/www/naturalgis_demo/lizmap/lizmap-modules/pgrouting/


configure [-p|--parameters PARAMETERS] [-r|--remove] [-f|--force] [-e|--entry-points ENTRY-POINTS] [--] [<module>]

2. installation with composer seems to work, anyway running the "configurator.php" script as described here

https://github.com/3liz/lizmap-pgrouting-module/blob/master/docs/installation.md#launching-the-installer-with-lizmap-web-client-36

do not ask "all parameters for the PostgreSQL database access", just the other infos (SRID, role, etc.), so the next step

php lizmap/install/installer.php

fails with

Installation is starting
All modules dependencies are ok
Installation starts
[error] An error occured during the installation of the module pgrouting: error during the connection localhost
Installation is finished

I'm using LMWC 3.6.9 and PHP 8.1 and the doubt is if the path to follow is the one described in "Launching the installer with Lizmap Web Client 3.6"

https://github.com/3liz/lizmap-pgrouting-module/blob/master/docs/installation.md#launching-the-installer-with-lizmap-web-client-36

or in "Launching the installer with Lizmap 3.5"

https://github.com/3liz/lizmap-pgrouting-module/blob/master/docs/installation.md#launching-the-installer-with-lizmap-35

because the latter also says "If you are using Lizmap Web Client 3.6 or higher..." as the former, but maybe this just an error in the docs(?).

Any help is much appreciated.

At the moment only partial distances are shown.

LWC 3.6.3 pgrouting 0.3.1 installed via composer
Behaviour with original pgrouting.js
Video del 05-03-2023 02:00:52 PM.webm

after that I've commented the from line 181 to 193,

then ,
Video del 05-03-2023 01:58:45 PM.webm

after the comments selection become drawed

If you already have set start and end point, you only be able to move these points.

If you move the map, you are not able to get the points and move it, you prefer to restart the operation.

Bonjour, j'utilise pgrouting pour un de mes projet (version Lizmap Web Client 3.6). J'ai suivi la documentation avec une Installation manuelle du module (la dernière archive ZIP ) . Mais dès que je procède à l'installation et imprt de la couche route dans ma table pgrouting dans postgis, mon serveur ne marche plus, il me met "This web site is closed" .
Journal :
2023-12-12T08:21:45 WARNING Récupération du HTTP http://localhost/lizmap36/lizmap/www/index.php/view/app/metadata échouée avec l'erreur Error transferring http://localhost/lizmap36/lizmap/www/index.php/view/app/metadata - server replied: Application not available
2023-12-12T08:22:08 INFO État de l'application
variable d'environnement QGIS_PREFIX_PATH : C:/PROGRA1/QGIS321.0/apps/qgis
Préfixe: C:/PROGRA1/QGIS321.0/apps/qgis
Chemin des extensions: C:/PROGRA1/QGIS321.0/apps/qgis/plugins
Chemin des paquets de données: C:/PROGRA1/QGIS321.0/apps/qgis/.
Nom du thème actif: default
Chemin du thème actif: C:/PROGRA1/QGIS321.0/apps/qgis/./resources/themes\default\icons/
Chemin du thème par défaut: :/images/themes/default/
Chemins de recherche SVG: C:/PROGRA1/QGIS321.0/apps/qgis/./svg/
C:/Users/gakou/AppData/Roaming/QGIS/QGIS3\profiles\default/svg/
Chemin de la BD utilisateur: C:/PROGRA1/QGIS321.0/apps/qgis/./resources/qgis.db
Chemin de la BD d'authentification: C:/Users/gakou/AppData/Roaming/QGIS/QGIS3\profiles\default/qgis-auth.db .
Pourriez-vous m'aider s'il vous plait ?

If no routes have been found, the previous roadmap still displayed and no message is displayed.

In the Search Class, be sure that the data provided by the request is not null.

https://github.com/3liz/lizmap-pgrouting-module/blob/master/pgrouting/classes/search.class.php#L80

With concatenated dropdowns/comboboxes.

user choose a road, a separate combobox show only the door numbers in that specific road. Of course this would need to have a relation with a table with roads lines/names, and points representing the door numbers.