Archive Manager fails to start after a CA Spectrum install due to the install username having more than 16 characters.

Document ID : KB000036574
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

Archive Manager fails to start after a CA Spectrum install.

The error seen in the $SPECROOT/SS/DDM/ARCHMGR.OUT:

 

Jan 14 06:54:10 : ArchMgr started as user 'svc-spectrum-ldap'
Jan 14 06:54:10 : ArchMgr validating database.

Error opening the DDM database. The most likely causes: 

 1. The SQL database server is not running. 
 2. The username, password, hostname, or database name are not correct. 

Jan 14 06:54:10 : ArchMgr error opening database.

You will also find two failures in the $SPECROOT/Install-Tools/LOGS/10.0.0.251_<Date>/postinst.hh.mm logfile. The mysql.cus script and ddm.cus script both failed due to the Spectrum Owner username being longer than 16 characters.

********** Started: Wed Jan 13 18:28:06 2016 **********

running Custom Script Install-Tools/CUS/mysql.cus

 ERROR 1470 (HY000) at line 1: String 'svc-spectrum-ldap' is too long for user name (should be no longer than 16)

newUser Failure: mysql --defaults-file=d:/win32app/Spectrum/mysql/my-spectrum.cnf -u root -proot mysql

Error(s) occurred. Please see d:/win32app/Spectrum/Install-Tools/LOGS/10.0.0.0.251_20160113/mysql.log.

Script Install-Tools/CUS/mysql.cus has FAILED

********** Completed: Wed Jan 13 18:28:17 2016 **********

And

********** Started: Wed Jan 13 18:29:41 2016 **********

running Custom Script Install-Tools/CUS/ddm.cus

 Creating .configrc

Error(s) occurred. Please see d:/win32app/Spectrum/Install-Tools/LOGS/10.0.0.0.251_20160113/ddm.log.

Script Install-Tools/CUS/ddm.cus has FAILED

********** Completed: Wed Jan 13 18:29:41 2016 **********

 

Cause:

If the Spectrum Owner's user name is longer than 16 characters, it will cause the Spectrum Install to complete with failures. The 16 character limitation is set by MySQL and not Spectrum. The result of the failures are:

1. The Spectrum Owner account will not be added in mysql.

2. The ddmdb database does not get created.

As a result Archive Manager will not be able to run.

 

 

 

Workaround:

 

A request has been opened to address this in a future release of Spectrum, so the Installer will warn you if the username is more than 16 characters. In the meantime you can do the following steps as a workaround.

1. Shorten the Spectrum Owner user name to 16 characters or less.

2. Uninstall Spectrum

3. Reboot the server

4. Reinstall Spectrum so that it uses the new account, which will allow the MySQL configuration complete and the ddmdb database will be created.

 

Additional Information:

 http://dev.mysql.com/doc/refman/5.7/en/user-names.html