Einführung in LAMP

<body background="../../../images/top.png" bgcolor="#FFFFFF"> <table width="100%" cellspacing="0" cellpadding="0" summary=""> <tr> <td align="left" valign="top" rowspan="2" width="99%"><img src="../../../images/toptext_Johannes-Linux-talks.png" alt= "Johannes Linux talks" width="348" height="53" /></td> <td rowspan="2" align="center" valign="bottom"><img src="../../../images/dieseseite.en.png" alt="This page:" width="59" height="19" /></td> <td rowspan="2"><img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border="0" /></td> <td align="center" valign="top"><a href="lamp_inhalt.en.html" target="_parent"><img src="../../../images/empty.png" alt="no frames" border="0" width="23" height="30" /></a></td> <td rowspan="2"><img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border="0" /></td> <td align="center" valign="top"> <div title="Size: 144 kB"><a href="lamp.en.pdf" target="_blank"><img src="../../../images/pdffile.png" alt="-->" border="0" width="30" height="30" /></a></div> </td> <td rowspan="2"><img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border="0" /></td> <td align="center" valign="top"><a href="lamp.de.html" target="_top"><img src="../../../images/germanflag.png" alt= "-->" border="0" width="27" height="23" /></a></td> </tr> <tr> <td align="center" valign="bottom"><script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <a href="lamp_inhalt.en.html" target="_parent" onmouseover= "ro_imgOver('ro_img_unknown1', 'without frameset'); return true" onmouseout= "ro_imgNormal('ro_img_unknown1'); return true" onfocus="ro_imgOver('ro_img_unknown1', 'without frameset'); return true" onblur="ro_imgNormal('ro_img_unknown1'); return true"><img name="ro_img_unknown1" src= "../../../images/noframes-std.en.png" alt="without frameset" width="95" height="19" border="0" /></a></td> <td align="center" valign="bottom"> <div title="Size: 144 kB"><script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <a href="lamp.en.pdf" target="_blank" onmouseover="ro_imgOver('ro_img_unknown2', 'save as PDF'); return true" onmouseout="ro_imgNormal('ro_img_unknown2'); return true" onfocus= "ro_imgOver('ro_img_unknown2', 'save as PDF'); return true" onblur= "ro_imgNormal('ro_img_unknown2'); return true"><img name="ro_img_unknown2" src="../../../images/PDF-std.en.png" alt= "save as PDF" width="71" height="19" border="0" /></a></div> </td> <td align="center" valign="bottom"><script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <a href="lamp.de.html" target="_top" onmouseover="ro_imgOver('ro_img_unknown3', 'auf Deutsch'); return true" onmouseout="ro_imgNormal('ro_img_unknown3'); return true" onfocus= "ro_imgOver('ro_img_unknown3', 'auf Deutsch'); return true" onblur= "ro_imgNormal('ro_img_unknown3'); return true"><img name="ro_img_unknown3" src="../../../images/Sprache-std.en.png" alt="auf Deutsch" width="69" height="19" border="0" /></a></td> </tr> </table> <p align="center"><img src="linux/Tux_bg.png" alt="" width="265" height="314" /></p> <div align="center"> <h1 class="subject">Einführung in LAMP</h1> </div> <br /> <p align="center"><strong>Johannes Franken<br /></strong><kbd><jfranken@jfranken.de></kbd></p> <br /> <br /> <br /> <table summary=""> <tr> <td bgcolor="#FFAAAA" class="border"><strong>Caution:</strong><br /> Please note: This document is available in german only. An english translation for this document is in progress</td> </tr> </table>  <h1>Contents</h1> <ol type="1"> <li><a href="#ToC1"><strong>Übersicht</strong></a></li> <li><a href="#ToC2"><strong>MySQL</strong></a> <ol type="a"> <li><a href="#ToC3"><strong>Relationale Datenbank-Management-Systeme (RDBMS)</strong></a></li> <li><a href="#ToC4"><strong>(My)SQL-Befehle</strong></a> <ol type="i"> <li><a href="#ToC5"><strong>Tabellen einrichten (DDL, DCL, control)</strong></a></li> <li><a href="#ToC6"><strong>Mit Tabellen arbeiten (DML)</strong></a></li> </ol> </li> <li><a href="#ToC7"><strong>Benutzerrechte</strong></a></li> </ol> </li> <li><a href="#ToC8"><strong>Apache</strong></a> <ol type="a"> <li><a href="#ToC9"><strong>HTML</strong></a></li> <li><a href="#ToC10"><strong>Webserver und HTTP</strong></a></li> <li><a href="#ToC11"><strong>Apache</strong></a> <ol type="i"> <li><a href="#ToC12"><strong>CGI-Skripte</strong></a></li> <li><a href="#ToC13"><strong>Module</strong></a></li> <li><a href="#ToC14"><strong>Virtual Hosting</strong></a></li> </ol> </li> </ol> </li> <li><a href="#ToC15"><strong>PHP</strong></a> <ol type="a"> <li><a href="#ToC16"><strong>Sprache</strong></a></li> <li><a href="#ToC17"><strong>Kleine Datenbankanwendung</strong></a></li> </ol> </li> </ol>  <h1><a name="ToC1">Übersicht</a></h1> "LAMP" steht für <ol> <li><strong>L</strong>inux</li> <li><strong>A</strong>pache</li> <li><strong>M</strong>ySQL</li> <li><strong>P</strong>HP (oder Perl)</li> </ol> <p align="center"><img src="linux/lamp.png" alt="" width="300" height="256" /><br /> <em>Figure: LAMP-Architektur</em></p> <h1><a name="ToC2">MySQL</a></h1> <h2><a name="ToC3">Relationale Datenbank-Management-Systeme (RDBMS)</a></h2> <p align="center"><img src="linux/mysqld.png" alt="" width="300" height="311" /><br /> <em>Figure: MySQL-Server</em></p> Vorteile DBMS vs. direktem Dateizugriff: <ul> <li>Zentralisierung des Datenzugriffs (DBMS kümmert sich um Netzzugriff, Locks, Caches u.s.w. -- nicht jede Anwendung selbst)</li> <li>Höhere Funktionalität (SQL)</li> <li>Unabhängig von physischer Speicherung der Daten</li> <li>...</li> </ul> Konzept RDBMS: <ul> <li>Datenbanken</li> <li>Tabellen</li> <li>Spalten (=Eigenschaften =Attribute)</li> <li>Werte (=Eigenschaftswerte =Attributswerte)</li> <li>Zeilen (=Tupel =Datensätze)</li> <li>Referenzen (=Verweise =Fremdschlüssel)</li> <li>Abgeschlossenheit (Tabellendefinitionen und Zugriffsrechte innerhalb des DBMS)</li> <li>Abfragen (über spezielle Abfragesprache, z.B. SQL): <ul> <li>Selektion (zeilenweise)</li> <li>Projektion (spaltenweise)</li> <li>Join (Verbindung mehrerer Tabellen an Hand gemeinsamen Wertes)</li> </ul> </li> </ul> <br /> <table summary=""> <tr> <td bgcolor="#FFFFAA" class="border"><strong>More about "RDBMS":</strong><br /> siehe <a target="_blank" href= "http://de.wikipedia.org/wiki/Relationale_Datenbank">http://de.wikipedia.org/wiki/Relationale_Datenbank</a></td> </tr> </table> <br /> Referenzen: <ul> <li>1:1, 1:c</li> <li>1:m(c)</li> <li>m:n (schlecht)</li> </ul> <br /> Normalformen: <ul> <li>Ziel: Schutz vor Redundanzen und Inkonsistenzen</li> <li>Hierzu zerlegt man das Datenmodell in mehrere Tabellen, die zueinander in Beziehung stehen. Dabei geht man gewöhnlich in drei Schritten vor: <ol> <li><strong>Erste Normalform</strong>: Alle Spalten sind atomar, Werte beziehen sich auf einen Primärschlüssel</li> <li><strong>Zweite Normalform</strong>: zusätzlich (bei zusammengesetzten Primärschlüsseln): alle Werte nur vom kompletten Primärschlüssel abhängig</li> <li><strong>Dritte Normalform</strong>: zusätzlich: transitive Abhängigkeiten beseitigt (Werte nur vom Primärschlüssel abhängig)</li> </ol> </li> </ul> <br /> <table summary=""> <tr> <td bgcolor="#FFFFAA" class="border"><strong>More about Datenbank-Normalisierung:</strong><br /> Beispiele auf <a target="_blank" href= "http://de.wikipedia.org/wiki/Normalisierung_%28Datenbank%29">http://de.wikipedia.org/wiki/Normalisierung_%28Datenbank%29</a></td> </tr> </table> <h2><a name="ToC4">(My)SQL-Befehle</a></h2> Man unterscheidet zwischen <ul> <li>Data Defininition Language (DDL)</li> <li>Data Modification Language (DML)</li> <li>Data Control Language (DCL)</li> <li>Kommandos zur Steuerung der eigenen Datenbanksitzung (control)</li> </ul> Beispiele: <h3><a name="ToC5">Tabellen einrichten (DDL, DCL, control)</a></h3> <ul> <li>Datenbanken anlegen und löschen:<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> $ <strong>mysql -uroot -p</strong> mysql> <strong>drop database test;</strong> Query OK, 1 row affected (0.01 sec) mysql> <strong>create database test;</strong> Query OK, 1 row affected (0.00 sec) mysql> <strong>exit</strong> </pre></td> </tr> </table> <em>Listing: DROP DATABASE (DDL)</em></div> <br /></li> <li>Einem User Zugriffsrechte auf eine Datenbank einräumen und entziehen:<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> $ <strong>mysql -uroot -p</strong> mysql> <strong>grant select,insert,update,delete,drop,alter,create on test.* to 'testuser'@'localhost' identified by 'testpw';</strong> Query OK, 0 rows affected (0.00 sec) mysql> <strong>revoke alter on test.* from 'testuser'@'localhost';</strong> Query OK, 0 rows affected (0.00 sec) mysql> <strong>exit</strong> </pre></td> </tr> </table> <em>Listing: GRANT, REVOKE (DCL)</em></div> <br /></li> <li>Als User mit dem DBMS verbinden, die erreichbaren Datenbanken auflisten und eine Datenbank auswählen:<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> $ <strong>mysql -utestuser -ptestpw</strong> Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14374 to server version: 4.1.12 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> <strong>show databases;</strong> +----------+ | Database | +----------+ | test | +----------+ 1 row in set (0.00 sec) mysql> <strong>use test</strong> Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A </pre></td> </tr> </table> <em>Listing: show databases, use (control)</em></div> <br /></li> <li>Eine neue Tabelle anlegen (innerhalb der Datenbank):<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> mysql> <strong>create table tab1 (id int, vorname char(30), nachname char(30) );</strong> Query OK, 0 rows affected (0.00 sec) </pre></td> </tr> </table> <em>Listing: CREATE TABLE (DDL)</em></div> <br /></li> <li>eine Tabelle löschen (inkl. aller ggf. darin enthaltenen Datensätze):<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> mysql> <strong>drop table tab1;</strong> Query OK, 0 rows affected (0.00 sec) </pre></td> </tr> </table> <em>Listing: DROP TABLE (DDL)</em></div> <br /> (bitte jetzt noch nicht ausführen)</li> <li>Tabellen der aktuellen Datenbank auflisten (Namen und Eigenschaften):<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> mysql> <strong>show tables;</strong> +----------------+ | Tables_in_test | +----------------+ | tab1 | +----------------+ 1 row in set (0.00 sec) mysql> <strong>describe tab1;</strong> +----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+----------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | vorname | char(30) | YES | | NULL | | | nachname | char(30) | YES | | NULL | | +----------+----------+------+-----+---------+-------+ 3 rows in set (0.00 sec) </pre></td> </tr> </table> <em>Listing: show, describe (control)</em></div> <br /></li> </ul> <h3><a name="ToC6">Mit Tabellen arbeiten (DML)</a></h3> <ul> <li>Datensätze in eine Tabelle einfügen:<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> mysql> <strong>insert into tab1 (id,nachname,vorname) values (1,'Mueller','Hans'), (2,'Meier','Gudrun');</strong> Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 </pre></td> </tr> </table> <em>Listing: INSERT (DML)</em></div> <br /></li> <li>Datensätze aus einer Tabelle abfragen:<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> mysql> <strong>select * from tab1;</strong> +------+---------+----------+ | id | vorname | nachname | +------+---------+----------+ | 1 | Hans | Mueller | | 2 | Gudrun | Meier | +------+---------+----------+ 2 rows in set (0.00 sec) mysql> <strong>select nachname from tab1 where vorname='Hans';</strong> +----------+ | nachname | +----------+ | Mueller | +----------+ 1 row in set (0.00 sec) </pre></td> </tr> </table> <em>Listing: SELECT (DML)</em></div> <br /></li> <li>Datensätze in einer Tabelle verändern:<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> mysql> <strong>update tab1 set nachname='Meier-Schulze' where vorname='Gudrun' and nachname='Meier';</strong> Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 </pre></td> </tr> </table> <em>Listing: UPDATE (DML)</em></div> <br /></li> <li>Datensätze aus einer Tabelle löschen:<br /> <div align="center"> <table summary=""> <tr> <td bgcolor="#DDDDFF" class="border" align="left"> <pre> mysql> <strong>delete from tab1 where vorname='Alfons' and nachname='Schubert';</strong> Query OK, 0 rows affected (0.00 sec) mysql> <strong>delete from tab1 where id=3;</strong> Query OK, 0 rows affected (0.00 sec) mysql> <strong>truncate table tab1;</strong> Query OK, 0 rows affected (0.00 sec) </pre></td> </tr> </table> <em>Listing: DELETE, TRUNCATE (DML)</em></div> <br /></li> </ul> <h2><a name="ToC7">Benutzerrechte</a></h2> mysql-Datenbank <p>Berechtigungen auf</p> <ul> <li>Server-Ebene (connect, global)</li> <li>Datenbanken</li> <li>Tabellen</li> <li>(Spalten)</li> </ul> <h1><a name="ToC8">Apache</a></h1> <h2><a name="ToC9">HTML</a></h2> <p align="center"><img src="tcpip2/html.png" alt="" width="640" height="231" /><br /> <em>Figure: HTML-Quelltext</em></p> <p>Das Standardwerk gibt es kostenlos unter <a target="_blank" href= "http://de.selfhtml.org/">http://de.selfhtml.org/</a></p> <h2><a name="ToC10">Webserver und HTTP</a></h2> A "webserver" is a program, which receives an HTTP-query (e.g. from some webbrowser over an internet) and sends back data provided for the queried URL. This data can be either <ol> <li>static (stored in files) or</li> <li>dynamic (generated by other programs).</li> </ol> <p>The first webserver ("W3 demon") was developed by Tim Berners-Lee in 1989. Today, there are hundreds of implementations, which differ in their</p> <ul> <li>speed of operation</li> <li>dependability</li> <li>expandability and</li> <li>their supported operating systems.</li> </ul> <br /> <table summary=""> <tr> <td bgcolor="#FFFFAA" class="border"><strong>More about:</strong><br /> see <ul> <li><a target="_blank" href="http://www.ietf.org/rfc/rfc2616.txt">http://www.ietf.org/rfc/rfc2616.txt</a> (HTTP/1.1-Protokoll)</li> <li><a target="_blank" href="http://en.wikipedia.org/wiki/Webserver">http://en.wikipedia.org/wiki/Webserver</a></li> </ul> </td> </tr> </table> <p align="center"><img src="tcpip2/www1.png" alt="" width="640" height="201" /><br /> <em>Figure: HTTP Beispiel</em></p> <p align="center"><img src="tcpip1/http2.png" alt="" width="640" height="314" /><br /> <em>Figure: HTTP Beispiel</em></p> <p align="center"><img src="tcpip2/www2.png" alt="" width="640" height="178" /><br /> <em>Figure: Proxyserver</em></p> <h2><a name="ToC11">Apache</a></h2> Apache is open source software, works most efficiently and reliably. Its modular design leads to a wide scope of services, which surpass every other webserver on the market. So it's no wonder, that about 60% of all websites are running on Apache.<br /> <table summary=""> <tr> <td bgcolor="#FFFFAA" class="border"><strong>More about "Apache":</strong><br /> A short overview on the apache webserver is available at <a target="_blank" href= "http://en.wikipedia.org/wiki/Apache_HTTP_Server">Wikipedia</a> and <a target="_blank" href= "http://httpd.apache.org/docs/misc/FAQ.html">Apache Foundation</a>.</td> </tr> </table> <br /> <table summary=""> <tr> <td bgcolor="#FFFFAA" class="border"><strong>More about "Apache-Konfiguration":</strong><br /> siehe <a href="apache.en.html" target="_parent">Debian/Apache HowTo</a></td> </tr> </table> <h3><a name="ToC12">CGI-Skripte</a></h3> <p align="center"><img src="tcpip2/cgi.png" alt="" width="640" height="268" /><br /> <em>Figure: CGI-Skript</em></p> <h3><a name="ToC13">Module</a></h3> z.B. PHP <h3><a name="ToC14">Virtual Hosting</a></h3> <p align="center"><img src="tcpip2/hosting.png" alt="" width="640" height="294" /><br /> <em>Figure: VirtualHost Definition</em></p> <h1><a name="ToC15">PHP</a></h1> <h2><a name="ToC16">Sprache</a></h2> siehe <a target="_blank" href="http://www.php.net/manual/de/langref.php">http://www.php.net/manual/de/langref.php</a> <h2><a name="ToC17">Kleine Datenbankanwendung</a></h2> <a href="linux/phptest.tgz" target="_blank"><img src="../../../images/disk.png" border="0" alt="download:" width="20" height="20" />phptest.tgz [73 kB]</a> <p align="center"><img src="linux/includes.png" alt="" width="300" height="231" /><br /> <em>Figure: Includes</em></p> <div class="noprint"> <hr /> <table width="100%" summary=""> <tr> <td align="left" valign="middle"><font size="-2">$Id: lamp.wml,v 1.4 2009-09-30 19:45:14 jfranken Exp $ <a href= "lamp.log.html">[ChangeLog]</a><br /> $Id: template.inc,v 1.81 2009-09-07 19:26:07 jfranken Exp $ <a href="../../../template.log.html">[ChangeLog]</a><br /> © Johannes Franken. <a href="../../../impressum/rechtliches.en.html" target="_parent">Imprint and disclaimer</a></font></td> <td align="right" valign="middle"><a href="http://validator.w3.org/check/referer" target="w3c"><img border="0" src= "../../../images/valid-xhtml10.png" alt="Valid XHTML 1.0!" width="88" height="31" /></a></td> </tr> </table> </div> <hr /> <h1>Navigation:</h1> <font size="1"><script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <a href="../../../startseite.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_startseite', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_startseite'); return true" onfocus="nb_imgOver('nb_img1_startseite', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_startseite'); return true"><img name="nb_img1_startseite" src= "../../../images/startseite-std.en.png" border="0" alt="Home" width="52" height="26" /></a><br /> <a href="../../../unternehmen.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_unternehmen', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_unternehmen'); return true" onfocus="nb_imgOver('nb_img1_unternehmen', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_unternehmen'); return true"><img name="nb_img1_unternehmen" src= "../../../images/unternehmen-std.en.png" border="0" alt="Company" width="80" height="26" /></a><br /> <a href="../../../homepages.en.html" target="_top" onmouseover="nb_imgOver('nb_img1_homepages', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_homepages'); return true" onfocus= "nb_imgOver('nb_img1_homepages', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_homepages'); return true"><img name="nb_img1_homepages" src= "../../../images/homepages-std.en.png" border="0" alt="Homepages" width="98" height="26" /></a> <script type= "text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script><br /> <img src="../../../images/transparentpixel.png" alt=" " width="10" height="1" align="bottom" border="0" /><a href= "../../../homepages/johannes.en.html" target="_top" onmouseover="nb_imgOver('nb_img1_johannes', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_johannes'); return true" onfocus="nb_imgOver('nb_img1_johannes', 0, ''); return true" onblur="nb_imgNormal('nb_img1_johannes'); return true"><img name="nb_img1_johannes" src= "../../../images/johannes-std.en.png" border="0" alt="Johannes" width="76" height="26" /></a> <script type= "text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_vortraege', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_vortraege'); return true" onfocus="nb_imgOver('nb_img1_vortraege', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_vortraege'); return true"><img name="nb_img1_vortraege" src= "../../../images/vortraege-std.en.png" border="0" alt="Talks" width="46" height="26" /></a> <script type= "text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/apache.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_apache', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_apache'); return true" onfocus= "nb_imgOver('nb_img1_apache', 0, ''); return true" onblur="nb_imgNormal('nb_img1_apache'); return true"><img name= "nb_img1_apache" src="../../../images/apache-std.en.png" border="0" alt="apache" width="58" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/bind.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_bind', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_bind'); return true" onfocus= "nb_imgOver('nb_img1_bind', 0, ''); return true" onblur="nb_imgNormal('nb_img1_bind'); return true"><img name= "nb_img1_bind" src="../../../images/bind-std.en.png" border="0" alt="bind" width="35" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/flypaper.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_flypaper', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_flypaper'); return true" onfocus="nb_imgOver('nb_img1_flypaper', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_flypaper'); return true"><img name="nb_img1_flypaper" src="../../../images/flypaper-std.en.png" border="0" alt="flypaper" width="66" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/lsof.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_lsof', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_lsof'); return true" onfocus= "nb_imgOver('nb_img1_lsof', 0, ''); return true" onblur="nb_imgNormal('nb_img1_lsof'); return true"><img name= "nb_img1_lsof" src="../../../images/lsof-std.en.png" border="0" alt="lsof" width="29" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/linux1.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_linux1', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_linux1'); return true" onfocus= "nb_imgOver('nb_img1_linux1', 0, ''); return true" onblur="nb_imgNormal('nb_img1_linux1'); return true"><img name= "nb_img1_linux1" src="../../../images/linux1-std.en.png" border="0" alt="Linux 1" width="61" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/linux2.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_linux2', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_linux2'); return true" onfocus= "nb_imgOver('nb_img1_linux2', 0, ''); return true" onblur="nb_imgNormal('nb_img1_linux2'); return true"><img name= "nb_img1_linux2" src="../../../images/linux2-std.en.png" border="0" alt="Linux 2" width="62" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/linux3.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_linux3', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_linux3'); return true" onfocus= "nb_imgOver('nb_img1_linux3', 0, ''); return true" onblur="nb_imgNormal('nb_img1_linux3'); return true"><img name= "nb_img1_linux3" src="../../../images/linux3-std.en.png" border="0" alt="Linux 3" width="62" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/vi.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_vi', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_vi'); return true" onfocus= "nb_imgOver('nb_img1_vi', 0, ''); return true" onblur="nb_imgNormal('nb_img1_vi'); return true"><img name="nb_img1_vi" src="../../../images/vi-std.en.png" border="0" alt="vi" width="15" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><img src="../../../images/lamp-sel.en.png" alt="LAMP*" width="58" height="26" /><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/make.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_make', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_make'); return true" onfocus= "nb_imgOver('nb_img1_make', 0, ''); return true" onblur="nb_imgNormal('nb_img1_make'); return true"><img name= "nb_img1_make" src="../../../images/make-std.en.png" border="0" alt="make" width="48" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/mirroring.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_mirroring', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_mirroring'); return true" onfocus="nb_imgOver('nb_img1_mirroring', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_mirroring'); return true"><img name="nb_img1_mirroring" src= "../../../images/mirroring-std.en.png" border="0" alt="Mirroring" width="78" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/netcat.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_netcat', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_netcat'); return true" onfocus= "nb_imgOver('nb_img1_netcat', 0, ''); return true" onblur="nb_imgNormal('nb_img1_netcat'); return true"><img name= "nb_img1_netcat" src="../../../images/netcat-std.en.png" border="0" alt="netcat" width="55" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/ntpd.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_ntpd', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_ntpd'); return true" onfocus= "nb_imgOver('nb_img1_ntpd', 0, ''); return true" onblur="nb_imgNormal('nb_img1_ntpd'); return true"><img name= "nb_img1_ntpd" src="../../../images/ntpd-std.en.png" border="0" alt="Time-sync" width="86" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/rcs.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_rcs', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_rcs'); return true" onfocus= "nb_imgOver('nb_img1_rcs', 0, ''); return true" onblur="nb_imgNormal('nb_img1_rcs'); return true"><img name= "nb_img1_rcs" src="../../../images/rcs-std.en.png" border="0" alt="rcs" width="25" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/squid.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_squid', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_squid'); return true" onfocus= "nb_imgOver('nb_img1_squid', 0, ''); return true" onblur="nb_imgNormal('nb_img1_squid'); return true"><img name= "nb_img1_squid" src="../../../images/squid-std.en.png" border="0" alt="squid" width="42" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/solaris.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_solaris', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_solaris'); return true" onfocus= "nb_imgOver('nb_img1_solaris', 0, ''); return true" onblur="nb_imgNormal('nb_img1_solaris'); return true"><img name= "nb_img1_solaris" src="../../../images/solaris-std.en.png" border="0" alt="Solaris" width="52" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/ssh1.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_ssh1', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_ssh1'); return true" onfocus= "nb_imgOver('nb_img1_ssh1', 0, ''); return true" onblur="nb_imgNormal('nb_img1_ssh1'); return true"><img name= "nb_img1_ssh1" src="../../../images/ssh1-std.en.png" border="0" alt="ssh 1" width="41" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/ssh2.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_ssh2', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_ssh2'); return true" onfocus= "nb_imgOver('nb_img1_ssh2', 0, ''); return true" onblur="nb_imgNormal('nb_img1_ssh2'); return true"><img name= "nb_img1_ssh2" src="../../../images/ssh2-std.en.png" border="0" alt="ssh 2" width="42" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/ssh3.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_ssh3', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_ssh3'); return true" onfocus= "nb_imgOver('nb_img1_ssh3', 0, ''); return true" onblur="nb_imgNormal('nb_img1_ssh3'); return true"><img name= "nb_img1_ssh3" src="../../../images/ssh3-std.en.png" border="0" alt="ssh 3" width="42" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/tcpip1.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_tcpip1', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_tcpip1'); return true" onfocus= "nb_imgOver('nb_img1_tcpip1', 0, ''); return true" onblur="nb_imgNormal('nb_img1_tcpip1'); return true"><img name= "nb_img1_tcpip1" src="../../../images/tcpip1-std.en.png" border="0" alt="tcp/ip 1" width="67" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="   " width="30" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/vortraege/tcpip2.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_tcpip2', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_tcpip2'); return true" onfocus= "nb_imgOver('nb_img1_tcpip2', 0, ''); return true" onblur="nb_imgNormal('nb_img1_tcpip2'); return true"><img name= "nb_img1_tcpip2" src="../../../images/tcpip2-std.en.png" border="0" alt="tcp/ip 2" width="68" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/books.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_books', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_books'); return true" onfocus= "nb_imgOver('nb_img1_books', 0, ''); return true" onblur="nb_imgNormal('nb_img1_books'); return true"><img name= "nb_img1_books" src="../../../images/books-std.en.png" border="0" alt="Books" width="54" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/j_fotos.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_j_fotos', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_j_fotos'); return true" onfocus= "nb_imgOver('nb_img1_j_fotos', 0, ''); return true" onblur="nb_imgNormal('nb_img1_j_fotos'); return true"><img name= "nb_img1_j_fotos" src="../../../images/j_fotos-std.en.png" border="0" alt="Photos" width="60" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/leisure.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_leisure', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_leisure'); return true" onfocus= "nb_imgOver('nb_img1_leisure', 0, ''); return true" onblur="nb_imgNormal('nb_img1_leisure'); return true"><img name= "nb_img1_leisure" src="../../../images/leisure-std.en.png" border="0" alt="Leisure" width="58" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/j_humor.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_j_humor', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_j_humor'); return true" onfocus= "nb_imgOver('nb_img1_j_humor', 0, ''); return true" onblur="nb_imgNormal('nb_img1_j_humor'); return true"><img name= "nb_img1_j_humor" src="../../../images/j_humor-std.en.png" border="0" alt="Humor" width="60" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/kenntnisse.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_kenntnisse', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_kenntnisse'); return true" onfocus="nb_imgOver('nb_img1_kenntnisse', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_kenntnisse'); return true"><img name="nb_img1_kenntnisse" src= "../../../images/kenntnisse-std.en.png" border="0" alt="Experiences" width="97" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/j_lebenslauf.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_j_lebenslauf', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_j_lebenslauf'); return true" onfocus="nb_imgOver('nb_img1_j_lebenslauf', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_j_lebenslauf'); return true"><img name="nb_img1_j_lebenslauf" src= "../../../images/j_lebenslauf-std.en.png" border="0" alt="Vitae" width="45" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/j_wunschliste.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_j_wunschliste', 0, ''); return true" onmouseout= "nb_imgNormal('nb_img1_j_wunschliste'); return true" onfocus="nb_imgOver('nb_img1_j_wunschliste', 0, ''); return true" onblur="nb_imgNormal('nb_img1_j_wunschliste'); return true"><img name="nb_img1_j_wunschliste" src= "../../../images/j_wunschliste-std.en.png" border="0" alt="Wishlist" width="64" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt="  " width="20" height="1" align="bottom" border= "0" /><a href="../../../homepages/johannes/j_pgp.en.html" target="_top" onmouseover= "nb_imgOver('nb_img1_j_pgp', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_j_pgp'); return true" onfocus= "nb_imgOver('nb_img1_j_pgp', 0, ''); return true" onblur="nb_imgNormal('nb_img1_j_pgp'); return true"><img name= "nb_img1_j_pgp" src="../../../images/j_pgp-std.en.png" border="0" alt="PGP" width="42" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt=" " width="10" height="1" align="bottom" border="0" /><a href= "../../../homepages/beate.en.html" target="_top" onmouseover="nb_imgOver('nb_img1_beate', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_beate'); return true" onfocus="nb_imgOver('nb_img1_beate', 0, ''); return true" onblur="nb_imgNormal('nb_img1_beate'); return true"><img name="nb_img1_beate" src="../../../images/beate-std.en.png" border="0" alt="Beate" width="51" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt=" " width="10" height="1" align="bottom" border="0" /><a href= "../../../homepages/sarah.en.html" target="_top" onmouseover="nb_imgOver('nb_img1_sarah', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_sarah'); return true" onfocus="nb_imgOver('nb_img1_sarah', 0, ''); return true" onblur="nb_imgNormal('nb_img1_sarah'); return true"><img name="nb_img1_sarah" src="../../../images/sarah-std.en.png" border="0" alt="Sarah" width="48" height="26" /></a><br /> <img src="../../../images/transparentpixel.png" alt=" " width="10" height="1" align="bottom" border="0" /><a href= "../../../homepages/hannah.en.html" target="_top" onmouseover="nb_imgOver('nb_img1_hannah', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_hannah'); return true" onfocus="nb_imgOver('nb_img1_hannah', 0, ''); return true" onblur="nb_imgNormal('nb_img1_hannah'); return true"><img name="nb_img1_hannah" src="../../../images/hannah-std.en.png" border="0" alt="Hannah" width="64" height="26" /></a><br /> <a href="../../../gaestebuch.en.html" target="_top" onmouseover="nb_imgOver('nb_img1_gaestebuch', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_gaestebuch'); return true" onfocus= "nb_imgOver('nb_img1_gaestebuch', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_gaestebuch'); return true"><img name="nb_img1_gaestebuch" src= "../../../images/gaestebuch-std.en.png" border="0" alt="Guestbook" width="91" height="26" /></a><br /> <a href="../../../impressum.en.html" target="_top" onmouseover="nb_imgOver('nb_img1_impressum', 0, ''); return true" onmouseout="nb_imgNormal('nb_img1_impressum'); return true" onfocus= "nb_imgOver('nb_img1_impressum', 0, ''); return true" onblur= "nb_imgNormal('nb_img1_impressum'); return true"><img name="nb_img1_impressum" src= "../../../images/impressum-std.en.png" border="0" alt="About" width="54" height="26" /></a></font><br /> <br /> <br /> <form method="get" action="http://www.google.com/custom" target="jfrankeninhalt"><img src= "../../../images/transparentpixel.png" alt=" " width="190" height="2" align="bottom" border="0" /><br /> <img src="../../../images/transparentpixel.png" alt=" " width="8" height="1" align="bottom" border="0" /><img src= "../../../images/google16x16.png" alt="" width="16" height="19" /><img src="../../../images/transparentpixel.png" alt= " " width="8" height="1" align="bottom" border="0" /><input type="image" name="sa" value="Search" src= "../../../images/Suche.en.png" alt="Search:" /><br /> <img src="../../../images/transparentpixel.png" alt=" " width="32" height="1" align="bottom" border="0" /><input type= "text" name="q" size="10" maxlength="255" value="" style= "color:#ddddff;border-color:#ddddff;background:#112277" /><input type="hidden" name="cof" value= "T:000000;LW:540;ALC:112277;L:http://www.jfranken.de/images/toptext_FRANKEN--IT-CONCEPTS.png;LC:112277;LH:53;BGC:ffffff;AH:left;VLC:112277;AWFID:ec81011eb1f53f99;" /><input type="hidden" name="domains" value="www.jfranken.de" /><br /> <input type="hidden" name="sitesearch" value="www.jfranken.de" /></form> <script type="text/javascript" language="JavaScript"> //<![CDATA[ function ro_imgNormal(imgName) { if (document.images) { document[imgName].src = eval(imgName + '_n.src'); self.status = ''; } } function ro_imgOver(imgName, descript) { if (document.images) { document[imgName].src = eval(imgName + '_o.src'); self.status = descript; } } //]]> </script><br /> <img src="../../../images/transparentpixel.png" alt=" " width="190" height="2" align="bottom" border="0" /><br /> <img src="../../../images/transparentpixel.png" alt=" " width="8" height="1" align="bottom" border="0" /><img src= "../../../images/feed-icon-16x16.png" alt="" width="16" height="19" /><img src="../../../images/transparentpixel.png" alt=" " width="8" height="1" align="bottom" border="0" /><img src="../../../images/NewsFeeds.png" alt="NewsFeeds" width="67" height="19" /><br /> <img src="../../../images/transparentpixel.png" alt=" " width="32" height="1" align="bottom" border="0" /> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script><a href="http://www.jfranken.de/feed-rss2.en.xml" target="_blank" onmouseover= "ro_imgOver('ro_img_unknown4', 'RSS2-Feed'); return true" onmouseout="ro_imgNormal('ro_img_unknown4'); return true" onfocus="ro_imgOver('ro_img_unknown4', 'RSS2-Feed'); return true" onblur= "ro_imgNormal('ro_img_unknown4'); return true"><img name="ro_img_unknown4" src="../../../images/feed-rss2.png" alt= "RSS2-Feed" width="70" height="15" border="0" /></a><br /> <img src="../../../images/transparentpixel.png" alt=" " width="32" height="1" align="bottom" border="0" /> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script><a href="http://www.jfranken.de/feed-atom1.en.xml" target="_blank" onmouseover= "ro_imgOver('ro_img_unknown5', 'ATOM1-Feed'); return true" onmouseout="ro_imgNormal('ro_img_unknown5'); return true" onfocus="ro_imgOver('ro_img_unknown5', 'ATOM1-Feed'); return true" onblur= "ro_imgNormal('ro_img_unknown5'); return true"><img name="ro_img_unknown5" src="../../../images/feed-atom1.png" alt= "ATOM1-Feed" width="70" height="15" border="0" /></a><br /> <img src="../../../images/transparentpixel.png" alt=" " width="32" height="1" align="bottom" border="0" /> <script type="text/javascript" language="JavaScript"> //<![CDATA[  //]]> </script><a href="../../../impressum/feeds.en.html" target="_parent" onmouseover= "ro_imgOver('ro_img_unknown6', 'Subscribe'); return true" onmouseout="ro_imgNormal('ro_img_unknown6'); return true" onfocus="ro_imgOver('ro_img_unknown6', 'Subscribe'); return true" onblur= "ro_imgNormal('ro_img_unknown6'); return true"><img name="ro_img_unknown6" src="../../../images/Subscribe.en.png" alt= "Subscribe" width="65" height="19" border="0" /></a> </body>