Uploaded image for project: 'AMQ Broker'
  1. AMQ Broker
  2. ENTMQBR-2733

JDBC HA shared store does not take credentials from the jdbc-user and jdbc-password tags

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.5.0.CR2, AMQ 7.4.2.GA
    • AMQ 7.4.0.CR2
    • jdbc
    • None
    • Release Notes
    • +
    • Hide
      Cause:
      Previously, when using JDBC with HA (Shared Store), `jdbc-user` and `jdbc-password` are ignored.
      Consequence:
      The broker was unable to start.
      Fix:
      The broker is using `jdbc-user` and `jdbc-password` with JDBC HA (Shared Store).
      Result:
      The broker can start.
      Show
      Cause: Previously, when using JDBC with HA (Shared Store), `jdbc-user` and `jdbc-password` are ignored. Consequence: The broker was unable to start. Fix: The broker is using `jdbc-user` and `jdbc-password` with JDBC HA (Shared Store). Result: The broker can start.
    • Documented as Resolved Issue
    • Verified in a release
    • Workaround Exists
    • Hide

      Specify the credentials in the connectionURL when using jdbc shared HA.
      But these credentials can not be encrypted and may cause security concerns.

      Show
      Specify the credentials in the connectionURL when using jdbc shared HA. But these credentials can not be encrypted and may cause security concerns.

    Description

      When using JDBC with HA (Shared Store), the username and password configured in the tags jdbc-user, jdbc-password are ignored.
      It only works with jdbcConnectionURL. So, if the credentials are specified there, it works fine.

      This works:

      <database-store>
<jdbc-connection-url>jdbc:mysql://user:password@localhost:3306/data</jdbc-connection-url>
<jdbc-connection-url>jdbc:sqlserver://host:1433;databaseName=db;user=user;password=password</jdbc-connection-url> 
....

      This does not work:

      <jdbc-connection-url>jdbc:sqlserver://host:1433;databaseName=db</jdbc-connection-url> 
				 <jdbc-user>user</jdbc-user>
				 <jdbc-password>password</jdbc-password>

      Attachments

        Issue Links

          is cloned by

          Bug - A problem that impairs or prevents the functions of the product. ENTMQBR-3098 JDBC HA shared store does not take credentials from the jdbc-user and jdbc-password tags

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              fnigro Francesco Nigro
              rhn-support-adongre Avinash Dongre
              Mikhail Krutov Mikhail Krutov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: