Closed Bug 530751 Opened 16 years ago Closed 16 years ago

http://download.mozilla.org/rss/download-counts.php is broken

Categories

(Webtools :: Bouncer, defect)

Product:
Webtools
Component:
Bouncer
Type:
defect
Priority:
Not set
Severity:
critical

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: sipaq, Assigned: justdave)

References

(
URL
)

Details

(Keywords: regression)

Attachments

(1 file)

Patch v1 for production branch
672 bytes, patch
Details | Diff | Splinter Review
As per bug 464778 comment 23, bouncer logging on has been disabled since November 4th (20 days ago). Can this please be re-enabled?
Assignee: morgamic → server-ops
Component: Bouncer → Server Operations
Product: Webtools → mozilla.org
QA Contact: bouncer → mrz
Version: Trunk → other
Severity: major → critical
Assignee: server-ops → jeremy.orem+bugs
Looks like someone already got to this.
Status: NEW → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Chizu enabled it at 7:39am on November 11th. It's been on since then.
Resolution: FIXED → INVALID
Per bug 464778 comment 27 and 28, the feed reporting these numbers to the public is what's actually broken. Most likely cause: MySQL permission changes that were made when the bouncer administration interface was moved behind the VPN.
Assignee: jeremy.orem+bugs → justdave
Status: RESOLVED → REOPENED
Keywords: regression
Resolution: INVALID → ---
Summary: Re-enable bouncer download logging on http://download.mozilla.org/ → http://download.mozilla.org/rss/download-counts.php is broken
OK, root cause: the rss feed is trying to connect to the master database. The download.m.o web cluster has access to the master database completely revoked except for updates to the counts. It's supposed to be using the slaves for all read activities (and that's all it has permission to do).
Assignee: justdave → morgamic
URL: http://download.mozilla.org/rss/downl...
Component: Server Operations → Bouncer
Product: mozilla.org → Webtools
QA Contact: mrz → bouncer
Target Milestone: --- → 1.0
Version: other → 1.0
This patch is live in production already and does indeed fix the problem.
Assignee: morgamic → justdave
Status: REOPENED → NEW
ok, that gets the feed working again, but the numbers it's reporting don't look right... still poking...
Depends on: 506403
ok, mysql permissions were too restrictive for logging to work anyway, so we indeed have had no logging since the 4th :( See bug 506403 comment 14 for details. I've filed bug 530993 to see if we can recover the missing stats.
Sending php/rss/download-counts.php Transmitting file data . Committed revision 56831.
Status: NEW → RESOLVED
Closed: 16 years ago → 16 years ago
Resolution: --- → FIXED
Nice! Thanks!
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: