ACS 5.2 upgrade to 5.3

Innocent Nkomo · ‎06-15-2012

I want to upgrade my ACS 5.2 to 5.3 from a remote repository as documentation suggest but after issuing the command "application upgrade ACS_5.3.tar.gz <repository-name>" : Gives me no indication what is happening and when I check after an hour or 2, shows that nothing happened. I know the ACS has access to the repository, all backups are happening fine but the upgrade just doesn't work?

Here is what I see:

IPSACS001/admin# application upgrade ACS_5.3.0.40.tar.gz BACKUP-REP-IMP-RUS

Do you want to save the current configuration ? (yes/no) [yes] ?

Generating configuration...

Saved the running configuration to startup successfully

!and it just stays here

Jatin Katyal · ‎06-15-2012

Does it behave normally after the above process?

Could you please get the output of below listed commands:

show version

show application status acs

Regards,

Jatin

Do rate helpful posts-

~Jatin

Innocent Nkomo · ‎06-15-2012

It Work normally after this.

Here is the aoutput requested:

IPSACS101/admin# sh application status acs

ACS role: PRIMARY

Process 'database'                  running
Process 'management'                running
Process 'runtime'                   running
Process 'adclient'                  running
Process 'view-database'             running
Process 'view-jobmanager'           running
Process 'view-alertmanager'         running
Process 'view-collector'            running
Process 'view-logprocessor'         running

IPSACS101/admin# sho application version acs

Cisco ACS VERSION INFORMATION
-----------------------------
Version : 5.2.0.26
Internal Build ID : B.3075

Innocent Nkomo · ‎06-15-2012

Here is the show version as well:

IPSACS101/admin# sho version

Cisco Application Deployment Engine OS Release: 1.2
ADE-OS Build Version: 1.2.0.182
ADE-OS System Architecture: i386

Copyright (c) 2005-2009 by Cisco Systems, Inc.
All rights reserved.
Hostname: IPSACS101

Version information of installed applications
---------------------------------------------

Cisco ACS VERSION INFORMATION
-----------------------------
Version : 5.2.0.26
Internal Build ID : B.3075

c12208406 · ‎04-28-2016

Cisco Application Deployment Engine OS Release: 1.2
ADE-OS Build Version: 1.2.0.228
ADE-OS System Architecture: i386

Copyright (c) 2005-2009 by Cisco Systems, Inc.
All rights reserved.
Hostname: acs-main

Version information of installed applications
---------------------------------------------

Cisco ACS VERSION INFORMATION
-----------------------------
Version : 5.3.0.40
Internal Build ID : B.839

Jatin Katyal · ‎06-15-2012

Do you see any logs on the FTP server while we have that command executing? Also, can we capture the upgrade logs from the ACS?

For now can we get the debugs from the ACS:

debug transfer 7

debug copy 7

Now try again ...

Regards,

Jatin

~Jatin

Innocent Nkomo · ‎06-15-2012

Here is the debug out put, will check the FTP logs shortly:

IPSACS101/admin# application upgrade ACS_5.3.0.40.tar.gz BACKUP-REP-IMP-SPR

Do you want to save the current configuration ? (yes/no) [yes] ?

Generating configuration...

Saved the running configuration to startup successfully

6 [16146]: transfer: cars_xfer.c[54] [admin]: ftp copy in of ACS_5.3.0.40.tar.gz requested

7 [16146]: transfer: cars_xfer_util.c[89] [admin]: ftp get source - ACS_5.3.0.40.tar.gz

7 [16146]: transfer: cars_xfer_util.c[90] [admin]: ftp get destination - /storeddata/Installing/.1339775074/ACS_5.3.0.40.tar.gz

7 [16146]: transfer: cars_xfer_util.c[109] [admin]: initializing curl

7 [16146]: transfer: cars_xfer_util.c[122] [admin]: full url is ftp://139.53.4.9/NSIS-SharedACS/ACS_5.3.0.40.tar.gz

Innocent Nkomo · ‎06-15-2012

Jatin,

from the FTP server, appears to have sent the file:

19:53:49 172.17.0.99 [2239]USER ftpuser 331 0

19:53:49 172.17.0.99 [2239]PASS - 230 0

19:53:49 172.17.0.99 [2239]CWD NSIS-SharedACS 250 0 19:53:49 172.17.0.99 [2239]USER ftpuser 331 0
19:53:49 172.17.0.99 [2239]PASS - 230 0
19:53:49 172.17.0.99 [2239]CWD NSIS-SharedACS 250 0

22:05:07 172.17.0.99 [2239]sent /NSIS-SharedACS/ACS_5.3.0.40.tar.gz 426 64

rgds

Innoe

Innocent Nkomo · ‎06-15-2012

Output of "show acs-log" taken after the last upgrade attempt

