Re: [Savannah-hackers-public] mismatching licenses in list on Savannah

[Assaf Gordon]

Hello Karl and all,

I hope this is resolved now.

The file that is used is definitely this:
  frontend:/etc/savane/content/gnu-content/hashes.txt

perhaps accidentally the other file was modified ( 
/usr/src/savane/etc/site-specific-content/hashes.txt ),
as it doesn't contain 'gplv3orlater' anymore. That might have made restoration 
attempts trickier...
Luckily Bob just recently copied everything to 'frontend0', so I had a pristine 
copy that worked :)

For future experimentation and restoration:
  frontend:/etc/savane/content/gnu-content/hashes.frontend0.txt - a good copy 
of licenses, before adding 'apache2'.
  frontend:/etc/savane/content/gnu-content/apache2-2016-09-06.txt - same as 
above, with apache2 added.

  # diff -u -p0 hashes.frontend0.txt hashes.apache2-2016-09-06.txt 
  --- hashes.frontend0.txt      2016-09-07 03:13:22.701361951 +0000
  +++ hashes.apache2-2016-09-06.txt     2016-09-07 03:29:53.106036415 +0000
  @@ -38,0 +39 @@ $LICENSE['agpl'] = 'GNU Affero General P
  +$LICENSE['apache2'] = 'Apache License, Version 2.0';
  @@ -63,0 +65 @@ $LICENSE_URL['agpl'] = 'http://www.fsf.o
  +$LICENSE_URL['apache2'] = 'http://www.apache.org/licenses/LICENSE-2.0';


If there's a need to quickly revert to a list without apache2, the following 
should work:
  cd /etc/savane/content/gnu-content/
  cp hashes.frontend0.txt hashes.txt

As a side note to future admins, despite having '.txt' extension this is a PHP5 
file,
it must pass compilation, and (based on the comment in the file) must not 
generate any white space.
So the following must work and print nothing:
   php5 < /etc/savane/content/gnu-content/hashes.txt


Last but not least, Karl asked:
> assaf/bob/anyone: my impression is that the license is just stored as a string
> in the database, ie, there is no sql enum to be modified. confirm/deny?

I think this is indeed the case.
The database contains:
====
mysql> select license,count(*) from groups group by license ;
+---------------+----------+
| license       | count(*) |
+---------------+----------+
| NULL          |        2 |
| affero        |       11 |
| agpl          |       62 |
| cartistic     |        3 |
| classpath     |        6 |
| dual-gpl      |        7 |
| expat         |       24 |
| fdl           |      103 |
| gpl           |     2421 |
| gplv3orlater  |      751 |
| lgpl          |      271 |
| mbsd          |       96 |
| none          |        1 |
| other         |      128 |
| perl          |        9 |
| public domain |       14 |
| python2       |        1 |
| website       |       66 |
| x11           |       19 |
| zlib          |        6 |
+---------------+----------+
20 rows in set (0.03 sec)
=====

And these values are keys in the PHP file 'hashes.txt'.



regards,
 - assaf