[ https://issues.apache.org/jira/browse/AIRAVATA-2517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16166647#comment-16166647
]
Marcus Christie edited comment on AIRAVATA-2517 at 9/14/17 5:29 PM:
--------------------------------------------------------------------
Links related to configuring MySQL in Wildfly for dealing with this problem
* https://developer.jboss.org/thread/266941
* https://docs.jboss.org/author/display/WFLY10/DataSource+configuration?_sscc=t
Specifically the first link suggests adding the following to MySQL connection pool configuration:
{code:xml}
<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>
{code}
More details on configuration options: https://developer.jboss.org/wiki/ConfigDataSources
was (Author: marcuschristie):
Links related to configuring MySQL in Wildfly for dealing with this problem
* https://developer.jboss.org/thread/266941
* https://docs.jboss.org/author/display/WFLY10/DataSource+configuration?_sscc=t
Specifically the first link suggests adding the following to MySQL connection pool configuration:
{code:xml}
<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>
{code}
> Cannot view Users in seagrid gateway
> ------------------------------------
>
> Key: AIRAVATA-2517
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2517
> Project: Airavata
> Issue Type: Bug
> Environment: https://seagrid.org
> Reporter: Eroma
> Assignee: Marcus Christie
> Priority: Critical
> Attachments: Screen Shot 2017-09-14 at 10.49.25 AM.png
>
>
> Cannot view users in the gateway, getting Invalid argument supplied for foreach()
> this restrict giving access to new users. or changing roles of existing in the gateway.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
|