www-infrastructure-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rodent of Unusual Size (JIRA)" <j...@apache.org>
Subject [jira] Created: (INFRA-1698) Need environment for hosting ASF list statistics package
Date Fri, 01 Aug 2008 18:00:31 GMT
Need environment for hosting ASF list statistics package
--------------------------------------------------------

                 Key: INFRA-1698
                 URL: https://issues.apache.org/jira/browse/INFRA-1698
             Project: Infrastructure
          Issue Type: New Feature
      Security Level: public (Regular issues)
          Components: Infra Wishlist, Mailing Lists, Zones
         Environment: MySQL 5 database (~160MiB), Perl, PHP installed (for scripts, not Web
server), eddress to which data can be sent; eddress to which queries can be sent
            Reporter: Rodent of Unusual Size


For the last several years, the ASF mailing list statistics have been hosted by my own servers.
 The package needs to move to the ASF infrastructure.

Here is how it currently works (three separate pieces):

1. Nightly, on mail.apache.org, a cron job runs under user apmail.  The job collects info
from the mailing lists, formats it as XML, and sends it to an email receiver on my system.
2. The receiver on my system grovels over the data and loads them into a MySQL database.

1. Nightly, on my system, a cron job runs that generates the pages and files that comprise
the display seen at http://people.apache.org/~coar/mlists
2. Nightly (well, in the early morning), a cron job runs on people.apache.org and fetches
the files from my system to my people.a.o directory.

1. On demand, queries can be sent to an eddress on my system.  The listener processes the
queries against the database and sends back a response.

To do all this, the following is needed:

o A MySQL database (with admin access granted as appropriate; for now, just to me)
o Perl
o bash
o PHP with certain features (for generating the charts, etc.).  Note that PHP is *not* used
in connexion with the Web server, so mod_php is not needed.
o An eddress to which queries can be sent, backed by a Perl listener which has access to the
database.
o Some means of getting the raw data from mail.a.o to the data-munging system (currently done
via email).
o A means of getting the formatted data to the Web page where it will be displayed (if it
moves from my personal people.a.o account)

Let me know if more info is needed.  This request has been pending for several months.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message