Local machine installation without FQDN and Error with starting up a local demo installation

You need to change custom.properties to have the correct jndi name mentioned inside appian-ds.xml. Inside appian-ds.xml you have named primary and secondary databases's jndi name as jdbc/AppianPrimaryDS and jdbc/AppianBusinessDS.....so in custom.properties file it should be named the same. Looking at the logs, I noticed two problems:

1. jdbc/AppianDS is being mentioned. I assume you have that spelled out wrong inside custom.properties file. Please change to:

conf.data.APPIAN_DATA_SOURCE=jdbc/AppianPrimaryDS and conf.data.datasources=jdbc/AppianBusinessDS

2. Also please check appian-ds.xml, I see in the logs: 

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'appian17.4_primary'

I assume that you created databases by the name "APPIAN_SCHEMA" and "BUSINESS_SCHEMA". So why appian17.4_primary? Please verify database name as APPIAN_SCHEMA and BUSINESS_SCHEMA inside appian-ds.xml.

Also one new thing I want you to try out is to set permission Mysql config.docxthrough SQL workbench. I am attaching a word doc of how I do it. Please follow that.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'appian17.4_primary'

I assume that you created databases by the name "APPIAN_SCHEMA" and "BUSINESS_SCHEMA". So why appian17.4_primary? Please verify database name as APPIAN_SCHEMA and BUSINESS_SCHEMA inside appian-ds.xml. 

                                                                                                                          |

                                                                                                                          |

I used the default instruction from the quickstart guide to change the line in Repo file and not the original file. Do you want me to replace the line with <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/appian17.4_APPIAN_SCHEMA?useOldAliasMetadataBehavior=true</xa-datasource-property>

Yes...pls change your appian-ds.xml to the file being attached...

<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="www.jboss.org/.../schema">
<xa-datasource
jndi-name="jdbc/AppianPrimaryDS"
pool-name="MySqlDS"
enabled="true"
use-java-context="false">
<xa-datasource-property name="serverName">localhost</xa-datasource-property>
<xa-datasource-property name="portNumber">3306</xa-datasource-property>
<xa-datasource-property name="databaseName">APPIAN_SCHEMA</xa-datasource-property>
<xa-datasource-property name="useUnicode">true</xa-datasource-property>
<xa-datasource-property name="characterEncoding">UTF-8</xa-datasource-property>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<driver>com.mysql.jdbc</driver>
<security>
<security-domain>ds-name-security-primary</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 xmlns="www.jboss.org/.../schema">
<xa-datasource
jndi-name="jdbc/AppianBusinessDS"
pool-name="MySqlDS"
enabled="true"
use-java-context="false">
<xa-datasource-property name="serverName">localhost</xa-datasource-property>
<xa-datasource-property name="portNumber">3306</xa-datasource-property>
<xa-datasource-property name="databaseName">BUSINESS_SCHEMA</xa-datasource-property>
<xa-datasource-property name="useUnicode">true</xa-datasource-property>
<xa-datasource-property name="characterEncoding">UTF-8</xa-datasource-property>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<driver>com.mysql.jdbc</driver>
<security>
<security-domain>ds-name-security-business</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>

Still facing the error loading JBOSS. I have attached the CMD result and also the server log2480.server.lognew error.doc

To add, my computer has 8 GB of memory with no other application running. As adviced I have stopped all running tasks from Task manager too.