Hi, I am a newcomer to xen and have a problem with MySQL access on domUs. dom0 is Debian Squeeze and two domUs are Squeeze also. I am installing a mail server on one domU and need MySQL to be available externally, however for some reason it is blocked, while other services e.g. IMAP and POP3 are available externally. Example nmap output is given below. I have not added any rules to iptables. One possible problem I can think of is that I had installed cacti on dom0 to monitor load etc., which also required MySQL. When I discovered the problem with domUs not being able to make MySQL available externally I uninstalled cacti and MySQL, but the problem remains. Any help would be much appreciated. Jimmy root@triangulum:~# nmap localhost Starting Nmap 5.00 ( http://nmap.org ) at 2011-10-03 18:53 BST Interesting ports on localhost (127.0.0.1): Not shown: 994 closed ports PORT STATE SERVICE 22/tcp open ssh 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 995/tcp open pop3s 3306/tcp open mysql Nmap done: 1 IP address (1 host up) scanned in 0.15 seconds root@triangulum:~# nmap 192.168.1.22 Starting Nmap 5.00 ( http://nmap.org ) at 2011-10-03 18:53 BST Interesting ports on triangulum.xxx (192.168.1.22): Not shown: 995 closed ports PORT STATE SERVICE 22/tcp open ssh 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 995/tcp open pop3s Nmap done: 1 IP address (1 host up) scanned in 0.15 seconds root@triangulum:~# -- http://toutlemonde.eu _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
On (03/10/11 19:26), Jimmy Cullen wrote:> To: xen-users@lists.xensource.com > Date: Mon, 03 Oct 2011 19:26:13 +0100 > From: Jimmy Cullen <jimmy@toutlemonde.eu> > Subject: [Xen-users] domU MySQL not available externally > > Hi, > > I am a newcomer to xen and have a problem with MySQL access on domUs. dom0 > is Debian Squeeze and two domUs are Squeeze also. I am installing a mail > server on one domU and need MySQL to be available externally, however for > some reason it is blocked, while other services e.g. IMAP and POP3 are > available externally. Example nmap output is given below. I have not added > any rules to iptables. > > One possible problem I can think of is that I had installed cacti on dom0 > to monitor load etc., which also required MySQL. When I discovered the > problem with domUs not being able to make MySQL available externally I > uninstalled cacti and MySQL, but the problem remains. >I would look at the Mysql configuration. By default it may only be listening to localhost. What''s going on with Mysql in dom0 should be totally independent. Look for some lines like this: # 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 good luck, James _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
Hi James, Thanks for the pointer, you were right. I commented out the bind line and MySQL is available beyond the loopback interface. Thanks for your help and advice. Jimmy On Mon, 3 Oct 2011 16:07:09 -0400, James Triplett <jm-xenusers@vj8.net> wrote:> On (03/10/11 19:26), Jimmy Cullen wrote: >> To: xen-users@lists.xensource.com >> Date: Mon, 03 Oct 2011 19:26:13 +0100 >> From: Jimmy Cullen <jimmy@toutlemonde.eu> >> Subject: [Xen-users] domU MySQL not available externally >> >> Hi, >> >> I am a newcomer to xen and have a problem with MySQL access on domUs. >> dom0 >> is Debian Squeeze and two domUs are Squeeze also. I am installing amail>> server on one domU and need MySQL to be available externally, howeverfor>> some reason it is blocked, while other services e.g. IMAP and POP3 are >> available externally. Example nmap output is given below. I have not >> added >> any rules to iptables. >> >> One possible problem I can think of is that I had installed cacti ondom0>> to monitor load etc., which also required MySQL. When I discovered the >> problem with domUs not being able to make MySQL available externally I >> uninstalled cacti and MySQL, but the problem remains. >> > > I would look at the Mysql configuration. By default it may only be > listening > to localhost. What''s going on with Mysql in dom0 should be totally > independent. > > Look for some lines like this: > # 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 > > good luck, > James > > > > _______________________________________________ > Xen-users mailing list > Xen-users@lists.xensource.com > http://lists.xensource.com/xen-users-- http://toutlemonde.eu _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users