1

I installed OTRS from a rpm and the web installer /orts/installer.pl stops with:

Error during AJAX communication. Status: error, Error: Internal Server Error

Apache error_log

install_driver(mysql) failed: Unable to get DBI state function. DBI not loaded.

/opt/otrs/bin/otrs.CheckModules.pl

DBD::mysql.......................FAILED! Not all prerequisites for this module correctly installed. YAML::XS.........................Not installed! (required - use "perl -MCPAN -e shell;" - )

But sudo zypper install perl-DBD-mysql-4.021-27.2.x86_64.rpm has Nothing to do. and mysql configuration is set as the manual requested.

System is SLES 11 SP2 (x86_64) and special thing: No internet connection!

I guess the question is: Why doesn't perl find DBI:mysql while it's installed?

Update

list_the_installed_modules

/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Bundle/DBI.pm /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Bundle/DBD/mysql.pm /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/DBD/mysql.pm /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/DBD/mysql/GetInfo.pm

Could I have installed the wrong rpm?

0

This error message does mean that perl can't find the DBD::mysql module. So if the rpm package is installed, this leads me to think that you might not be using the system perl.

Can you show us:

which perl

and also:

/usr/bin/perl /opt/otrs/bin/otrs.CheckModules.pl

In general it is not a good idea to install your own perl on top of the existing system perl. This can break other installed packages that expect a certain perl version.

If you want to use different perls on your system, use tools like plenv or perlbrew

Also, OTRS typically works with the system perl on SLES 11.

  • Thank you. There is only on perl installed and using /usr/bin/perl tells me the same. I have another SLES 11 SP2 (x86_64) running otrs. I am just trying to move it to another server. – PiTheNumber Oct 1 '13 at 8:58
  • So could it be that DBI is not listed as a prerequisite correctly? Can you do zypper install "perl(DBI)"? – MichielB Oct 1 '13 at 10:12
  • 'perl-DBI' providing 'perl(DBI)' is already installed. – PiTheNumber Oct 1 '13 at 10:52
0

turns out perl-DBD-mysql-4.021-27.2.x86_64.rpm was to new for my perl version. I had a look at the package list for SLES 11 PS2 (x86_64) and learnt it should be perl-DBD-mysql-4.008-4.3.x86_64.rpm. So I removed the installed one:

sudo zypper remove perl-DBD-mysql

Googled and installed perl-DBD-mysql-4.008-4.3.x86_64.rpm.ยด

Now it works!

  • Great, so where did you get the other one in the first place? You should not install RPMs off Google - that is kind of scar - you should use the SLES repos or the build service (and then some trusted repo) instead. DBD::mysql IS in the main SLES repositories. – MichielB Oct 1 '13 at 13:12
  • @Mike yes, it is scary. Found it on rpm.pbone.net – PiTheNumber Oct 1 '13 at 14:57

Your Answer

By clicking โ€œPost Your Answerโ€, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.