[ https://issues.apache.org/jira/browse/AIRAVATA-2517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16166647#comment-16166647 ] 

Marcus Christie commented on AIRAVATA-2517:
-------------------------------------------

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)