On Mon, May 27, 2013 at 9:02 PM, Gerald Young <cryth...@gmail.com> wrote:
> or alter > table<http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html> > > > On Mon, May 27, 2013 at 11:29 AM, David Boyes <dbo...@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
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs