Can someone please look at mysql

[phppete]

MySQL Error: Unknown MySQL Server Host 'mysql.needhambasketball.com'

15 minutes downtime so far, the site relies on mysql to function.

My inbox is also filling up with error emails :grr:

Thanks

[Melissa]

Thank you for bringing this to our attention (we received your Service Desk ticket as well). We were doing some internal work that was not expected to negatively affect any services. Needless to say, there was a bug that we didn't anticipate. Our sincerest apologies for interruption. The techs are working on the issue as I type this.

[phppete]

Hi Melissa,

Thanks for letting me know, it is my clients site and she is in Argentina this week so I didn't want it just leave it. Now I know you are dealing with it I'll leave you in peace :)

Thanks

Pete

[phppete]

I see its now fixed, thanks :)

[Bruce]

This was caused by a bug in the DNS database export routines that has now been corrected. All DNS data has been rebuilt and the caches have been flushed to ensure correct operation.

Long story: I have been doing some internal modifications to the database used to support our DNS operations. Today I was rewriting how IP addresses for servers are handled, reorganizing the data for more efficient operations. Internally, the IPs are stored as straight integers (since IP addresses are really just 32-bit numbers). Externally, of course, they have to be output in standard 4-number IP notation. The most obvious places that required a conversion were handled and tested a couple of times before the new mechanism was put into place. Unfortunately, there were other conversions that were missed which affected (among other things) the mysql.example.com DNS entries. The IP conversion process has now been rewritten to happen much earlier, avoiding the need to convert in multiple places later.

My apologies again for this interruption. All services should be operational at this time.

[phppete]

Hi Bruce,

Thanks for the info, no worries :smile: Given the error message I should have thought to switch the config file to the IP address instead of the domain, thinking about that now is a little too late but I'll keep it in mind if anything similar happens again. :smile: