≪ View Page

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen RevisionVorhergehende Überarbeitung
Nächste Überarbeitung		Vorhergehende Überarbeitung
en:installation_und_deinstallation [2025/08/23 21:01] – neelesten:installation_und_deinstallation [2026/04/29 15:08] (aktuell) – admin
Zeile 1: Zeile 1:
-======Installation and uninstallation======+====== Installation and Uninstallation ====== 
 +===== Preliminary Notes and Important Information =====
  
-===== Prerequisites =====+If you are using **PAM < 2.0**, please contact support in advance: [[mailto:software@ktp.upb.de|software@ktp.upb.de]].
  
-Before the database program PAM can be installed, the computer has to meet the requirements shown below: +If **PAM 2.0 or higher** is already installed, any existing PAM installation must be **uninstalled** before reinstalling. **Note:** The material databases will be retained unless you delete or overwrite them manually.
  
-^ **Database Server** ^    ^  ^ +With **PAM 3.0**, structural changes were introduced to the material database. Therefore, **local** and **network databases** from earlier versions must first be migrated to **PAM 3.0**. A detailed description can be found in the section **[[installation_und_deinstallation#migration_einer_alten_pam-datenbank_version_30 | Migration of an old PAM database]]**.
-| Operating System | Windows 10 or Windows 11| |  +
-| Data Base | Firebird Version 2.5; Port: 3050 | located on CD-ROM or www.firebirdsqul.org | +
-| Additional required software        | none | | +
-| Required Privileges        | administrator | (for DB installation) | +
  
-^ **PAM-Client** ^    ^  ^ +If you are working with a **network database** that has already been migrated to **PAM 3.0** or higher, **all users** must update the PAM software to the **same major version** in order to continue working with this database.
-| Operating System | Windows 10 or Windows 11| |  +
-| Additional required software       | 1) Firebird V2.5 or higher 2) HASP Safenet dongle driver (Sentinel LDK and Sentinel HASP Run-time Environment Installer: HASPUserSetup.exe)  | located on CD-ROM or www.firebirdsql.org sentinelcustomer.safenetinc.com | +
-| Required Privileges       | simple user authorization, administrator to install software |  | +
  
