Hi, I am trying to install 7.9 version and keep getting this permissi

Hi,

I am trying to install 7.9 version and keep getting this permission denied error inside the server log. I have run the query "Grant all on db.* to 'root'@'localhost' on MySQL for all the databases and I am using root as the user inside standalone.xml. But always keep getting this error that access is denied, Permission denied error. Can anybody suggest anything. Attached is server log.

thanks,
Aswin

server-7.9-log.txt

OriginalPostID-154029

OriginalPostID-154029

  Discussion posts and replies are publicly visible

Parents
  • I tried that....but still keep getting the same access denied error....I think the problem is in my standalone.xml file where I declared my datasources.....I am just gonna show the code section here:

    <datasource jndi-name="java:jboss/datasources/AppianPrimaryDS" pool-name="ds-name-security-primary" enabled="true" use-java-context="false">
    <connection-url>jdbc:mysql://localhost:3306/appian72primary?useOldAliasMetadataBehavior=true</connection-url>
    <driver>h2</driver>
    <security>
    <user-name>root</user-name>
    <password>79ba31e7dd57513d6cf3b03f66c6c6f8</password>
    </security>
    </datasource>
    <datasource jndi-name="java:jboss/datasources/AppianBusinessDS" pool-name="ds-name-security-business" enabled="true" use-java-context="false">
    <connection-url>jdbc:mysql://localhost:3306/appian72business?useOldAliasMetadataBehavior=true</connection-url>
    <driver>h2</driver>
    <security>
    <user-name>root</user-name>
    <password>79ba31e7dd57513d6cf3b03f66c6c6f8</password>
    </security>
    </datasource>

    Please tell me if there is anything wrong in here, particularly in the connection-url section....it had something weird by default in the beginning which I changed to this URL definition now....but the access denied error was there before also when that weird thing existed...so it just didn't happen because of me changing the definition of this thing(connection-url).....Also I am attaching server.log...

    server.log

Reply
  • I tried that....but still keep getting the same access denied error....I think the problem is in my standalone.xml file where I declared my datasources.....I am just gonna show the code section here:

    <datasource jndi-name="java:jboss/datasources/AppianPrimaryDS" pool-name="ds-name-security-primary" enabled="true" use-java-context="false">
    <connection-url>jdbc:mysql://localhost:3306/appian72primary?useOldAliasMetadataBehavior=true</connection-url>
    <driver>h2</driver>
    <security>
    <user-name>root</user-name>
    <password>79ba31e7dd57513d6cf3b03f66c6c6f8</password>
    </security>
    </datasource>
    <datasource jndi-name="java:jboss/datasources/AppianBusinessDS" pool-name="ds-name-security-business" enabled="true" use-java-context="false">
    <connection-url>jdbc:mysql://localhost:3306/appian72business?useOldAliasMetadataBehavior=true</connection-url>
    <driver>h2</driver>
    <security>
    <user-name>root</user-name>
    <password>79ba31e7dd57513d6cf3b03f66c6c6f8</password>
    </security>
    </datasource>

    Please tell me if there is anything wrong in here, particularly in the connection-url section....it had something weird by default in the beginning which I changed to this URL definition now....but the access denied error was there before also when that weird thing existed...so it just didn't happen because of me changing the definition of this thing(connection-url).....Also I am attaching server.log...

    server.log

Children
No Data