[feladat @ 288]
authorrejo
Thu, 12 Jun 2008 22:00:46 +0000
changeset 180 e17c8536d718
parent 179 5a2d4418385d
child 181 76a304b484ed
[feladat @ 288] Fixed GRANT statement installer to give working example, even if web interface and database are on different server. Closes #67.
install/index.php
--- a/install/index.php	Sat Jun 07 10:51:11 2008 +0000
+++ b/install/index.php	Thu Jun 12 22:00:46 2008 +0000
@@ -200,6 +200,7 @@
 		$db_name = $_POST['db_name'];
 		$db_type = $_POST['db_type'];
 		$pa_pass = $_POST['pa_pass'];
+		$pa_srvr = getenv('SERVER_NAME');
 		$dns_hostmaster = $_POST['dns_hostmaster'];
 		$dns_ns1 = $_POST['dns_ns1'];
 		$dns_ns2 = $_POST['dns_ns2'];
@@ -207,7 +208,7 @@
 		echo "<p>" . _('You now want to give limited rights to Poweradmin so it can update the data in the tables. To do this, you should create a new user and give it rights to select, delete, insert and update records in the PowerDNS database.') . " ";
 		if ($db_type == 'mysql') {
 			echo _('In MySQL you should now perform the following command:') . "</p>";
-			echo "<p><tt>GRANT SELECT, INSERT, UPDATE, DELETE<BR>ON " . $db_name . ".*<br>TO '" . $db_user . "'@'" . $db_host . "'<br>IDENTIFIED BY '" . $db_pass . "';</tt></p>";
+			echo "<p><tt>GRANT SELECT, INSERT, UPDATE, DELETE<BR>ON " . $db_name . ".*<br>TO '" . $db_user . "'@'" . $pa_srvr . "'<br>IDENTIFIED BY '" . $db_pass . "';</tt></p>";
 		} elseif ($db_type == 'pgsql') {
 			echo _('On PgSQL you would use:') . "</p>";
 			echo "<p><tt>$ createuser -E -P " . $db_user . "<br>" .