-**Note**: If the PAM client is to have a **local database**, the requirements for the database server also apply to it, with additional restrictions.+=== Firebird === 
 +PAM uses the relational DBMS **Firebird**. In order for PAM to access a database, the required [[https://download.ktp-software.de/Firebird-5.0.4.1812-0-windows-x64.exe | Firebird components]] must be installed on the computer.   
 + 
 + 
 +=== Dongle Driver === 
 +The appropriate driver must be installed in order to detect the license dongle (Sentinel Hasp HL).   
 +Installer: [[https://download.ktp-software.de/HaspUserSetup.zip|HaspUserSetup.zip]] 
 + 
 + 
 +The following requirements must be met for installing and operating PAM: 
 + 
 +^ **Database Server** ^ **Requirement** ^ **Notes** ^ 
 +| Operating system | Windows 11 (64-bit) |  | 
 +| Database | Firebird **5.0.4** (port **3050/TCP**) | If you are still using Firebird 2.5.9, please [[https://sigmadoc.ktp-software.de/doku.php?id=installation_und_deinstallation:migration_nach_5 | update]] it.|  
 +| Additional software components | none |  | 
 +| Required permissions | Administrator rights | required for installation/firewall/service configuration | 
 + 
 +^ **PAM Client** ^ **Requirement** ^ **Notes** ^ 
 +| Operating system | Windows 11 |  | 
 +| Additional software components | 1) Firebird Client/Server **5.0.4** (x64) \\ 2) HASP Sentinel dongle driver (Sentinel LDK / HASP Runtime) | [[https://download.ktp-software.de/Firebird-5.0.4.1812-0-windows-x64.exe | Firebird components]] \\  [[https://download.ktp-software.de/HaspUserSetup.zip|Dongle driver]] | 
 +| Required permissions | User rights (operation), administrator rights (installation) |  | 
 + 
 +**Note:** If the PAM client is to use a **local database**, the database server requirements also apply additionally: local Firebird service, local port/firewall configuration, and administrator rights for setup. 
 + 
 + 
 +===== Uninstalling an Existing PAM Version ===== 
 + 
 +1. Close PAM, including any open database connections. 
 + 
 +2. In Windows: select the existing PAM version under **Settings > Apps > Installed Apps** or in the Control Panel. 
 + 
 +3. Run **Uninstall**. 
 + 
 +4. **Important:** Database files, such as *.gdb/*.fdb, are **not** removed. 
 + 
 +===== Installing PAM ===== 
 + 
 +1. Run the setup, preferably by right-clicking and selecting “Run as administrator”. 
 + 
 +2. Select the language: 
 + 
 +{{ :de_pam311_dlg_setup_006.png?nolink |}} 
 + 
 + 
 +3. Complete the installation wizard. 
 + 
 +4. [[ Installationsanleitung_Firebird | Install]] Firebird ([[https://download.ktp-software.de/Firebird-5.0.4.1812-0-windows-x64.exe | Firebird components]]). 
 + 
 +5. Install the dongle driver ([[https://download.ktp-software.de/HaspUserSetup.zip| Dongle driver]]). 
 + 
 +6. Start PAM and configure the database connection, either local or network. 
 + 
 + 
 +===== Migration of an Old PAM Database (Version < 3.0) ===== 
 + 
 +=== Requirements === 
 + 
 +**Advanced / administrative rights** are required for the migration. 
 + 
 +Please note: 
 + 
 +  * During the migration, the affected material database must **not** be opened by other programs/users, such as SIGMA, REX, PSI, or Flame Robin. 
 +  * If the migration is started while another user is still connected, an error message appears: 
 + 
 +{{ :de_pam311_dlg_setup_001.png?nolink |}} 
 + 
 +=== Migration Procedure === 
 + 
 +When you open a database from an older version, such as 2.x, in PAM 3.0, an information dialog appears: 
 + 
 +{{ :de_pam311_dlg_setup_002.png?nolink |}} 
 + 
 +1. Make sure that there are **no further connections** to the database. 
 + 
 +2. Click **“Update”** to start the migration. 
 + 
 +3. PAM automatically creates a backup version of the old database in compressed format.   
 +   Typical storage location: 
 +   ''C:\Users\<User>\AppData\Roaming\KTP\PAM2.1\backups\''   
 +   File name according to the following pattern: 
 +   ''<DB-name>-<backup-date>-<ID>'' 
 + 
 + 
 +4. PAM then performs the database migration. After successful completion, the log may look like this: 
 + 
 +{{ :de_pam311_dlg_setup_003.png?nolink |}} 
 + 
 +=== Restoring a Backup Database (gbak) === 
 + 
 +The backup file is stored in a compressed format that cannot be read directly. To restore it, use the Firebird tool **gbak**. 
 + 
 +Example: 
 + 
 +<code> 
 +gbak -r -user SYSDBA -password <Password> "<Path_to_backup_file>" "<Path_to_target_database.fdb>" 
 +</code> 
 + 
 +Notes: 
 +  * **gbak** is located in the Firebird installation directory under ''...\bin\''. 
 +  * Make sure to use correct quotation marks for paths containing spaces. 
 +  * The target path should point to a writable directory. 
 + 
 + 
 +===== Upgrading a Material Database from 3.0 to 3.1 ===== 
 + 
 +PAM 3.1 provides new functions that require an adjustment of the database structure. When connecting to a database in format 3.0, the following notice is displayed: 
 + 
 +{{ :de_pam311_dlg_setup_004.png?nolink&600 |}} 
 + 
 +You can still select **“Connect”**, but not all functions may be available.   
 +Recommendation: Update the database to the current format (v3.1) using **“Update”**. 
 + 
 +**Important notes:** 
 +  * If using a shared network database, make sure that **no other users** are connected. 
 +  * **Administrative rights** are required for the update. 
 +  * Perform the update only if the required permissions are available and no other users are affected. 
 + 
 + 
 +===== Installing a PAM Database on a Server (Network Operation) ===== 
 + 
 +**Scenario:** PAM stores the material data on an internal server. Users should primarily have **read access**, while only administrators should have write access. 
 + 
 +{{ :de_pam311_dlg_setup_005.png?nolink |}} 
 + 
 +=== Preparing the Infrastructure (Server) === 
 + 
 +  - Note the **server IP**, for example 123.123.123.123 
 +  - Install the Firebird Server with administrator rights according to the following [[Installationsanleitung_Firebird |guide]]. 
 +  - Copy the PAM database file to the server, for example: 
 +    * Target path: ''C:\data\pam\PAM.GDB'' or *.fdb 
 +  - Set the Firebird alias on the server: 
 +    * Open the file ''C:\Program Files\Firebird\Firebird_5_0\databases.conf'' with administrator rights 
 +    * Add the alias. It must match the target path exactly: 
 +    * Example: <code>pam_db = C:\data\pam\PAM2se.GDB</code> 
 +  - Add a firewall rule on the server: 
 +    * Option A, recommended: allow inbound TCP port **3050** 
 +    * Option B: allow the program ''...\Firebird_5_0\firebird.exe'' 
 +    * Enable access at least for Private/Domain according to your company policy 
 +{{ :de_pam311_dlg_setup_007.png?nolink |}} 
 + 
 +     
 + 
 +   
 + 
 + 
 +=== Setting Up the Network Database in PAM (Client) === 
 + 
 +On each PAM client: 
 + 
 +1. Open PAM 
 +2. Menu: **File -> Databases** 
 +3. In **Database Management**, click **“Add”** and enter the data: 
 + 
 +{{ :de_pam311_dlg_setup_008.png?nolink |}} 
 + 
 +Recommended fields: 
 + 
 +  * **Database name:** freely selectable, for example “PAM-DB Net” 
 +  * **Database server:** server IP or hostname 
 +  * **Database path:** alias from ''aliases.conf'', for example ''pam_db'' 
 +  * **User name / password:** initially often ''sysdba'' / ''masterkey''; recommendation: change the password later 
 + 
 +4. Click **“Connect database”**. 
 + 
 +===== Users and Permissions on a PAM Network Database ===== 
 + 
 +Often, only certain users should be allowed to write data records, while other users should have read-only access. 
 + 
 +User management is performed server-side in Firebird. An administration tool such as **Flame Robin** can be used for this: [[https://www.flamerobin.org/|flamerobin.org]] 
 + 
 +**Step 1: Register the database in Flame Robin** 
 + 
 +Menu: **Database -> Register existing database…** 
 + 
 +{{ :de_pam311_dlg_setup_009.png?nolink |}} 
 + 
 +  * **Display name:** freely selectable 
 +  * **Database path:** path to the database file or alias path, depending on the setup 
 +  * **Authentication:** stored user/password 
 +  * **User:** sysdba (admin) 
 +  * **Password:** corresponding admin password 
 + 
 +After successful registration, the database appears in the tree view: 
 + 
 +{{ :de_pam311_dlg_setup_010.png?nolink |}} 
 + 
 + 
 +**Step 2: Create users and change the SYSDBA password** 
 + 
 +Menu: **Server -> Manage users…** 
 + 
 +{{ :de_pam311_dlg_setup_011.png?nolink |}} 
 + 
 +**Create a new user:** 
 +  * Select “Add user” 
 +  * Set the user name, for example ''pamuser'', and password: 
 + 
 +{{ :de_pam311_dlg_setup_012.png?nolink |}} 
 + 
 +**Change the SYSDBA password (recommended):** 
 +  * Select SYSDBA and open “Modify user” 
 +  * Set a new password: 
 + 
 +{{ :de_pam311_dlg_setup_013.png?nolink |}} 
 + 
 +**Important:** The new password must then be used in PAM for the database connection. 
 + 
 + 
 +==== Client: Entering the Network Database with New Login Credentials ==== 
 + 
 +In PAM: **File -> Databases** -> **Add** 
 + 
 +  * Server: hostname or IP 
 +  * Database path: alias, for example ''pam_net_db'' 
 + 
 +{{ :de_pam311_dlg_setup_014.png?nolink |}} 
 + 
 +If the SYSDBA password has been changed, it may be necessary to confirm that a connection can no longer be established with the default password. 
 + 
 + 
 + 
 + 
 +===== Startup Problems / Troubleshooting ===== 
 + 
 +=== Database Connection Fails === 
 + 
 +Possible causes: 
 + 
 +  * Port **3050/TCP** has not been opened in the firewall, on the server and possibly also on the client. 
 +  * The Firebird service is not running on the server. 
 +  * The user does not have write permissions for database migration/update. 
 + 
 +If an error message appears during automatic extension/migration, connect once as the database administrator: 
 +  * User: **sysdba** 
 +  * Password: **masterkey**, unless it has been changed 
 + 
 +=== Dongle Problems === 
 + 
 +If the dongle driver is installed, diagnostics can be performed via the Sentinel Admin Control Center: 
 + 
 +  * Open browser: ''https://localhost:1947'' 
 + 
 +=== Log === 
 +PAM logs program behavior in the folder <code> %APPDATA%\KTP\PAM2.1\pamlog.0.0.log </code>. 
 + 
 +===== Note on Database Migration at Program Startup ===== 
 + 
 +  * Old material databases are usually extended automatically the first time a connection is established (PAM 2.2+). 
 +  * Starting with PAM 3, the **migration wizard** starts automatically when an old database version is detected. 
 +  * If write permissions are missing, a corresponding error message appears. In this case: connect once as **sysdba** and perform the migration.