Network setup

<< Click here to display whole document >>

Database >

Network setup

First: Install Firebird and CutLogic 1D database file on the server

On the server computer:

1.Download Firebird SQL server version 2.5 64-bit at https://firebirdsql.org/ and install it (use default settings, don't change anything, just click Next buttons). Make sure that no firewall or other SW blocks Firebird server on ports 3050 and 3051.

2.Copy or restore database file CL1D.fdb to chosen folder, e.g. C:\CutLogic\CL1D.fdb.

To obtain CL1D.fdb, install CutLogic 1D on one of the station computers, then you will find CL1D.fdb on station at:
C:\ProgramData\TMachines\CL1D\CL1D.fdb

3.In Firebird folder, open file aliases.conf and add to it line:

TMachines.CL1D = C:\CutLogic\CL1D.fdb
on Linux e.g.
TMachines.CL1D =  /opt/databases/CL1D.fdb
Make sure you have full write access right and file aliases.conf was really modified.

4.In Firebird folder, open file firebird.conf and add to it line:

RemoteAuxPort = 3051
Make sure you have full write access right and file firebird.conf was really modified.

5.Write down computer name. It can be either computer name (e.g. JOECOMP), or IP address (e.g. 192.0.2.25). Further we will refer to it as to ServerName.

6.Restart Firebird SQL server.

Second: Install CutLogic 1D on each station

On each station computer:

1.Install CutLogic 1D

2.Run CutLogic 1D, go to "Tools > Database > Server", and enter ServerName.

Third: Define users

1.Choose one station computer (any) and run CutLogic 1D, log in under username "SYSDBA" and password "masterkey".

2.Go to "Tools > Database > Users" and define users - their user names and passwords.

Fourth: Security

It is recommended to change SYSDBA's password from publicly known "masterkey" to your own one. To do it, run CutLogic 1D, log in under username "SYSDBA" and password "masterkey", and go to "Tools > Database > Users".