maintenance/ourusers.php

   1 <?php
   2 /**
   3  * @todo document
   4  * @package MediaWiki
   5  * @subpackage Maintenance
   6  */
   7
   8 /** */
   9 $wikiuser_pass = `wikiuser_pass`;
  10 $wikiadmin_pass = `wikiadmin_pass`;
  11 $wikisql_pass = `wikisql_pass`;
  12
  13 $hosts = array(
  14         'localhost',
  15         '207.142.131.194',
  16         '207.142.131.195',
  17         '207.142.131.196',
  18         '207.142.131.197',
  19         '207.142.131.198',
  20         '207.142.131.199',
  21         '207.142.131.226',
  22         '207.142.131.227',
  23         '207.142.131.228',
  24         '207.142.131.229',
  25         '207.142.131.230',
  26         '207.142.131.231',
  27         '207.142.131.232',
  28         '207.142.131.233',
  29         '207.142.131.234',
  30         '207.142.131.237',
  31         '207.142.131.238',
  32         '207.142.131.239',
  33         '207.142.131.243',
  34         '207.142.131.244',
  35         '207.142.131.249',
  36         '207.142.131.250',
  37         '207.142.131.216',
  38         '10.0.%',
  39 );
  40
  41 $databases = array(
  42         '%wikibooks',
  43         '%wiki',
  44         '%wikiquote',
  45         '%wiktionary',
  46         '%wikisource',
  47         '%wikinews',
  48         '%wikiversity',
  49         '%wikimedia',
  50 );
  51
  52 foreach( $hosts as $host ) {
  53         print "--\n-- $host\n--\n\n-- wikiuser\n\n";
  54         print "GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  55         print "GRANT ALL PRIVILEGES ON `boardvote`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  56         foreach( $databases as $db ) {
  57                 print "GRANT SELECT, INSERT, UPDATE, DELETE ON `$db`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  58         }
  59
  60 /*
  61         print "\n-- wikisql\n\n";
  62         foreach ( $databases as $db ) {
  63 print <<<EOS
  64 GRANT SELECT ON `$db`.`old` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  65 GRANT SELECT ON `$db`.`imagelinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  66 GRANT SELECT ON `$db`.`image` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  67 GRANT SELECT ON `$db`.`watchlist` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  68 GRANT SELECT ON `$db`.`site_stats` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  69 GRANT SELECT ON `$db`.`archive` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  70 GRANT SELECT ON `$db`.`links` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  71 GRANT SELECT ON `$db`.`ipblocks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  72 GRANT SELECT ON `$db`.`cur` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  73 GRANT SELECT (user_rights, user_id, user_name, user_options) ON `$db`.`user` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  74 GRANT SELECT ON `$db`.`oldimage` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  75 GRANT SELECT ON `$db`.`recentchanges` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  76 GRANT SELECT ON `$db`.`math` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  77 GRANT SELECT ON `$db`.`brokenlinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  78
  79 EOS;
  80         }*/
  81
  82         print "\n-- wikiadmin\n\n";
  83         print "GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'wikiadmin'@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
  84         print "GRANT ALL PRIVILEGES ON `boardvote`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
  85         foreach ( $databases as $db ) {
  86                 print "GRANT ALL PRIVILEGES ON `$db`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
  87         }
  88         print "\n";
  89 }