Re: CASE[183421] Moving Seapine to new server

Do you have something more official on how to change the password on PostgreSQL database back to the default when the password is forgotten?

Below is the email on the specifics if needed.

Thanks

Hi Darren,

I also found this in the PostgreSQL Tips/Help:

Support for pgAdmin can be requested through the pgadmin-support@postgresql.org mailing list.

Might be an option.

Thanks,

Babak

Darren,

PostgreSQL is a free 3^rd party RDBMS database that we include on the Surround SCM installer, so how to change the password on a PostgreSQL database is not something support can typically assist with. I did do a quick Google search on PosgreSQL password reset and found the following articles that may help you change the password. These are not Seapine articles and have not been tested by Seapine:

http://www.postgresql.org/docs/8.0/static/sql-alteruser.html

http://dba.stackexchange.com/questions/19643/how-do-i-reset-the-postgres-password-for-postgresql-on-windows

https://www.tekovic.com/changing-forgotten-postgresql-password

Support, if the passwords don’t work, is there a way to set back to default password?

Babak,

You can try using the password P0stgreSQL. We only provided the 2 defaults passwords (P0stgreSQL and s34p1n3) so if the person who did the installed chose a different password I would have no way of knowing what it is.

Hi Trish,

Thank you for the information, I think I have enough to complete the task.

1.      For TestTrack it seems pretty straight forward.

2.      For SurroundSCM, I read the Moving Surround SCM and PostgreSQL Servers Between Computers article and I tried the pgAdmin III but could not log into the local PostgreSQL server with the supplied password of s34p1n3, see screenshot below. Is there a different password? I am running pgAdmin III version 1.8.2.

Thanks,

Babak

Babak,

Thank you for contacting Seapine Software. The steps below will help you backup your current TestTrack and Seapine License Server data and move it to your new machine. These steps assume you are using the TestTrack Native databases for your TestTrack Server and TestTrack projects databases and the SQLite database for your Seapine License Server database. If you are using a different RDBMS database for any of these you will need to backup those databases in addition to the steps below; these articles will assist you with backing up your data Backing Up TestTrack Databases & Backing Up License Server Databases.  If you are not sure what database format your TestTrack Projects are in you can log into the TestTrack Server Admin Utility, select Projects, the Type columns will display either Native or RDBMS.  If it shows RDBMS you will need to go to Server Options\RDBMS Connections to determine which RDBMS format you are using. The TestTrack Server database type can be found in the TestTrack Server Admin Utility under Server OptionsàServer Database. The Seapine License Server database type can be found by logging into the License Server Admin Utility then go to Server OptionsàServer Database. These articles will assist you with moving Surround SCM Moving Surround SCM and PostgreSQL Servers Between Computers or Moving Surround SCM and SQL Server Databases Between Computers.  If you need the Surround SCM 2015.0.0 installer for Windows you can download it from here:

http://downloads.seapine.com/pub/software_old/sscm2015x/sscmwin201500install.exe

I am also including some articles at the end of this email that you will find helpful you choose to upgrade TestTrack.

Backing Up, Moving and Upgrading TestTrack Pro and the Seapine License Server--Native Databases

1.     Install your current version or if upgrading install the new version of TestTrack Pro and the Seapine License Server at the new location.  (Do Not Start the TestTrack or Seapine License Server until you get past step 4)  Seapine Software - Product Upgrades. You can download the 2015.0.0 version of TestTrack for windows from here http://downloads.seapine.com/pub/software_old/ttpro2015x/ttwin201501install.exe

2. At the old locations, stop the TestTrack Pro Server and the Seapine License Server.

3. At the old location, make a copy\backup of the LicenseServDB directory and all sub-directories and paste them in the install directory at the new location allowing it to overwrite the directory that was created during the install.  

The install directory is generally C:\Program Files\Seapine\License Server\LicenseServDb in Windows and /var/lib/splicsvr/LicenseServDB in UNIX/Linux

4. At the old location, make a copy\backup of  the TTServDB directory and all sub-directories and paste them in the install directory at the new location allowing it to overwrite the directory that was created during the install.  If you plan to continue using the existing software while you test the upgrade on another machine you can start the Seapine License Server Service and the TestTrack Server Service on the old machine as soon as you finish copying this directory.

The install directory is generally C:\Program Files\Seapine\TestTrack Pro\TTServDb in Windows and /var/lib/ttpro/TTServDB in UNIX/Linux

5. Start the Seapine License Server at the new location.

6. Start the TestTrack Pro Server at the new location.

7.  Log into the TestTrack Server Admin Utility, select Projects, if you are upgrading you should see in the status field you upgrading, waiting to be upgraded, or Loaded Successfully.  Once the projects are loaded successfully you can log into the project.  If the status is blank and does not change within a few minutes you should select the projects in the list and click upgrade.

8. One other thing to check and this can be done after you upgrade.  Log into the License Server Admin Utility, select Licenses and verify that you have your current license keys installed.  The keys should be displaying in Black and have a Maintenance date that is in the future.  Any keys in Red with an old maintenance date will no longer work after you upgrade.  If your keys are in red you will need to add the current License File that was sent by Sales when Maintenance was renewed.

***If you are doing this on a Test Machine while the License Server on the Production machine is still active you will need to remove the production keys from the license server on the test machine and contact your Salesperson for an evaluation key to use for testing****

Upgrading TestTrack

Users Cannot Log In After Upgrading

Cannot Connect to the License Server After Upgrading

TestTrack Server System Requirements

TestTrack Client System Requirements

TestTrack RDBMS Support

TestTrack Release Notes

Configuring IIS and Apache Web Servers for TestTrack Web  If you are just upgrading existing web components you do not need this article. This is only needed the 1^st time you install the TestTrack web components on your web server.

Read this article before upgrading to 2015.1.0 or higher if you use TestTrack SDK

TestTrack Pro Supported Web Servers

DSNs Are Not Displayed in the TestTrack or Seapine License Server Admin Utility --SQL Databases Only

Surround SCM

Backing Up Surround SCM 2009 and Later Databases

Backing Up License Server Databases

Surround SCM Server System Requirements

Surround SCM Client System Requirements

Surround Release Notes

Surround SCM RDBMS Support

Users Cannot Log In After Upgrading

Cannot Connect to the License Server After Upgrading

Hi,

We intent to move our current Seapine Server application from an old server with Win server 2003 R2, Standard Ed., with Service Pack 2, 32-bit OS to a new server with Win server 2012 R2, Standard Ed. 64-bit 0S. I intend to keep the server application as a 32-bit installation. We are currently running SurroundSCM 2015.0.0 Build 12 and TestTrack 2015.0.0 Build 18. Can you provide guidance and documentation as to how to go about this?

Thanks,