DEBUG:Fri Jun 15 08:15:23 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): storeUpgrade start upgrade.'
DEBUG:Fri Jun 15 08:15:23 SAST 2012 getCurrentVersionInfo db_version: 5.2.0.26=B.3075=30.1
DEBUG:Fri Jun 15 08:15:23 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): Current database version: 5.2.0
.26, rev 30.1'
DEBUG:Fri Jun 15 08:15:23 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): Current swSchema version: 5.2.0
.26, rev 30.1'
DEBUG:Fri Jun 15 08:15:23 SAST 2012 upgradeRequired?false
DEBUG:Fri Jun 15 08:15:23 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): Database is already upgraded.'
DEBUG:Fri Jun 15 08:15:23 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): storeUpgrade end upgrade.'
DEBUG:Fri Jun 15 08:15:23 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): just nothing to do - upgrade no
t needed.'
DEBUG:Fri Jun 15 08:15:23 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): storeUpgrade Done.'
INFO: Fri Jun 15 08:15:53 SAST 2012 Begin View 5.2 data upgrade
INFO: Fri Jun 15 08:15:53 SAST 2012 Connecting to new database...
java.sql.SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified:
java.sql.SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.cisco.nm.acs.view.dataupgrade.DbConnector.getConnection(DbConnector.java:103)
        at com.cisco.nm.acs.view.dataupgrade.ViewDataUpgrade.upgradeData(ViewDataUpgrade.java:3695)
        at com.cisco.nm.acs.view.dataupgrade.ViewDataUpgrade.main(ViewDataUpgrade.java:4336)
DEBUG: Fri Jun 15 08:15:54 SAST 2012 Waiting for database server...
INFO: Fri Jun 15 08:16:03 SAST 2012 New database version is 5.2
INFO: Fri Jun 15 08:16:03 SAST 2012 New database version is not 5.1 and upgrade is not necessary
INFO: Fri Jun 15 08:16:03 SAST 2012 Final upgrade state is: No upgrade activity ( 0 0 )
INFO: Fri Jun 15 08:16:03 SAST 2012 Running SQL script /opt/CSCOacs/view/data/sql/stopdb.sql
Error in file "/opt/CSCOacs/view/data/sql/stopdb.sql" at line 2
Specified database not found

% Executing command:
% STOP DATABASE acsview51 ON acsview UNCONDITIONALLY;
*** ERROR *** Error in file "/opt/CSCOacs/view/data/sql/stopdb.sql" at line 2
*** ERROR *** Specified database not found
% // Error: Error in file "/opt/CSCOacs/view/data/sql/stopdb.sql" at line 2
// Specified database not found
//
% // ( /opt/CSCOacs/view/data/sql/stopdb.sql )

ERROR: Fri Jun 15 08:16:07 SAST 2012 SQL script /opt/CSCOacs/view/data/sql/stopdb.sql failed due to error code: 1
INFO: Fri Jun 15 08:16:07 SAST 2012 End View 5.2 data upgrade
IPSACS101/admin#

Jatin Katyal · ‎06-15-2012

This is what we see in the debugs.

INFO: Fri Jun 15 08:16:03 SAST 2012 Final upgrade state is: No upgrade activity ( 0 0 )

INFO: Fri Jun 15 08:16:03 SAST 2012 Running SQL script /opt/CSCOacs/view/data/sql/stopdb.sql

Error in file "/opt/CSCOacs/view/data/sql/stopdb.sql" at line 2

Specified database not found

% Executing command:
% STOP DATABASE acsview51 ON acsview UNCONDITIONALLY;
*** ERROR *** Error in file "/opt/CSCOacs/view/data/sql/stopdb.sql" at line 2
*** ERROR *** Specified database not found
% // Error: Error in file "/opt/CSCOacs/view/data/sql/stopdb.sql" at line 2
// Specified database not found
//
% // ( /opt/CSCOacs/view/data/sql/stopdb.sql )

ERROR: Fri Jun 15 08:16:07 SAST 2012 SQL script /opt/CSCOacs/view/data/sql/stopdb.sql failed due to error code: 1

I need to know what is the patch on ACS 5.2.0.26 while upgrading it to ACS 5.3.0.40. Make sure we have latest patch installed on ACS 5.2 that would be patch 10.

After that try again.

Upgrading ACS 5.2 to 5.3

http://www.cisco.com/en/US/docs/net_mgmt/cisco_secure_access_control_system/5.3/installation/guide/csacs_upg.html#wp1199337

Regards,

Jatin

Do rate helpful posts-

~Jatin

Innocent Nkomo · ‎06-18-2012

Jatin

Still doesn't work after loading the patch 10. I will use the ISO file and do a fresh installation, could be a quicker way to get the upgrade done.

Here is what the log says:

Sat Jun 16 15:08:39 SAST 2012 patch '5-2-0-26-10' unpacked successfully

DEBUG:Sat Jun 16 21:31:19 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): storeUpgrade start upgrade.'
DEBUG:Sat Jun 16 21:31:19 SAST 2012 getCurrentVersionInfo db_version: 5.2.0.26=B.3075=30.1
DEBUG:Sat Jun 16 21:31:19 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): Current database version: 5.2.0
.26, rev 30.1'
DEBUG:Sat Jun 16 21:31:19 SAST 2012 Invoking /opt/CSCOacs/bin/syslog.sh 2 'storeUpgrade(main): Current swSchema version: 5.2.0
.26, rev 30.1'
DEBUG:Sat Jun 16 21:31:19 SAST 2012 upgradeRequired?false

Thanks for your input

rgds

I.Nkomo

Innocent Nkomo · ‎06-18-2012

Jkatyal,

It behaves normally- as if nothing really happened!

IPSACS101/admin# sho application status acs

ACS role: PRIMARY

Process 'database' running

Process 'management' running

Process 'runtime' running

Process 'adclient' running

Process 'view-database' running

Process 'view-jobmanager' running

Process 'view-alertmanager' running

Process 'view-collector' running

Process 'view-logprocessor' running

Jatin Katyal · ‎06-18-2012

Were you able to use ISO image for the fresh installation?

Regards,

Jatin

~Jatin

Innocent Nkomo · ‎06-18-2012

It's offsite so I will be doing it on Thursday-earliest.

Rgds