Avatar
Juan
  • Updated

Road Works GIS stack setup

Note: Road Works is deprecated. Please contact us if you have questions about tracking your fleet coverage with existing GpsGate features.

The Road Works plugin requires GIS stack. Before running the plugin, follow the steps below to set up GIS. 

PostgreSQL installation

1. Download and install the latest stable PostgreSQL version from here.

2. Open the installer.

mceclip0.png

3. Select the destination directory for the installation.

mceclip1.png

4. Select the following components.

mceclip2.png

5. Select the directory where you store the data.

  • It's highly recommended that you use a dedicated disk only for PostgreSQL Database.
  • In a production environment, it's recommended that you store the PostgreSQL data files on its own drive. Don't share the same drive for MySQL and Postgres data.

mceclip3.png

6. Select the password for the database. We recommend having "postgres" by default.

mceclip4.png

7. Leave the default port.

mceclip5.png

8. Select the default locale.

mceclip6.png

9. Click on Next.

mceclip7.png

10. Click on Next.

mceclip8.png

11. Select the option Stack Builder and click on Finish.

mceclip9.png

12. Select the version of PostgreSQL.

mceclip10.png

13. Select Spatial Extensions > PostGIS X.X Bundle.

mceclip11.png

14. Click on Next.

mceclip12.png

15. Click on Next.

mceclip13.png

16. Agree to the terms in order to continue.

mceclip14.png

17. Select PostGIS and click on Next.

mceclip15.png

18. Select the location for installing PostGIS

mceclip16.png

19. Select Yes.

mceclip17.png

20. Select Yes.

mceclip18.png

21. Select Yes.

22. Select Close.

mceclip19.png

23. Select Finish.

mceclip20.png

Now your PostgresSQL installation is done!

Edit the GpsGate.Service.config file

4.1. Click to edit C:\GpsGateServer\Franson NMEA Service\GpsGate.Service.exe.config.

4.2. In the "<appSettings>" section, paste the following settings:

 <!-- Username to connect to PostgreSQL. -->
 <!-- Enter the username selected during the installation process. -->
 <add key="POSTGRESQL_USERNAME" value="postgres"/>
 
 <!-- Password to connect to PostgreSQL. -->
 <!-- Enter the password selected during the installation process. -->
 <add key="POSTGRESQL_PASSWORD" value="postgres"/>
 
 <!-- The hostname to PostgreSQL database server. -->
 <!-- Set this if it's installed on a remote server. -->
 <!-- If it is not, you can exclude this setting. -->
 <add key="POSTGRESQL_HOSTNAME" value="localhost"/>
 
 <!-- Set this if you selected a custom port during the installation. -->
 <!-- If you did not, you can exclude this setting. --> 
 <add key="POSTGRESQL_PORT" value="5432"/>

 

Note: complete the "value" parameter with the password used in the PostgreSQL installation.

4.3. Save the file. 

Additional notes

  • For security reasons, don't expose the Postgresql server to the internet. Make sure the ports in use are blocked by your firewall.

Now you can continue with the rest of the Road Works setup.

Related articles