Grouper Users - Open Discussion List

[Sudheer Singidi <>]

Hello Varun,

You might have tried these quick fixes but sharing them anyway:

Here are some quick fixes:

1. Verify the connection

Check the network connection to make sure that there’s no TCP/IP connectivity issue from your host
 And double check the credentials.

2. Increase the value of max_connect_errors

You should find the setting in the MySQL configuration file under the [mysqld] tag (my.ini on Windows, my.cnf on Unix/Linux) and edit the value of max_connect_errors.


For example:

[mysqld]
max_connect_errors=10000


Or run this query:


SET GLOBAL max_connect_errors=10000;

3. Flush host cache


If you have shell access to the server, login and execute this command:

mysql -u root -p -e 'flush hosts'

From the SQL console, run this statement:


FLUSH HOSTS;

Restarting the DB server should help clear the cache too.

On Wed, Jun 22, 2022 at 8:33 AM Varun Vudatha <> wrote:

Hi Team Grouper,

I am trying to setup a POC on grouper. I need some assistance in completing the installation process for grouper v2.5.60. I was referring to this article(https://spaces.at.internet2.edu/display/Grouper/Install+the+Grouper+v2.5+container+with+maturity+level+0+manually) for grouper installation. I am following All-In-One strategy to install all containers and was able to run all the containers with the grouperAllDockerRun.sh script. Once the container started running, I have checked the logs and found these errors in the log:-

 "Host 'X.XXX.XX.XX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'".

I have flushed out the hosts using 'mysqladmin flush-hosts' from the mysql admin, still not able to proceed further. Please assist to continue with the installation and continue further.

I am running the docker on a EC2 Red Hat Enterprise Linux 8 (HVM), SSD Volume Type linux t2.medium (4 gig ram) server provided by AWS and the database(MySQL) was created on AWS RDS.

Varun Vudatha

Weill Cornell Medicine

Information Technologies & Services

575 Lexington Avenue, 3rd Floor

New York, NY 10022

--

Thanks&Regards Sudheer Singidi.