From 49a6511f363094e5a1050fbca1daf7d40fd3df77 Mon Sep 17 00:00:00 2001 From: Tim Starling Date: Fri, 24 Oct 2008 15:17:57 +0000 Subject: [PATCH] * Added a special user for nagios * Deleted obsolete yaseo configuration --- maintenance/ourusers.php | 48 ++++++++++------------------------------ 1 file changed, 12 insertions(+), 36 deletions(-) diff --git a/maintenance/ourusers.php b/maintenance/ourusers.php index 620393fb99..a7a3132bae 100644 --- a/maintenance/ourusers.php +++ b/maintenance/ourusers.php @@ -14,42 +14,14 @@ /** */ $wikiuser_pass = `wikiuser_pass`; $wikiadmin_pass = `wikiadmin_pass`; -$wikisql_pass = `wikisql_pass`; +$nagios_pass = `nagios_sql_pass`; -if ( @$argv[1] == 'yaseo' ) { - $hosts = array( - 'localhost', - '211.115.107.158', - '211.115.107.159', - '211.115.107.160', - '211.115.107.138', - '211.115.107.139', - '211.115.107.140', - '211.115.107.141', - '211.115.107.142', - '211.115.107.143', - '211.115.107.144', - '211.115.107.145', - '211.115.107.146', - '211.115.107.147', - '211.115.107.148', - '211.115.107.149', - '211.115.107.150', - '211.115.107.152', - '211.115.107.153', - '211.115.107.154', - '211.115.107.155', - '211.115.107.156', - '211.115.107.157', - ); -} else { - $hosts = array( - 'localhost', - '10.0.%', - '66.230.200.%', - '208.80.152.%', - ); -} +$hosts = array( + 'localhost', + '10.0.%', + '66.230.200.%', + '208.80.152.%', +); $databases = array( '%wik%', @@ -60,7 +32,8 @@ print "/*!40100 set old_passwords=1 */;\n"; print "/*!40100 set global old_passwords=1 */;\n"; foreach( $hosts as $host ) { - print "--\n-- $host\n--\n\n-- wikiuser\n\n"; + print "--\n-- $host\n--\n"; + print "\n-- wikiuser\n\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 ) { @@ -73,6 +46,9 @@ foreach( $hosts as $host ) { foreach ( $databases as $db ) { print "GRANT ALL PRIVILEGES ON `$db`.* TO wikiadmin@'$host' IDENTIFIED BY '$wikiadmin_pass';\n"; } + print "\n-- nagios\n\n"; + print "GRANT REPLICATION CLIENT ON *.* TO 'nagios'@'$host' IDENTIFIED BY '$nagios_pass';\n"; + print "\n"; } -- 2.20.1