Issue Database remote access

[Castellarnau Aurélien]

Hello everyone,

I'm in difficulties trying to reach a newly created database on plesk platform from my windows host.
The final goal is to open a connection from a golang application in a docker container. For now, i try to connect my app to the remote database from my windows without any docker context. Fail after fail, i have read a lot, followed the documentation and all relatives forum threads without any success...

Context:
Plesk Onyx Version 17.5.3 Update #39
CentOs Linux 7.4.1708 (Core)‬
mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1

Firewall: MySQL server Allow incoming from all
ACL: plesk bin database -u db_name -update_user user_name -passwd sample -add-access % => done
And by IHM: Allow remote connections from any host => check
my.cnf : i tried all founded solutions one by one ( bind address = 0.0.0.0 or :: or commented bind_address)

Local connection trought ssh works fine with user credentials.
To reach the mysql server from a distant host i use:
mysql -u username -p -h ip => ERROR 2002 (HY000): Can't connect to MySQL server on 'ip' (10060)
or
golang tcp dial with or without custom TLSconfig (using ozzo/dbx) => no answer

A little bit worry about the facts that relatives threads have no answers or given answers don't works for me.

What did i missed?

Thanks

 

[IgorG]

I think this problem is addressed in the following KB - How to enable remote access to MySQL database server. Does this solve your issue?

 

[Castellarnau Aurélien]

Hello Igor,

Thank you for your reply. As i said, i followed documentation, included the link you provided (if you read my post, you will retrieve all steps from 1 to 6...).

Step 1: Allow remote connections from any host => check
Step 2: my.cnf : i tried all founded solutions one by one ( bind address = 0.0.0.0 or :: or commented bind_address)
Step 3 and 4: ACL: plesk bin database -u db_name -update_user user_name -passwd sample -add-access % => done
Step 5: ok
Step 6: mysql -u username -p -h ip => ERROR 2002 (HY000): Can't connect to MySQL server on 'ip' (10060)

 

[IgorG]

Can you connect to port 3306 of the server from your workstation with telnet, for example?

 

[Castellarnau Aurélien]

No, i can't. The return of telnet -l username 'ip' is:
Impossible to open a connection to the host on port 3306: fail during connection.
Same on port 23.

It's working on 8443

Could be related to this?
Resolved - Can't send mail - can't telnet to any destination on port 25

 

[Bitpalast]

In similar cases, a firewall before the server that the provider operates has caused connection issues. Maybe you need to open port 3306 in that external firewall? Maybe you have an entry for that in your hosting provider's customer panel?

 

[AYamshanov]

Hi Castellarnau Aurélien,

Step 2: my.cnf : i tried all founded solutions one by one ( bind address = 0.0.0.0 or :: or commented bind_address)

1) First of all, check that MySQL ready to server request from the network.

# telnet localhost 3306
Trying ::1...
Connected to localhost.
Escape character is '^]'.
R
5.5.56-MariaDB[...]

2) If it not so, fix and restart the MySQL service. One of the correct variants is:

# grep bind-address /etc/my.cnf
bind-address = ::
#

3) Check, that setting was applied:

# netstat -an | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN

4) Check, that you can connect to MySQL from the server, that MySQL listen on TCP-socket:

# telnet localhost 3306
Trying ::1...
Connected to localhost.
Escape character is '^]'.
R
5.5.56-MariaDB[...]

Now you can make next steps and check network connectivity from one computer/server to another. If you can't connect to MySQL with telnet, you need check firewall(s) and routing.

 

[Castellarnau Aurélien]

Thanks you for answers AYAMSHANOV and Peter Debik,

I don't have access to the web provider panel for now. I propose to close this thread, i'll reopen one when i'll have all required access.
It can take a while...