Project and Portfolio Management Practitioners Forum
cancel

Extract and import PPM objects without telnet & FTP servers

Highlighted
Łukasz Czech
Super Contributor.

Extract and import PPM objects without telnet & FTP servers

Hi,

due to security reasons we do not have telnet & FTP enabled on PPM servers. We would like to move workflows, requests & other objects from development/test environment to production environment by making Extract on dev/tes, manualy coping files to production and making Import in production environment.
I think it is not neccessary for PPM to use telnet/FTP in this case as Migrator only needs to operate in local filesystem, however I am still facing problems during package creation due to failed telnet connection (negotiation of terminal type), which I think is not neccessary.
Two questions:
- is it possible to migrate entities without telnet & FTP servers in place
- what should configuration of workflow and package should look like in order to get this migration work?

Thank you
Lukasz Czech
8 REPLIES
Erik Cole_1
Outstanding Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

Hi Lukasz,

The migrator objects use telnet whether you are in fact connecting to self or connecting to a remote server. (Look at ksc_connect_source_server in special commands)

How do you connect to the server yourself, if not via telnet?
Łukasz Czech
Super Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

Erik,

as extracting entities is being done on localhost (connecting to db (could be remote) + writing files in local filesystem)
- it seems that connecting via telnet session to could be avoided.

Nevertheles I've tried to use Microsoft Telnet Server and got logs as attached.
Any ideas what can be wrong?

Thank you
Lukasz Czech
Jim Esler
Acclaimed Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

We also do not use telnet or ftp because of security concerns. All PPM connections to other servers use scp and ssh. On our Windows servers, these commands are part of the Cygwin package.
Łukasz Czech
Super Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

Jim,

could you elaborate more on commands and Cygwin - I can't get your point.

Thank you.

Lukasz Czech
Jim Esler
Acclaimed Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

ssh is 'secure shell' and scp is 'secure copy'. You can google ssh for more information. In the Environment Workbench, you can configure the connection protocol used to access the server to be telnet, ssh or ssh 2. We use ssh 2. Similarly, the transfer protocol can be configured as a flavor of ftp or secure copy. Secure copy is scp. You will need to install software to support these protocols if it is not already on your servers.

For migrations, you need to configure environments defining each of your PPM instances. This is where you would configure the protocols to be used.

In order to run on Windows, you need a UNIX emulator. We use Cygwin. ssh and scp are available within this product.
Alan Delimon
Super Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

We recently had to disable telnet and FTP as well for security reasons.

It is now using SCP and SSH instead.
Łukasz Czech
Super Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

It can be done using import and export scripts from bin folder:
- Extraction: sh kDevMigratorExtract.sh -username -password -dbpassword -itg_home <> -action bundle -entityId -primaryKey -filename
- Import: sh kDevMigratorImport.shusername -password -dbpassword -itg_home <> -action import -filename -refdata update -flags YYYYYYYYYYYYYYYYYYY

Of course objects need to be extracted in source environment, manually copied (zip files) to destination environment, and imported there.
Run scripts without parameters to see optional parameters and their description.
Łukasz Czech
Super Contributor.

Re: Extract and import PPM objects without telnet & FTP servers

.