Add DBs.tex
[ach-master.git] / src / DBs.tex
1
2 \subsection{Database Systems}
3 \subsubsection{MySQL}
4
5 \paragraph*{my.cnf}\mbox{}\\
6
7 %Tested with Debian 7.0 and MySQL 5.5
8
9 \begin{lstlisting}[breaklines]
10 [mysqld]
11 ssl
12 ssl-ca=/etc/mysql/ssl/ca-cert.pem
13 ssl-cert=/etc/mysql/ssl/client-cert.pem
14 ssl-key=/etc/mysql/ssl/client-key.pem
15 ssl-cipher=EECDH+aRSA+AESGCM:EECDH+aRSA+SHA384:EECDH+aRSA+SHA256:EDH+CAMELLIA256:EECDH:EDH+aRSA:+SSLv3:!aNULL:!eNULL:!LOW:!3DES:!MD5:!EXP:!PSK:!SRP:!DSS:!RC4:!SEED:!AES128:!CAMELLIA128:!ECDSA:AES256-SHA
16 \end{lstlisting}
17
18 After restarting the server run the following query to see if the ssl settings are correct:
19 \begin{lstlisting}[breaklines]
20 show variables like '%ssl%';
21 \end{lstlisting}
22