Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-16451

Set database tables to be all UPPERCASE when running Bamboo install

    XMLWordPrintable

Details

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      Summary

      In the following example we will be using MySQL but the same applies to PostgreSQL, MSSQL and such.

      Steps to Reproduce

      1. connect to MySQL database: 
        # USERNAME, i.e.: root
# PASSWORD, i.e.: toor
# HOSTNAME, i.e.: localhost
# DATABASE, i.e.: bamboo-5.9.4
mysql -u USERNAME -pPASSWORD --host=HOSTNAME_IP --port=3306 DATABASE
      2. run the following command to show tables: 
        mysql > show tables;

      Expected Results

      $ mysql -u root -ptoor --host=localhost --port=3306 bamboo-5.9.4;
mysql > show tables;

+--------------------------------+
| Tables_in_bamboo-5.9.4         |
+--------------------------------+
| ACL_ENTRY                      |
| ACL_OBJECT_IDENTITY            |
| AGENT_ASSIGNMENT               |
| AGENT_AUTHENTICATION           |
| AO_38321B_CUSTOM_CONTENT_LINK  |
| AO_7A45FB_AOTRACKING_ENTRY     |
| AO_7A45FB_AOTRACKING_RESULT    |
| AO_7A45FB_AOTRACKING_USER      |
| AO_A0B856_WEB_HOOK_LISTENER_AO |
| ARTIFACT                       |
| ARTIFACT_DEFINITION            |
| ARTIFACT_SUBSCRIPTION          |
| AUDIT_LOG                      |
| AUTHOR                         |
| AUTH_ATTEMPT_INFO              |
| BANDANA                        |
| BRANCH_COMMIT_INFO             |
| BRS_ARTIFACT_LINK              |
| BRS_CONSUMED_SUBSCRIPTION      |
| BRS_LINKEDJIRAISSUES           |
| BUILD                          |
| BUILDRESULTSUMMARY             |
| BUILDRESULTSUMMARY_CUSTOMDATA  |
| BUILDRESULTSUMMARY_LABEL       |
| BUILD_DEFINITION               |
| CAPABILITY                     |
| CAPABILITY_SET                 |
| CHAIN_STAGE                    |
| CHAIN_STAGE_RESULT             |
| COMMIT_FILES                   |
| CREDENTIALS                    |
| DEPLOYMENT_ENVIRONMENT         |
| DEPLOYMENT_ENV_VCS_LOCATION    |
| DEPLOYMENT_PROJECT             |
| DEPLOYMENT_PROJECT_ITEM        |
| DEPLOYMENT_PROJECT_ITEM_BA     |
| DEPLOYMENT_RESULT              |
| DEPLOYMENT_RESULT_CUSTOMDATA   |
| DEPLOYMENT_VARIABLE_SUBS       |
| DEPLOYMENT_VERSION             |
| DEPLOYMENT_VERSION_CHANGESET   |
| DEPLOYMENT_VERSION_COMMIT      |
| DEPLOYMENT_VERSION_ITEM        |
| DEPLOYMENT_VERSION_ITEM_BA     |
| DEPLOYMENT_VERSION_JIRA_ISSUE  |
| DEPLOYMENT_VERSION_NAMING      |
| DEPLOYMENT_VERSION_STATUS      |
| DEP_VERSION_PLANRESULTKEYS     |
| EC2_IMAGE_SCRIPT               |
| ELASTIC_IMAGE                  |
| ELASTIC_SCHEDULE               |
| IMSERVER                       |
| LABEL                          |
| MERGE_RESULT                   |
| NOTIFICATIONS                  |
| NOTIFICATION_SETS              |
| OS_PROPERTYENTRY               |
| PLAN_DEPENDENCIES              |
| PLAN_VCS_HISTORY               |
| PLAN_VCS_LOCATION              |
| PROJECT                        |
| QUEUE                          |
| RELEVANT_CHANGESETS            |
| REMEMBERME_TOKEN               |
| REPOSITORY_CHANGESET           |
| REQUIREMENT                    |
| REQUIREMENT_SET                |
| SCRIPT                         |
| STAGE_VARIABLE_CONTEXT         |
| TEST_CASE                      |
| TEST_CASE_RESULT               |
| TEST_CLASS                     |
| TEST_CLASS_RESULT              |
| TEST_ERROR                     |
| TRUSTED_APPS                   |
| TRUSTED_APPS_IPS               |
| TRUSTED_APPS_URLS              |
| USER_COMMENT                   |
| USER_COMMIT                    |
| VARIABLE_BASELINE_ITEM         |
| VARIABLE_CONTEXT               |
| VARIABLE_CONTEXT_BASELINE      |
| VARIABLE_DEFINITION            |
| VARIABLE_SUBSTITUTION          |
| VCS_BRANCH                     |
| VCS_LOCATION                   |
| external_entities              |
| external_members               |
| groups                         |
| hibernate_unique_key           |
| local_members                  |
| password_reset_token           |
| users                          |
| variablesToAutoIncrement       |
+--------------------------------+
94 rows in set (0.01 sec)

      Notes

      As you can notice, the following tables are lowercase whilst the majority are uppercase:

      | external_entities              |
| external_members               |
| groups                         |
| hibernate_unique_key           |
| local_members                  |
| password_reset_token           |
| users                          |
| variablesToAutoIncrement       |

      Workaround

      In case your database tables differ from above, please:

      1. install Bamboo using a fresh database
      2. export inserts from previous databse
      3. import inserts into the new database

      Attachments

        Issue Links

          mentioned in

          Page Loading...

          Activity

            People

              Unassigned Unassigned
              rsperafico Rafael Sperafico (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: