oldimage table:

[lhc/web/wiklou.git] / maintenance / ourusers.php

diff --git a/maintenance/ourusers.php b/maintenance/ourusers.php
index 4d543fe..37b1abb 100644 (file)
--- a/maintenance/ourusers.php
+++ b/maintenance/ourusers.php
@@ -1,10 +1,23 @@
 <?php
+/**
+ * @todo document
+ * @package MediaWiki
+ * @subpackage Maintenance
+ */
+
+/** */
 $wikiuser_pass = `wikiuser_pass`;
 $wikiadmin_pass = `wikiadmin_pass`;
 $wikisql_pass = `wikisql_pass`;
 
 $hosts = array( 
        'localhost',
+       '207.142.131.194',
+       '207.142.131.195',
+       '207.142.131.196',
+       '207.142.131.197',
+       '207.142.131.198',
+       '207.142.131.199',
        '207.142.131.226',
        '207.142.131.227',
        '207.142.131.228',
@@ -18,7 +31,11 @@ $hosts = array(
        '207.142.131.238',
        '207.142.131.239',
        '207.142.131.243',
-       '207.142.131.244'
+       '207.142.131.244',
+       '207.142.131.249',
+       '207.142.131.250',
+       '207.142.131.216',
+       '10.0.%',
 );
 
 $databases = array(
@@ -26,18 +43,24 @@ $databases = array(
        '%wiki',
        '%wikiquote',
        '%wiktionary',
+       '%wikisource',
+       '%wikinews',
+       '%wikiversity',
+       '%wikimedia',
 );
 
 foreach( $hosts as $host ) {
        print "--\n-- $host\n--\n\n-- wikiuser\n\n";
-       print "GRANT REPLICATION CLIENT ON *.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
+       print "GRANT REPLICATION CLIENT,PROCESS ON *.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
        print "GRANT ALL PRIVILEGES ON `boardvote`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
        foreach( $databases as $db ) {
                print "GRANT SELECT, INSERT, UPDATE, DELETE ON `$db`.* TO 'wikiuser'@'$host' IDENTIFIED BY '$wikiuser_pass';\n";
        }
+       
+/*
        print "\n-- wikisql\n\n";
        foreach ( $databases as $db ) {
-/*print <<<EOS
+print <<<EOS
 GRANT SELECT ON `$db`.`old` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 GRANT SELECT ON `$db`.`imagelinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 GRANT SELECT ON `$db`.`image` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
@@ -53,16 +76,14 @@ GRANT SELECT ON `$db`.`recentchanges` TO 'wikisql'@'$host' IDENTIFIED BY '$wikis
 GRANT SELECT ON `$db`.`math` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 GRANT SELECT ON `$db`.`brokenlinks` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
 
-EOS;*/
-       }
+EOS;
+       }*/
        
        print "\n-- wikiadmin\n\n";
        print "GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'wikiadmin'@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
-       print "GRANT ALL PRIVILEGES ON 'boardvote'.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
+       print "GRANT ALL PRIVILEGES ON `boardvote`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
        foreach ( $databases as $db ) {
-               print "GRANT ALL PRIVILEGES ON '$db'.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
+               print "GRANT ALL PRIVILEGES ON `$db`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n";
        }
        print "\n";
 }
-
-