Mercurial > dive4elements > river
annotate backend/doc/documentation/de/overview.tex @ 5983:0c63ce5a7e74
Use name id as username in saml.User.
The old WAS-only code used the user-name typed in by the user when
logging in. When logging in via SAML single sign on, we must extract the
user name from the SAML ticket and the name ID should basically be what
the user types in when authenticating.
| author | Bernhard Herzog <bh@intevation.de> |
|---|---|
| date | Fri, 10 May 2013 19:03:48 +0200 |
| parents | 7e48f7a64182 |
| children | 92c8cc7e064b |
| rev | line source |
|---|---|
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
1 \section{�bersicht} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
2 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
3 Diese Dokumentation beschreibt die von Intevation entwickelten Werkzeuge zum |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
4 Importieren der hydrologischen, morphologischen und geod�tischen Daten der BfG. |
|
5040
d55ba61e9970
documentation: Typo fix.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
3682
diff
changeset
|
5 Die im Folgenden\\ beschriebenen Werkzeuge zum Importieren der fachlichen und |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
6 geod�tischen Daten sind speziell auf das Verzeichnissystem der BfG ausgerichtet. |
|
3668
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
7 Dabei wird angenommen, dass sich das Verzeichnis eines Gew�ssers auf oberster |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
8 Ebene in drei Unterverzeichnisse aufgliedert: |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
9 |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
10 \begin{itemize} |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
11 \item Geodaesie |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
12 \item Hydrologie |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
13 \item Morphologie |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
14 \end{itemize} |
|
2a3bc47d1ba9
Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3667
diff
changeset
|
15 |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
16 Desweiteren beziehen sich die Befehle, die auf der Kommandozeile abgesetzt |
|
3678
6185c15efccf
Added hint for root permission in documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3672
diff
changeset
|
17 werden, auf ein SuSE-Linux-Enterprise-Server Version 11. Bitte beachten Sie |
|
6185c15efccf
Added hint for root permission in documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3672
diff
changeset
|
18 auch, dass einige der Befehle \textit{root}-Rechte ben�tigen. |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
19 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
20 \subsection{Vorbereitungen} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
21 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
22 \subsubsection{Entpacken des Datenimporters} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
23 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
24 Damit die Software performant und korrekt ausgef�hrt werden kann, ist es |
|
5041
41ab66c2fb28
Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
5040
diff
changeset
|
25 erforderlich, dass sie auf dem selben System wie die Datenbank installiert |
|
41ab66c2fb28
Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
5040
diff
changeset
|
26 und ausgef�hrt wird. |
|
41ab66c2fb28
Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
5040
diff
changeset
|
27 Sollten Sie das Paket nicht auf dem |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
28 Zielsystem selbst heruntergeladen haben, sind ggf. weitere Werkzeuge notwendig. |
|
5041
41ab66c2fb28
Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
5040
diff
changeset
|
29 Wenn Sie von einem Windows System auf das Zielsystem zugreifen |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
30 wollen, k�nnen Sie beispielsweise folgende Werkzeuge verwenden: |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
31 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
32 \begin{itemize} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
33 \item WinSCP \\ |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
34 WinSCP ist ein Open Source Werkzeug zum Transferieren von Dateien zwischen zwei |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
35 Systemen. Um das heruntergeladene Paket auf das Zielsystem zu transferieren, |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
36 k�nnen Sie WinSCP benutzen. F�r weitere Informationen und den Gebrauch von |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
37 WinSCP lesen Sie bitte unter folgender Adresse nach: |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
38 \href{http://winscp.net/}{http://winscp.net/}. |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
39 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
40 \item Putty \\ |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
41 Putty ist ein Open Source Werkzeug, mit dem Sie sich von einem Windows System |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
42 per SSH auf das Zielsystem verbinden k�nnen. Anschlie�end k�nnen Sie �ber die |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
43 Kommandozeile auf dem Zielsystem die Befehle, die in diesem Dokument beschrieben |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
44 sind, ausf�hren. F�r weitere Informationen zu Putty und dessen Gebrauch lesen |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
45 Sie bitte unter folgender Adresse nach: \href{http://www.putty.org/} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
46 {http://www.putty.org/}. |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
47 \end{itemize} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
48 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
49 Bitte beachten Sie, dass diese Werkzeuge nicht zur Installtion und zum Betrieb |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
50 der Software selbst notwendig sind! |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
51 |
|
5065
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
52 \subsection{Systemanforderungen} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
53 \label{Systemanforderungen} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
54 \begin{itemize} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
55 \item Oracle oder PosgreSQL Datenbank inkl. Schema f�r FLYS |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
56 \item SUSE Enterprise Linux 11.2 SP 1 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
57 \end{itemize} |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
58 |
|
5065
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
59 \subsection{Installationsanleitung} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
60 \label{Installationsanleitung} |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
61 |
|
3672
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
62 Nachdem Sie das Paket nun in das Heimatverzeichnis des Nutzers auf das |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
63 Zielsystem kopiert haben, entpacken Sie es mit folgenden Befehlen: |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
64 |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
65 \begin{lstlisting} |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
66 cd ~ |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
67 tar xvfz flys-importer.tar.gz |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
68 cd flys-importer |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
69 \end{lstlisting} |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
70 |
| 5075 | 71 \subsubsection{Java} |
|
5065
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
72 Der flys-importer ben�tigt Java Version 6 um diese zu installieren laden Sie |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
73 bitte von \url{http://www.oracle.com/technetwork/java/javase/downloads/jdk6downloads-1902814.html} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
74 eine aktulle Java Version als -rpm.bin herunter. Zum Beispiel: jdk-6u41-linux-x64-rpm.bin |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
75 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
76 Nach dem Herunterladen, �ffnen Sie eine konsole und wechseln in das Downloadverzeichnis. |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
77 F�hren Sie nun folgende Befehle aus: |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
78 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
79 \begin{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
80 su - # login als root |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
81 sh jdk-6u41-linux-x64-rpm.bin |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
82 <bestaetigen mit enter> |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
83 update-alternatives --install /usr/bin/java java /usr/java/jdk1.6.0_41/bin/java 5 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
84 update-alternatives --install /etc/alternatives/jre jre /usr/java/jdk1.6.0_41/jre 5 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
85 update-alternatives --config java |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
86 \end{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
87 |
| 5075 | 88 \subsubsection{Python und GDAL} |
|
5065
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
89 Installieren Sie nun die restlichen ben�tigten Pakete. |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
90 Dazu installieren Sie zuerst einige Abh�ngigkeiten und anschlie�end die |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
91 von der Intevation GmbH bereitgestellten speziellen Versionen von proj und libgeos |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
92 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
93 Um die Abh�ngigkeiten zu installieren f�hren Sie bitte folgende Befehle aus: |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
94 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
95 \begin{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
96 zypper ar http://download.opensuse.org/repositories/home:/intevation:/bfg/SLE_11/ "intevation:bfg" |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
97 rpm --import http://download.opensuse.org/repositories/home:/intevation:/bfg/SLE_11/repodata/repomd.xml.key |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
98 zypper ref # Paketlist neu laden |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
99 zypper in python libgeos0 libproj0 proj netcdf libnetcdf4 \ |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
100 xerces-c libxerces-c-3_0 unixODBC postgresql-libs |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
101 zypper mr -d "intevation:bfg" |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
102 zypper ref # Paketliste neu laden |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
103 \end{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
104 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
105 %\subsubsection Oracle Instantclient\\ |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
106 %Der Oracle Instantclient 11.2.0.2.0 wird ben�tigt, damit der Importer mittels Python |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
107 %und GDAL in die bestehende Oracle Datenbqlnk schreiben kann. Wenn Sie |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
108 %eine PosgreSQL Datenbank verwenden, k�nnen Sie diesen Schritt �berspringen. |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
109 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
110 %Zur Anbindung von Oracle ist es erforderlich, folgende Archive von |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
111 %Oracle herunterzuladen (Sie ben�tigen daf�r ein Oracle Benutzerkonto): |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
112 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
113 %Der Oracle Instantclient 11.2 wird ben�tigt, damit der Importer mittels Python |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
114 %und GDAL in die bestehende Oracle Datenbank schreiben kann. Dazu ist es |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
115 %erforderlich, folgende Archive von Oracle herunterzuladen. |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
116 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
117 % \begin{itemize} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
118 % \item instantclient-basic-linux-x86-64-11.2.0.2.0.zip |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
119 % \item instantclient-sdk-linux-x86-64-11.2.0.2.0.zip |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
120 % \item instantclient-sqlplus-linux-x86-64-11.2.0.2.0.zip |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
121 % \end{itemize} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
122 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
123 %Zu finden sind die |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
124 % Pakete unter:\\ |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
125 %\href{http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
126 %{http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
127 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
128 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
129 %Um diese Pakete zu installieren, �ffnen Sie eine Konsole und wechseln |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
130 %in das Verzeichnis in welches Sie die heruntergeladenen Pakete |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
131 %gespeichert haben. (z.B.: cd /home/benutzername/Downloads ) |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
132 % Anschlie�end f�hren Sie folgende Befehle auf der Kommandozeile aus: |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
133 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
134 % \begin{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
135 % unzip instantclient-basic-linux-x86-64-11.2.0.2.0.zip -d /opt |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
136 % unzip instantclient-sdk-linux-x86-64-11.2.0.2.0.zip -d /opt |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
137 % unzip instantclient-sqlplus-linux-x86-64-11.2.0.2.0.zip -d /opt |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
138 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
139 % mkdir /opt/instantclient_11_2/lib |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
140 % cd /opt/instantclient_11_2/lib |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
141 % ln -s ../libclntsh.so.11.1 . |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
142 % ln -s ../libclntsh.so.11.1 libclntsh.so |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
143 % ln -s ../libnnz11.so . |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
144 % ln -s ../libocci.so.11.1 . |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
145 % ln -s ../libocci.so.11.1 libocci.so |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
146 % ln -s ../libociei.so . |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
147 % ln -s ../libocijdbc11.so . |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
148 % ln -s ../libsqlplusic.so . |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
149 % ln -s ../libsqlplus.so . |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
150 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
151 % echo "/opt/instantclient_11_2/lib/" > /etc/ld.so.conf.d/oci.conf |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
152 % ldconfig |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
153 % \end{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
154 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
155 %Sollten keine Fehler aufgetreten sein, haben Sie den \textit{Oracle |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
156 % Instantclient 11.2} erfolgreich entpackt und im Dateisystem unter |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
157 % \textit{/opt/instantclient\_11\_2} abgelegt. |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
158 % |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
159 \subsubsection{Vorbereiten der Datenbank} |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
160 Bevor die Importer verwendet werden k�nnen, ist es notwendig, dass eine leere |
|
5877
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
161 Oracle Datenbank vorhanden ist. Anschlie�end m�ssen folgende SQL-Skripte in |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
162 diese Datenbank eingespielt werden: |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
163 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
164 \begin{enumerate} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
165 \item oracle.sql \\ |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
166 In diesem SQL Skript befindet sich das Schema zum Speichern der hydrologischen |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
167 Daten. |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
168 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
169 \item oracle-minfo.sql \\ |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
170 In diesem SQL Skript befindet sich das Schema zum Speichern der morphologischen |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
171 Daten. |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
172 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
173 \item oracle-spatial.sql \\ |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
174 In diesem SQL Skript befindet sich das Schema zum Speichern der geod�tischen |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
175 Daten. |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
176 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
177 \item oracle-spatial\_idx.sql \\ |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
178 Mittels diesem SQL Skript werden die Indizes zum geod�tischen Datenbankschema\\ |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
179 hinzugef�gt. |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
180 |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
181 \end{enumerate} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
182 |
|
3672
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
183 Zum Einspielen dieser Schemata setzen Sie folgende Befehle auf der Kommandozeile |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
184 ab. Beachten Sie, dass $sqlplus$ im Pfad liegen muss, und der Linux-Nutzer |
|
5041
41ab66c2fb28
Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
5040
diff
changeset
|
185 dieses Kommando ausf�hren k�nnen muss. Au�erdem sind $benutzername$ und $passwort$ |
|
3672
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
186 entsprechend Ihres Datenbank-Zugangs anzupassen. |
|
5065
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
187 SQLPlus befindet sich in /opt/instantclient\_11\_2 um es verf�gbar zu machen |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
188 f�hren Sie im Importer Verzeichnis folgende Befehle aus: |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
189 |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
190 \begin{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
191 export LD_LIBRARY_PATH=opt/instantclient\_11\_2/lib:$LD_LIBRARY_PATH |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
192 export PATH=opt/instantclient\_11\_2:$PATH |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
193 \end{lstlisting} |
|
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
194 |
|
5877
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
195 Damit alle in den UTF8-codierten SQL-Skripten vorhandenen Zeichen (also z.B.\ |
|
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
196 auch Umlaute) korrekt in die Datenbank eingelesen werden k�nnen, f�hren |
|
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
197 Sie folgenden Befehl aus: |
|
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
198 |
|
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
199 \begin{lstlisting} |
|
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
200 export NLS_LANG=.AL32UTF8 |
|
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
201 \end{lstlisting} |
|
7e48f7a64182
document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
202 |
|
5065
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
203 Nun erstellen Sie das Schema: |
|
3667
9b08db037ee5
Fixes and structural changes in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3661
diff
changeset
|
204 |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
205 \begin{lstlisting} |
|
3672
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
206 sqlplus benutzername/passwort @schema/oracle.sql |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
207 sqlplus benutzername/passwort @schema/oracle-minfo.sql |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
208 sqlplus benutzername/passwort @schema/oracle-spatial.sql |
|
1cb3b9708d99
Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3668
diff
changeset
|
209 sqlplus benutzername/passwort @schema/oracle-spatial_idx.sql |
|
3661
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
210 \end{lstlisting} |
|
3ea5e835ecce
Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
211 |
|
5065
a56efdfcab17
Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents:
3682
diff
changeset
|
212 |