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 Extract to create the D:\mysql directory.

Once the extraction has finished, go to d:\msql\bin and execute the 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 support@stilog.com.

From an existing MySQL server

If a version 5.x or higher MySQL server 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.

Warning:

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 context-sensitive 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 context-sensitive menu.

The following dialog box opens:

On the General tab, proceed as follows:

  • Enter the User name (e.g.: vpuser),

  • Tick the SQL Server Authentication option.

On the Server Roles tab:

  • Tick the Database creator role.

Click OK to confirm.

The dedicated user name and the password will be required when installing the software. This information is necessary 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.

Objet

Nom

Taille

TableSpace

USERS

700 Mo

TableSpace

INDEX

500 Mo

TableSpace

SYSTEM

500 Mo

TableSpace

TEMP

200 Mo

Then create a user dedicated to VISUAL PLANNING under this instance (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.

ghostghostghostghostghost
loading table of contents...