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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Done
    • AMQ 7.4.0.CR2
    • AMQ 7.4.2.GA
    • jdbc
    • None
    • Release Notes
    • 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.
    • Hide
      Previously, when you configured shared store high availability using JDBC persistence, the broker did not read the `jdbc-user` and `jdbc-password` values that you specified in the `database-store` configuration. As a consequence of this issue, the broker could not connect to the database. This issue is now resolved. The broker reads the encrypted values that you specify for `jdbc-user` and `jdbc-password`.
      Show
      Previously, when you configured shared store high availability using JDBC persistence, the broker did not read the `jdbc-user` and `jdbc-password` values that you specified in the `database-store` configuration. As a consequence of this issue, the broker could not connect to the database. This issue is now resolved. The broker reads the encrypted values that you specify for `jdbc-user` and `jdbc-password`.
    • Documented as Resolved Issue
    • +
    • Verified in a release

    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

          Activity

            People

              fnigro Francesco Nigro
              dbruscin Domenico Francesco Bruscino
              Mikhail Krutov Mikhail Krutov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: