Vesta Control Panel - Forum

Hi,
the problem is always the same.
I cannot connect hosting php web site on my mysql vesta vps.
From command line i can connect without any problem and from many location.
Mysql log error doesn't trace any error.
I set bind address to my external ip but nothing.
I stopped iptables and fail2ban.
The strange behavior is the for some minute i see website working but then ,after a while, always same message:
Can't connect to MySQL server on 'ip address'

On the other vps (without vesta) i can connect without any problem......(same OS , same mysql version, apache,php etc)
Please give me a solution
thanks

Oh, it's Vesta fault again? ;)

There is simple solution:
[*] firewall of the server must be set-up to enable incomming connections on port 3306
[*] you must have a user in MySQL who is allowed to connect from % (any host) (see manualfor details)

More detailed thread - http://stackoverflow.com/questions/1935 ... -using-php

[*] firewall of the server must be set-up to enable incomming connections on port 3306

firewall is set correctly

[*] you must have a user in MySQL who is allowed to connect from % (any host) (see manualfor details)

already done.

For a while connection was up. Then after some minutes was down again!
Client error is : SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'ip' (4)
the error code (4) means interrupted system call.
From the remote command line I can make connection and querying wihout problem.
Very strange problem!
Moreover with tcdump i see incoming / outgoing connection: In outogoing conn ack value is very high!!

Then problem may be in php.ini

max_execution_time
mysql.connect_timeout

And php limitations.

Hosting doesn't allow connection to external database.
So it's not vesta problem. Hosting limitation.
thanks

Expected unexpected ;-)
Thanks for answer.