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 if ( @$argv[1] == 'yaseo' ) {
  14         $hosts = array(
  15                 'localhost',
  16                 '211.115.107.158',
  17                 '211.115.107.159',
  18                 '211.115.107.160',
  19                 '211.115.107.138',
  20                 '211.115.107.139',
  21                 '211.115.107.140',
  22                 '211.115.107.141',
  23                 '211.115.107.142',
  24                 '211.115.107.143',
  25                 '211.115.107.144',
  26                 '211.115.107.145',
  27                 '211.115.107.146',
  28                 '211.115.107.147',
  29                 '211.115.107.148',
  30                 '211.115.107.149',
  31                 '211.115.107.150',
  32                 '211.115.107.152',
  33                 '211.115.107.153',
  34                 '211.115.107.154',
  35                 '211.115.107.155',
  36                 '211.115.107.156',
  37                 '211.115.107.157',
  38         );
  39 } else {
  40         $hosts = array(
  41                 'localhost',
  42                 '207.142.131.194',
  43                 '207.142.131.195',
  44                 '207.142.131.196',
  45                 '207.142.131.197',
  46                 '207.142.131.198',
  47                 '207.142.131.199',
  48                 '207.142.131.221',
  49                 '207.142.131.226',
  50                 '207.142.131.227',
  51                 '207.142.131.228',
  52                 '207.142.131.229',
  53                 '207.142.131.230',
  54                 '207.142.131.231',
  55                 '207.142.131.232',
  56                 '207.142.131.233',
  57                 '207.142.131.234',
  58                 '207.142.131.237',
  59                 '207.142.131.238',
  60                 '207.142.131.239',
  61                 '207.142.131.243',
  62                 '207.142.131.244',
  63                 '207.142.131.249',
  64                 '207.142.131.250',
  65                 '207.142.131.216',
  66                 '10.0.%',
  67         );
  68 }
  69
  70 $databases = array(
  71         '%wikibooks',
  72         '%wiki',
  73         '%wikiquote',
  74         '%wiktionary',
  75         '%wikisource',
  76         '%wikinews',
  77         '%wikiversity',
  78         '%wikimedia',
  79 );
  80
  81 foreach( $hosts as $host ) {
  82         print "--\n-- $host\n--\n\n-- wikiuser\n\n";
  83         print "GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  84         print "GRANT ALL PRIVILEGES ON `boardvote`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  85         print "GRANT ALL PRIVILEGES ON `boardvote2005`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  86         foreach( $databases as $db ) {
  87                 print "GRANT SELECT, INSERT, UPDATE, DELETE ON `$db`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  88         }
  89
  90 /*
  91         print "\n-- wikisql\n\n";
  92         foreach ( $databases as $db ) {
  93 print <<<EOS
  94 GRANT SELECT ON `$db`.`old` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  95 GRANT SELECT ON `$db`.`imagelinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  96 GRANT SELECT ON `$db`.`image` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  97 GRANT SELECT ON `$db`.`watchlist` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  98 GRANT SELECT ON `$db`.`site_stats` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  99 GRANT SELECT ON `$db`.`archive` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 100 GRANT SELECT ON `$db`.`links` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 101 GRANT SELECT ON `$db`.`ipblocks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 102 GRANT SELECT ON `$db`.`cur` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 103 GRANT SELECT (user_rights, user_id, user_name, user_options) ON `$db`.`user` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 104 GRANT SELECT ON `$db`.`oldimage` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 105 GRANT SELECT ON `$db`.`recentchanges` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 106 GRANT SELECT ON `$db`.`math` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 107 GRANT SELECT ON `$db`.`brokenlinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 108
 109 EOS;
 110         }*/
 111
 112         print "\n-- wikiadmin\n\n";
 113         print "GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'wikiadmin'@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
 114         print "GRANT ALL PRIVILEGES ON `boardvote`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
 115         print "GRANT ALL PRIVILEGES ON `boardvote2005`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
 116         foreach ( $databases as $db ) {
 117                 print "GRANT ALL PRIVILEGES ON `$db`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
 118         }
 119         print "\n";
 120 }
 121 ?>