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:!SRP:!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}