Hello,

I can't connect to to my trove mysql DB from an instance in a selfservice network.

Strange thing is I CAN connect to the trove instance via ssh:

ubuntu@dozbox2:~$ telnet 192.168.0.176 22
Trying 192.168.0.176...
Connected to 192.168.0.176.
Escape character is '^]'.
SSH-2.0-OpenSSH_7.6p1 Ubuntu-4ubuntu0.7

But I CANNOT reach the DB port from on the troave instance:

ubuntu@box2:~$ telnet 192.168.0.176 3306
Trying 192.168.0.176...
telnet: Unable to connect to remote host: No route to host

Within the Trove instance I CAN work with the client...

root@ms3:/var/log/trove# mysql -h 192.168.0.176 -u dbadmin -p -P 3306
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 331

The security group for that trove instance allows ssh AND 3306 (see additional infos/rules below).

Any help is really appreciated!

------- Additional Infos ------------------

root@voscontrol:~# openstack security group show trove_sg-27547af3-9bb0-4df5-b4ff-e85daa72c6ef
+-----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Field | Value |
+-----------------+-----------------------------------------------------------------------------------
| created_at | 2023-12-18T23:04:51Z
| description | Security group for trove instance 27547af3-9bb0-4df5-b4ff-e85daa72c6ef
| id | d73ff24a-5288-486b-b10b-fe9902f80e15
| name | trove_sg-27547af3-9bb0-4df5-b4ff-e85daa72c6ef
| project_id | d2e35c5479c441dc9ba4dba8e9b914bc
| revision_number | 3

| rules | created_at='2023-12-18T23:04:52Z',
direction='ingress', ethertype='IPv4',
id='0484ddff-c945-45d0-b271-7d30e7fbf619',
port_range_max='3306', port_range_min='3306',
protocol='tcp', remote_ip_prefix='0.0.0.0/0',
updated_at='2023-12-18T23:04:52Z' |

| | created_at='2023-12-18T23:04:51Z',
direction='egress', ethertype='IPv6',
id='27ed1225-984a-454e-86da-656de3669038',
updated_at='2023-12-18T23:04:51Z' |

| | created_at='2023-12-18T23:10:33Z',
direction='ingress', ethertype='IPv4',
id='c2c7c390-8b13-4b00-ab7c-0a8a7687ac08',
port_range_max='22', port_range_min='22',
protocol='tcp', remote_ip_prefix='0.0.0.0/0',
updated_at='2023-12-18T23:10:33Z' |

| | created_at='2023-12-18T23:04:51Z',
direction='egress', ethertype='IPv4',
id='d1fdc662-fc24-46bd-80db-3aca725f96aa',
updated_at='2023-12-18T23:04:51Z' |