Preparing MySQL Library for Athena

Only for tarball installation?

During installation, the location of MySQL lib is set in /etc/ld.so.conf to let the C compiler know where to look when it is needed. However, on some systems, the compiler seems to miss that setting just like it does when MySQL server is installed by the rpm method. Quite often, successfully compiled Athena does not find the required files. That is because many default rpm installations do not include the development library, distinguished by the presence of -devel- in its package name. If it is not install, do so with the rpm method before you proceed.

We can, of course, do some tests to ascertain the libs are indeed installed. We will not go through that. Instead, we will use the quickest way, which is to set the symbolic links (symlinks) using the command ln -s to those libs.

Let us create the symbol links to those files. Issue the following commands as root from any directory. (Important: Ensure that the second path is the same as that stated in Athena Makefile.)

RPM-installation: replace /usr/local/mysql with /rpm/installed/dir
# ln -s /usr/local/mysql/lib/mysql /usr/local/lib/mysql
# ln -s /usr/local/mysql/include/mysql /usr/local/include/mysql

In case you need to delete those symlinks:

# rm /usr/local/lib/mysql
# rm /usr/local/include/mysql