Actions

FN19497: Difference between revisions

No edit summary
No edit summary
Line 1: Line 1:
{{DISPLAYTITLE:FN19497 - Procedure to Recover a Major Upgrade after Recovering a }}
{{DISPLAYTITLE:FN19497 - Procedure to Recover a Major Upgrade after Recovering Database from Newer Version to Older Version }}


= Affected Products =
= Affected Products =
* TMG800, TMG3200, TMG7800-CTRL
* TMG800, TMG3200, TMG7800-CTRL running Toolpack software older than rel2.7.176
* Tdev Linux server with (CentOS, RedHat, etc) running Toolpack software


= Problem Description =
* Import a database backup from a newer version to an older version. e.g. Imported a database backup from rel2.9 to a TMG which is running rel2.7.175 (or older)
* Validate/Recover the database
* Do a major upgrade on the TMG
= Problem Symptoms =
* Upgrade fails, always switch back to the old version
* tboamapp logs shows:
database_upgrade: [FAIL]    ERROR: data upgrade 26 failed: ERROR: data upgrade 26
= Solution =


= Problem Description =
1- ssh to the TMG host
* snmpd process continuously restarts in a loop.
2- stop toolpack by shell command: tbtoolpack stop
* System which are shipped before April 2015 requires this fix.
[root@TB007036 ~]# tbtoolpack stop
* This fix is applicable if you have an older net-snmp version than below. To verify:
0:tbtoolpack_12358
[root@TB011107 tbsnmpagent]# rpm -qa | grep snmp
Stopping tbtoolpack_12358:                                [  OK ]
  net-snmp-libs-5.3.2.2-25.el5.tb
Toolpack current state: Disconnected
net-snmp-utils-5.3.2.2-25.el5.tb
Ok
net-snmp-5.3.2.2-25.el5.tb


If you have version previous to this one (5.3.2.2-25), you are affected by this Field Notice.
2- Drop both databases: toolpack_0 and toolpack_2_x
[root@TB007036 ~]# mysql -u tbdb -ptbdbpw
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 116
Server version: 5.1.47-log Source distribution


= Problem Symptoms =
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
* core files are observed in tbsnmpagent directory:
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
/mnt/.0/tb/toolpack/setup/12358/2.8/apps/tbsnmpagent
and you are welcome to modify and redistribute it under the GPL v2 license


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


= Solution =
mysql> drop database toolpack_0;
== Online Procedures ==
mysql> drop database toolpack_2_9;
Applicable if the system has internet access with proper DNS configuration and is able to reach the TelcoBridges repositories server.


* Stop Toolpack
3- Check the config files to make sure it is pointing to the new release.
tbtoolpack stop
vi /lib/tb/toolpack/setup/12358/service/config.txt
* Make sure your system is pointing to the TelcoBridges repositories. Verify the following TelcoBridges repository file:
vim /etc/yum.repos.d/TB-Base.repo


# TelcoBridges-Base.repo
application= /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini
#
# This repository is using TelcoBridges frozen version of CentOS
# to help client installing the required version of the
# applications required to run Toolpack
#
[tb-base]
name=TelcoBridges-$releasever - Base
baseurl=http://repo.telcobridges.com/centos/5/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
#released updates
[tb-updates]
name=TelcoBridges-$releasever - Updates
baseurl=http://repo.telcobridges.com/centos/5/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5-tb
* Get TelcoBridges repository key. If you don't already have them.
cd /etc/pki/rpm-gpg/
wget http://repo.telcobridges.com/centos/RPM-GPG-KEY-CentOS-5
wget http://repo.telcobridges.com/centos/RPM-GPG-KEY-CentOS-5-tb
* Update your net-snmp to the latest version
yum update net-snmp*
* Verify the updated net-snmp version. You should see:
[root@TB011107 tbsnmpagent]# yum list net-snmp
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
  * tb-base: repo.telcobridges.com
  * tb-updates: repo.telcobridges.com
Excluding Packages in global exclude list
Finished
Installed Packages
net-snmp.x86_64                  1:5.3.2.2-25.el5.tb                        installed
* Start Toolpack
tbtoolpack start


== Offline Procedures ==
vi /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini
Applicable for systems which are behind the firewall in a private network without internet access.


* Stop Toolpack
TB_PKG_PATH                    = /lib/tb/toolpack/pkg/2.9.41
tbtoolpack stop
* Remove net-snmp. Confirm removal with "Y" when prompted.
yum remove net-snmp
* Manually install below RPMs:
rpm -ivhU net-snmp-libs-5.3.2.2-25.el5.tb.x86_64.rpm
rpm -ivhU net-snmp-5.3.2.2-25.el5.tb.x86_64.rpm
rpm -ivhU net-snmp-utils-5.3.2.2-25.el5.tb.x86_64.rpm
* Above files can be found at:
http://repo.telcobridges.com/centos/5/os/x86_64/CentOS/
* Verify the updated net-snmp version. You should see:
[root@TB011107 tbsnmpagent]# yum list net-snmp
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
  * tb-base: repo.telcobridges.com
  * tb-updates: repo.telcobridges.com
Excluding Packages in global exclude list
Finished
Installed Packages
net-snmp.x86_64                  1:5.3.2.2-25.el5.tb                        installed
* Start Toolpack
tbtoolpack start


= References =
4- Manually start toolpack on the newer release
RPM release note for net-snmp-utils-5.3.2.2-25
[root@TB007036 ~]# tbtoolpack start
  http://rpmfind.net/linux/RPM/centos/updates/5.11/x86_64/RPMS/net-snmp-utils-5.3.2.2-25.el5_11.x86_64.html
0:tbtoolpack_12358
Starting tbtoolpack_12358:                                [  OK ]
Toolpack current state: Ready
Ok

Revision as of 14:18, 15 June 2016


Affected Products

  • TMG800, TMG3200, TMG7800-CTRL running Toolpack software older than rel2.7.176

Problem Description

  • Import a database backup from a newer version to an older version. e.g. Imported a database backup from rel2.9 to a TMG which is running rel2.7.175 (or older)
  • Validate/Recover the database
  • Do a major upgrade on the TMG

Problem Symptoms

  • Upgrade fails, always switch back to the old version
  • tboamapp logs shows:

database_upgrade: [FAIL] ERROR: data upgrade 26 failed: ERROR: data upgrade 26

Solution

1- ssh to the TMG host 2- stop toolpack by shell command: tbtoolpack stop [root@TB007036 ~]# tbtoolpack stop 0:tbtoolpack_12358 Stopping tbtoolpack_12358: [ OK ] Toolpack current state: Disconnected Ok

2- Drop both databases: toolpack_0 and toolpack_2_x [root@TB007036 ~]# mysql -u tbdb -ptbdbpw Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 116 Server version: 5.1.47-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database toolpack_0; mysql> drop database toolpack_2_9;

3- Check the config files to make sure it is pointing to the new release. vi /lib/tb/toolpack/setup/12358/service/config.txt

application= /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini

vi /mnt/.0/tb/toolpack/setup/12358/2.9/apps/tboamapp/tboamapp_wd_cfg.ini

TB_PKG_PATH = /lib/tb/toolpack/pkg/2.9.41

4- Manually start toolpack on the newer release [root@TB007036 ~]# tbtoolpack start 0:tbtoolpack_12358 Starting tbtoolpack_12358: [ OK ] Toolpack current state: Ready Ok

Retrieved from "https://docs.telcobridges.com/w/index.php?title=FN19497&oldid=21185"