From owner-freebsd-questions Sun May 5 0:35:36 2002 Delivered-To: freebsd-questions@freebsd.org Received: from spitfire.velocet.net (spitfire.velocet.net [216.138.223.227]) by hub.freebsd.org (Postfix) with ESMTP id 3A5CA37B41A for ; Sun, 5 May 2002 00:35:32 -0700 (PDT) Received: from wenk (H204.C233.tor.velocet.net [216.138.233.204]) by spitfire.velocet.net (Postfix) with SMTP id 68634FB45D7; Sun, 5 May 2002 03:35:30 -0400 (EDT) Message-ID: <001601c1f421$0ff6b890$b300a8c0@wenk> From: "Jeff Shevlen" To: Cc: References: <000901c1f414$36f6ed00$b300a8c0@wenk> <200205050651.g456pQI07020@pen.homeip.net> Subject: Re: mysql & ISP hostname Date: Sun, 5 May 2002 03:38:56 -0700 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG > On Sunday 05 May 2002 01:06 am, Jeff Shevlen wrote: > > I don't know how MySQL manages it's networking, but is there a way to > > change this behavior? Is there maybe some way to have MySQL do a DNS > > lookup (or use /etc/hosts somehow...) so I don't have to use the ISP's > > assigned name? > > If you have a static why would your isp assign your host name? > Are you still required to use dhcp? (I've know a few ISPs that > require everyone to use dhcp, and just make a table entry for > static ips by mac address). > > If using dhcp, set the option that does NOT request a host > name from your isp and just set your own. > I have no idea how my ISP has things set up. But no, my ISP isn't using dhcp somehow. I have double-checked the logs and there is no dhcp transaction when I come up on the network. The name that MySQL indicated I use ("xxx.xxx.my.isp.net") is an alias under somebody's network. Nslookup confirms that this address is aliasing to my IP; but also, and I don't know if this is relevant, nslookup seems to be getting this response from my ISP's ISP. I assume that there is some way to rig MySQL so it asks the right question, to the right name server, but I don't know how this is done. For the record, I have a few websites, a mail server, and a name server, all doing what they do based on the one static IP. This is the first time I've ever come accross "xxx.xxx.my.isp.net". To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message