X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=docs%2Fmanual%2Fmysql.tex;h=240b147dc330a6764c7a4957fdd8c918a1b90954;hb=c957321e0c7ff8d440bcc1fd5755536e9c53b8a8;hp=21bcbae10d426860b89fb85ded06fd0cdb05323b;hpb=55ec6a96975b79937a2f90845a8758883196026e;p=bacula%2Fdocs diff --git a/docs/manual/mysql.tex b/docs/manual/mysql.tex index 21bcbae1..240b147d 100644 --- a/docs/manual/mysql.tex +++ b/docs/manual/mysql.tex @@ -1,16 +1,14 @@ %% %% -\section*{Installing and Configuring MySQL} -\label{_ChapterStart} +\chapter{Installing and Configuring MySQL} +\label{MySqlChapter} \index[general]{MySQL!Installing and Configuring } \index[general]{Installing and Configuring MySQL } -\addcontentsline{toc}{section}{Installing and Configuring MySQL} -\subsection*{Installing and Configuring MySQL -- Phase I} +\section{Installing and Configuring MySQL -- Phase I} \index[general]{Installing and Configuring MySQL -- Phase I } \index[general]{Phase I!Installing and Configuring MySQL -- } -\addcontentsline{toc}{subsection}{Installing and Configuring MySQL -- Phase I} If you use the ./configure \verb:--:with-mysql=mysql-directory statement for configuring {\bf Bacula}, you will need MySQL version 3.23.53 or later @@ -31,9 +29,36 @@ it on our machines. Please note that our configuration leaves MySQL without any user passwords. This may be an undesirable situation if you have other users on your system. +The notes below describe how to build MySQL from the source tar files. If +you have a pre-installed MySQL, you can return to complete the installation +of Bacula, then come back to Phase II of the MySQL installation. If you +wish to install MySQL from rpms, you will probably need to install +the following: + +\footnotesize +\begin{verbatim} +mysql-.rpm +mysql-server-.rpm +mysql-devel-.rpm +\end{verbatim} +\normalsize +The names of the packages may vary from distribution to +distribution. It is important to have the devel package loaded as +it contains the libraries and header files necessary to build +Bacula. There may be additional packages that are required to +install the above, for example, zlib and openssl. + +Once these packages are installed, you will be able to build Bacula (using +the files installed with the mysql package, then run MySQL using the +files installed with mysql-server. If you have installed MySQL by rpms, +please skip Phase I below, and return to complete the installation of +Bacula, then come back to Phase II of the MySQL installation when indicated +to do so. + Beginning with Bacula version 1.31, the thread safe version of the -MySQL client library is used, and hence you must add the {\bf -\verb:--:enable-thread-safe-client} option to the {\bf ./configure} as shown below: +MySQL client library is used, and hence you should add the {\bf +\verb:--:enable-thread-safe-client} option to the {\bf +./configure} as shown below: \begin{enumerate} \item Download MySQL source code from @@ -46,9 +71,9 @@ MySQL client library is used, and hence you must add the {\bf Note, the above command requires GNU tar. If you do not have GNU tar, a command such as: -{\bf zcat mysql-filename | tar xvf - +{\bf zcat mysql-filename | tar xvf - } -} will probably accomplish the same thing. +will probably accomplish the same thing. \item cd {\bf mysql-source-directory} @@ -91,11 +116,9 @@ second phase of the MySQL installation are created during the Bacula Installation. \label{mysql_phase2} -\subsection*{Installing and Configuring MySQL -- Phase II} +\section{Installing and Configuring MySQL -- Phase II} \index[general]{Installing and Configuring MySQL -- Phase II } \index[general]{Phase II!Installing and Configuring MySQL -- } -\addcontentsline{toc}{subsection}{Installing and Configuring MySQL -- Phase -II} At this point, you should have built and installed MySQL, or already have a running MySQL, and you should have configured, built and installed {\bf @@ -162,10 +185,9 @@ select * from user; \end{verbatim} \normalsize -\subsection*{Re-initializing the Catalog Database} +\section{Re-initializing the Catalog Database} \index[general]{Database!Re-initializing the Catalog } \index[general]{Re-initializing the Catalog Database } -\addcontentsline{toc}{subsection}{Re-initializing the Catalog Database} After you have done some initial testing with {\bf Bacula}, you will probably want to re-initialize the catalog database and throw away all the test Jobs @@ -194,10 +216,10 @@ end of file mark on the volume so that Bacula can reuse it. Do so with: Where you should replace {\bf /dev/nst0} with the appropriate tape drive device name for your machine. -\subsection*{Linking Bacula with MySQL} +\section{Linking Bacula with MySQL} \index[general]{Linking Bacula with MySQL } \index[general]{MySQL!Linking Bacula with } -\addcontentsline{toc}{subsection}{Linking Bacula with MySQL} +\index[general]{Upgrading} After configuring Bacula with @@ -239,10 +261,27 @@ LDFLAGS="-lssl -lcyrpto" \ \end{verbatim} \normalsize -\subsection*{Upgrading MySQL} +\section{Installing MySQL from RPMs} +\index[general]{MySQL!Installing from RPMs} +\index[general]{Installing MySQL from RPMs} +If you are installing MySQL from RPMs, you will need to install +both the MySQL binaries and the client libraries. The client +libraries are usually found in a devel package, so you must +install: + +\footnotesize +\begin{verbatim} + mysql + mysql-devel +\end{verbatim} +\normalsize + +This will be the same with most other package managers too. + +\section{Upgrading MySQL} \index[general]{Upgrading MySQL } \index[general]{Upgrading!MySQL } -\addcontentsline{toc}{subsection}{Upgrading MySQL} +\index[general]{Upgrading} If you upgrade MySQL, you must reconfigure, rebuild, and re-install Bacula otherwise you are likely to get bizarre failures. If you install from rpms and you upgrade MySQL, you must also rebuild Bacula.