*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.*
