Re: [Savannah-hackers-public] Refreshing /cooperation/groups.tsv

[Bob Proulx]

Sylvain wrote:
> There is a list of GNU projects exported to a flat file on a regular
> basis, and it was used by planet.gnu.org to auto-subscribe their project
> News feed.
> I see it's still available at http://savannah.gnu.org/cooperation/groups.tsv
> but it's Last-Modified "Wed, 27 Jul 2016 06:25:12 GMT" :/

That must have been one of the things that wasn't known and wasn't
found and didn't have a test for so didn't get migrated.  :-(

> (I also see there was some work in 2015 to export it in .json and such,
> I don't know about that).

There seems to be this.  I don't know anything about any of it.

  http://savannah.gnu.org/cooperation/v0/index.md

> Could you re-enable the regular export again?
> 
> For reference the cron job I had setup was:
> mysql savane -h 10.1.0.101 -B -e 'SELECT group_type.type_id,
> group_type.name, unix_group_name, group_name FROM groups, group_type
> WHERE groups.type = group_type.type_id AND groups.status="A" ORDER BY
> type;' > /var/www/overlay/cooperation/groups.tsv

I have created a somewhat more extensive implementation to do this on
frontend0.  If we ever get multiple frontends then this should be done
in a shared storage area.  But for now the single frontend0 can
produce it.

  /etc/cron.hourly/planet-news-list

I have written a test to check that this feature exists and is working
and added it to the savannah-test test suite.

  
http://git.savannah.gnu.org/cgit/administration/savannah-tests.git/commit/?id=540c3ded3c2920e171a46978465e37e661abc196

I added a frontend0:/var/www/overlay/cooperation/README.txt file
saying a few words about the file for future notes.

It should be up and running now.

Bob