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”