8 Replies Latest reply on Feb 14, 2020 11:08 AM by Ramon Vazquez

    TrueSight Server Automation 8.9.04

    Raul Calderon de la Barca
      Share This:

      Hello,

       

      I want to change the fileserver location from //192.168.116.130/C/Program Files/BMC Software/BladeLogic/storage/ to //WIN-PFHT7R212QT/C/Program Files/BMC Software/BladeLogic/storage.

       

      But the problem is that appserver is down because the service can't be up because old fileserver doesn't exist yet.

       

      In the documentacion says thay you have first execute:

      set fileserver name <hostname>

      where hostname is the name of the new file server to which you just moved the files.

      set fileserver location <directory>

       

      But I can't because appserver is down.

       

      How can change the value of the fileserver location directly in the database?

       

      Thank you.

        • 1. Re: TrueSight Server Automation 8.9.04
          Bill Robinson

          the appserver doesn't need to be up to use blasadmin.

          • 2. Re: TrueSight Server Automation 8.9.04
            Raul Calderon de la Barca

            But if I connect to blasadmin I haven't data in the show fileserver.

             

            If a do the set fileserver name and location won't work.

             

            I don't know have to change the fileserver name and location in this case.

             

            C:\Users\bmcadmin>blasadmin

            To change future application servers, blasadmin must be run against the _template deployment. Please refer to the chapter 'Configuring the Application Server' in the Administration Guide for further information.

            blasadmin now running against deployment: default

            Bladelogic Admin Utility; Version 8.9.04.200.

            (C) Copyright 1996-2019 Bladelogic, Inc.

            (C) Copyright 2014-2019 BMC Software, Inc.

            Type 'help' for Bladmin help.

            bladmin:default>show fileserver

            [FileServer]

            available options: [location|name]

             

             

            location             - The full path of the file server location (i.e. /c/Program Files/BMC BladeLogic/OM/storage/). The location should include a trailing ''/''.

            name                 - the name of the fileserver

            • 3. Re: TrueSight Server Automation 8.9.04
              Bill Robinson

              you might be running into the problem described in this ka: 000136584

              • 4. Re: TrueSight Server Automation 8.9.04
                Raul Calderon de la Barca

                Hi,

                I try to run but the root_path is cut in the space:

                 

                 

                C:\Users\bmcadmin\Desktop\ScriptsSQL\file_server_change>file_server_change_sqlserver_system_property WIN-4BBPH8OTNQD sa TSA WIN-PFHT7R212QT /C/Program Files/BMC Software/BladeLogic/storage/

                 

                 

                Updating the BLOM database located at SQL Server [WIN-4BBPH8OTNQD], Database [TSA]

                 

                 

                Connecting as the user [sa]

                 

                 

                Setting up the default file server to host [WIN-PFHT7R212QT], root folder [/C/Program]

                 

                 

                 

                 

                In the documentation says this:

                 

                 

                Usage:

                 

                 

                file_server_change_sqlserver_system_property <sqlsrv> <usr> <db> <fs> <rf>

                 

                where

                   <sqlsrv> - name of the SQL Server hosting the BLOM database

                 

                <usr>    - name of the SQL Server user that has the db_owner role

                 

                <db>     - name of the database hosting the BLOM database

                 

                <fs>     - host name of the new default file server

                 

                <rf>     - location of the file server root folder; if root folder

                 

                contains spaces it needs to be enclosed into double quotes;

                 

                e.g. C:\BMC Software\File Server 1 should be entered as

                "/C/BMC Software/File Server 1/".

                 

                 

                NOTE: File server record must already exist, otherwise an error will be

                 

                 

                raised.

                 

                 

                But if I executed with double quotes doesn't work:

                 

                 

                C:\Users\bmcadmin\Desktop\ScriptsSQL\file_server_change>file_server_change_sqlserver_system_property WIN-4BBPH8OTNQD sa TSA WIN-PFHT7R212QT "/C/Program Files/BMC Software/BladeLogic/storage/"

                Files/BMC was unexpected at this time.

                C:\Users\bmcadmin\Desktop\ScriptsSQL\file_server_change>

                 

                 

                I have tried to escape in several forms but I can't executed the sql correctly.

                 

                 

                How can I run the sql to have a path with spaces??

                 

                Thank you.

                • 5. Re: TrueSight Server Automation 8.9.04
                  Raul Calderon de la Barca

                  Hello,

                   

                  Do you know a possible solution to do the called file_server_change_sqlserver_system_property fine?

                   

                  I need to change the fileserver path but the sql doesn't work with a path with spaces. I have tried to escape in several ways but it's impossible for me.

                   

                  Thank you.

                  • 6. Re: TrueSight Server Automation 8.9.04
                    Bill Robinson

                    if you are running blasadmin and getting blank values for the file server, then you are probably hitting the problem in that ka and we need to fix that.  and then you can use blasadmin to set the file server path.   so i would focus on getting blasadmin to show values, because that needs to work.

                     

                    what's the history of this env ?  are you making a copy of the env or just moving the file server ?

                    • 7. Re: TrueSight Server Automation 8.9.04
                      Raul Calderon de la Barca

                      Hi Bill,

                       

                      We have access to the blasadmin commands correctly.

                       

                      It was a mistake in the use of the commands.

                       

                      Thank you.

                       

                      BR.

                      • 8. Re: TrueSight Server Automation 8.9.04
                        Ramon Vazquez

                        Adding for future reference, help to others.

                         

                        Origin of this environment was a clonning of VMs (deployment from OVFs) to speed up PoC installation.

                         

                        To check DB is resolved by hostname and not IP, from blasadmin

                            bladmin:default> show Database ConnectionString

                         

                        To see FileServer config values:

                            bladmin:default> show FileServer all

                        (or "show FileServer location" and "show FileServer name")

                         

                        To change FileServer from IP to hostname

                            bladmin:default> set FileServer name <hostname>

                        1 of 1 people found this helpful