[Dnsmasq-discuss] dnsmasq / dns server / iptables config glitch?
Mark Beierl
mark at jemms.net
Tue Nov 24 14:28:48 GMT 2009
The TIME_WAIT is not an active socket, it's the remnant of a previous
connection. I have no idea at all why mysqld has moved to 127.0.1.1.
Is the bind address config line set to the host name and is the host
name entry in /etc/hosts 127.0.1.1?
Unfortunately, I know very little about mysql, so I can't point you in
the right direction for configuration...
Regards,
Mark
Adam Hardy wrote:
> 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 at 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 at lists.thekelleys.org.uk
>>> http://lists.thekelleys.org.uk/mailman/listinfo/dnsmasq-discuss
>>>
>>>
>
>
> _______________________________________________
> Dnsmasq-discuss mailing list
> Dnsmasq-discuss at lists.thekelleys.org.uk
> http://lists.thekelleys.org.uk/mailman/listinfo/dnsmasq-discuss
>
More information about the Dnsmasq-discuss
mailing list