After upgrading to Mavericks, 500 server error is got when accessing to OTRS. Refer to the error log, the module perl(DBD::MySQL) should be missing. Then I check it by using OTRS script $OTRS_HOME/bin/otrs.CheckModule.pl and find that DBD::MySQL is marked as “Not installed!”.

This post provides clear steps to install the module. I have revised the steps as below:

# cd /usr/local

Check whether the folder “lib” exists. If yes, rename the folder and create a new folder “lib”

# sudo mkdir lib
# cd lib
# sudo ln -s /usr/local/mysql/lib/*.dylib .
# cd ~/.cpan/build/DBD-mysql-xxxxxx/
# sudo perl Makefile.PL --testuser='yourmysqluser' --testpassword='yourmysqlpassword'
# sudo make
# sudo make test
# sudo make install

Run the OTRS script $OTRS_HOME/bin/otrs.CheckModule.pl again and DBD::MySQL is marked is “ok”

((enjoy))