Server Error after changing public ip

I recently changed the public ip pointing to my webserver. Since the change, I cannot connect to my remote MySQL database. The new ip is whitelisted on the host provider's server where the database resides. DNS resolves properly. The error I get is (500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed.)

I can ping the database server. Both my host provider and my firewall management says neither of them believe the problem is on their end. Pages not requiring a database connection work fine. Do I have to make changes in IIS? Any help would be appreciated. The web address is www.panama.k12.ok.us
waynerayAsked:
Who is Participating?
 
matrix8086Commented:
Hi,

I had the same problem and I know the cause: the initialization of database connection and or the initialization of the paths of webpages. Check there in the configuration files of the website and search  for the old IP address.

I am guessing that the developer did not use the name of the server, but the IP.

Also, check in IIS if the site is not configured to listen on the old IP address

Best regards!
0
 
David Johnson, CD, MVPOwnerCommented:
where is the mysql database server located? using the mysql manager can you access the mysql database?
0
 
waynerayAuthor Commented:
The website is on my school network. The database is located at my account webhostinghub.com. My host provider (webhostinghub.com allows remote connections. I have to whitelist my school domain to make the connection. The connection worked fine until today. I did whitelist the new public ip. I can also ping the mysql host from the web server. Can I use the mysql manager on a remote database?
0
 
waynerayAuthor Commented:
The problem was I had to whitelist my network ip and website ip  in order to make the connection.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.