SMP 3.0 server - change of Database details from file

[Former Member]

Hello...

I have done the installation of SMP 3.0 SP7 server along with MSSQL Database on another server.

Now I want to change DB details which I gave during the installation of SMP server without running the SMP installer again.  Is there any file which gets created after installation of SMP server which stores all parameter like HOST NAME, PORT NUMBER, DATABASE NAME, DATABASE TYPE which we gave input at the time of installation of SMP server.

Best regards

Javed

[Jitendra_Kansal · Accepted solution]

Hi Javed,

Take a backup before modifying any server-side file(s).

There must be a file connection.properties under <SMP_HOME>\config_master\connection_data path. You can update the details.

For changing the password

1. Go to <SMP_HOME>/MobilePlatform3/Server/tools/cipher path, run CMD
2. Java -jar CLIEncrypter.jar <key> <newpassword> <length>
   • <key> : open props.ini file (<SMP_HOME>/Server) and copy DsecretKey value
   • <new password> : for new DB
   • <length> : copy Dsecretlength value from props.ini

3. Press enter> copy the new value

4. open connection.properties,paste the copied value (make sure to have {enc} prefix)

javax.persistence.jdbc.password={enc}z33kqmSJ6IG7fFMasoPAL+QPZlL93CJdkv1Wh4E8Tqk=

[agentry_src]

Discussion successfully moved from SAP for Mobile to SMP Developer Center as the more appropriate venue.

Regards, Mike (Moderator)

[Former Member]

Thanks Kevin , Jitendra for your help. Able to find the required file. If required , will raise a new thread.

[Former Member]

Hi...

Yes. It worked . Many thanks Jitendra and Kevin.   I did  changed the  properties for DB in  file connection.properties.

However I am now trying to find the way to change the port no. details which I gave during the installation of SMP server through file , same way as we did above. ( ref. in attached screenshot ) .Any suggestions on this ?

BR,

Javed

[Jitendra_Kansal]

Hi Javed,

Before modifying the file, make sure you take the backup of the file.

SMP services should be stopped.

New ports shouldnt be used by any other services/processes.

There is a file in SMP3 server installation path

/server/config_master/org.eclipse.gemini.web.tomcat/default-server.xml

Please raise a new thread in case of any new queries.

There is alternate way to change the port from admin cockpit as well... settings> connector (but i never tried it)

Regards,

JK

[Kevin_SAP]

This is covered in the documentation Port Number Reference - Administration Overview - SAP Library.

Thanks,

Kevin

[Kevin_SAP]

You can find database connection details at SAP\MobilePlatform3\Server\config_master\connection_data.  Please see documentation at Changing Database Connection Passwords - Administration Overview - SAP Library.

I am not aware that changing the database is actually supported though as there are several values inserted on installation.  It is safer to uninstall and delete the server files and reinstall with new database.  Updating the database target on an existing server could cause the server to no longer function and is not supported.