www-infrastructure-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gavin (JIRA)" <j...@apache.org>
Subject [jira] Commented: (INFRA-1698) Need environment for hosting ASF list statistics package
Date Thu, 17 Sep 2009 12:24:57 GMT

    [ https://issues.apache.org/jira/browse/INFRA-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12756507#action_12756507
] 

Gavin commented on INFRA-1698:
------------------------------

Ken, ping, can you confirm you can get into phobia ok, (your keys are installed), and can
you let us know if you need anything else before closing the issue?

Thanks


> 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
>            Assignee: Tony Stevenson
>
> 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