OpenVZ Forum


Home » General » Support » MySQL inside container
MySQL inside container [message #37181] Tue, 25 August 2009 12:10 Go to next message
CrazyLapinou is currently offline  CrazyLapinou
Messages: 9
Registered: August 2009
Junior Member
Hi,
First, sorry for my bad english...
I am using OpenVZ kernel 2.6.26 under Debian Lenny. My container is under Debian Lenny too.
In my host node, i have some PHP files. These files need to access MySQL database. The MySQL database is in a container. The problem is that i can't access MySQL server from my host node.
I'm using this iptables script:
HOST_IP="192.168.1.60"
HOST_PORTS="22 80"

iptables -P FORWARD ACCEPT
iptables -P INPUT DROP
iptables -P OUTPUT ACCEPT

iptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
iptables -A FORWARD -m state --state ESTABLISHED,RELATED -j ACCEPT

iptables -A INPUT -i lo -j ACCEPT

for port in $HOST_PORTS ; do
    iptables -A INPUT -p tcp -d $HOST_IP --dport $port -j ACCEPT
    iptables -A INPUT -p udp -d $HOST_IP --dport $port -j ACCEPT
done

I tried whitout iptables but it is the same.
Can someone help me ? Thank you Wink
Re: MySQL inside container [message #37182 is a reply to message #37181] Tue, 25 August 2009 12:21 Go to previous messageGo to next message
arghbis is currently offline  arghbis
Messages: 35
Registered: November 2007
Member
is you mysql server configured to listen to network requests?
Re: MySQL inside container [message #37183 is a reply to message #37181] Tue, 25 August 2009 12:29 Go to previous messageGo to next message
CrazyLapinou is currently offline  CrazyLapinou
Messages: 9
Registered: August 2009
Junior Member
That is maybe the problem...
I don't really know how to configure mysql. It is a clear install with apt-get.
I have this in configuration file:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

I need to change this ?
Re: MySQL inside container [message #37184 is a reply to message #37183] Tue, 25 August 2009 12:32 Go to previous messageGo to next message
arghbis is currently offline  arghbis
Messages: 35
Registered: November 2007
Member
just comment this line and restart mysql
Re: MySQL inside container [message #37185 is a reply to message #37181] Tue, 25 August 2009 12:45 Go to previous messageGo to next message
CrazyLapinou is currently offline  CrazyLapinou
Messages: 9
Registered: August 2009
Junior Member
It is the same... I get this errors:
mysql_connect(): Can't connect to MySQL server on '192.168.1.60' (4) in /var/www/mysql.class.php on line 26

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/mysql.class.php on line 27

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /var/www/mysql.class.php on line 35
Re: MySQL inside container [message #37186 is a reply to message #37185] Tue, 25 August 2009 12:47 Go to previous messageGo to next message
arghbis is currently offline  arghbis
Messages: 35
Registered: November 2007
Member
try in command line and with your INPUT iptables tables set to accept, it would be easier to debug
Re: MySQL inside container [message #37187 is a reply to message #37181] Tue, 25 August 2009 12:54 Go to previous messageGo to next message
CrazyLapinou is currently offline  CrazyLapinou
Messages: 9
Registered: August 2009
Junior Member
What is command line for you ? It is to use mysql-client program ?
Re: MySQL inside container [message #37188 is a reply to message #37187] Tue, 25 August 2009 12:56 Go to previous messageGo to next message
arghbis is currently offline  arghbis
Messages: 35
Registered: November 2007
Member
yes, something like : mysql -u yourUser -h yourMysqlServerIp -p YourDatabase
Re: MySQL inside container [message #37189 is a reply to message #37181] Tue, 25 August 2009 12:59 Go to previous message
CrazyLapinou is currently offline  CrazyLapinou
Messages: 9
Registered: August 2009
Junior Member
Arg... That was so easy...
I forgotten i added iptables on container too... And i didn't openned mysql port in it. Embarassed
Thank you. Wink
Previous Topic: reset cached RAM?
Next Topic: APF - Kernel Module Error
Goto Forum:
  


Current Time: Fri Apr 19 19:01:23 GMT 2024

Total time taken to generate the page: 0.01852 seconds