maintenance/ourusers.php

   1 <?php
   2 $wikiuser_pass = `wikiuser_pass`;
   3 $wikiadmin_pass = `wikiadmin_pass`;
   4 $wikisql_pass = `wikisql_pass`;
   5
   6 $hosts = array(
   7         'localhost',
   8         '207.142.131.226',
   9         '207.142.131.227',
  10         '207.142.131.228',
  11         '207.142.131.229',
  12         '207.142.131.230',
  13         '207.142.131.231',
  14         '207.142.131.232',
  15         '207.142.131.233',
  16         '207.142.131.234',
  17         '207.142.131.237',
  18         '207.142.131.238',
  19         '207.142.131.239',
  20         '207.142.131.243',
  21         '207.142.131.244'
  22 );
  23
  24 $databases = array(
  25         '%wikibooks',
  26         '%wiki',
  27         '%wikiquote',
  28         '%wiktionary',
  29 );
  30
  31 foreach( $hosts as $host ) {
  32         print "--\n-- $host\n--\n\n-- wikiuser\n\n";
  33         print "GRANT REPLICATION CLIENT ON *.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  34         print "GRANT ALL PRIVILEGES ON `boardvote`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  35         foreach( $databases as $db ) {
  36                 print "GRANT SELECT, INSERT, UPDATE, DELETE ON `$db`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
  37         }
  38         print "\n-- wikisql\n\n";
  39         foreach ( $databases as $db ) {
  40 /*print <<<EOS
  41 GRANT SELECT ON `$db`.`old` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  42 GRANT SELECT ON `$db`.`imagelinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  43 GRANT SELECT ON `$db`.`image` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  44 GRANT SELECT ON `$db`.`watchlist` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  45 GRANT SELECT ON `$db`.`site_stats` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  46 GRANT SELECT ON `$db`.`archive` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  47 GRANT SELECT ON `$db`.`links` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  48 GRANT SELECT ON `$db`.`ipblocks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  49 GRANT SELECT ON `$db`.`cur` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  50 GRANT SELECT (user_rights, user_id, user_name, user_options) ON `$db`.`user` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  51 GRANT SELECT ON `$db`.`oldimage` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  52 GRANT SELECT ON `$db`.`recentchanges` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  53 GRANT SELECT ON `$db`.`math` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  54 GRANT SELECT ON `$db`.`brokenlinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
  55
  56 EOS;*/
  57         }
  58
  59         print "\n-- wikiadmin\n\n";
  60         print "GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'wikiadmin'@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
  61         print "GRANT ALL PRIVILEGES ON 'boardvote'.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
  62         foreach ( $databases as $db ) {
  63                 print "GRANT ALL PRIVILEGES ON '$db'.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
  64         }
  65         print "\n";
  66 }
  67
  68