How to install Perl DBD on Mac OS X Mavericks with MAMP Stack

Today I decided to work on Honeyd-Viz a bit which I feel I have abandoned the last year. In order to do so, I needed to have a sample database to play with. As you know, you can create a MySQL database with entries from Honeyd’s honeyd.log file using the Honeyd2MySQL script. Honeyd2MySQL uses Perl’s DBI::DBD module for MySQL operations. I have also been using MAMP Stack from BitNami for development. The problem I had was the installation of DBI::DBD on my Mac OS X which I needed in order to use the DBD::mysql driver. If you’re having troubles you can follow the guide below (written with some help from StackOverflow):

1. Install XCode from the App Store. Then, open XCode, go to the Preferences -> Downloads menu and install the Command Line Tools.

2. Install MAMP Stack from BitNami. Write down or take a mental note of the password value for MySQL’s root user. Choose to start the services (Apache & MySQL).

3. Add MAMP’s MySQL binaries to your PATH (this is particularly needed for mysql_config). Example:

   1 2	locate mysql_config /Applications/mampstack-5.4.32-0/mysql/bin/mysql_config

   Get that directory and add it to your .bash_profile file, appending it to the PATH variable:

   1 2	nano ~/.bash_profile PATH={ ... }:/Applications/mampstack-5.4.32-0/mysql/bin

   Logout and open a new shell session.

4. Create symlinks for MySQL’s lib files in your local lib path:

   1 2 3 4 5

   cd /usr/local mkdir lib #it might already exist, e.g. if you're using Homebrew cd lib sudo ln -s /Applications/mampstack-5.4.32-0/mysql/lib/plugin/ plugin sudo ln -s /Applications/mampstack-5.4.32-0/mysql/lib/*.dylib .

5. Initialize CPAN and install cpanm:

   1 2	cpan #accept defaults sudo cpan App::cpanminus

6. Install DBI and download DBD::mysql:

   1 2 3 4

   sudo cpanm DBI sudo perl -MCPAN -e 'shell' #opens a CPAN shell session cpan> get DBD::mysql cpan> exit

7. Manually install DBD::mysql:

   1 2 3

   cd ~/.cpan/build/DBD* sudo perl Makefile.PL --testuser='root' --testpassword='<mysql_root_password>' #use the password you entered during MAMP's installation sudo make install

8. (optional) Symlink your MAMP’s MySQL sock file if needed (e.g. if you get an error while trying to connect to MySQL server running on ‘localhost’):

   1 2	ln -s /Applications/mampstack-5.4.32-0/mysql/tmp/mysql.sock /tmp/mysql.sock chmod 777 /tmp/mysql.sock

That’s it! Hopefully everything would be good to go.