On Mon, May 27, 2013 at 9:02 PM, Gerald Young <crythias@gmail.com> wrote:

or alter table

On Mon, May 27, 2013 at 11:29 AM, David Boyes <dboyes@sinenomine.net> wrote:

Have a look at the actual error messages:

Your storage engine is InnoDB.

These tables use a different storage engine:

Your current MySQL default storage engine is set to InnoDB. The listed tables are not using InnoDB. MySQL doesn’t like databases that use mixed storage engines. Consult the MySQL documentation for how to convert tables to the InnoDB storage engine.

Short version: dump the database contents, recreate the tables using InnoDB, and reload the data. The health check script will then stop complaining.

Hi,

I have checked for the storage engine for all tables and they are InnoDB. I am getting the below issue when i run the health check script

/etc/init.d/otrs status

httpd (pid 2060) is running...

Checking database connection... Trying to connect to database

DSN: DBI:mysql:database=otrs;host=localhost;

DatabaseUser: otrs

Connected.

done.

Checking OTRS Scheduler service.... Not Running!

Error!

Maybe your database isn't configured yet?

Checking /opt/otrs/bin/otrs.PostMaster.pl ... (active) done.

Checking otrs spool dir...

(message:/opt/otrs/var/spool/problem-email-21fa10a73014cab73385e17bee97087d) found! done.

[root@otrs ~]#

Please suggest further.

Regards,

Kaushal