INSTALLING VISUAL PLANNING

VISUAL PLANNING is a client / server network version with an n-tier architecture of the VISUAL PLANNING software.

Therefore, the installation is made up of several parts:

  • Installation and/or configuration of the DBMS to be used with VISUAL PLANNING,
  • Installation of the application server,
  • Connection of the application server to the DBMS,
  • Activation of the licenses.

TECHNICAL PREREQUISITES

Check that the following technical prerequisites are met before starting the installation of VISUAL PLANNING.

INSTALLING THE DBMS

Check that the selected DBMS is installed and working before starting the installation of VISUAL PLANNING.

The DBMS settings are required during the installation procedure.

If there is no DBMS on the server, install the version of MySQL supplied by STILOG I.S.T.

MYSQL

There are two ways to install MySQL:

  • using the version of MySQL provided,
  • from an existing MySQL server.

Using the version of MySQL provided

Start by running the mysql.exe executable at the address provided by STILOG.

Enter the hard drive where the MySQL directory will be created (e.g. C:\ or D:\).

Click on Extract to create the D:\mysql directory.

Once the extraction has finished, go to d:\mysql\bin and run file “winmysqladmin.exe”.

The window shown below opens:

Click Execute to install and start the MYSQL service.

Open the Windows Task Manager and check that the mysqld.exe process is running to make sure that the MySQL service has started.

If the line above does not appear, MySQL has not started.

In this case, contact VISUAL PLANNING support at sav@stilog.com

From an existing MySQL server

If a MYSQL server version 5.x or higher is already installed, you must create a MySQL user dedicated to VISUAL PLANNING (e.g. vpuser).

Use the script below:

mysql> CREATE USER 'vpuser'@'%' IDENTIFIED BY 'vpuser_password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'vpuser'@'%' WITH GRANT OPTION;

Replace vpuser_password with the real password of vpuser.

Remember this password, because you will need it during the installation procedure and for as long as VISUAL PLANNING is used on your server.

Caution

Remember this password, because you will need it during the installation procedure and for as long as VISUAL PLANNING is used on your server.

SQLSERVER

VISUAL PLANNING is only compatible with instances of SQL Server in mixed authentication mode.

If SQL Server is in Windows authentication mode, then you must change it.

Proceed as follows:

  • Start the Enterprise Manager application,

  • Right-click on the name of your server,

  • Select the Properties option in the pop-up menu,

  • Select the Security tab in the dialog box that opens,

  • Tick the SQL Server and Windows authentication modes,

  • Click OK to confirm the change.

Now create an SQL Server user dedicated to VISUAL PLANNING (e.g., vpuser).

Proceed as follows:

  • Start the Enterprise Manager application,

  • Left-click on the name of your server,

  • Double-click on the Security folder,

  • Right-click on Login,

  • Select the New login option in the pop up menu.

The following dialog box opens:

In the General tab, proceed as follows:

  • Enter the user name (e.g. vpuser),

  • Tick the SQL Server Authentication option.

In the Server Roles tab:

  • Tick the Database creator role.

Click OK to validate.

The dedicated user name and corresponding password will be requested when installing the software. Make sure you have this information before starting the installation procedure.

If the SQL Server version is higher than SQL Server 2005, check that the TCP/IP protocol of SQL Server is activated.

Start the SQL Server Configuration Manager and activate TCP/IP.

ORACLE

An instance must be reserved for VISUAL PLANNING (e.g. VPSID).

This instance may exist already, but it is preferable to create one for VISUAL PLANNING.

The disk space values shown below are for reference only. They will be adjusted according to the way in which VISUAL PLANNING is used.

Object Name Size
TableSpace USERS 700 Mo
TableSpace INDEX 500 Mo
TableSpace SYSTEM 500 Mo
TableSpace TEMP 200 Mo

Now create an SQL Server user dedicated to VISUAL PLANNING (e.g. VISUALPLANNING) according to the script shown below:

Sqlplus system/<passwdSystem>@VPSID
CREATE USER <userName> IDENTIFIED BY <passwd>
GRANT CONNECT TO <userName>
GRANT CREATE SESSION TO <userName> WITH ADMIN OPTION
GRANT CREATE TABLE TO <userName> WITH ADMIN OPTION
GRANT UNLIMITED TABLESPACE TO <userName> WITH ADMIN OPTION
GRANT CREATE USER TO <userName>
GRANT DROP USER TO <userName>

Caution

If the Oracle user does not obey this script, VISUAL PLANNING will not function properly.

The names of the tablespaces of the instance for VISUAL PLANNING and the dedicated user name and password are required when installing the software. This information is necessary before starting the installation procedure.

INSTALLING THE APPLICATION SERVER

VISUAL PLANNING ENTERPRISE 8 can be installed:

  • using the complete vp8enterprise package,
  • using an existing J2EE server.

Installing with the complete package

Start by executing the package vp8enterprise.exe.

The following window appears:

vp7_en_enterprise_installation_1

Click Next to continue.

The following window displays the license contract.

vp7_en_enterprise_installation_2

Read the terms of use of the license carefully. The installation procedure will be interrupted if you refuse the terms of use.

Click Next to continue.

vp7_en_enterprise_installation_3

It is preferable to use the installation path proposed by default, especially if you are using Microsoft Windows 7, 8 or 2008. If you have to change the directory, please keep the directory name “VPServer Enterprise 8”.

Click Next to continue.

vp7_en_enterprise_installation_4

If the information in this window is not correct, click “Back” to change it.

Click Next to continue.

vp7_en_enterprise_installation_5

The installer then tries to check whether there is already a web service installed on the server (use of port 80).

If there is, the following window appears.

vp7_en_enterprise_installation_6

If port 81 is already used, enter another port (e.g. 82), etc.

This window only closes if the proposed port N° is not already used by another application.

Click Next to continue.

Then, specify whether there is already an installation of VISUAL PLANNING on the server.

If this is not the case, select No then click on Next.

vp7_en_enterprise_installation_7

Sinon, il faut sélectionner Oui et cliquer sur Suivant.

If there is already an installation, select Yes and click on Next.

In this case, enter the location of this installation and click on Next.

In both cases, the following window opens:

vp7_en_enterprise_installation_8

Click on Finish to complete the install procedure.

To configure and activate the application, go to Start > All programs > VPServer Enterprise 8.

vp7_en_enterprise_portail_appli

Click on VP Application Portal to open the configuration page.

Installing on an existing J2EE application server

The software is installed by deploying the vplanning.war file which you can request by sending an e-mail to support.

The deployment procedure described below is for the Java Tomcat 5.2 application server.

If other servers, such as JBoss or JOnAS are used, refer to their user manual for the installation of the WAR file.

First, go to the Tomcat server portal.

Click on Tomcat Manager.

Then:

  • go to the WAR file to deploy section,

  • select file vplanning.war,

  • then click Deploy to start the deployment.

Once the deployment is confirmed as being deployed, open your web browser and enter the address:

http://VP_server:808/vplanning/

where VP_server is the DNS name of the server machine and and 808 is the port used by the Tomcat J2EE server.

These settings must be adjusted to the installation.

Print Friendly, PDF & Email
1 Etoile2 Etoiles3 Etoiles4 Etoiles5 Etoiles (3 votes, average : 5.00 on 5)
Loading...
Consulting training

Need training?

Use our consulting services!