First installation of the Meso system

• The work in the version of one workstation.
  In this case, there is possibility of working with the program and simultaneously, all the program's data will be stored there. To make it possible, on this computer:
  • install the server of the Firebird database,
  • install the Meso program
  • there have to be database files (they are automatically placed in the Meso/db folder at the time of the Meso installation )

++++ Ekran: Work in the version of one workstation| ++++

• Work in the network version.

In case of using Meso program on several computers online, work results will not be stored on particular computers. The data from every computer will be transmitted and stored only on one computer - Server.
In order to make this type of work possible:

• install a database server on the computer, which will function as the server,
• place the database files on the server,
• install the Meso program on every user's computer,
• configure the connection with the database on every user's computer,

++++ Ekran: Work in the network version| ++++

To work in the Meso system, you need security keys. These are small devices that are plugged into the USB slot of the computer. In case of working in the network version, the system can use:

• workstation keys - each computer requires to have the security key plugged in. In this case, the server can work powered by Linux or Windows operating systems.
• one server key - the key is plugged into the server, on which the Meso system is installed. Other workstations do not need security keys or Meso installation. The system is activated through the RDP remote desktops. In this case, the server should work powered by the Windows Server operating system and possess additional licenses for the remote desktops.

1. from the website http://www.firebirdsql.org/en/server-packages/ download the Firebird database server in 2.5.2 version, compatible with the operating system of the computer, where database of the Meso system will be stored.

• Windows 32-bit
• Windows 64-bit
• Linux - do not install Firebird from the Linux packages. Additional information about this topic you can find here.
• MacOSX

1. On the server, install the Firebird database server, preserving default settings.

1. Download instalation file of Meso system from serwis.rho.pl:
2. Activate downloaded file,
3. The installer's window appears that informs you about the installation of the Meso application. Click on Yes.
4. The welcome window opens, click on the Dalej.
5. The next window consists of the license agreement. Familiarize with it. If you accept the conditions, choose the option Accept the license conditions i and click on „Proceed”. Otherwise, click on Delete.

1. In the next window, give the installation folder of the program (or accept the default one) and click on the Proceed button.
2. Another two windows enable you to choose the place of the program in the Start menu, as well as the order of creating program icons on the desktop and on the Quick Launch toolbar. After making the choice, click on the Proceed button.
3. Next window consists of the summary of the installation parameters. In order to confirm, click on Install button.
4. The process of installation will begin.
5. Click on the Finish button. If the option Start-up the Meso program was not unmarked, the program will activate automatically.

During the installation of the Meso program in the db folder, database files are also installed (meso.fdb, bin_meso.fdb)

Working on one workstation:

To configure the connection:

1. unblock the 3050 port. More information about this operation you can find here,
2. Run the Meso and click on Yes,
3. Define the localization of database,
4. Click on Confirm,
5. run the RhoAdmin and click on Connect.
6. In the window Loggin data to the base:
   • insert the password (default password:masterkey),
   • user SYSDBA,

1. After connection with the base, register the system by clicking on the Program Registration, and next Download the license.

Working on many workstations:

SERWER:

• on the computer that plays a role of the server create the folder, e.g. baza_meso
• locate there the database files meso.fdb and bin_meso.fdb (check if the files are not protected from the transcription. For safety, users should not visit this folder in the network)
• unblock the 3050 port. More information about this operation you can find tutaj.

USERS' WORKSTATIONS:

• unblock the 3050 port. More information about this operation you can find tutaj.
• run the RhoAdmin
• choose Yes
• enter database name and choose OK
• in the field Localization of the database define the localization of the database files that are placed on the server:
• for the base located on the server with the system Windows - e.g.:

C:\meso\db\start.fdb

• for the base located on the server with the system Linux - e.g.:

/baza_meso/start.fdb

• complete the data in the field Address IP serwera bazy danych Firebird - e.g.:

192.168.1.1

• save the inserted settings by clicking on Save settings.
• fill out the data in the window Data of logging into the base.
  • insert the password (default password:masterkey)
  • the user SYSDBA
• insert above settings in the RHOAdmin on every workstation.

Backups are made only in the Firebird's server. Thanks to this solution:

• operations of making copies, retrieving the base from copies, and optimization of database will proceed faster (on the linux servers even several times faster);
• such operations will be much safer and not vulnerable to the network breakdowns - all is taking place on one computer without the use of network.

To make the copy, you have to:

• in the server-computer (where is the base and the Firebird installed) you should create or choose the folder, where the backups of the Modus base will be created. To increase the safety, this folder should not be available in the network. It should be given rights for recording.
• Save or remember a whole access path for this folder, e.g.:
  • c:\copies\meso (access path in the Windows format),
  • /backup/meso (access path in the Linux format),
• run the panel administracyjny ModusAdmin.
• Choose the appropriate database and click the button Join.
• Go to the tab „Backups”.
• In the field 'Folder of copies' enter the access path. Remember that from this version it the path on the server, not the local path. If you enter the path, that does not exist on the server, an error will occur during an attempt of making a copy or restore the database from the backup.
• Press the button Make a copy.

Apart from the manual mode, the backup is made automatically, always before the update of the database to the new version, as well as during the optimization of database. In such cases, an appropriate description of the copy is added.