Documentation for WEB Report System PSIM 1.0.1.

Previous page General description of Web Report System PSIM distribution kit  Repairing Next page

WEB Report System PSIM is installed as a part of Axxon PSIM. 

Attention!

WEB Report System PSIM should be installed only on Server/Administrator's workplace (for details, see Axxon PSIM software. Administrator's Guide).

To install WEB Report System PSIM, do the following:

  1. Run the setup.exe executable file in the distribution root directory. 
  2. To continue the installation process, click Next.
  3. Read the terms of the license agreement carefully. Then set the switch to I accept the terms of the License agreement position and click Next.

  4. Select MS SQL Server DB server and set the connection parameters (for details, see Installation of Axxon PSIM as a Server/Remote Administrator's workstation). To continue the installation process, click Next.

    Note

    The WEB Report System PSIM database will be created on the selected SQL server.

    Later it's possible to move the database of WEB Report System PSIM to another SQL server. After that, it is necessary to make changes to the <Axxon PSIM installation directory>\Modules\Wt2\Web.config file by correcting the ReportSystemConnectionString connection string:

    • <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient"/>


  5. Specify the connection strings to the main Axxon PSIM database and the POS PSIM receipts database. The connected databases will serve as a data source when creating reports.


  6. To set connection string to the main Axxon PSIM database, do the following:

    1. Click Connection to the main PSIM DB.

    2. As a result the Data Link Properties dialog box is displayed.

    3. In the Provider tab select Microsoft OLE DB Provider for SQL Server. Click Next.

    4. As a result there will be an automatic switch to Connection.

    5. In 1. Select or enter a server name line select from the list or enter manually the name of SQL server where the main Axxon PSIM database is stored.

    6. To log on SQL server it is necessary to set authentication parameters. For this set switch into Use a specific user name and password position. In the User name and Password fields enter username (login) and password in order to connect to SQL server. Set the Allow saving password checkbox.

    7. To check connection to SQL server, click Test Connection.
      In case of successful connection, the window with the Test connection succeeded message will be displayed.

      It's necessary to click OK       in the window of message and as a result the window will be shut down automatically.
      If the name of SQL server and/or authentication parameters that are used in order to connect to it were set wrong then the corresponding message is displayed.

      To shut down the window with the message, click OK      . Then correct the data and check connection to SQL server once again.

    8. If check of connection to SQL server is successful, select from the Select database on server list the name of connected database.

    9. Click OK in the Data Link Properties dialog box. As a result of this operation the dialog box will shut down.
      Setting connection string to the main Axxon PSIM database is completed.

  7. In the same way, set the connection string to the POS PSIM database of receipts (the default database name is pos).
  8. Click the Next button to proceed to setting up the connection to the Auto PSIM databases.
  9. In the same way, set the connection string to the Traffic Detection database (the default database name is traffic_db).

  10. In the same way, set the connection string to the License Plate Recognizer database (the default database name is lprex).

  11. Click Next to proceed to configuring the connection to the DetectorPack PSIM databases.

  12. In the same way, set the connection string to the DetectorPack PSIM database (the default database name is detectorpack).

    Note

    If you install POS PSIM, Auto PSIM and DetectorPack PSIM after the WEB Report System PSIM, it is necessary to connect the WEB Report System PSIM database to the corresponding modules. To do this, start the repairing mode of the reporting subsystem and specify the appropriate connection strings (see Repairing).

    You can also set the connection strings to all databases through the <Axxon PSIM installation directory>\Modules\Wt2\Web.config file. Examples of connection strings are given below:

    • <add name="PSIMDB" connectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Axxon PSIM;Data Source=(local)\SQLEXPRESS2014" />
    • <add name="PosDB" connectionString="Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pos;Provider=SQLOLEDB.1" providerName="System.Data.SqlClient" />
    • <add name="TrafficDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=traffic_db" />
    • <add name="DtDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=dt" />
    • <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient" />
    • <add name="Analytics" connectionString="Server=localhost;Port=15432;User id=postgres;Password=Analytics_default_DB_4;Database=analytics;CommandTimeout=600;" providerName="Npgsql" />
    • <add name="lprex" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=lprex" />
    • <add name="detectorpack" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=detectorpack;"/>


  13. To continue the installation process, click Next. As a result, the copying of the necessary WEB Report System PSIM files to the hard disk will start.
  14. After successful copying of the WEB Report System PSIM components, a message about the completion of the installation process will be displayed. Then click Finish..

The installation of WEB Report System PSIM is completed.

  • No labels