Cisco Cisco Prime Network Registrar 8.1 Troubleshooting Guide

•  7 

To configure the Production Executive as Active Master, execute the 

prepmaster.sh

 script 

on the Production Executive. When completed, the script displays instructions on the next 

steps you need to take to set up replication. 

To execute the 

prepmaster.sh

 script, follow these steps. 

As 

incadmin user, change directory to /opt/incontrol/etc/support. 

>cd /opt/incontrol/etc/support 

Execute the script command. 

>./prepmaster.sh 

The script begins by granting access to the Backup Executive replication account and 

updating the configuration file, 

my.cnf

, to support replication. 

Creating replication monitor database with: CREATE DATABASE IF NOT EXISTS REPLMON 

Configuring Active Master settings ... 

 

Backed up /opt/incontrol/mysql/my.cnf to 
/opt/incontrol/mysql/my.cnf.pre_replication 

Configuration file updated: /opt/incontrol/mysql/my.cnf 

 

After the appropriate changes have been made to the configuration file, the master is 

restarted. 

Stopping MySQL Database Server... 

MySQL Database Server stopped. 

Waiting 5 seconds before starting... 

 

Starting MySQL Database Server... 

MySQL Database Server started. 

Waiting 10 seconds for mysql to start ... 

Stopping replication slave process with: STOP SLAVE 

Disconnecting from old master with: CHANGE MASTER TO MASTER_HOST='' 

Resetting slave with: RESET SLAVE 

 

The script then uses 

mysqldump

 to create a dump file in the current directory.  This 

defines the starting point for replication. 

Dumping the master database and getting Log File Coordinates ... 

Master Log File Coordinates: 

MASTER_LOG_FILE='mysql-bin.000001' 

MASTER_LOG_POS=2645 

 

Dump File: dbforrepl.sql