[Users] MySQL server is unreachable from OpenVZ container

[jjs - mainphrame]

Sergey,

This may or may not be of use -

I've got an ubuntu container running a mysql database, for use by
several centos containers running maia mailguard. I remember having to
edit the mysql config to have the database listening via tcp/ip rather
than on a unix socket only, and, further, to specify that it was bound
to 0.0.0.0, rather than the default of 127.0.0.1.

Regards,

Jake



On Tue, Apr 19, 2016 at 4:02 AM, Sergey Bolbat <madd.korben at gmail.com> wrote:
> Writing out of despair. Yesterday, as usual and having done this for
> thousands of times before, I'd installed MySQL server in the Head Node for
> using it from the OpenVZ container. I've created user, gave privileges for
> the base and configured my.cnf to listen for server's IP. Then I've tried to
> connect server from the container using mysql client - mysql -h server-ip -u
> user -p and after long delay I've got error 'ERROR 2003 (HY000): Can't
> connect to MySQL server on 'server ip' (110)
>
> I try to telnet to 3306 - timeout. I try to change listening port to 3307 or
> any other - timeout. I've added a rule for 3306 and container's IP (despite
> the entire subnet of containers was already allowed before) in iptables -
> timeout. Stopped iptables - also timeout!
>
> Then I thought - maybe server is totally unreachable from the container
> (despite the Internet connection is working properly inside container
> through venet), but ssh connection succeded. Then I thought - maybe MySQL
> server is inaccesible from any of container, but connection from another
> container succeded. I thought that maybe something blocks mysql connections
> from the container but tcpdump in the HN successfully cought incoming
> packets on specified port.
>
> What could be wrong else!? I don't have any versions or methods of
> investigating. Maybe you can advice something? Thanks in advance.
>
> Thank you.
>
>
> _______________________________________________
> Users mailing list
> Users at openvz.org
> https://lists.openvz.org/mailman/listinfo/users
>