Link to home
Start Free TrialLog in
Avatar of wayneray
waynerayFlag for United States of America

asked on

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
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

where is the mysql database server located? using the mysql manager can you access the mysql database?
Avatar of wayneray

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of matrix8086
matrix8086
Flag of Romania image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The problem was I had to whitelist my network ip and website ip  in order to make the connection.