Various changes by Philipp G├╝hring
[ach-master.git] / src / DBs.tex
1
2 \subsection{Database Systems}
3 % This list is based on : http://en.wikipedia.org/wiki/Relational_database_management_system#Market_share
4
5 \subsubsection{Oracle}
6 \todo{write this}
7
8 \subsubsection{SQL Server}
9 \todo{write this}
10
11
12
13
14 \subsubsection{MySQL}
15
16 \paragraph*{my.cnf}\mbox{}\\
17
18 %Tested with Debian 7.0 and MySQL 5.5
19
20 \begin{lstlisting}[breaklines]
21 [mysqld]
22 ssl
23 ssl-ca=/etc/mysql/ssl/ca-cert.pem
24 ssl-cert=/etc/mysql/ssl/client-cert.pem
25 ssl-key=/etc/mysql/ssl/client-key.pem
26 ssl-cipher=EECDH+aRSA+AESGCM:EECDH+aRSA+SHA384:EECDH+aRSA+SHA256:EDH+CAMELLIA256:EECDH:EDH+aRSA:+SSLv3:!aNULL:!eNULL:!LOW:!3DES:!MD5:!EXP:!PSK:!DSS:!RC4:!SEED:!AES128:!CAMELLIA128:!ECDSA:AES256-SHA
27 \end{lstlisting}
28
29 After restarting the server run the following query to see if the ssl settings are correct:
30 \begin{lstlisting}[breaklines]
31 show variables like '%ssl%';
32 \end{lstlisting}
33
34
35 \subsubsection{DB2}
36 \todo{write this}
37
38 \subsubsection{Postgresql}
39 \todo{write this}
40
41 \subsubsection{Informix}
42 \todo{write this}