You're right. The result from netstat was:
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2557/mysqld
after changing the bindaddress config in the mysql config as per the docs to
free up networking, it then gives this result:
adam@isengard:~$ sudo netstat -napt | grep 3306
tcp 0 0 127.0.1.1:3306 0.0.0.0:* LISTEN 16473/mysqld
tcp 0 0 127.0.1.1:53067 127.0.1.1:3306 TIME_WAIT -
which looks weird. But then it's probably just because I don't have much
experience in this area. Why has it switched over to 127.0.1.1 ?
Thanks
Adam
Mark Beierl on 23/11/09 19:00, wrote:
Silly thought but - is mysql configured to listen to 127.0.0.1 only?
Something like
sudo netstat -napt | grep 3306
ought to show if mysql is listening on 127.0.0.1:3306 or 0.0.0.0:3306.
Regards,
Mark
Adam Hardy wrote:
Thought I had a simple problem but I don't really find anything
relevant on the web and I'm not getting any responses to my questions
here.
Just a pointer in the right direction would be helpful - something to
put me back on the scent?
Thanks
Adam
Adam Hardy on 20/11/09 20:38, wrote:
I have a lan with a gateway machine running an ADSL modem and two
NICs with iptables and dnsmasq.
It also runs mysql and tomcat but is currently just a simple gateway,
I'm not trying to configure any DMZ or fancier stuff like that.
My problem is that I can access mysql using 'localhost:3306' but I
can't access it on the same box when using the machine name e.g.
'isengard:3306' and my guess is that I have mis-configured either
dnsmasq or iptables.
I figure that my command "mysql --host=isengard" is probably being
resolved as external and then getting blocked by the firewall.
My dnsmasq config file, based on the example config but with comments
removed, is:
domain-needed
bogus-priv
filterwin2k
local=/localdomain/
domain=localdomain
dhcp-range=192.168.0.3,192.168.0.254
dhcp-option=option:router,192.168.0.2
dhcp-option=option:mtu,1500
and my resolv.conf file is:
nameserver 194.74.65.68
and I think this is getting continually rewritten by dhcp with the
nameserver info from the dhcp server on the modem which gives the
outside NIC its internet ip address.
Does this make any sense? Or rather does anyone see where my
situation is foobarred?
_______________________________________________
Dnsmasq-discuss mailing list
Dnsmasq-discuss@lists.thekelleys.org.uk
http://lists.thekelleys.org.uk/mailman/listinfo/dnsmasq-discuss