Revision 12a7cea9
Von Moritz Bunkus vor fast 17 Jahren hinzugefügt
| bin/mozilla/admin.pl | ||
|---|---|---|
| 635 | 635 |
print $form->parse_html_template("admin/dbadmin");
|
| 636 | 636 |
} |
| 637 | 637 |
|
| 638 |
sub test_db_connection {
|
|
| 639 |
$form->{dbdriver} = 'Pg';
|
|
| 640 |
User::dbconnect_vars($form, $form->{dbname});
|
|
| 641 |
|
|
| 642 |
my $dbh = DBI->connect($form->{dbconnect}, $form->{dbuser}, $form->{dbpasswd});
|
|
| 643 |
|
|
| 644 |
$form->{connection_ok} = $dbh ? 1 : 0;
|
|
| 645 |
$form->{errstr} = $DBI::errstr;
|
|
| 646 |
|
|
| 647 |
$dbh->disconnect() if ($dbh); |
|
| 648 |
|
|
| 649 |
$form->{title} = $locale->text('Database Connection Test');
|
|
| 650 |
$form->header(); |
|
| 651 |
print $form->parse_html_template("admin/test_db_connection");
|
|
| 652 |
} |
|
| 653 |
|
|
| 638 | 654 |
sub continue {
|
| 639 | 655 |
call_sub($form->{"nextsub"});
|
| 640 | 656 |
} |
| js/common.js | ||
|---|---|---|
| 147 | 147 |
return false; |
| 148 | 148 |
} |
| 149 | 149 |
|
| 150 |
function get_input_value(input_name) {
|
|
| 151 |
var the_input = document.getElementsByName(input_name); |
|
| 152 |
if (the_input && the_input[0]) |
|
| 153 |
return the_input[0].value; |
|
| 154 |
return ''; |
|
| 155 |
} |
|
| locale/de/admin | ||
|---|---|---|
| 47 | 47 |
'DELETED' => 'Gel?scht', |
| 48 | 48 |
'DUNNING STARTED' => 'Mahnprozess gestartet', |
| 49 | 49 |
'Database Administration' => 'Datenbankadministration', |
| 50 |
'Database Connection Test' => 'Test der Datenbankverbindung', |
|
| 50 | 51 |
'Database User missing!' => 'Datenbankbenutzer fehlt!', |
| 51 | 52 |
'Database backups and restorations are disabled in lx-erp.conf.' => 'Datenbanksicherungen und -wiederherstellungen sind in der lx-erp.conf deaktiviert.', |
| 52 | 53 |
'Dataset missing!' => 'Datenbank fehlt!', |
| ... | ... | |
| 250 | 251 |
'set_longdescription' => 'set_longdescription', |
| 251 | 252 |
'show_history' => 'show_history', |
| 252 | 253 |
'show_vc_details' => 'show_vc_details', |
| 254 |
'test_db_connection' => 'test_db_connection', |
|
| 253 | 255 |
'unlock_system' => 'unlock_system', |
| 254 | 256 |
'update_dataset' => 'update_dataset', |
| 255 | 257 |
'user_migration_complete' => 'user_migration_complete', |
| locale/de/all | ||
|---|---|---|
| 403 | 403 |
'DUNS-Nr' => 'DUNS-Nr.', |
| 404 | 404 |
'Database' => 'Datenbank', |
| 405 | 405 |
'Database Administration' => 'Datenbankadministration', |
| 406 |
'Database Connection Test' => 'Test der Datenbankverbindung', |
|
| 406 | 407 |
'Database Host' => 'Datenbankcomputer', |
| 407 | 408 |
'Database User missing!' => 'Datenbankbenutzer fehlt!', |
| 408 | 409 |
'Database backups and restorations are disabled in lx-erp.conf.' => 'Datenbanksicherungen und -wiederherstellungen sind in der lx-erp.conf deaktiviert.', |
| ... | ... | |
| 591 | 592 |
'Error in position #1: You must either assign no stock at all or the full quantity of #2 #3.' => 'Fehler in Position #1: Sie müssen einer Position entweder gar keinen Lagereingang oder die vollständige im Lieferschein vermerkte Menge von #2 #3 zuweisen.', |
| 592 | 593 |
'Error in position #1: You must either assign no transfer at all or the full quantity of #2 #3.' => 'Fehler in Position #1: Sie müssen einer Position entweder gar keinen Lagerausgang oder die vollständige im Lieferschein vermerkte Menge von #2 #3 zuweisen.', |
| 593 | 594 |
'Error in row #1: The quantity you entered is bigger than the stocked quantity.' => 'Fehler in Zeile #1: Die angegebene Menge ist größer als die vorhandene Menge.', |
| 595 |
'Error message from the database driver:' => 'Fehlermeldung des Datenbanktreibers:', |
|
| 594 | 596 |
'Error!' => 'Fehler!', |
| 595 | 597 |
'Ertrag' => 'Ertrag', |
| 596 | 598 |
'Ertrag prozentual' => 'Ertrag prozentual', |
| ... | ... | |
| 1332 | 1334 |
'Template database' => 'Datenbankvorlage', |
| 1333 | 1335 |
'Templates' => 'Vorlagen', |
| 1334 | 1336 |
'Terms missing in row ' => '+Tage fehlen in Zeile ', |
| 1337 |
'Test connection' => 'Verbindung testen', |
|
| 1335 | 1338 |
'Text field' => 'Textfeld', |
| 1336 | 1339 |
'Text field variables: \'WIDTH=w HEIGHT=h\' sets the width and height of the text field. They default to 30 and 5 respectively.' => 'Textfelder: \'WIDTH=w HEIGHT=h\' setzen die Breite und die Höhe des Textfeldes. Wenn nicht anders angegeben, so werden sie 30 Zeichen breit und fünf Zeichen hoch dargestellt.', |
| 1337 | 1340 |
'Text variables: \'MAXLENGTH=n\' sets the maximum entry length to \'n\'.' => 'Textzeilen: \'MAXLENGTH=n\' setzt eine Maximallänge von n Zeichen.', |
| ... | ... | |
| 1351 | 1354 |
'The config file "config/authentication.pl" was not found.' => 'Die Konfigurationsdatei "config/authentication.pl" wurde nicht gefunden.', |
| 1352 | 1355 |
'The connection to the LDAP server cannot be encrypted (SSL/TLS startup failure). Please check config/authentication.pl.' => 'Die Verbindung zum LDAP-Server kann nicht verschlüsselt werden (Fehler bei SSL/TLS-Initialisierung). Bitte überprüfen Sie die Angaben in config/authentication.pl.', |
| 1353 | 1356 |
'The connection to the authentication database failed:' => 'Die Verbindung zur Authentifizierungsdatenbank schlug fehl:', |
| 1357 |
'The connection to the database could not be established.' => 'Die Verbindung zur Datenbank konnte nicht hergestellt werden.', |
|
| 1354 | 1358 |
'The connection to the template database failed:' => 'Die Verbindung zur Vorlagendatenbank schlug fehl:', |
| 1359 |
'The connection was established successfully.' => 'Die Verbindung zur Datenbank wurde erfolgreich hergestellt.', |
|
| 1355 | 1360 |
'The creation of the authentication database failed:' => 'Das Anlegen der Authentifizierungsdatenbank schlug fehl:', |
| 1356 | 1361 |
'The custom variable has been deleted.' => 'Die benutzerdefinierte Variable wurde gelöscht.', |
| 1357 | 1362 |
'The custom variable has been saved.' => 'Die benutzerdefinierte Variable wurde gespeichert.', |
| templates/webpages/admin/edit_user_de.html | ||
|---|---|---|
| 1 | 1 |
[% USE HTML %]<body class="admin"> |
| 2 | 2 |
|
| 3 |
<form method="post" action="admin.pl"> |
|
| 3 |
<script type="text/javascript" src="js/common.js"></script> |
|
| 4 |
<script type="text/javascript"> |
|
| 5 |
<!-- |
|
| 6 |
function open_connection_test_window() {
|
|
| 7 |
// host name port user passwd |
|
| 8 |
var url = "admin.pl?action=test_db_connection&" + |
|
| 9 |
"dbhost=" + escape_more(get_input_value("dbhost")) + "&" +
|
|
| 10 |
"dbname=" + escape_more(get_input_value("dbname")) + "&" +
|
|
| 11 |
"dbuser=" + escape_more(get_input_value("dbuser")) + "&" +
|
|
| 12 |
"dbpasswd=" + escape_more(get_input_value("dbpasswd")) + "&";
|
|
| 13 |
|
|
| 14 |
var parm = centerParms(400,300) + ",width=400,height=300,status=yes,scrollbars=yes"; |
|
| 15 |
|
|
| 16 |
window.open(url, "_new_generic", parm); |
|
| 17 |
} |
|
| 18 |
--> |
|
| 19 |
</script> |
|
| 20 |
|
|
| 21 |
<form name="Form" method="post" action="admin.pl"> |
|
| 4 | 22 |
|
| 5 | 23 |
<div class="listtop" width="100%">[% title %]</div> |
| 6 | 24 |
|
| ... | ... | |
| 187 | 205 |
<th align="right">Passwort</th> |
| 188 | 206 |
<td><input name="dbpasswd" type="password" size="10" value="[% HTML.escape(myc_dbpasswd) %]"></td> |
| 189 | 207 |
</tr> |
| 208 |
|
|
| 209 |
<tr> |
|
| 210 |
<td colspan="2"><input type="button" class="submit" onclick="open_connection_test_window();" value="Verbindung testen"></td> |
|
| 211 |
</tr> |
|
| 190 | 212 |
</table> |
| 191 | 213 |
</td> |
| 192 | 214 |
</tr> |
| templates/webpages/admin/edit_user_master.html | ||
|---|---|---|
| 1 | 1 |
[% USE HTML %]<body class="admin"> |
| 2 | 2 |
|
| 3 |
<form method="post" action="admin.pl"> |
|
| 3 |
<script type="text/javascript" src="js/common.js"></script> |
|
| 4 |
<script type="text/javascript"> |
|
| 5 |
<!-- |
|
| 6 |
function open_connection_test_window() {
|
|
| 7 |
// host name port user passwd |
|
| 8 |
var url = "admin.pl?action=test_db_connection&" + |
|
| 9 |
"dbhost=" + escape_more(get_input_value("dbhost")) + "&" +
|
|
| 10 |
"dbname=" + escape_more(get_input_value("dbname")) + "&" +
|
|
| 11 |
"dbuser=" + escape_more(get_input_value("dbuser")) + "&" +
|
|
| 12 |
"dbpasswd=" + escape_more(get_input_value("dbpasswd")) + "&";
|
|
| 13 |
|
|
| 14 |
var parm = centerParms(400,300) + ",width=400,height=300,status=yes,scrollbars=yes"; |
|
| 15 |
|
|
| 16 |
window.open(url, "_new_generic", parm); |
|
| 17 |
} |
|
| 18 |
--> |
|
| 19 |
</script> |
|
| 20 |
|
|
| 21 |
<form name="Form" method="post" action="admin.pl"> |
|
| 4 | 22 |
|
| 5 | 23 |
<div class="listtop" width="100%">[% title %]</div> |
| 6 | 24 |
|
| ... | ... | |
| 187 | 205 |
<th align="right"><translate>Password</translate></th> |
| 188 | 206 |
<td><input name="dbpasswd" type="password" size="10" value="[% HTML.escape(myc_dbpasswd) %]"></td> |
| 189 | 207 |
</tr> |
| 208 |
|
|
| 209 |
<tr> |
|
| 210 |
<td colspan="2"><input type="button" class="submit" onclick="open_connection_test_window();" value="<translate>Test connection</translate>"></td> |
|
| 211 |
</tr> |
|
| 190 | 212 |
</table> |
| 191 | 213 |
</td> |
| 192 | 214 |
</tr> |
| templates/webpages/admin/test_db_connection_de.html | ||
|---|---|---|
| 1 |
[% USE HTML %]<body> |
|
| 2 |
|
|
| 3 |
<div class="listtop">[% title %]</div> |
|
| 4 |
|
|
| 5 |
[%- IF connection_ok %] |
|
| 6 |
|
|
| 7 |
<p>Die Verbindung zur Datenbank wurde erfolgreich hergestellt.</p> |
|
| 8 |
|
|
| 9 |
[%- ELSE %] |
|
| 10 |
|
|
| 11 |
<p> |
|
| 12 |
Die Verbindung zur Datenbank konnte nicht hergestellt werden. |
|
| 13 |
Fehlermeldung des Datenbanktreibers: |
|
| 14 |
</p> |
|
| 15 |
|
|
| 16 |
<p>[% HTML.escape(errstr) %]</p> |
|
| 17 |
|
|
| 18 |
[%- END %] |
|
| 19 |
|
|
| 20 |
<p> |
|
| 21 |
<form> |
|
| 22 |
<input type="button" class="submit" onclick="window.close()" value="Fenster Schließen"> |
|
| 23 |
</form> |
|
| 24 |
</p> |
|
| 25 |
|
|
| 26 |
</body> |
|
| 27 |
</html> |
|
| templates/webpages/admin/test_db_connection_master.html | ||
|---|---|---|
| 1 |
[% USE HTML %]<body> |
|
| 2 |
|
|
| 3 |
<div class="listtop">[% title %]</div> |
|
| 4 |
|
|
| 5 |
[%- IF connection_ok %] |
|
| 6 |
|
|
| 7 |
<p><translate>The connection was established successfully.</translate></p> |
|
| 8 |
|
|
| 9 |
[%- ELSE %] |
|
| 10 |
|
|
| 11 |
<p> |
|
| 12 |
<translate>The connection to the database could not be |
|
| 13 |
established.</translate> |
|
| 14 |
<translate>Error message from the database driver:</translate> |
|
| 15 |
</p> |
|
| 16 |
|
|
| 17 |
<p>[% HTML.escape(errstr) %]</p> |
|
| 18 |
|
|
| 19 |
[%- END %] |
|
| 20 |
|
|
| 21 |
<p> |
|
| 22 |
<form> |
|
| 23 |
<input type="button" class="submit" onclick="window.close()" value="<translate>Close Window</translate>"> |
|
| 24 |
</form> |
|
| 25 |
</p> |
|
| 26 |
|
|
| 27 |
</body> |
|
| 28 |
</html> |
|
Auch abrufbar als: Unified diff
Administration: Einen Button zum Testen der Datenbankeinstellung in der Maske zur Bearbeitung der Benutzerdaten eingefügt.