Changing AR Server & DB Reference in SmartIT / MyIT Application

Version 9
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    MyIT Digital Workplace


    APPLIES TO:

    SmartIT 2.0 and older / MyIT 18.02 and older (bundle) For DWP 18.05 and beyond, use KA 000169175 SmartIT 18.05 and beyond



    QUESTION:

    How to change AR server references in SmartIT / MyIT Application?
    How to Update (encrypt) the password within SmartIT /MyIT database?
    How to change SmartIT DB reference?


    ANSWER:

     1) Login onto Remedy with a MyIT/SmartIT Admin user.

                 Step1 : Application -> BMC MyIT administration -> MyIT administration console -> Persistent Data Stores -> click on the AR server that is currently being used.

                 Step2 :  Modify the host_name , Provide Port Number , Admin Password(provide remedy application service password) , DataStore type(Select AR Server)

                             Click on the application tab and do the same for rest of the three applications - BMC MyIT / MyIT-ITSM /MyIT HRCM and save the information. Make sure 'enabled' is set to Yes

    **Post 18.05 This change should be done in the SMT:Administration Console form**


    User-added image

      2) Login with the SmartIT Database.

    NOTE:

    These steps apply for

       
    1. Any SmartIT -any version from 18.05 (stand alone SmartIT)  and beyond.
    2.  
    3. Any SmartIT that is bundled with MyIT and prior.
    4.  
    5. For DWP 18.05 and beyond, follow KA 000169175
      
                   Step1 : go to the Table - 'Configuration Parameter' with the Schema 'SmartIT_System' 
                             Run the following query: 
                               SELECT * FROM [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER]

                 Step2 : Execute the Update query to update HostName: 
                                UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = 'Server_Name' Where Name='connect.arsystem.hostName'

                    Step3 : If the password has changed then password has to be encrypted. for this you have to use   SmartIT Manteinance Tool
                               <SmartIT Installdirectory>/SmartIT/SmartITMaintTool/SmartIT Maintenance Tool/

                                Execute the Update query to update password information: 
                                UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = 'encrypted password' Where Name='connect.arsystem.password'
      
                 Step4 : Execute the Update query to update Port information 
                                UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = '0' Where Name='connect.arsystem.port'

       
      User-added image
      

                    Step5 : Restart Application's Tomcat
      
    Change SmartIT DB reference:

      

    If you want to change smartIT DB reference then it has to be done in smartIT.xml file:

      

    The smartit.xml file located at <SmartIT_Tomcat_Install_Dir>\conf\Catalina\localhost contains references to the JDBC connection to the SmartIT_System and SmartIT_Business schemas.

      

    The following example is from a system connecting to MS SQL Server database: url=jdbc:jtds:sqlserver://mydbserver-011:1433/SmartIT 

      



                

     


    Article Number:

    000130901


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles