Bug 1467697 - Unable to deploy xa-datasource (postgres driver) over ssl
Unable to deploy xa-datasource (postgres driver) over ssl
Status: NEW
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: jbossas (Show other bugs)
unspecified
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: jboss-set
Peter Mackay
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2017-07-04 12:18 EDT by Abhi
Modified: 2017-07-04 12:18 EDT (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Instance Name: Not Defined Build: CSProcessor Builder Version 1.8 Build Name: 8740, Administration and Configuration Guide-6-3 Build Date: 05-04-2013 09:18:51
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Abhi 2017-07-04 12:18:27 EDT
Title: SSL on PostgreSQL XA Datasource

Describe the issue:

Following configuration was used:

 <xa-datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="JBPMDS" enabled="true" use-ccm="false">
                    <xa-datasource-property name="databaseName">
                        DB
                    </xa-datasource-property>
                    <xa-datasource-property name="serverName">
                        127.0.0.1
                    </xa-datasource-property>
                    <xa-datasource-property name="portNumber">
                        5432
                    </xa-datasource-property>
                    <xa-datasource-property name="Ssl">
                        true
                    </xa-datasource-property>
                    <xa-datasource-property name="trustServerCertificate">
                        true
                    </xa-datasource-property>
                    <xa-datasource-property name="trustStore">
                        keystore
                    </xa-datasource-property>
                    <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
                    <driver>postgresql</driver>
                    <xa-pool>
                        <allow-multiple-users>true</allow-multiple-users>
                        <is-same-rm-override>false</is-same-rm-override>
                        <interleaving>false</interleaving>
                        <pad-xid>false</pad-xid>
                        <wrap-xa-resource>false</wrap-xa-resource>
                    </xa-pool>
                    <security>
                        <user-name>postgres</user-name>
                        <password>postgres</password>
                    </security>
                    <validation>
                        <check-valid-connection-sql>select 1</check-valid-connection-sql>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>true</background-validation>
                        <background-validation-millis>10000</background-validation-millis>
                    </validation>
                    <statement>
                        <share-prepared-statements>false</share-prepared-statements>
                    </statement>
                </xa-datasource>

Suggestions for improvement:


Additional information:
Please advise.
Setup not working.

Following is the error:
Response

Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0042: failed to match pool. Check JndiName: java:jboss/datasources/jbpmDS",
    "rolled-back" => true,
    "response-headers" => {"process-state" => "reload-required"}
}

Note You need to log in before you can comment on or make changes to this bug.