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

[NDS Surgical Imaging]<http://www.ndssi.com/>

Darren Penfield
Sr. System Support Engineer
darren(dot)penfield(at)novanta(dot)com<mailto:darren(dot)penfield(at)novanta(dot)com>

tel: 408-754-4185
cel: 408-425-8666
www.ndssi.com<http://www.ndssi.com/>

NDS Surgical Imaging
5750 Hellyer Avenue
San Jose, CA 95138, USA

From: Saghafi, Babak
Sent: Tuesday, March 8, 2016 9:53 AM
To: Penfield, Darren <darren(dot)penfield(at)ndssi(dot)com>
Subject: FW: CASE[183421] Moving Seapine to new server

Hi Darren,

I also found this in the PostgreSQL Tips/Help:

Support for pgAdmin can be requested through the pgadmin-support(at)postgresql(dot)org<mailto:pgadmin-support(at)postgresql(dot)org> mailing list.

Might be an option.

Thanks,
Babak

From: Support Account [mailto:support(at)seapine(dot)com]
Sent: Tuesday, March 08, 2016 6:30 AM
To: Penfield, Darren
Cc: Saghafi, Babak
Subject: CASE[183421] Moving Seapine to new server

Darren,

PostgreSQL is a free 3rd 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

Let me know if you have further questions or comments.

Regards,
Trish Cordes
Technical Support Specialist

Seapine Software, Inc. | Be Quality Ready
6960 Cintas Blvd Mason, OH 45040-2555
Phone: +1.513.754-1655 | Fax: +1.513.754.1660
www.seapine.com<http://www.seapine.com/>

Seapine Answers. Get help, give help.
www.seapine.com/answers<http://www.seapine.com/answers>

Struggling with scaling agile for larger projects?
Watch "Six Steps for Successfully Scaling Agile"<https://www.youtube.com/watch?v=Qv-HmhIIjzY&feature=youtu.be>

When responding to us concerning this specific issue, please ensure that the subject line of the email contains the case number as listed above. If you have other non-related issues or questions please contact us, but do not include a case number in the subject line.

From: Penfield, Darren [mailto:darren(dot)penfield(at)ndssi(dot)com]
Sent: Monday, March 07, 2016 6:22 PM
To: Support Account
Cc: Saghafi, Babak
Subject: RE: CASE[183421] Moving Seapine to new server

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

From: Support Account [mailto:support(at)seapine(dot)com]
Sent: Thursday, February 25, 2016 6:27 AM
To: Saghafi, Babak <babak(dot)saghafi(at)ndssi(dot)com<mailto:babak(dot)saghafi(at)ndssi(dot)com>>
Cc: Penfield, Darren <darren(dot)penfield(at)ndssi(dot)com<mailto:darren(dot)penfield(at)ndssi(dot)com>>
Subject: CASE[183421] Moving Seapine to new server

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.

Let me know if you have further questions or comments.

Regards,
Trish Cordes
Technical Support Specialist

Seapine Software, Inc. | Be Quality Ready
6960 Cintas Blvd Mason, OH 45040-2555
Phone: +1.513.754-1655 | Fax: +1.513.754.1660
www.seapine.com<http://www.seapine.com/>

Seapine Answers. Get help, give help.
www.seapine.com/answers<http://www.seapine.com/answers>

Struggling with scaling agile for larger projects?
Watch "Six Steps for Successfully Scaling Agile"<https://www.youtube.com/watch?v=Qv-HmhIIjzY&feature=youtu.be>

When responding to us concerning this specific issue, please ensure that the subject line of the email contains the case number as listed above. If you have other non-related issues or questions please contact us, but do not include a case number in the subject line.

From: Saghafi, Babak [mailto:babak(dot)saghafi(at)ndssi(dot)com]
Sent: Wednesday, February 24, 2016 5:20 PM
To: Support Account
Cc: Penfield, Darren
Subject: RE: CASE[183421] Moving Seapine to new server

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<http://www.seapine.com/kb/questions/1624/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

[cid:image005(dot)png(at)01D1C1A5(dot)B1C705B0]

From: Support Account [mailto:support(at)seapine(dot)com]
Sent: Monday, February 22, 2016 4:37 AM
To: Saghafi, Babak
Cc: Penfield, Darren
Subject: CASE[183421] Moving Seapine to new server

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<http://www.seapine.com/kb/questions/1344/Backing+Up+TestTrack+Databases> & Backing Up License Server Databases. <http://www.seapine.com/kb/questions/1679/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<http://www.seapine.com/kb/questions/1624/Moving+Surround+SCM+and+PostgreSQL+Servers+Between+Computers> or Moving Surround SCM and SQL Server Databases Between Computers. <http://www.seapine.com/kb/questions/1691/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<http://www.seapine.com/upgrades.php>. 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<http://www.seapine.com/kb/questions/1332/Upgrading+TestTrack>

Users Cannot Log In After Upgrading<http://www.seapine.com/kb/questions/1722/Users+Cannot+Log+In+After+Upgrading>

Cannot Connect to the License Server After Upgrading<http://www.seapine.com/knowledgebase/index.php?View=entry&EntryID=275>

TestTrack Server System Requirements<http://www.seapine.com/kb/questions/1306/TestTrack+Server+System+Requirements>

TestTrack Client System Requirements<http://www.seapine.com/kb/questions/1408/TestTrack+Client+System+Requirements>

TestTrack RDBMS Support <http://www.seapine.com/kb/questions/1527/TestTrack+RDBMS+Support>

TestTrack Release Notes<http://www.seapine.com/ttreleasenotes.html>

Configuring IIS and Apache Web Servers for TestTrack Web <http://www.seapine.com/kb/questions/1468/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 1st 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<http://www.seapine.com/blog/2015/08/experience-faster-soap-apps-testtrack-2015-1/>

TestTrack Pro Supported Web Servers<http://www.seapine.com/kb/questions/1333/TestTrack+Pro+Supported+Web+Servers>

DSNs Are Not Displayed in the TestTrack or Seapine License Server Admin Utility<http://www.seapine.com/kb/questions/1472/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 <http://www.seapine.com/kb/questions/1528/Backing+Up+Surround+SCM+2009+and+Later+Databases>
Backing Up License Server Databases <http://www.seapine.com/kb/questions/1679/Backing+Up+License+Server+Databases>
Surround SCM Server System Requirements<http://www.seapine.com/kb/questions/1173/Surround+SCM+Server+System+Requirements>
Surround SCM Client System Requirements<http://www.seapine.com/kb/questions/1204/Surround+SCM+Client+System+Requirements>
Surround Release Notes<http://www.seapine.com/scmreleasenotes.html>
Surround SCM RDBMS Support<http://www.seapine.com/kb/questions/1497/RDBMS+Support+%96+Surround+SCM>
Users Cannot Log In After Upgrading<http://www.seapine.com/kb/questions/1722/Users+Cannot+Log+In+After+Upgrading>
Cannot Connect to the License Server After Upgrading<http://www.seapine.com/knowledgebase/index.php?View=entry&EntryID=275>

Let me know if you have further questions or comments.

Regards,
Trish Cordes
Technical Support Specialist

Seapine Software, Inc. | Be Quality Ready
6960 Cintas Blvd Mason, OH 45040-2555
Phone: +1.513.754-1655 | Fax: +1.513.754.1660
www.seapine.com<http://www.seapine.com/>

Seapine Answers. Get help, give help.
www.seapine.com/answers<http://www.seapine.com/answers>

Struggling with scaling agile for larger projects?
Watch "Six Steps for Successfully Scaling Agile"<https://www.youtube.com/watch?v=Qv-HmhIIjzY&feature=youtu.be>

When responding to us concerning this specific issue, please ensure that the subject line of the email contains the case number as listed above. If you have other non-related issues or questions please contact us, but do not include a case number in the subject line.

From: Saghafi, Babak [mailto:babak(dot)saghafi(at)ndssi(dot)com]
Sent: Friday, February 19, 2016 8:17 PM
To: Support Account
Cc: Penfield, Darren
Subject: Moving Seapine to new server

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,

[NDS Surgical Imaging]<http://www.ndssi.com/>

Babak Saghafi
NPI & Software QA Manager
Babak(dot)Saghafi(at)ndssi(dot)com<mailto:Babak(dot)Saghafi(at)ndssi(dot)com>

tel: 408-754-4134
fax: 408-754-4212

www.ndssi.com<http://www.ndssi.com/>

[Radiance, Dome]NDS Surgical Imaging
5750 Hellyer Avenue
San Jose, CA 95138, USA