<?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.226'
- '207.142.131.227'
- '207.142.131.228'
- '207.142.131.229'
- '207.142.131.230'
- '207.142.131.231'
- '207.142.131.232'
- '207.142.131.233'
- '207.142.131.234'
- '207.142.131.237'
- '207.142.131.238'
- '207.142.131.239'
- '207.142.131.243'
- '207.142.131.244'
+ '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',
+ '207.142.131.229',
+ '207.142.131.230',
+ '207.142.131.231',
+ '207.142.131.232',
+ '207.142.131.233',
+ '207.142.131.234',
+ '207.142.131.237',
+ '207.142.131.238',
+ '207.142.131.239',
+ '207.142.131.243',
+ '207.142.131.244',
+ '207.142.131.249',
+ '207.142.131.250',
+
);
$databases = array(
'%wiki',
'%wikiquote',
'%wiktionary',
+ '%wikisource',
);
foreach( $hosts as $host ) {
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';
GRANT SELECT ON `$db`.`recentchanges` TO 'wikisql'@'$host' IDENTIFIED BY '$wikisql_pass';
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;
- }
+ }*/
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";
}
-
-