Re: FN-FORUM: Testing Server Crashed

date posted 24th November 2005 17:38

The router is giving your PC a DHCP address. If you have a NIC, the IP
address is associated with the computer's name - it is always *also*
localhost and 127.0.0.1. That's how TCP/IP and netbios over TCP/IP works.
127.0.0.1 is a special "fake" ip address called the loopback address used
for testing etc. It exists if TCP/IP is installed even if there is no
physical network card.

I don't use DW and I've always had a network, so I know that I have be
consistent and refer EITHER to localhost/127.0.0.1 OR to pcname/IP address.
Typing http://localhost should always work.

I suspect it just takes time for mySQL and DW to "notice" the change. Your
internal DNS resolver cache may have had the wrong address - it's often
worth typing ipconfig /flushhdns at a command prompt.

Anyway, as long as it works! If it's a server, it might be happier with a
static IP address unless your router allows you to make DHCP reservations
based on MAC address (identity number of network card)

I'd avoid turning the router off and on as well, so that environment stays
the same.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kathy
http://www.vendetta.co.uk
+44(0)7005 982 261
DNRC Minister for Useful but Irritating Information and Trivia
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

----- Original Message -----
From: [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, November 24, 2005 2:37 PM
Subject: Re: FN-FORUM: Testing Server Crashed


>
> Hello Kathy,
>
> Your right I had the same router but connect via a powered USB hub. I have
> now installed a Ethernet card, and use this only for my broadband
> connection.
>
> The MySQL sever is on my box, not the hosting companies. If I turn the
> router off, the MySQL server shows: david 127.0.0.1 as being localhost,
when
> I turn the router on, this changes to 192.168.1.4, still showing david
> [boxes name].
>
> The problem I had was, I couldn't get DW to display any files via IE, nor
> connect to the MySQL server. All my sites files are in DW which uses
> localhost to connect to my testing server, and they all stopped working.
>
> I've now got them working again, the problem is I don't know HOW!, so if
> this occurs again I have no idea how to resolve it.
>
> I altered some connection criteria in DW , but have put them all back, and
> it still works. The only I thing I did do differently was turn off the
> router, so not sure if that alone could have sorted it. But the actual IP
> shown in MySQL does change, depending whether the router is on or not.
>
> I tried binding address my.ini to 127.0.0.1, and checked HOST in
C:\windows,
> which shows localhost as being 127.0.0.1. So have no idea what the problem
> was?
>
> DG)
> ----- Original Message -----
> From: "Lists" [EMAIL REMOVED]
> To: [EMAIL REMOVED]
> Sent: Thursday, November 24, 2005 12:30 PM
> Subject: Re: FN-FORUM: Testing Server Crashed
>
>
> >
> > Try explaining that again.
> >
> > As I understand it, you had a USB modem. Now you have a router and a NIC
> in
> > the PC.
> >
> > If the PC has a NIC, it will have TWO ip addresses (sort of) - 127.0.0.1
> > (which is ALWAYS localhost - the PC itself) and something else (eg
> > 192.168.0.3). This should NOT be the same as the router or the default
> > gateway. If you have more than one PC, and have ICS enabled, there are
> other
> > considerations. Please post the result of ipconfig /all on all PCs you
> have
> > and state which one the SQL server is on.
> >
> > You could try just referring to the PC consistently either by the same
ip
> > address every time(either) or by name or as localhost.
> >
> > All my IIS/MSDE installations work as PCNAME, IP address or localhost.
If
> > you mix, you'll find that localhost=127.0.0.1 and PCNAME=real IP
address.
> > That's how it works.
> >
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Kathy
> > http://www.vendetta.co.uk
> > +44(0)7005 982 261
> > DNRC Minister for Useful but Irritating Information and Trivia
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > ----- Original Message -----
> > From: [EMAIL REMOVED]
> > To: [EMAIL REMOVED]
> > Sent: Tuesday, November 22, 2005 1:59 PM
> > Subject: FN-FORUM: Testing Server Crashed
> >
> >
> > >
> > > Hello,
> > >
> > > Just moved my router from powered USB, to Ethernet board. Now all of
my
> > > testing server has crashed, this consists of:
> > >
> > > Apache2
> > > php4
> > > Perl5 and
> > > MySQL 4.1 beta.
> > >
> > > I think the MySQL server gives a hint as to why, but how to repair
it...
> > >
> > > MySql server has suddenly acquired a new IP address, whereas before it
> was
> > > Local Host: 127.0.0.1 DAVID,
> > > Now it's the same as the router gateway.
> > >
> > > How can I get my box back to 127.0.0.1 and using the box's name...
> > >
> > > DG)
> > >
> > >
> > > --
> > > Freelancers, contractors earn more with Prosperity4
> > > Call 0870 870 4414 or visit www.prosperity4.com
> > > and benefit from Inland Revenue approved expenses today.
> > >
> > > To advertise here: http://www.freelancers.net/advertising.html
> > >
> > >
> > --
> > Freelancers, contractors earn more with Prosperity4
> > Call 0870 870 4414 or visit www.prosperity4.com
> > and benefit from Inland Revenue approved expenses today.
> >
> > To advertise here: http://www.freelancers.net/advertising.html
> >
> >
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>