[jira] Commented: (INFRA-1698) Need environment for hosting ASF list statistics package

["Gavin (JIRA)" <ji...@apache.org>]

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

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

Ken, I've added you as a watcher, hopefully you'll get to know your VM for stats has been completed.
Tony should have sent you access details, please ping us again if any problems getting in.

Thanks

Gav...

> 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.