Table of Contents
While it is possible to run RAPC on other operating systems, this document focuses on the RAPC administration under Windows.
A "\" at the end of the line in program listings means that the line continues in the next line.
This document uses Unified Modeling Language (UML) diagrams to illustrate various aspects of the RAPC application.
For those not familiar with the UML symbology, Figure 1, “UML Legend” provides a basic UML legend.
The RAPC application can be installed in a stand-alone setup or in a client-server environment.
The RAPC application is meant to run in an intranet environment. If you want to use the application over the internet you should protect it by a proper firewall and/or VPN setup. To run the application directly on an internet server would require a complete security audit of the application code.
Regardless of the type of installation, it is important that the administrator stays up-to-date with the latest Apache, PostgreSQL, Windows and PHP releases to avoid security leaks.
In addition to the outlined approach it might be possible to run a RAPC on server on the internet if it is hardened with SSL and additional access control on the Apache side (E.g. client-side certificates).
This section describes the hard- and software requirements of the RAPC application.
A PC with at least 256 MB RAM and at least 1 GHz CPU speed.
The actual hardware requirements might be higher depending on the size and nature of the map data as well as the number of concurrent users.
To print the forms, a printer with at least 300dpi resolution is required
The following software packages are required to run the RAPC application:
Apache (Other web servers will also work)
The following PEAR modules:
Mapserver (PHP Mapscript)
Section 4, “Installation” covers the installation of all required software packages.
If it is intended to use the Arabic interface of the RAPC application, the PostArabic software package is required in addition.
While it might be possible to install the RAPC server on other Windows flavors, only Windows 2003 Server and Windows XP are recommended.
The filesystem of
Windows 2000 installations have been tested and should work. Windows NT, 95, 98 are ME not recommended.
Installation of RAPC on other operating systems such as Linux may require minor changes to the source code. Please contact the RAPC developers if you are having problems. The initial RAPC version was created on Windows.
On Windows, the following folders contain files that belong to the standard RAPC installation:
+ c: | +--+ Program Files | | | +--+ Apache Group | | | | | +--- Apache2 | | | | +--+ rapc | | | | | +--- config | | | | | +--- doc | | | | | +--- data | | | | | +--- plugin | | | +--+ PostgreSQL | | | +--+ 8.0 | | | +--- data | +--+ tmp | | | +--- ms_tmp | +--+ windows | +--- fonts | +--- php
Note that your actual folder structure might be different, e.g. when you use a Non-English version of Windows XP. Use the structure above as a reference when you're not sure where to install things.
If you are installing manually, you should install the software to the above mentioned folders.
PostgreSQL folder holds the PostgreSQL
Apache2 folder the Apache
webserver and the
php folder the PHP installation.
tmp folder holds temporary files (e.g. PHP
session information) and the
ms_tmp folder contains
temporary map files created by mapserver.
For most of the software packages these folders are the default on a system with an English version of the Windows operating system. The folders will be created during the installation process described below.
c:\Program Files\rapc\config contains all
c:\Program Files\rapc\doc contains the
documentation in various formats: CHM, DocBook XML, HTML, PDF.
c:\Program Files\rapc\data contains GIS data
(shape files) used by the application. However this location is not
fixed and may be overridden in the map file.
c:\Program Files\rapc\plugin contains
application plug-ins (extensions that extend the functionality).
Basic computer knowledge together with this guide should be sufficient to administer a stand-alone installation.
Any administrator will benefit from knowledge in SQL, PostgreSQL, the Windows command line interface (cmd.exe), Windows user administration, Windows services, GIS (e.g. ArcView), mailing lists - however such knowledge is not a requirement.
Various support possibilities are available to support new administrators.
This section outlines important concepts that are relevant to the RAPC administration.
This section introduces Windows services.
Apache and PostgreSQL run as Windows services.
To open the Services Panel, open the Control Panel from the Start Menu as shown in Figure 5, “Control Panel”.
In the Control Panel, click on the following icon:
Open the Services Panel by clicking on the this shortcut:
The Services Panel is displayed in Figure 6, “Services Panel”.
The Status column shows the services that are currently running. In Figure 6, “Services Panel” is running ("Started") while the Removable Storage is not running (empty Status column).
To start a service, click on the button.
To stop a service, click on the button.
In both cases, verify the success in the Status column of the service list.
For additional information on Windows services, consult your Windows documentation.
Important information on Windows user accounts.Figure 7, “Windows Users” shows users that are important for the RAPC administration. Note that the unpriviledged users account to operate RAPC are omitted.
For additional information on Windows user accounts, consult your Windows documentation.
While the Windows user accounts "system" and "postgres", you don't have to know their passwords.
The name of the Windows user account to run the PostgreSQL database service (default: postgres) can be changed during the PostgreSQL installation.
Introduction to PostgreSQL user management.Figure 8, “PostgreSQL Users” shows PostgreSQL users that are important for the RAPC administration. Windows users and system boundaries are shown to clarify the relationships.
The PostgreSQL documentation which you can access e.g. through the Start Menu (after PostgreSQL installation) or on the PostgreSQL website contains additional information on PostgreSQL user management.
Don't get confused by the two "postgres" accounts: Even though they have the same name, they are different things, one lives inside PostgreSQL and one inside Windows. You don't have to know the password of the Windows account "postgres" (The PostgreSQL intaller is creating a long, random password for it), but you have to know the password of the PostgreSQL account "postgres".
Please follow the PostgreSQL installation instructions carefully (Section 4.1.3, “PostgreSQL”).
If you are going to use RAPC in more than one language and would like to use the RAPC translation system for your data, you should read this section.
RAPC is actually using the GNU gettext for text that occurs in the PHP sources .
GNU gettext is a widely used system for translation management.
RAPC is using the PHP gettext extension, the translations are
edited in the
files. Replace "*" with a two letter ("ar") or five letter ("ar_JO")
In order to be used by gettext, the source files
rapc.po) files have to be compiled to
Editing and compilation is conveniently done with poEdit (Section 4.5.3, “poEdit”). poEdit is also capable of extracting the translation terms from PHP sources.
Messages that have to be translated but are not included in the
PHP sources should be added to
This is the case e.g. for coded values from the database.
Messages residing in the PostgreSQL database should be
internationalized using the
dcmmstranslation() function looks up
translations from the
name field of the
should contain the name in the primary language that is used to
operate the application. E.g. in the case of landmarks, this is
the field that is filled and used if no other translation is given.
Additional translations are stored in the translation table.
The shapefile loader (Section 6.1.1, “Shapefile Loader”) allows
to update the translation table
from fields like
arname (Arabic), etc.
To use translations, e.g. in map files, use the following statement:
dcmmstranslation('en', name)where 'en' is the ISO code of the language you want to use.
If no matching translation is found in the translation table,
the term to translate is returned by
Mailing lists are automated distribution systems for emails.
Feature request, and bugs can be sent directly to the following
The majority of the software products mentioned in this document offer a multitude of mailing lists to keep users and administrators updates about the latest releases as well as potential security issues.
If you are not familiar with mailing lists yet, take the time to familiarize with the techniques to subscribe and to post to them.
This section outlines several installation options for the RAPC application.
The manual installation instructions will also work on operating systems like Linux.
Please report all RAPC installation problems in order to allow the developers to further enhance the installation process.
Any remarks can be sent directly to the following email
How to install RAPC on Windows XP Professional or Windows 2003 Server.
Please contact the RAPC developers if you are looking for a RAPC CD release.
All installers mentioned below area available in the
setup folder of the CD.
If you are running Skype, you may want to shutdown Skype while you are installing Apache as Skype might otherwise prevent Apache from using port 80.
If the Apache installation is not fully
successful because another program (e.g. IIS) is already using port
80, simply edit
Run the Apache installer. The Apache
installer is available from the
setup folder of
the RAPC CD or from the Apache website: http://httpd.apache.org.
C:\Program Files\Apache Groupand click .
The RAPC installer reads the Apache installation folder from the Windows registry. You can install Apache to different locations.
If the Apache installation fails because another application is using port 80, you can use the following commands to find out which application is using port 80:
tasklistLook for the process id (PID) of the process occupying port 80 and find the application of the process id.
Run the DCMMS Scripting installer. The
installer is available from the
setup folder of
the CD or from the DCMMS website: http://dcmms.sourceforge.net.
PEAR modules can be easily installed and upgraded over the internet. See the PEAR documentation for details. However, the DCMMS scripting installer provides all necessary packages.
c:\windows\php, by clicking (Figure 18, “PHP Location”).
This section describes how to install PostgreSQL for Windows.
The PostgreSQL installer
postgresql-8.0.msi) is available from the
setup folder of the RAPC CD or from http://pgfoundry.org/projects/pginstaller/.
Don't get confused by the two PostgreSQL installer files. They are both required and can only be installed together.
Run the PostgreSQL installer and select the English language.
Click on the icon next to "PostGIS Spatial Extensions" and select.
Instead of installing PostGIS with the PostgreSQL installer,
you should install a newer version from a separate installer (at
least version 1.0.3). Such an installer is available from http://www.webbased.co.uk/mca/
or from the
Once PostgreSQL 8.1 is released, the PostGIS version included in the PostgreSQL installer will be sufficient.
Note that the PostgreSQL installation path is not important. Please accept the default installation path provided by the installer.
Accept the other settings as shown in Figure 22, “Choose Installation Options” and click .Figure 23, “Service Configuration” and click . Instead of "Z1027" your installer will show the name of your computer.
You don't have to remember the random password. It is only used internally to run the PostgreSQL service on Windows. See Section 3, “Concepts” for detailed information.
You'll need this password (for the PostgreSQL superuser "postgres") later on during the installation process e.g. while running the RAPC setup and for database maintenance purposes. Make sure that you remember it well.
Accept the default selection as shown in Figure 29, “Enable Contrib Modules” and click .Figure 30, “Enable PostGIS”, leave the option Enable PostGIS in template1 unchecked and click .
PostGIS will be enabled for the rapc database by the RAPC installer.Figure 31, “Ready to Install”, PostgeSQL can be installed now. Click .
As mentioned in Figure 32, “Installation complete”, it is recommended to subscribe to the pgsql-announce mailing list to stay up-to-date with the latest PostgreSQL developments.
Once the PostgreSQL
setup has finished, start the
PostGIS setup which is
available in the
setup folder of the CD or on the
Uncheck the option Create Database as shown in Figure 34, “PostGIS Components” and click .
The rapc database will be created by the RAPC installer.
The destination folder is your PostgreSQL installation folder and might differ from the one shown in Figure 35, “PostGIS Location”
Start the RAPC Setup, which is available
setup folder of the RAPC CD .
c:\program files\rapc, as shown in Figure 40, “RAPC Location” and click .Figure 27, “Initialise Database Cluster”). Click .
You should now be able to start the RAPC from the Start Menu or through the shortcut on the Desktop. Note that the full functionality will only be available once you've completed the data set, e.g. by loading the sample data.
The installer will not overwrite existing RAPC configuration files.
How to install RAPC manually.
This section might be useful only for installations on non-Windows platforms and for developers who are interested in the details of the RAPC installation process.
The RAPC installer sources (e.g.
The following expects that various PostgreSQL binaries, such as psql.exe or createlang.exe are in the PATH. If necessary, you have to change your PATH environment variable to include the bin folder of your PostgreSQL installation.
The PostgreSQL database is available from http://www.postgresql.org.
The PostgreSQL installation should support UNICODE.
You may run into problems if you use a binary PostgreSQL distribution under Linux or UNIX. In order to use PostGIS and specifically GEOS from PostgreSQL, the binaries have to be linked against libstc++. The PostGIS documentation contains details regarding this issue.
In order to enforce RAPC logins with
password authentication, the
configuration file should be altered like in the following example:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD host all postgres 127.0.0.1 255.255.255.255 trust host rapc all 127.0.0.1 255.255.255.255 password
Note that this still allows the PostgreSQL superuser postgres to connect to PostgreSQL server without authentication. However the user postgres is not allowed to log on to RAPC.
The instructions below assume that the PostgreSQL administrator is named postgres and that the postmaster is running on the local machine (localhost). If this is not the case for you, you'll have to adjust the commands accordingly. The same applies to the connection method - if your postmaster is not configured to accept TCP/IP connections, you have to adjust the commands (and possibly the RAPC configuration).
Create a new database named rapc using UNICODE, load the PL/SQL language to the database:
createdb -U postgres -h localhost --encoding=UNICODE rapc createlang -U postgres -h localhost plpgsql rapc
If PL/SQL was created in template1, the second command will fail. Ignore the error message in this case.
PostGIS is available from http://postgis.refractions.net .
Follow the installation instructions in the PostGIS documentation.
Once PostGIS is installed, change to the
spatial_ref_sys.sql and load
PostGIS to the rapc
psql -U postgres -h localhost -f postgis.sql rapc psql -U postgres -h localhost -f spatial_ref_sys.sql rapc
PostArabic is a small module that adds Arabic shaping functionality to PostgreSQL.
The PostArabic installation is only required in order to display Arabic map labels. If you are not interested in Arabic map labels, you can skip the PostArabic installation.
Follow the installation instructions in the file
Change to the directory containing
arabic.sql and load
PostArabic to the rapc
psql -U postgres -h localhost -f arabic.sql rapc
The Apache webserver is available from http://httpd.apache.org .
Follow the installation instructions in the Apache documentation.
Apache is configured through the
httpd.conf file. In order to access the
RAPC application by a convenient URL like
http://localhost/rapc/, you should add lines like the following to
Alias /rapc "c:/program files/rapc/" <Directory "c:/program files/rapc"> Options Indexes Multiviews </Directory> Alias /ms_tmp/ "c:/tmp/ms_tmp/"
The second alias line configures the location of temporary files created by PHP/Mapscript. You will have to adjust the RAPC sources to use the same alias and path. Adjust the path names according to your RAPC installation path.
The PHP scripting language is available from www.php.net.
RAPC is currently using PHP 4.*. Use of RAPC with PHP 5.0 will require some small changes to the application and is not recommended yet. Please contact the RAPC developers if PHP 5.0 is a requirement for your installation.
Follow the installation instructions in the PHP documentations.
If you don't install PHP to
Because of previous PHP/Mapscript limitations, it is recommended to install PHP as a CGI command.
The use of PHP as an Apache module is not very well tested with RAPC and may lead to instabilities. If you are testing such a setup, please share your experiences with the RAPC developers.
The installation can be completed with the following three lines
ScriptAlias /php/ "c:/windows/php/" AddType application/x-httpd-php .php Action application/x-httpd-php "/php/php.exe"
Again, make sure that the path names above match the ones on your system.
Add the following RAPC-specific configuration settings to
default_mimetype = "text/html" default_charset = "utf-8" include_path = ".;c:\windows\php\pear" error_reporting = E_ALL & ~E_NOTICE extension_dir = "c:/windows/php/extensions" enable_dl = On allow_call_time_pass_reference = On file_uploads = On upload_tmp_dir = c:\tmp upload_max_filesize = 20M extension=php_gd2.dll extension=php_gettext.dll extension=php_pgsql.dll extension=php_zip.dll extension=php_dbx.dll extension=php_oci.dll extension=php_pgsql.dll extension=php_mapscript_46.dll [Session] session.save_path = c:/tmp
In order to use gettext in PHP on Linux, the PHP safe mode has
to be enabled. The reason is that the
safe_mode = On
On Windows, install the mapserver distribution with PHP/Mapscript, which is available from the internet under http://maptools.org.
On other operating systems, install PHP/Mapscript from the Mapserver distribution which is available from http://mapserver.gis.umn.edu/index.html.
Make sure that the PHP/Mapscript extension is loaded in
You'll need a PHP/Mapscript binary compiled with PostGIS support.
Upon first installation, the RAPC application will provide two default PostgreSQL (RAPC) users:
User rapc with password rapc.
User admin with password admin.
As the name indicates, admin has administrator rights, whereas the user rapc has not.
See Section 3.3, “PostgreSQL users” for detailed information on Windows and PostgreSQL users.
On production systems, you should change the default passwords as soon as possible for security reasons.
The following points should be checked before a RAPC goes into production:
System clock setting
Eventually all removable media drives should be disabled to prevent installation of software
The PostgreSQL timezone setting. If necessary, adjust
postgresql.conf, e.g. by adding a line like
timezone = 'GMT-3'
You can check the timezone setting by the following SQL statement:
Failure to configure the timezone correctly will result in the following error message in the logon page: Configuration Error: PHP Time != PostgreSQL time.
This section describes the installation of various optional tools that ease the RAPC administration and configuration.
Active Perl is a PERL distribution for Windows.
It is freely available from http://www.activestate.com.
PERL is the programming language used for some PostGIS
maintenance tools like
On other operating systems like Linux, you will most likely be able to use the PERL distribution that is already installed.
GIX is an ArcView 3.* extension that allows to export views to mapserver map files.
GIX is available from http://gix.sourceforge.net.
You can only use fragments from the map files created by GIX as ArcView 3.* does not support PostGIS.
See Section 5.2, “Custom Map” for details regarding the RAPC map files.
To edit the
poEdit is recommended. It is freely available
Install poEdit version 1.3.1 or higher.
In order to extract the translation messages from the PHP sources, the following settings should be applied.
Selectfrom the menu.
Select the Parser tab and click on the button.Figure 42, “poEdit PHP parser settings”
Close the dialogs.
Choosefrom the menu.
In the Paths tab, add the path to the RAPC source as shown in Figure 43, “Catalog Path”
Make sure that you enter the actual path to the RAPC sources on your system.
Once the settings above have been applied, it is possible to update the catalog by selectingfrom the menu.
See also Section 3.4, “Translation System”.
This section describes how to configure RAPC after successfull installation.
conf/rapcconfig.php contains the
configuration of the RAPC application.
A default configuration file is stored under
conf/rapcconfig.php.default. Copy this file to
conf/rapcconfig.php if necessary.
The configuration file can be edited using any text editor.
All other configuration files can be found in the
How to use your own maps with RAPC.
Create your own map file(s) and edit the following line in
dcmconfig.php to point to this file:
$_SESSION["strMapFile"] = "conf/rpac_%s.map";
When customizing the map files, make sure to use other names than rapc_en.map. An update of the application would otherwise overwrite your customized map files.
In the default configuration, you need one map file for every language (%s will be replaced with the two-letter ISO language code).
If you would like to use RAPC in more than one language.
The "DESCRIPTION" metadata information must be provided for layers that return results for the identify tool.
In addition, the "TEMPLATE" has to be set for the respective class.
The following layers are required and should be copied from the sample files:
The default map resolution in map.php can be configured in the map file. Look for a line like the following:
SIZE 600 450
Currently the following configurations are possible without changes to the PHP source:
RAPC comes with symbol and font definitions in the files
A RAPC update will overwrite these files.
Use shptree.exe from the mapserver distribution to index large shape files used by the application.
Indexes created by shptree.exe will increase the performance when PHP/Mapscript is dealing with these files.
Note that the shptree.exe index format differs e.g. from the one used by ArcView.
The mapserver documentation available from http://mapserver.gis.umn.edu/ contains detailed information about the mapfile syntax.
The RAPC application replaces the dummy user name and password in the mapfile with the information provided by the user when logging on. Example 1, “PostGIS Connection Example” shows an example PostGIS connection line from a mapfile.
Example 1. PostGIS Connection Example
CONNECTION "dbname=rapc user=dummy password=dummy host=localhost"
Make sure that the PostgreSQL "rapcuser" group has the right to select from the tables used for your PostGIS layers.
Plug-ins for the identify tool of the map page allow to extend the functionality of the application.
The plug-ins are configured in
conf/identifyplugin.ini. The file is a simple
text file that can be edited with any text editor.
; Configuration file for map.php plug-ins [IdentifyPlugin] Plugin1 = ImageIdentifyPlugin Layer1 = Panel ;Plugin2 = ??? ;Layer2 = ???
Lines starting with ";" are comments and are ignored.
Section header of the IdentifyPlugin section.
plugin/imageidentifyplugin.php) will be
loaded as the first plug-in. The configuration line for the second
plug-in starts with "Plugin2"
The first plug-in will be used when the identify tool selects features in the "village" layer.
The configuration lines for the second plug-in are commented out, this plug-in has been disabled.
identifyplugin.ini can also
contain configuration options for the individual plug-ins (in
different sections). See the "[Plugin1]", "[Plugin2]", ... sections
This section describes various tasks related to the RAPC administration.
This section discusses various ways to load GIS data in various formats to the rapc database.
Not all GIS data used by the application has to be loaded to the database. Data that is only displayed on the map and not used otherwise in the application can be kept in its original format and location if it is supported by Mapserver. This is the case for shapefiles. Unless you are restoring a backup.
Besides the options described in the following sections, tools like ogr, QGIS or FME can also be used to load the data.
If you would like to load and use data in multiple languages.
The RAPC application allows to load GIS data in shapefile format through a web interface. Log in using a RAPC account with administrator rights, e.g. admin. Zip the shapefile before uploading.
See the RAPC User Guide for details on the shapefile loader.
Data that is edited in RAPC uses sequences to determine the next primary key. For this reason it might be necessary to adjust a sequence if certain shapefiles are loaded.
The commandline tool shp2pgsql is part of the PostGIS distribution and used internally by the RAPC shapefile loader web interface. It allows to load shapefiles to PostGIS tables.
Make sure that shp2pgsql.exe and psql.exe are in the path:
If necessary, adjust the encoding used by
psql through the
PGCLIENTENCODING environment variable:
If the table does not exist in your database yet, omit the "-d" option when calling shp2pgsql. See the shp2pgsql documentation for details.
Recreate the views if necessary:
You can use pgAdmin III as well as the commandline tools pg_dump or pg_dumpall to backup your RAPC database. Please refer to the pgAdmin III and PostgreSQL documentation for detailed information on how to perform the backups. In addition, the instructions below explain how to backup the database using the PostgreSQL command line tool pg_dumpall.
For all GIS data displayed in the RAPC maps, follow your usual backup strategies.
In order to backup the content of the RAPC database, do the following:
Open a Windows commandline (e.g. by executing %SYSTEMROOT%\system32\cmd.exe).
Execute the command below to create a dump file of the
database. The dump file will be saved as
pg_dumpall -c -U postgres -h localhost > c:\rapc-backup.sql
You have to make sure that pg_dumpall is in your PATH.
Write the dump file to a suitable backup media (e.g. a rewritable CD-ROM or a tape) and store it in a safe place.
Make sure that you also backup your map and configuration and
symbol files (
Restore is available through pgAdmin III as well as the commandline tools psql or pg_restore. Please refer to the pgAdmin III and PostgreSQL documentation for details how to restore a database dump. In addition, the instructions below explain how to restore the database using the PostgreSQL command line tool psql.
Restore all the GIS data used in the map from your GIS data backups.
In order to restore a previous dump file of the RAPC database, execute the following commands:
Open a Windows commandline (e.g. by executing %SYSTEMROOT%\system32\cmd.exe).
Restore the dump file:
psql -f c:\rapc-backup.sql -U postgres -h localhost -d rapcWhere
c:\rapc-backup.sqlis the path to the dump file - adjust this accordingly if your dump file is not
c:\rapc-backup.sql. Alternatively, you can copy your dump file to
You may be asked to enter the password of the PostgreSQL superuser "postgres".
Remove old files from
Be careful not to delete the
The RAPC installer schedules a task that runs the script
every day at 12:01.
The Schedule can be changed or deleted through the Windows Task Scheduler:
Choose Performance and Maintenance from the list.
Click on Scheduled Task. The task will most probably be called at1.
All data related to the RAPC business processes should be checked, at least with some samples.
The following list is a preliminary list of checks that should be performed:
The data entry quality should be checked by comparing the Panel application papers against the contents of the database.
The database information should be verified with the route maps that should link the Panels within the route.
A damaged RAPC installation can be difficult to repair and may require a complete re-installation of the system. For this reason, a proper user privilege separation is of utmost importance.
The user operating the RAPC application on the server must not have any administrator rights assigned.
The PostgreSQL administrator and the postgres accounts should be guarded by good passwords (not "password", "1234567quot; or "") and these password should only be known to the administrators.
When changing the password of the Windows user "postgres", the administrator has to re-enter the postgres password in the properties of the PostgreSQL Database Server 8.0 service.
This section gives help to solve problems with the RAPC installation.
The RAPC mailing list may provide
help to solve problems, either through the archives which are available
by sending an email to
If the application fails to connect to the database, check that the "PostgreSQL Database Server" service is up and running on the server. The Windows Services control panel can be reached for example by right-mouse clicking on the Apache Monitor symbol in the taskbar and selectingfrom the context menu.
If you're running a firewall, make sure that the firewall is not blocking the connection from PHP to PostgreSQL.
Try to reboot the machine. Alternatively, log on as
administrator and restart the service. The most common startup
problem is a leftover
If the PostgreSQL Database Server service fails to start, the Windows event log might provide useful information.
If the PostgreSQL service fails to start make sure that there
is no file named
If map labels are not displayed properly (e.g. garbage routename) and you're using tiled shapefiles, check that all your shapefiles have exactly the same table definition. Field name, type and order have to be exactly the same in all your shapefile tiles.
Suppose you have problems restoring a RAPC
database and you are getting the following error message:
ERROR: could not load library "/usr/lib/postgis.dll": dlopen: Win32
Edit your sql file and replace all occurrences of
If there are error messages like ERROR: function geometryfromtext(text, integer) does not exist., the text to geometry cast might be missing. It can be recreated with the following SQL command
create cast (text as geometry) with function geometry(text) as implicit;
The better way to fix this problem is to use the PostGIS
If the file upload in the Restore or
Shapefile Loader pages fails, the following
php.ini settings may have to be adjusted:
max_execution_time=3000 max_input_time=600 memory_limit=80M post_max_size=50M upload_max_filesize=50M
When trying to open a page, the following message appears on the server: Unknown(): Unable to load dynamic 'C:/Program Files/PHP/extensions\php_gettext.dll' - The specified module could not be found.
The following points may help to solve the problem:
Make sure that you've installed the zip distribution of PHP and not the installer version
Copy the file
Copy the file
c:\program files\php\dlls to
This also applies to
iconv.dll - in
this case, copy
The dll files can be found in the folder
dlls of the PHP
Apache, PostgreSQL, PHP and some of the installers write log files that are often helpful when troubleshooting.
The level of verbosity of the server logs can often be specified in the server configuration files.
The following locations might contain important log files:
%TEMP% - log files of the
rapc installer scripts
- fodler with log file of the PostgreSQL server.
The windows system log files.