The international store is unavailable

RESOLVED FIXED

Status

Websites
store.mozilla.org
--
blocker
RESOLVED FIXED
11 years ago
11 years ago

People

(Reporter: clouserw, Assigned: John Slater)

Tracking

Details

(Reporter)

Description

11 years ago
http://intlstore.mozilla.org/ is only printing this and exiting:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/stot/public_html/includes/functions/database.php on line 19
Unable to connect to database server!

Not sure who is running that site, so hopefully someone else knows. :)
Assignee: server-ops → marcia
Severity: critical → blocker
Component: Server Operations → Mozilla Store
QA Contact: justin → marcia
I'll start calling people if I don't see any activity on the bug in the next 20 minutes or so.  In the meantime I'm going to see if I can come up with a status page that we can put up somewhere and change DNS to point at if you can't get ahold of anyone at the store vendor to fix it.  It's been this way for at least the last half hour.
We actually have a maintenance page for the store already with the cavendish-style Mozilla banners on it, but it seems tuned to the US store at the moment.  Here's the text currently on it:

  <h2>The Mozilla Store has been closed for maintenance</h2>
  <p>
    If you need assistance with store purchases, you can contact our
    customer care hotline -- <b> for sales issues only</b>
    you may call 1-888-738-4300 (8am to 7pm CST) within the US and Canada, or email
    <a href="mailto:customercare@store.mozilla.org">customercare@store.mozilla.org</a>.
  </p>
  <p>
    For technical support with Mozilla products, please visit
    <a href="http://www.mozilla.org/support/">www.mozilla.org/support</a>.
  </p>
  <p>
    The Mozilla Team
  </p>


Do we have alternate text that would be more appropriate for the international store that I can drop in there? (if we need the maintenance page anyway - if you get the site fixed it's irrelevant, or maybe it'd be good to have for next time anyway)
Left voicemail for both marcia and cbeard.  Talked to timr, who isn't near a computer to look anything up right now, and thinks marcia or cbeard would be better people to talk to anyway.  Not sure who else to call, so guess I'm just waiting for callbacks now.
(In reply to comment #1)
> It's been this way for at least the last half hour.

Er, guess I didn't realize how old this bug was when I said that (someone mentioned it on IRC and that's the time I used).  Looks like it's been 4 hours.
(Reporter)

Comment 5

11 years ago
(In reply to comment #4)
> (In reply to comment #1)
> > It's been this way for at least the last half hour.
> 
> Er, guess I didn't realize how old this bug was when I said that (someone
> mentioned it on IRC and that's the time I used).  Looks like it's been 4 hours.
> 

Pascal mentioned it to me on IRC before I filed this bug.  Neither of us knew how long it had been down.  Is this something we can add to nagios once this is resolved?

Comment 6

11 years ago
There is a "closed for maintenance" message live now.
OK, DNS has been pointed at one of our clusters with a maintenance page answering to that URL.  I just took out the contact info paragraph since that seemed pretty specific to the US store.

cbeard emailed the store contact about 40 minutes ago.
(In reply to comment #5)
> Is this something we can add to nagios once this is resolved?

I actually tried that shortly after we found out it was down...  and the scripts that generate our nagios configs choke on the fact that the site's reverse-DNS doesn't resolve (when adding a website to check, it looks up the site, and tries to add a service check for each IP address found, but uses the domain name it gets from the reverse-lookup for the hostname, which in this case, didn't exist)

intlstore.mozilla.org has address 63.245.209.11
217.206.13.85.in-addr.arpa domain name pointer 85.13.206.217.reverse.coreix.net.
Host 85.13.206.217.reverse.coreix.net not found: 3(NXDOMAIN)
I suppose it helps if I had copied a forward lookup from before I made the DNS changes :)  But the reverse I pasted was the correct one.
I found a way around the host lookups in the generator scripts, nagios checks for the international store are now in place.

Something else interesting detected by nagios: their SSL certificate expired back in December.  I'm amazed nobody's complained about that yet.
The store is back online.
Status: NEW → RESOLVED
Last Resolved: 11 years ago
Resolution: --- → FIXED
Assignee: marcia → jslater
Component: Mozilla Store → store.mozilla.org
Product: mozilla.org → Websites
QA Contact: marcia → store-mozilla-org
Version: other → unspecified
You need to log in before you can comment on or make changes to this bug.