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

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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.

      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>

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

                Created:
                Updated:
                Resolved: