Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- tachtler:mariadb_centos_7 [2018/04/27 05:52] – [SSL: Client-Zertifikat erstellen] klaus
+++ tachtler:mariadb_centos_7 [2018/04/27 06:38] (aktuell) – [SSL: Client-Zertifikat erstellen] klaus
@@ Zeile 1033: / Zeile 1033: @@
 Die Konfiguration beinhaltet
   - Erstellen einer **eignen CA** - **''MariaDB CA''**
-  - Erstellen eines **''self-signed''**-Zertifikats für den Server - **''MariaDB Server''**
+  - Erstellen eines **''self-signed''**-Zertifikats für den Server - **''db.idmz.tachtler.net''**
   - Erstellen eines **''self-signed''**-Zertifikats für den Client - **''MariaDB Client''**
@@ Zeile 1197: / Zeile 1197: @@
 Organization Name (eg, company) [Default Company Ltd]:Klaus Tachtler
 Organizational Unit Name (eg, section) []:.
-Common Name (eg, your name or your server's hostname) []:MariaDB Server
+Common Name (eg, your name or your server's hostname) []:db.idmz.tachtler.net
 Email Address []:hostmaster@tachtler.net
@@ Zeile 1268: / Zeile 1268: @@
 CA/emailAddress=hostmaster@tachtler.net
         Validity
-            Not Before: Apr 27 03:43:09 2018 GMT
+            Not Before: Apr 27 04:26:53 2018 GMT
-            Not After : Apr 23 03:43:09 2028 GMT
+            Not After : Apr 23 04:26:53 2028 GMT
-        Subject: C=DE, ST=Bayern (Bavaria), L=Muenchen (Munich), O=Klaus Tachtler, CN=MariaDB
+        Subject: C=DE, ST=Bayern (Bavaria), L=Muenchen (Munich), O=Klaus Tachtler,
-Server/emailAddress=hostmaster@tachtler.net
+CN=db.idmz.tachtler.net/emailAddress=hostmaster@tachtler.net
         Subject Public Key Info:
             Public Key Algorithm: rsaEncryption
                 Public-Key: (2048 bit)
                 Modulus:
-:ea:10:23:47:fb:c8:f0:fb:a0:c3:df:70:a7:ed:
+:c5:81:5c:95:da:2b:19:33:cc:61:ba:b3:ea:bb:
-                    aa:1b:55:18:7a:de:89:0b:d8:e4:d6:35:8c:d9:8f:
+:a2:40:69:bf:7f:5a:71:1f:af:a0:94:bb:17:11:
-:c2:18:b9:df:16:73:38:cd:3c:3c:a4:9d:8b:44:
+:b6:85:3b:06:a6:61:b1:88:50:a9:c0:a9:37:0c:
-                    ac:1f:33:92:e8:96:81:f3:33:57:e2:6f:9f:e3:b2:
+                    c9:30:5e:87:26:0e:32:35:02:14:b5:93:02:fb:5c:
-:a7:0b:6f:53:06:c2:27:78:22:59:5e:87:a2:f1:
+:57:f1:e0:d0:a7:5c:79:f0:74:39:3f:6e:5b:a7:
-e:a6:6c:75:5e:62:cf:4a:a0:4d:fb:b3:1f:92:f3:
+:bc:18:46:55:9f:78:43:4f:f2:69:17:b1:cb:da:
-                    f2:18:da:ba:0b:99:f5:a3:19:33:e6:38:bf:12:1f:
+d:6a:f5:90:03:1b:b2:f1:8c:19:0a:bc:47:d0:da:
-b:ef:5a:2b:65:3e:54:f3:fa:5b:95:54:09:d4:7f:
+:30:0f:63:6f:45:0b:30:8a:34:7f:70:50:90:9a:
-e:b1:01:43:2e:48:db:6d:cd:29:06:a8:ce:4e:5c:
+                    f6:93:82:e4:ec:a5:74:4b:a9:80:30:d4:4a:11:41:
-                    d0:8d:fc:4c:ef:10:5b:57:9b:29:53:3b:78:d1:5f:
+:64:76:03:cf:be:a4:cc:46:da:e0:95:20:8f:6c:
-c:ea:91:a7:d8:01:a1:41:4c:02:86:15:d9:e1:d2:
+:5c:95:ab:21:e6:3d:39:69:df:69:36:a6:d8:73:
-:2f:c9:a1:02:60:4a:d5:03:07:1e:f3:22:41:2c:
+c:d3:41:9e:51:72:0e:bf:c2:e7:7b:4b:da:e6:f9:
-e:68:6f:59:d2:d7:17:2d:4e:dc:e2:b7:97:82:8d:
+f:66:8e:ba:be:a4:59:a7:dc:13:d4:00:41:83:e4:
-                    d9:9e:eb:41:94:19:02:35:3c:6c:34:bc:1b:19:1c:
+                    d2:3f:c8:73:e7:00:ee:63:fd:f5:e8:79:41:0e:45:
-                    f2:49:c7:c1:67:1c:02:3b:e4:59:46:0d:52:04:8c:
+:d5:50:c7:14:0f:2a:1a:97:eb:e1:a0:18:d6:40:
-                    b7:a9:30:65:76:4a:38:d6:ea:fa:e8:24:ef:93:e3:
+c:07:0b:05:a9:72:c8:cd:a5:96:f1:c6:e1:39:04:
-:39:f1:33:bc:ba:f0:41:1d:33:c1:37:d5:ca:8c:
+                    ed:63:06:dc:8d:cd:30:90:e5:b4:2c:bd:de:b4:a6:
-:51
+:2a
                 Exponent: 65537 (0x10001)
     Signature Algorithm: sha256WithRSAEncryption
-a:26:f7:27:e9:c7:72:23:58:f9:b0:24:82:be:a1:90:5e:38:
+:c3:cb:a8:4e:4d:fe:82:78:18:72:6f:6d:76:7a:6b:64:25:
-:cc:cb:a2:ad:d6:e2:28:e9:0f:8c:46:60:e1:88:00:34:ee:
+         b6:f3:08:51:bd:19:f4:75:9e:bd:cc:05:50:d8:6b:2b:93:b5:
-         a9:82:79:59:76:55:23:b3:ea:f3:73:a2:14:90:78:d4:7b:4e:
+:02:44:ff:ee:4a:b8:a9:db:57:9e:66:9c:25:28:a1:a5:48:
-         b3:7c:24:10:45:0d:04:88:cb:47:68:b0:a8:51:ce:f2:47:de:
+e:4f:83:d4:1d:cd:c5:7e:4e:70:10:3a:9f:dd:dc:2d:82:c9:
-         ae:ce:6c:ae:48:6b:08:bd:17:4a:79:f9:28:cc:c4:da:ed:cf:
+         e5:55:84:27:50:51:93:07:06:5e:1f:ae:b2:2c:59:23:ff:4f:
-:3b:13:bb:19:41:a5:a9:8d:e3:32:3b:0e:17:ab:4c:42:3f:
+:c5:3f:65:07:fc:42:cd:5c:47:2f:2f:54:ca:8a:70:34:9e:
-:f1:24:e2:a4:e5:59:37:36:98:9a:00:b5:b0:da:9c:a4:1e:
+d:1d:bc:ec:35:9d:d0:7d:64:a5:65:16:9d:f2:77:e5:ee:a3:
-:62:83:94:3a:88:9d:02:fc:71:f5:13:b8:d4:67:33:a4:47:
+         f1:94:ec:f4:89:fe:a7:95:c6:27:38:6d:ef:44:90:90:03:70:
-         e2:a2:a2:65:1b:e2:ca:70:1b:4f:cf:7b:43:be:d4:17:f8:f3:
+         aa:cf:1d:57:0e:f1:2b:e5:09:ed:7d:c9:9e:c6:84:9a:77:5c:
-f:ea:41:56:ae:a8:e8:75:00:ec:da:41:53:6a:cb:fa:23:1e:
+d:9f:4a:d4:e5:43:00:a8:04:51:00:26:4a:23:3b:09:ed:b1:
-:2a:ab:7d:aa:af:72:a3:75:fd:23:b1:14:4d:e6:de:43:8b:
+a:1f:e8:62:09:5a:83:f6:43:4a:c9:53:4b:06:96:36:55:d1:
-         a4:6c:b7:0a:ed:97:44:b8:e6:f2:ac:b9:d9:eb:39:d1:f9:35:
+c:f7:1e:59:1a:c2:cb:82:6f:3e:c7:cb:53:9a:62:04:0d:38:
-:9e:c0:a2:29:5c:69:70:d6:99:af:d1:fb:b0:8b:4e:c9:71:
+         f7:98:95:0c:5e:9f:e3:69:39:a3:c7:e5:b1:e6:b6:5e:52:87:
-         f4:26:4f:2b:01:6f:c7:6e:a7:45:a7:2a:80:10:a7:3d:2a:a4:
+:05:a2:ba:b0:12:c9:01:9b:0c:38:97:2c:0d:55:3e:06:ef:
-c:fb:8f:e2
+:ed:8a:35
 </code>
@@ Zeile 1316: / Zeile 1316: @@
 Nachfolgende Befehle erstellen ein **''MariaDB Client''**-Zertifikate aus der **eigenen CA**.
+:!: **HINWEIS** - **Dies kann in Client wie z.B.**
+  * **[[tachtler:phpmyadmin_centos_6|phpMyAdmin CentOS 6]]**
+  * **[[tachtler:phpmyadmin_centos_7#konfigurationsbeispiel|phpMyAdmin CentOS 7 - Konfigurationsbeispiel]]**
+**eingebunden werden**.
 **__1. Schritt__**: Zuerst müssen jeweils ein
@@ Zeile 1461: / Zeile 1466: @@
 f:dd:f7:f2:89:4e:fd:98:6e:89:79:58:6a:b9:5d:38:02:e6:
 c:f1:31:c9
+</code>
+==== /etc/my.cnf ====
+Um den [[https://mariadb.org/|MariaDB]]-Datenbank-Server mit **SSL**-Verschlüsselung nutzen zu können, ist es erforderlich das
+  * **ROOT**-Zertifikat aus der **eigenen CA** und das
+  * **''MariaDB Server''**-Zertifikate
+  * **''MariaDB Server''**-Schlüssel
+in den  mit einzubinden.
+Die Anpassungen sind in der Konfigurationsdatei **''/etc/my.cnf''** vorzunehmen und in diesem Beispiel, durch voranstellen eines Kommentars im Format:
+<code>
+# Tachtler
+</code>
+gekennzeichnet.
+Hier eine mögliche Anpassung (**komplette Konfigurationsdatei/nur SSL-Verschlüsselung**):
+<code ini>
+[mysqld]
+# Tachtler
+# default: datadir=/var/lib/mysql
+datadir=/var/lib/mysql/data
+socket=/var/lib/mysql/mysql.sock
+# Disabling symbolic-links is recommended to prevent assorted security risks
+symbolic-links=0
+# Settings user and group are ignored when systemd is used.
+# If you need to run mysqld under a different user or group,
+# customize your systemd unit file for mariadb according to the
+# instructions in http://fedoraproject.org/wiki/Systemd
+# Tachtler - ssl -
+ssl-ca=/etc/pki/mariadb/certs/mariadb-ca-crt.pem
+ssl-cert=/etc/pki/mariadb/certs/mariadb-server-crt.pem
+ssl-key=/etc/pki/mariadb/private/mariadb-server-key.pem
+[mysqld_safe]
+log-error=/var/log/mariadb/mariadb.log
+pid-file=/var/run/mariadb/mariadb.pid
+#
+# include all files from the config directory
+#
+!includedir /etc/my.cnf.d
+</code>
+Um überprüfen zu können, ob eine **SSL**-Verschlüsselung nun im [[https://mariadb.org/|MariaDB]]-Datenbank-Server aktiv ist, ist eine Anmeldung am [[https://mariadb.org/|MariaDB]]-Datenbank-Server erforderlich und nachfolgende Befehle, welche den Status in Bezug auf die **SSL**-Verschlüsselung zeigen:
+<code mysql>
+# mysql -h 127.0.0.1 -u root -p
+Enter password:
+Welcome to the MariaDB monitor.  Commands end with ; or \g.
+Your MariaDB connection id is 7
+Server version: 5.5.56-MariaDB MariaDB Server
+Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
+Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
+MariaDB [(none)]>
+</code>
+Anschließend zeigt nachfolgender **SQL**-Befehl die **SSL**-Verschlüsselungseinstellungen an:
+<code mysql>
+MariaDB [(none)]> SHOW VARIABLES LIKE '%ssl%';
++---------------+-------------------------------------------------+
+| Variable_name | Value                                           |
++---------------+-------------------------------------------------+
+| have_openssl  | YES                                             |
+| have_ssl      | YES                                             |
+| ssl_ca        | /etc/pki/mariadb/certs/mariadb-ca-crt.pem       |
+| ssl_capath    |                                                 |
+| ssl_cert      | /etc/pki/mariadb/certs/mariadb-server-crt.pem   |
+| ssl_cipher    |                                                 |
+| ssl_key       | /etc/pki/mariadb/private/mariadb-server-key.pem |
++---------------+-------------------------------------------------+
+rows in set (0.01 sec)
+</code>
+Um die Verbindung zum [[https://mariadb.org/|MariaDB]]-Datenbank-Server zu beenden, kann nachfolgender Befehl verwendet werden:
+<code>
+MariaDB [(none)]> quit
+Bye
+</code>
+Nachfolgender Befehl baut eine **SSL**-Verschlüsselte Verbindung zum [[https://mariadb.org/|MariaDB]]-Datenbank-Server auf und zeigt so, ob **SSL**-Verschlüsselte Verbindungen möglich sind:
+<code>
+# openssl s_client -connect 127.0.0.1:3306
+CONNECTED(00000003)
+140490808899488:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol:s23_clnt.c:794:
+---
+no peer certificate available
+---
+No client certificate CA names sent
+---
+SSL handshake has read 7 bytes and written 289 bytes
+---
+New, (NONE), Cipher is (NONE)
+Secure Renegotiation IS NOT supported
+Compression: NONE
+Expansion: NONE
+No ALPN negotiated
+SSL-Session:
+    Protocol  : TLSv1.2
+    Cipher    : 0000
+    Session-ID:
+    Session-ID-ctx:
+    Master-Key:
+    Key-Arg   : None
+    Krb5 Principal: None
+    PSK identity: None
+    PSK identity hint: None
+    Start Time: 1524802147
+    Timeout   : 300 (sec)
+    Verify return code: 0 (ok)
+---
 </code>