Hi Jibsan, you have to ensure MySQL has bind on all interfaces not only to localhost netstat -patn | grep 3306
And for each additional host you need an extra grant statement (or for the whole network of you have a non gateway VLAN) GRANT (...) TO 'hola'@'<HOST IP>' (...) TIP: Install mysql-client on each host and try to connect to database from each host mysql -p -h <Mysql IP> open504 Greetings from Germany Marcus Am 6. August 2020 21:25:34 MESZ schrieb Jibsan Joel Rosa Toirac <[email protected]>: >*Hello Maxim and the rest of the comunity. I have a problem, I'm trying >to >set up a cluster between two OM nodes. I made the installation and I >installed MySQL and it worked fine for the first node. On the other >hand, >the second one when I go to the installation and I chose the MySQL >database >type, I fill the data:* > >host ip >port (3306) >database name (open504) >database user (hola) the same of the tutorial PDF just for test it >database password (1a2B3c4D) the same of the tutorial PDF just for >test it > >W*hen I click check or next it gives me the next error:* > >Could not create connection to database server. Attempted reconnect 3 >times. Giving up.<br/><a target="_blank" href=" >https://openmeetings.apache.org/MySQLConfig.html";>MySQL</a> > >*I've changed the time zone at node:* > >timedatectl set-timezone America/Havana > >*and at mysq_persistence.xml by adding:* > >serverTimezone=America/Havana& > >*Also I have changed the MySQL conf to allow external connections:* > >nano /etc/mysql/mysql.conf.d/mysqld.cnf > >bind-address = 0.0.0.0 (modified to that value) > >*And to allow it through the Firewall:* > >iptables -A INPUT -p tcp --destination-port 3306 -j ACCEPT > >ufw allow 3306/tcp > >*As the tutorial teach, I did this to create DB and DB_User:* > >CREATE DATABASE open504 DEFAULT CHARACTER SET 'utf8'; > >GRANT ALL PRIVILEGES ON open504.* TO 'hola'@'localhost' IDENTIFIED BY >'1a2B3c4D' WITH GRANT OPTION; > >*And if I try this from an external host it work:* > >mysql -u hola -h 192.168.14.200 -p > >*So could you help me with this, I have try everything but it doesn's >work >yet to me.* > >*Thank you,* > >*Jibsan.* -- Marcus Wellnitz
