Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
23 replies
Subscribers
8 subscribers
Views
7047 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
I am trying to Install Appian 7.2 with JBOSS EAP 6.1.0 but after completing all
rishub
over 10 years ago
I am trying to Install Appian 7.2 with JBOSS EAP 6.1.0 but after completing all the steps mentioned in documentation,when I am running JBOSS, I am getting error in Application server log: "Cause: An error occurred while trying to save the type information to the primary data source. No types have been imported. Cause: PBOX000016: Access denied: authentication failed (APNX-1-4166-003)". How can I fix it? Thx...
OriginalPostID-83607
OriginalPostID-83607
Discussion posts and replies are publicly visible
0
Patty Isecke
Appian Employee
over 10 years ago
Hi Rishu, please make sure that you've updated standalone.xml to contain the datasources subsystem. More information can be found here:
forum.appian.com/.../Configuring_Relational_Databases
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Patty Isecke
Appian Employee
over 10 years ago
Additionally, ensure that you've added your security domain to standalone.xml as you did with the standalone.xml file for AS7.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Hi Patty, I added the following security domain in standalone.xml
<security-domain name="ds-name-security" cache-type="default">
<authentication>
<login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="optional">
<module-option name="username" value="WWXDemo"/>
<module-option name="password" value="Br*222271"/>
</login-module>
</authentication>
</security-domain>
</security-domains>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Here password is not encrypted
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Patty Isecke
Appian Employee
over 10 years ago
1. The password should be encoded.
2. Did you replace or add the datasources subsystem for your specific database?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Also, I did update Datasource in Standalone.xml which looks like:
<subsystem xmlns="urn:jboss:domain:datasources:1.1">
<datasources>
<drivers>
<driver name="com.microsoft.sqlserver.jdbc" module="com.microsoft.sqlserver.jdbc">
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Patty Isecke
Appian Employee
over 10 years ago
The following error: Access denied: authentication failed, indicates that the credentials used to access the database is wrong. Please make sure the password is encoded and that the security domain, ds-name-security, matches the security domain defined in your appian-ds.xml file.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Patty, Actually my command to execute the SecureIdentityLoginModule class failed. so I could not encode password
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
My appian-ds.xml loooks like: <?xml version="1.0" encoding="UTF-8"?>
<datasources
xmlns:xsi="
www.w3.org/.../XMLSchema-instance"
xsi:noNamespaceSchemaLocation="
www.jboss.org/.../datasources_1_0.xsd">
<xa-datasource
jndi-name="jdbc/WWXPrimary_SQLServer2008_Local"
pool-name="WWXPrimarySQLServer2008Local"
use-java-context="false">
<xa-datasource-property name="ServerName">ABCLocal\\SQLExpress</xa-datasource-property>
<xa-datasource-property name="PortNumber">1433</xa-datasource-property>
<xa-datasource-property name="DatabaseName">WWXDemo</xa-datasource-property>
<driver>com.microsoft.sqlserver.jdbc</driver>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
<security>
<security-domain>ds-name-security</security-domain>
</security>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<xa-pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</xa-datasource>
</datasources>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Patty Isecke
Appian Employee
over 10 years ago
On which part did the encoding fail?
For example, I am using a Windows machine, and my executions would be the following:
1. COMMAND: set JBOSS_HOME=<absolute path to \\jboss-as-7.1.1.Final>
MINE: set JBOSS_HOME=C:\\72_install\\bin\\jboss\\jboss-as-7.1.1.Final
2. You can copy and paste this, however ensure that there are no additional spaces when pasting into the command line: set CLASSPATH=%JBOSS_HOME%\\modules\\org\\picketbox\\main\\picketbox-4.0.7.Final.jar;%JBOSS_HOME%\\modules\\org\\jboss\\logging\\main\\jboss-logging-3.1.0.GA.jar;%CLASSPATH%
3. COMMAND: java org.picketbox.datasource.security.SecureIdentityLoginModule <your_unencrypted_datasource_password>
MINE: java org.picketbox.datasource.security.SecureIdentityLoginModule mySecretPassword
The output:
Encoded password: 23f7924b53c68b71a443aebbcfc61fd6df8592078de921bc
For linux, please view the documentation for the keywords necessary to set the variables.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>