ManageEngine Password Manager Pro – High Availability Tutorial

Vbala

Description

ManageEngine Password Manager Pro Tutorial Setting up High Availability Overview Setting up high availability in PMP consists of the following four steps: 1. Installing Primary & Secondary 2. Configurations to be done in Primary Installation 3. Configurations to be done in Secondary Installation 4. Enabling database replication Step 1 - Primary & Secondary Server Instances Before trying High Availability, you should have both Primary and Standby installations of PMP in place. You can use your current PMP installation as primary server. You can install another instance of PMP as secondary server in a separate workstation. To install PMP as secondary, during installation, you need to choose the option "Configure this server as High availability secondary server (Read Only)" (refer to the screenshot below). After installation, the PMP Primary server should have been started and stopped at least once. 2 ManageEngine Password Manager Pro – High Availability Tutorial Step 2 - Changes to be made in Primary Server Installation Prerequisite 1. Stop PMP Primary server, if already running. 2. Check if PMP Secondary Server is reachable from Primary Server and vice-versa (do a ping) 3. Go to the PMP Primary folder and carry out the following: Navigate to /mysql/data folder. The following file & folders are important: 'passtrix' folder, 'mysql' folder, 'test' folder, 'PasstrixTemp' ''ibdata1', ...

Informations

• Publié par: Eftou
• Nombre de lectures: 279
• Langue: English

Extrait

ManageEngine Password Manager Pro

Overview

Setting up High Availability

Settin u hih availabilitin PMP consists of the followinfour stes: 1.Installing Primary & Secondary 2.Configurations to be done in Primary Installation 3.Configurations to be done in Secondary Installation 4.Enabling database replication Step 1 - Primary & Secondary Server Instances

Tutorial

Before trin Hih Availabilitou should have both Primarand Standbin stallations of PMP in place. You can use your current PMP installation as primary server. You can install another instance of PMP as secondarserver in a searate workstation. To install PMP as secondardurin installationou need to choose the otion "thisConfi ure server as Hih availabilitsecondar serverRead Onl" referto the screenshot below .server should have been started andAfter installation, the PMP Primar stopped at least once.

2 ManageEngine Password Manager Pro–High Availability Tutorial

Step 2 - Changes to be made in Primary Server Installation

Prere uisite 1.Stop PMP Primary server, if already running. 2.Server and vice-versaServer is reachable from PrimarCheck if PMP Secondar (do a ping) 3. Go to the PMP Primary folder and carry out the following: Navigate to<PMP_Installation_Folder>/mysql/datafolder.The following file & folders are important: 'passtrix' folder, 'mysql' folder, 'test' folder, 'PasstrixTemp' ''ibdata1', 'ca-cert.pem', 'server-cert.pem' server-key.pem

KEEP THESE FOLDERS and delete all other files. If you delete them, you will lose all your data.

Steps 1.a commandO enate torom tand navi<PMP_Installation_Folder>/bindirector and run the scriptreplicationPack.bat(Windows)/replicationPack.sh(Linux)

2.This will create a new directory named 'replication' under <PMP_Installation_Folder> and a relication ackae named 'Re lication.zi' under<PMP_Home>/re lication folder. This zicontains the databaseacka efor standb 3. Go todirector .<PMP_Installation_Folder>/m s l/binYou will find a file named HAPrimar .confrenamethat file asHASecondar .conf Edit theHASecondar .confand enter the name of the host where the secondary server is running. master_host=<hostname of Secondar> For example, 'test_workstation' is the machine where the secondary PMP server is runninou need to enter the information as below: master_host=test_workstation

4.a commandrom tand naviate toO en<PMP_Installation_Folder>/binand run the scriptstartDB.bat <MySQL Port> (Windows) /startDB.sh <MySQL Port> (Linux).You

3 ManageEngine Password Manager Pro–High Availability Tutorial

need torovide the MSQL ortof PMP while executinthe above scrit as shown below. Bdefault, the MS Lort in PMP is 2345. startDB.bat <MySQL Port>(For Windows) startDB.sh <MS LPort>For Linux For example, with the default the MySQL port 2345, you need to execute this as: startDB.bat 2345(For Windows)

startDB.sh 2345For Linux This will start the Primary Database (Default MySQL port is 2345) Note: Durinthis rocessif ou etthis errorou masafel inore it as this is harmless: 090601 19:53:05Warnin Thes ntaxfor relication startuo tionsis derecat ed and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 090601 19:53:05Warnin otion 'max_allowed_acket': unsined value 3200000000 0 ad usted to 1073741824 5.Co theRe lication.ziunderfile resent<PMP_Installation_Folder>/re lication director. This has to beut in the PMP Secondarinstallation machine as detailed in Ste 3below. Step 3 - Changes to be made in PMP Secondary Installation

Prere uisite Stop PMP Secondary server, if already running. doServer is reachable from SecondarServer and vice-versaCheck if PMP Primar a ping) Go to the PMP Secondary folder and carry out the following: Navigate to<PMP_Installation_Folder>/mysql/datafolder.The following file & folders are important: 'passtrix' folder, 'mysql' folder, 'test' folder, 'PasstrixTemp' ''ibdata1', 'ca-cert.pem', 'server-cert.pem' server-key.pem

4 ManageEngine Password Manager Pro–High Availability Tutorial

KEEP THESE FOLDERS and delete all other files. If you delete them, you will lose all your data.

Ste s 1.Put theRe lication.ziied from thefile coPRIMARY Installation asdetailed in the reviousste into the<PMP_Installation_Folder>of Secondarand unziit. Take care to extract the files under<PMP_Installation_Folder> only. It will overwrite the existindata files. 2.Co the<PMP_Installation_Folder>/m s l/bin/database_ arams.conffile of secondary installation and put it over<PMP_Installation_Folder>/confdirectory of secondar installation 3.Copy thestartDB.bat(in Windows)/startDB.sh(in Linux)underfile present <PMP_Installation_Folder>/m s l/binof secondarinstallation andut it over <PMP_Installation_Folder>/bindirector ofsecondar installation 4.Go to<PMP_Installation_Folder>/bininstallation and executeof secondar startDB.bat <MS LPort> Windows /startDB.sh<M SL Port>Linux tostart Secondar databaseDefault MS Lort is 2345 For examleS Lort 2345,ou need to execute this as:, with the default the M startDB.bat 2345For Windows startDB.sh 2345For Linux This will start the Secondary Database (Default MySQL port is 2345) Note: Durinthis rocess,if ou etthis error,ou masafel inore it as this is harmless: 090601 19:53:05Warnin Thes ntaxfor relication startuo tionsis derecat ed and will be removed in MS L5.2. Please use 'CHANGE MASTER' instead. 090601 19:53:05Warnin otion 'max_allowed_acket': unsined value 3200000000 0 ad usted to 1073741824 Step 4 - Enabling Database Replication

1.RunenableRe lication.batWindows/enableRe lication.shLinux resent in<PMP_Installation_Folder>/m s l/binofboth Primarand Secondar installations

Step 5 - Start Primary and Secondary

1.Start Primary and Secondary Servers

2.High Availability setup is now ready

Step 6 - Verify High Availability setup

5 ManageEngine Password Manager Pro–High Availability Tutorial

After carrin outthe above stes, oucan verifif the Hih Availabilitsetu isworkin ro erlb lookin atthe messae in "Admin >> General >> Hih Availabilit" ae of Primary server. If the setup is proper, you will see the following: Connection Status: Alive and High Availability Live is in progress now Secondary server is running in host: <Host Name>

Note 1: In case, the Primary Server crashes, when carrying out disaster recovery, please ensure the following:

Go to the<PMP_Home>/mysql/dataofsecondary serverand copy the files ibdata1, passtrix Install another instance of PMP afresh (same version as that of the PMP secondary from which you copied the above files) In the new installation, go to<PMP_Home>/mysql/dataand overwrite the ibdata1, passtrixfiles Start the new PMP installation

Note 2:

PMPort of the Primare theAfter confiou chan, ifh availabiliturin hi server thehi havailabilit setu willnot work. It has to be re-confiured with suitable changes.

Troubleshooting Tips

Issue If ou eterror code 1201 uon executinenableRe lication.bat/ enableRelication.sh as shown in the screenshot below:

Solution Go to the PMP Primarand Secondarinstallation folders and carrout the followin: Navigate to<PMP_Installation_Folder>/mysql/datafolder.The following file & folders are important: 'passtrix' folder, 'mysql' folder, 'test' folder, 'PasstrixTemp'

6 ManageEngine Password Manager Pro–High Availability Tutorial

''ibdata1', 'ca-cert.pem', 'server-cert.pem' server-key.pem

ouou delete them,KEEP THESE FOLDERS and delete all other files. If will lose all your data. from Ste1ste sa ainh AvailabilitStart Hi Issue Re lication.ziis notettin createdeven after executin relicationPack.bat / replicationPack.sh

Solution One of there-re uisitesfor PMP Hih Availabilitsetu isthat after installation, the PMP Primar servershould have been started and stoed at least once. If this had not been done, you will face the above issue. ZOHO Corp. (formerly AdventNet Inc.) 4900 Hopyard Rd., Suite 310, Pleasanton, CA 94588, USA Phone: [phone]Fax: [phone] Website:http://www.passwordmanagerpro.com For Queries:[e-mail]