20 echo "  <h2>Installation step " . $step . "</h2>";

    36 echo "  <h2>" . _('Installation step') . " " . $step . "</h2>";

    25 		echo "<p>This installer expects you to have a PowerDNS database accessable from this server. This installer also expects you to have never ran Poweradmin before, or that you want to overwrite the Poweradmin part of the database. If you have had Poweradmin running before, any data in the following tables will be destroyed:</p>\n";

    42 

    26 		echo "<ul><li>perm_items</li><li>perm_templ</li><li>perm_templ_items</li><li>users</li><li>zones</li></ul>\n";

    43 		echo "<p>\n";

    27 		echo "<p>This installer will, of course, not touch the data in the PowerDNS tables of the database. However, it is, of course, recommended you create a backup of your database before proceeding.</p>";

    44 		echo " <form method=\"post\">\n";

    28 		echo "<p>Finally, if you see any errors during the installation process, a problem report would be. You can report problems (and ask for help) on the <a href=\"https://www.poweradmin.org/trac/wiki/Mailinglists\">poweradmin-users</a> mailinglist or you can create <a href=\"https://www.poweradmin.org/trac/newticket\">a ticket</a> in the ticketsystem.</p>";

    45 		echo "  <input type=\"radio\" name=\"language\" value=\"en_EN\"> I prefer to proceed in english.<br>\n";

    29 		echo "<p>Do you want to proceed now?</p>\n";

    46 		echo "  <input type=\"radio\" name=\"language\" value=\"nl_NL\"> Ik ga graag verder in het Nederlands.<br><br>\n";

    30 		echo "<form method=\"post\">";

    47 		echo "  <input type=\"hidden\" name=\"step\" value=\"" . $step . "\">";

    31 		echo "<input type=\"hidden\" name=\"step\" value=\"" . $step . "\">";

    48 		echo "  <input type=\"submit\" name=\"submit\" value=\"" . _('Go to step') . " " . $step . "\">";

    32 		echo "<input type=\"submit\" name=\"submit\" value=\"Go to step " . $step . "\">";

    49 		echo " </form>\n";

    33 		echo "</form>";

    50 		echo "</p>\n";

    34 		break;

    51 		break;

    35 

    52 

    36 	case 2:	

    53 	case 2:

    37 		$step++;

    54 		$step++;

    38 		echo "<p>To prepare the database for using Poweradmin, the installer needs to modify the PowerDNS database. It'll add a number of tables and it'll fill these tables with some data. If the tables are already present, the installer will drop them first.</p>";

    55 

    39 		echo "<p>To do all of this, the installer needs to access the database with an account which has sufficient rights. If you trust the installer, you may give it the username and password of the database user root. Otherwise, make sure the user has enough rights, before actually proceeding.</p>";

    56 		echo "<p>" . _('This installer expects you to have a PowerDNS database accessable from this server. This installer also expects you to have never ran Poweradmin before, or that you want to overwrite the Poweradmin part of the database. If you have had Poweradmin running before, any data in the following tables will be destroyed: perm_items, perm_templ, perm_templ_items, users and zones. This installer will, of course, not touch the data in the PowerDNS tables of the database. However, it is recommended that you create a backup of your database before proceeding.') . "</p>\n";

    40 		echo "<form method=\"post\">";

    57 

    41 		echo "<table>\n";

    58 		echo "<p>" . _('The alternative for this installer is a manual installation. Refer to the poweradmin.org website if you want to go down that road.') . "</p>\n";

    42 		echo "<tr><td>Username</td><td><input type=\"text\" name=\"user\" value=\"\"></td><td>The username to use to connect to the database, make sure the username has sufficient rights to perform administrative task to the PowerDNS database (e.g. \"root\").</td></tr>\n";

    59 

    43 		echo "<tr><td>Password</td><td><input type=\"password\" name=\"pass\" value=\"\"></td><td>The password for this username.</td></tr>\n";

    60 		echo "<p>" . _('Finally, if you see any errors during the installation process, a problem report would be appreciated. You can report problems (and ask for help) on the poweradmin-users mailinglist.') . "</p>";

    44 		echo "<tr><td>Hostname</td><td><input type=\"text\" name=\"host\" value=\"\"></td><td>The hostname on which the PowerDNS database resides. Frequently, this will be \"localhost\".</td></tr>\n";

    61 

    45 		echo "<tr><td>Database</td><td><input type=\"text\" name=\"name\" value=\"\"></td><td>The name of the PowerDNS database.</td></tr>\n";

    62 		echo "<p>" . _('Do you want to proceed now?') . "</p>\n";

    46 		echo "<tr><td>Database type</td><td><select name=\"type\"><option value=\"mysql\">MySQL</option><option value=\"pgsql\">PostgreSQL</option></td><td>The type PowerDNS database.</td></tr>\n";

    63 

    64 		echo "<form method=\"post\">";

    65 		echo "<input type=\"hidden\" name=\"language\" value=\"" . $language . "\">";

    66 		echo "<input type=\"hidden\" name=\"step\" value=\"" . $step . "\">";

    67 		echo "<input type=\"submit\" name=\"submit\" value=\"" . _('Go to step') . " " . $step . "\">";

    68 		echo "</form>";

    69 		break;

    70 

    71 	case 3:	

    72 		$step++;

    73 		echo "<p>" . _('To prepare the database for using Poweradmin, the installer needs to modify the PowerDNS database. It will add a number of tables and it will fill these tables with some data. If the tables are already present, the installer will drop them first.') . "</p>";

    74 

    75 		echo "<p>" . _('To do all of this, the installer needs to access the database with an account which has sufficient rights. If you trust the installer, you may give it the username and password of the database user root. Otherwise, make sure the user has enough rights, before actually proceeding.') . "</p>";

    76 

    77 		echo "<form method=\"post\">";

    78 		echo " <table>\n";

    79 		echo "  <tr>\n";

    80 		echo "   <td>" . _('Username') . "</td>\n";

    81 		echo "   <td><input type=\"text\" name=\"user\" value=\"\"></td>\n";

    82 		echo "   <td>" . _('The username to use to connect to the database, make sure the username has sufficient rights to perform administrative task to the PowerDNS database (the installer wants to drop, create and fill tables to the database).') . "</td>\n";

    83 		echo "  </tr>\n";

    84 		echo " <tr>\n";

    85 		echo "  <td>" . _('Password') . "</td>\n";

    86 		echo "  <td><input type=\"password\" name=\"pass\" value=\"\"></td>\n";

    87 		echo "  <td>" . _('The password for this username.') . "</td>\n";

    88 		echo " </tr>\n";

    89 		echo " <tr>\n";

    90 		echo "  <td>" . _('Hostname') . "</td>\n";

    91 		echo "  <td><input type=\"text\" name=\"host\" value=\"\"></td>\n";

    92 		echo "  <td>" . _('The hostname on which the PowerDNS database resides. Frequently, this will be "localhost".') . "</td>\n";

    93 		echo " </tr>\n";

    94 		echo " <tr>\n";

    95 		echo "  <td>" . _('Database') . "</td>\n";

    96 		echo "  <td><input type=\"text\" name=\"name\" value=\"\"></td>\n";

    97 		echo "  <td>" . _('The name of the PowerDNS database.') . "</td>\n";

    98 		echo " </tr>\n";

    99 		echo " <tr>\n";

   100 		echo "  <td>" . _('Database type') . "</td>\n";

   101 		echo "  <td>" .

   102 			"<select name=\"type\">" . 

   103 			"<option value=\"mysql\">MySQL</option>" . 

   104 			"<option value=\"pgsql\">PostgreSQL</option>" . 

   105 			"</td>\n";

   106 		echo "  <td>" . _('The type of the PowerDNS database.') . "</td>\n";

   107 		echo " </tr>\n";

    49 		echo "<input type=\"submit\" name=\"submit\" value=\"Go to step " . $step . "\">";

   110 		echo "<input type=\"hidden\" name=\"language\" value=\"" . $language . "\">";

    50 		echo "</form>";

   111 		echo "<input type=\"submit\" name=\"submit\" value=\"" . _('Go to step') . " " . $step . "\">";

    51 		break;

   112 		echo "</form>";

    52 

   113 		break;

    53 	case 3:

   114 

    54 		$step++;

   115 	case 4:

    55 		echo "<p>Updating database... ";

   116 		$step++;

   117 		echo "<p>" . _('Updating database...') . " ";

    82 

   140 		echo _('done!') . "</p>";

    83 		echo "done!</p>";

   141 

    84 

   142 		echo "<p>" . _('We have now updated the PowerDNS database to work with Poweradmin. 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.') . " ";

    85 		echo "<p>We have now updated the PowerDNS database to work with Poweradmin. 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. ";

    87 			echo "In MySQL should now perform the following command:</p>";

   144 			echo _('In MySQL you should now perform the following command:') . "</p>";

    90 			echo "<p>On PgSQL you would use:</p>";

   147 			echo _('On PgSQL you would use:') . "</p>";

    91 			echo "<p><tt>$ createuser poweradmin-user<br>Shall the new role be a superuser? (y/n) n<br>Shall the new user be allowed to create databases? (y/n) n<br>Shall the new user be allowed to create more new users? (y/n) n<br>CREATE USER<br>$ psql powerdns-database<br>psql> GRANT  SELECT, INSERT, DELETE, UPDATE<br>ON powerdns-database<br>TO poweradmin-user;</tt></p>";

   148 			echo "<p><tt>$ createuser poweradmin-user<br>" .

   149 				"Shall the new role be a superuser? (y/n) n<br>" . 

   150 				"Shall the new user be allowed to create databases? (y/n) n<br>" . 

   151 				"Shall the new user be allowed to create more new users? (y/n) n<br>" . 

   152 				"CREATE USER<br>" . 

   153 				"$ psql powerdns-database<br>" .

   154 				"psql> GRANT  SELECT, INSERT, DELETE, UPDATE<br>" . 

   155 				"ON powerdns-database<br>" .

   156 				"TO poweradmin-user;</tt></p>\n";

    93 		echo "<p>After you have added the new user, proceed with this installation procedure.</p>\n";

   158 		echo "<p>" . _('After you have added the new user, proceed with this installation procedure.') . "</p>\n";

    99 		echo "<input type=\"submit\" name=\"submit\" value=\"Go to step " . $step . "\">";

   164 		echo "<input type=\"hidden\" name=\"language\" value=\"" . $language . "\">";

   165 		echo "<input type=\"submit\" name=\"submit\" value=\"" . _('Go to step') . " " . $step . "\">";

   103 	case 4:

   169 	case 5:

   108 		echo "<p>Now we will put together the configuration. To do so, I need some details:</p>";

   174 		echo "<p>" . _('Now we will put together the configuration. To do so, the installer needs some details:') . "</p>\n";

   109 		echo "<form method=\"post\">";

   175 		echo "<form method=\"post\">";

   110 		echo "<table>";

   176 		echo " <table>";

   111 		echo "<tr><td>Username</td><td><input type=\"text\" name=\"db_user\" value=\"\"></td><td>The username as created in the previous step.</td></tr>";

   177 		echo "  <tr>";

   112 		echo "<tr><td>Password</td><td><input type=\"text\" name=\"db_pass\" value=\"\"></td><td>The password for this username.</td></tr>";

   178 		echo "   <td>" . _('Username') . "</td>\n";

   113 		echo "<tr><td>Hostmaster</td><td><input type=\"text\" name=\"dns_hostmaster\" value=\"\"></td><td>When creating SOA records and no hostmaster is provided, this value here will be used. Should be in the form \"hostmaster.example.net\".</td></tr>";

   179 		echo "   <td><input type=\"text\" name=\"db_user\" value=\"\"></td>\n";

   114 		echo "<tr><td>Primary nameserver</td><td><input type=\"text\" name=\"dns_ns1\" value=\"\"></td><td>When creating new zones using the template, this value will be used as primary nameserver. Should be like \"ns1.example.net\".</td></tr>";

   180 		echo "   <td>" . _('The username as created in the previous step.') . "</td>\n";

   115 		echo "<tr><td>Secondary nameserver</td><td><input type=\"text\" name=\"dns_ns2\" value=\"\"></td><td>When creating new zones using the template, this value will be used as secondary nameserver. Should be like \"ns2.example.net\".</td></tr>";

   181 		echo "  </tr>\n";

   182 		echo "  <tr>\n";

   183 		echo "   <td>" . _('Password') . "</td>\n";

   184 		echo "   <td><input type=\"text\" name=\"db_pass\" value=\"\"></td>\n";

   185 		echo "   <td>" . _('The password for this username.') . "</td>\n";

   186 		echo "  </tr>\n";

   187 		echo "  <tr>\n";

   188 		echo "   <td>" . _('Hostmaster') . "</td>\n";

   189 		echo "   <td><input type=\"text\" name=\"dns_hostmaster\" value=\"\"></td>\n";

   190 		echo "   <td>" . _('When creating SOA records and no hostmaster is provided, this value here will be used. Should be in the form "hostmaster.example.net".') . "</td>\n";

   191 		echo "  </tr>\n";

   192 		echo "  <tr>\n";

   193 		echo "   <td>" . _('Primary nameserver') . "</td>\n";

   194 		echo "   <td><input type=\"text\" name=\"dns_ns1\" value=\"\"></td>\n";

   195 		echo "   <td>" . _('When creating new zones using the template, this value will be used as primary nameserver. Should be like "ns1.example.net".') . "</td>\n";

   196 		echo "  </tr>\n";

   197 		echo "  <tr>\n";

   198 		echo "   <td>" . _('Secondary nameserver') . "</td>\n";;

   199 		echo "   <td><input type=\"text\" name=\"dns_ns2\" value=\"\"></td>\n";

   200 		echo "   <td>" . _('When creating new zones using the template, this value will be used as secondary nameserver. Should be like "ns2.example.net".') . "</td>\n";

   201 		echo "  </tr>\n";

   121 		echo "<input type=\"submit\" name=\"submit\" value=\"Go to step " . $step . "\">";

   207 		echo "<input type=\"hidden\" name=\"language\" value=\"" . $language . "\">";

   122 		echo "</form>";

   208 		echo "<input type=\"submit\" name=\"submit\" value=\"" . _('Go to step') . " " . $step . "\">";

   123 		break;

   209 		echo "</form>";

   124 

   210 		break;

   125 	case 5:

   211 

   212 	case 6:

   143 			echo "<p>The installer was able to write to the file \"" . $local_config_file . "\". A basic configuration, based on the details you have given, has been created.</p>\n";

   232 			echo "<p>" . _('The installer was able to write to the file "') . $local_config_file . _('". A basic configuration, based on the details you have given, has been created.') . "</p>\n";

   145 			echo "<p>The installer is unable to write to the file \"" . $local_config_file . "\" (which is in itself good). The configuration is printed here. You should now create the file " . $local_config_file . " in the Poweradmin root directory yourself. It should contain the following few lines:</p>\n";

   234 			echo "<p>" . _('The installer is unable to write to the file "') . $local_config_file . _('" (which is in itself good). The configuration is printed here. You should now create the file "') . $local_config_file . _('" in the Poweradmin root directory yourself. It should contain the following few lines:') . "</p>\n";

   152 		echo "<input type=\"submit\" name=\"submit\" value=\"Go to step " . $step . "\">";

   241 		echo "<input type=\"hidden\" name=\"language\" value=\"" . $language . "\">";

   153 		echo "</form>";

   242 		echo "<input type=\"submit\" name=\"submit\" value=\"" . _('Go to step') . " " . $step . "\">";

   154 		break;

   243 		echo "</form>";

   155 

   244 		break;

   156 	case 6:

   245 

   157 		$step++;

   246 	case 7:

   158 		echo "<p>Now we have finished the configuration, you should (must!) remove the directory \"install/\" from the Poweradmin root directory. You will not be able to use the file if it exists. Do it now.</p>";

   247 		$step++;

   159 		echo "<p>After you have removed the file, you can login to <a href=\"index.php\">Poweradmin</a> with username \"admin\" and password \"admin\". You are highly encouraged to change these as soon as you are logged in.</p>";

   248 		echo "<p>" . _('Now we have finished the configuration, you should (must!) remove the directory "install/" from the Poweradmin root directory. You will not be able to use Poweradmin if it exists. Do it now.') . "</p>";

   249 		echo "<p>" . _('After you have removed the directory, you can login to <a href="index.php">Poweradmin</a> with username "admin" and password "admin". You are highly encouraged to change these as soon as you are logged in.') . "</p>";