Installation and configuration of a Vigilens web server

This is the type of a Web server allowing to execute Vigilens requests from a Web browser or to call these requests from a third party application (http request from MS Excel, task menu in ORACLE JD Edwards EnterpriseOne, …).

In addition to the Web component, this server will have all the characteristics of the installation of a Vigilens workstation and can therefore serve as an application server for the Vigilens suite.

Selection of the installation folderSame as for the installation of the single workstation., and same remarks.

You can choose to install (or not) the various Windows applications making the Vigilens Tools Suite. The server can thus (possibly) serve as an application server.

The Vigilens Web component requires a PHP server. This screen allows you to choose between :

• Installing a new EasyPHP server : Installation of EasyPHP 5.3.2 (supplied with Vigilens)
• Installing in an existing Apache server : Vigilens will use a WAMP architecture previously installed on the server. Version must match EasyPHP 5.3.2 or higher)
• Update an existing installation of Vigilens WEB : This option allows you to reinstall Vigilens without reinstalling the PHP server.

Selecting the EasyPHP installation folder

To use an existing WAMP architecture, you must specify the folders containing the web pages, the php.ini file and the httpd.conf file.

Select the folder containing the web pages.

A Vigilens Web server is a Vigilens station like any other Vigilens station, setup section of Installation et paramétrage d’un poste Vigilens also applies to this case (especially with regard to data sources).

The next sections deal with the additional steps required for a Vigilens Web server.

PHP uses port 80 by default. If this port is used by another application (such as instant messaging software), Apache will display an error indicating that the port is in use. It may be necessary to change Apache's configuration to use a different port.

In order to do so:

• Right click on the EasyPHP icon available in the notification area of the taskbar.
• Choose “Configuration” then “Apache”, which opens the file “httpd.conf”.

• Look for the line beginning with Listen.
  • By default, it must be the line Listen 127.0.0.1:80.
  • Change the line to replace 80 by the desired port number.
  • example Listen 127.0.0.1:8080.

• Find the line beginning with ServerName.
  • By default, this must be the ServerName localhost:80 line.
  • Modify the line to replace 80 with the desired port number
  • example ServerName localhost:8080

• Save the file
• Right double-click on the EasyPHP icon available in the notification area of the taskbar.
  • Click on “Apache” to restart this server.
  • Apache will then use the new port, in the example, port 8080.

The installation creates a subgroup of “Web” programs (in the Vigilens program group ). It contains two shortcuts :

• Restart Service: this application allows you to restart the “Vigilens Web Service” service if the service has been stopped or if configuration modifications have to be taken into account.
• WebConfig: this application allows you to customize the Vigilens Web interface and to modify some configuration options.

Launch WebConfig. The first time you use it, you must enter the directory defined during the admin installation.

This application is accessible to the “Admin” user and to users who have been given access rights in the AdminTool application (see rights restrictions for groups and users).

The application has 6 tabs :

This tab allows you to change the default language, the initial size of the columns as well as the list of possible choices regarding the number of records displayed on each page. Changes made to these values take effect after the web page is refreshed.

This tab allows you to modify the images displayed at the top and bottom of the page. Changes made to these values take effect after the web page is refreshed.

The information contained in this tab is related to the operation of the “Vigilens Web Service” service. It is strongly recommended not to modify these values, except in specific cases.

This tab allows you to modify the following data:

• Calendar - First day of the week: This is the display mode of the calendar wizard.
• Tracing: Possibility to trace in a file (chosen by the user) the information transiting between the Web pages and the Vigilens engine.

• Web Vigilens Service: By default the service is executed with the local system account of the machine. In some cases, this account cannot be used. It is then possible to modify the account to be used in this tab. The modification of the account is only taken into account after restarting the service with the shortcut “ Restart Service”.

• Timeout :
  • The first value is the number of minutes between the closing of all Web windows corresponding to a Vigilens user and the deletion of the connection corresponding to this user.
  • The second value is the number of minutes since the last activity on a request.

• Data volume: This is the number of rows at which the query stops and returns an error message. This setting is used to secure the risk of memory saturation of the browser or server in the event of a large volume of data.
  • The first value concerns the output to a grid screen display.
  • the second one is for file outputs.

This tab allows you to add domains that can be used in Vigilens Monitor.

The web server must be defined as a trusted site in order to allow execution without systematic warning messages. It is also necessary to request permission to download files in order to allow file outputs.

Example for the MS Internet Explorer browser :

The usual mode of execution of the application is done by launching a list of requests using the following link: http://serveur/vigilens where server refers to the name or IP address of the Web server).

If the port has been redefined in PHP, it must be specified in the link, http://serveur:8080/vigilens, for example.

When executing a query, the result: grid or file (PDF, Excel…) depends on what was specified in Restitution in interactive mode when creating the query.

A single run is possible too : http://serveur/vigilens/table.php?vglCtrlName=nomRequete. See URL syntax dedicated page

Vigilens Web accesses the Vigilens engine via DCOM. It is the Vigilens Web service that activates the DCOM component (VigilensSrv.exe process). The DCOM component is therefore executed with the user used to connect to the Vigilens Web service. By default, it is the local system account of the machine.

However, the DCOM component must have access to the Vigilens shared directory. This is not a problem if the shared directory is located on the Web server.

*Otherwise, the DCOM component, if running with the local system account of the machine, will not have access to the shared directory (located on another server). It is then necessary to modify the account used to connect to the Vigilens Web service (“Advanced Settings” tab of the WebConfig application).