View Full Version : Computer help
My site moved servers yesterday - bigger & better lets say :)
Now I've changed the DNS IPs and that has been picked up by the domain register etc etc.
BUT when I try and access the backend DB to check for new orders/users/updated my products etc it's taking me to the old one:smt012 Which means for example that I cannot see the latest orders that have just been placed!!
I've deleted my cookies from Firefox - cleared the private data etc and it's still the same :( Did CTRL+F5 and still nothing.....
Any ideas?
Thnx
fizzwheel
16-07-08, 08:00 AM
have you flushed the local DNS cache on your desktop PC ? It might be that.
get into a DOS prompt and type
ipconfig /flushdns
Sometimes it takes a little time for the DNS changes to work its way around a network...
My site moved servers yesterday - bigger & better lets say :)
Now I've changed the DNS IPs and that has been picked up by the domain register etc etc.
Has the DNS propogated? What's the DNS name (don't bother with the full URL, just the DNS name is sufficient)?
I assume you're still running the old system on the old static IP, and the new one is on a new IP, you're just editing the DNS spec?
well I updated the DNS IPs on 123-reg yesterday. email works fine
ping my url without the www and that should be the DNS
yes I guess the kn0b host has kept the old system still online on the old server and yes the new servers have new IPs
Al_Sweetman
16-07-08, 08:18 AM
Is it server access from Client PC, or from Server? If server, are you sure that there's no hard-wired IP addr present in some configuration file somewhere? If it's driven by machine name, are there static routes setup in the hosting file etc? What are the server routes configured to be?...
What type of DB is it? Oracle/AS-400 DB2/M$ SQL/Postgres etc??
Al - I'm accessing from my home PC as usual
DB is probably MS SQL but not sure as I don't see that side of things
I'm the end user working from a nice GUI :)
OK, DNS appears to check out, but I don't know if it's the old or the new system.
I can see on that domain name you're running web & mail services, although naughtily your mail server doesn't respond with the same host name (pogdesign?).
Your web server IP ends with 94.84, and the mail server is on a completely seperate IP segment, but ends with 122.150. Do these IPs sound right with what you have configured?
What's the DNS name of the DB and I'll help verify what the IP of that is if you like (PM details if you feel safer).
yes the IPs are correct! all apart from the mail should be on the 94.84 address
Got your PM mate, but figured it'd be easier to keep things public (knowledge pooling etc).
OK, so the DB is accessed by web interface on the same DNS name. I've seen that pogdesign (the mail server) also looks after the DB, and all of this is actually stored within your webserver, and isn't redirected elsewhere (at least, as far as I can visibly see).
Without knowing the configuration at pogdesign it's a little hard to get indepth.
One thing that's just occured to me, is that you are logging into the DB from the website, not directly from your PC. Assuming that you're using MySQL, each DB (well, table technically) has access rights for user@location. If your location has changed because of the change of DNS, this may be the reason you're not accessing the DB you think you should be.
Chase it up with pogdesign & see what they say. The only other alternative would be to login, change your password, then PM me the details, and change your password back after I'd looked at the config in there. Understandly though, most folks don't trust random strangers on the t'inter-web. :lol:
timwilky
16-07-08, 08:54 AM
err have you got a local host file entry. connection strings using ip rather than dns names etc
Al_Sweetman
16-07-08, 08:57 AM
OOh apple-orgies I hadn't realised it was relating to your website - hadn't thought about third party hosting etc. I'd assumed it was all done as an end-to-end enterprise app from your local (e.g. company).
Will bow out now :-)
Good luck!
Al.
err have you got a local host file entry. connection strings using ip rather than dns names etc
N/A in this situation as far as I can see Tim.
Everything is conducted via the URL in 600+'s signature. The DB portal is effectively a folder within this.
My interpretation is that he logs in there, and sees the old DB, whereas he should see the new DB.
Al_Sweetman
16-07-08, 09:04 AM
N/A in this situation as far as I can see Tim.
Everything is conducted via the URL in 600+'s signature. The DB portal is effectively a folder within this.
My interpretation is that he logs in there, and sees the old DB, whereas he should see the new DB.
True, but if it's done by name rather than IP, then the hosts or other config file could still play a part as the web application will still need some kind of configuration settings specifying the datasource to use - if it's via some kind of JDBC driver interface then these need explicit connection information specifying...
The redirection to the DB and query accessibility (assuming it's not all hardcoded into the web pages :smt021) is the job of form handlers talking to other parts of the system responsible for DB access - so yes your interpretation is correct (e.g. he logs in, and should be taken to the new database) but I suspect someone's not updated config somewhere.
Either way, it definitely seems like a problem with the hosting company.
timwilky
16-07-08, 09:29 AM
Could then be down to the MySQL config as you say.
Whilst the location part is a nice touch. I never use it as the few time I have been forced to use MySQL, I have had DHCP with stupid leases. Also I found I became reliant on myisamchk to maintain database integrity so where possible I stick to Oracle
Without knowing the configuration at pogdesign it's a little hard to get indepth.
Chase it up with pogdesign & see what they say.
yes your interpretation is correct (e.g. he logs in, and should be taken to the new database) but I suspect someone's not updated config somewhere.
Either way, it definitely seems like a problem with the hosting company.
Nice to see we agree, in a geek explanitory kind of way. ;)
Could then be down to the MySQL config as you say.
Whilst the location part is a nice touch. I never use it as the few time I have been forced to use MySQL, I have had DHCP with stupid leases. Also I found I became reliant on myisamchk to maintain database integrity so where possible I stick to Oracle
Tim, the location part can accept wildcards, and will happily accept domain names instead of IPs. There's nothing to stop you using the location spec on DHCP. ;)
But yea, I too stick to Oracle where possible.
hmmm OK cheers folks!
I'll speak to POG and see if they can finally sort me out with a 100% working site
vBulletin® , Copyright ©2000-2025, Jelsoft Enterprises Ltd.