On Sun, May 26, 2013 at 2:24 PM, Kaushal Shriyan wrote:

On Sun, May 26, 2013 at 12:05 PM, Kaushal Shriyan < kaushalshriyan@gmail.com> wrote:

...

Hi,

When I do /etc/init.d/otrs status, I get the below issue.

[root@otrs log]# /etc/init.d/mysqld status mysqld (pid 4664) is running... [root@otrs log]# /etc/init.d/httpd status httpd (pid 4780) is running... [root@otrs log]# /etc/init.d/postfix status master (pid 4769) is running... [root@otrs log]# /etc/init.d/otrs status httpd (pid 4780) is running... Checking database connection... Trying to connect to database DSN: DBI:mysql:database=otrs;host=localhost; DatabaseUser: otrs

Connected. Your storage engine is InnoDB. These tables use a different storage engine:

article article_attachment article_flag article_plain article_search article_sender_type article_type auto_response auto_response_type customer_company customer_preferences customer_user dynamic_field dynamic_field_value follow_up_possible generic_agent_jobs gi_debugger_entry gi_debugger_entry_content gi_object_lock_state gi_webservice_config gi_webservice_config_history group_customer_user group_role group_user groups link_object link_relation link_state link_type mail_account notification_event notification_event_item notifications package_repository personal_queues postmaster_filter process_id queue queue_auto_response queue_preferences queue_standard_response role_user roles salutation scheduler_task_list search_profile service service_customer_user service_preferences service_sla signature sla sla_preferences smime_signer_cert_relations standard_attachment standard_response standard_response_attachment support_bench_test system_address ticket ticket_flag ticket_history ticket_history_type ticket_index ticket_lock_index ticket_lock_type ticket_loop_protection ticket_priority ticket_state ticket_state_type ticket_type ticket_watcher time_accounting user_preferences users valid virtual_fs virtual_fs_db virtual_fs_preferences web_upload_cache xml_storage

* *** Please correct these problems! *** * * * * Error! * * Maybe your database isn't configured yet? * *Checking OTRS Scheduler service.... Not Running!* * Error! * * Maybe your database isn't configured yet? * *Checking /opt/otrs/bin/otrs.PostMaster.pl ... (not active) failed.* *Checking otrs spool dir... done.*

Version Details are as below

[root@otrs log]# perl --version

This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi

Copyright 1987-2009, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on this system using "man perl" or "perldoc perl". If you have access to the Internet, point your browser at http://www.perl.org/, the Perl Home Page.

[root@otrs log]# cat /etc/redhat-release CentOS release 6.4 (Final) [root@otrs log]# perl --version

This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi

Copyright 1987-2009, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on this system using "man perl" or "perldoc perl". If you have access to the Internet, point your browser at http://www.perl.org/, the Perl Home Page.

[root@otrs log]# rpm -qa | grep httpd httpd-tools-2.2.15-28.el6.centos.x86_64 httpd-2.2.15-28.el6.centos.x86_64 httpd-devel-2.2.15-28.el6.centos.x86_64 [root@otrs log]# rpm -qa | grep postfix postfix-2.6.6-2.2.el6_1.x86_64 [root@otrs log]# rpm -qa | grep mysql mysql55-5.5.31-1.ius.centos6.x86_64 mysqlclient16-5.1.61-1.ius.centos6.x86_64 mysql55-libs-5.5.31-1.ius.centos6.x86_64 mysql55-server-5.5.31-1.ius.centos6.x86_64 php-mysql-5.3.3-22.el6.x86_64 You have mail in /var/spool/mail/root [root@otrs log]# rpm -qa | grep otrs otrs-3.2.7-01.noarch [root@otrs log]# [root@otrs log]# ps aux | grep otrs root 5137 0.0 0.0 103244 828 pts/1 S+ 12:02 0:00 grep otrs You have mail in /var/spool/mail/root [root@otrs log]# ps aux | grep mysql root 4177 0.0 0.0 108328 1500 ? S 11:51 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/data/mysql --socket=/data/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql mysql 4664 0.1 0.4 1133868 79492 ? Sl 11:51 0:01 /usr/libexec/mysqld --basedir=/usr --datadir=/data/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --open-files-limit=65535 --pid-file=/var/run/mysqld/mysqld.pid --socket=/data/mysql/mysql.sock root 5139 0.0 0.0 103248 836 pts/1 S+ 12:02 0:00 grep mysql [root@otrs log]# ps aux | grep httpd root 4780 0.1 0.4 410628 78328 ? Ss 11:51 0:00 /usr/sbin/httpd apache 4830 0.0 0.5 447484 91376 ? S 11:51 0:00 /usr/sbin/httpd apache 4831 0.0 0.5 445696 89500 ? S 11:51 0:00 /usr/sbin/httpd apache 4832 0.0 0.5 449580 91608 ? S 11:51 0:00 /usr/sbin/httpd apache 4833 0.0 0.5 447200 91264 ? S 11:51 0:00 /usr/sbin/httpd apache 4834 0.3 0.6 465828 107688 ? S 11:51 0:01 /usr/sbin/httpd apache 4835 0.0 0.4 411192 73348 ? S 11:51 0:00 /usr/sbin/httpd apache 4836 0.0 0.4 410760 72956 ? S 11:51 0:00 /usr/sbin/httpd apache 4837 0.0 0.4 410760 72956 ? S 11:51 0:00 /usr/sbin/httpd root 5141 0.0 0.0 103248 836 pts/1 S+ 12:02 0:00 grep httpd [root@otrs log]# ps aux | grep postfix root 4769 0.0 0.0 79284 3480 ? Ss 11:51 0:00 /usr/libexec/postfix/master postfix 4777 0.0 0.0 79364 3492 ? S 11:51 0:00 pickup -l -t fifo -u postfix 4778 0.0 0.0 79536 3604 ? S 11:51 0:00 qmgr -l -t fifo -u postfix 4974 0.0 0.0 79508 3600 ? S 11:54 0:00 cleanup -z -t unix -u postfix 4976 0.0 0.0 79660 4188 ? S 11:54 0:00 local -t unix postfix 4977 0.0 0.0 79400 3536 ? S 11:54 0:00 bounce -z -t unix -u root 5143 0.0 0.0 103248 832 pts/1 S+ 12:02 0:00 grep postfix [root@otrs log]#

Let me know if anyone needs any additional information. Any suggestions for the below issue.

**** Please correct these problems! *** * * * * Error! * * Maybe your database isn't configured yet? * *Checking OTRS Scheduler service.... Not Running!* * Error! * * Maybe your database isn't configured yet? * *Checking /opt/otrs/bin/otrs.PostMaster.pl ... (not active) failed.* *Checking otrs spool dir... done.* * * Regards,

Kaushal

Hi again,

/etc/init.d/otrs status httpd (pid 4780) 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 ... (not active) failed. Checking otrs spool dir... done. [root@otrs ~]# ll /opt/otrs/bin/otrs.PostMaster.pl -rw-r--r-- 1 otrs apache 4080 May 17 12:55 /opt/otrs/bin/ otrs.PostMaster.pl

cat /etc/init.d/otrs -> http://paste.fedoraproject.org/14613/55835613/

Any suggestions please?

Regards,

Kaushal

Hi, Checking in again for my earlier post to this mailing list. Any suggestions please for the below issue? /etc/init.d/otrs status httpd (pid 4780) 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 http://otrs.postmaster.pl/ ... (not active) failed. Checking otrs spool dir... done. [root@otrs ~]# ll /opt/otrs/bin/otrs.PostMaster.plhttp://otrs.postmaster.pl/ -rw-r--r-- 1 otrs apache 4080 May 17 12:55 /opt/otrs/bin/otrs.PostMaster.plhttp://otrs.postmaster.pl/ cat /etc/init.d/otrs -> http://fpaste.org/14780/69666427/ Regards, Kaushal

or alter tablehttp://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html On Mon, May 27, 2013 at 11:29 AM, David Boyes 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. ****

** **

--------------------------------------------------------------------- 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

http://doc.otrs.org/3.1/en/html/scheduler.html On Mon, May 27, 2013 at 11:52 AM, Kaushal Shriyan wrote:

On Mon, May 27, 2013 at 9:02 PM, Gerald Young wrote:

...

or alter tablehttp://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html

On Mon, May 27, 2013 at 11:29 AM, David Boyes 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

Checking OTRS Scheduler service.... Not Running! Error! Maybe your database isn't configured yet? Did you do the setup steps in the documentation for the OTRS Scheduler service?

As a newbie to this forum, I too am running into problems with CentOS 6.4 / PostgreSQL 8.4 / OTRS 3.2.7 I am unable to find clear and precise instructions on installing this combination and I am left to search and try and combine what I find into some instructions applicable. When I manage to complete my installation I will publish them - promise :-) but for now I am receiving the same error. Any help gratefully received. Regards ___________________________________________ Paul Simons From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Kaushal Shriyan Sent: 27 May 2013 18:24 To: User questions and discussions about OTRS. Subject: Re: [otrs] OTRS version 3.2.7 on CentOS 6.4 On Mon, May 27, 2013 at 9:47 PM, David Boyes mailto:dboyes@sinenomine.net> wrote: Checking OTRS Scheduler service.... Not Running! Error! Maybe your database isn't configured yet? Did you do the setup steps in the documentation for the OTRS Scheduler service? David, yes 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 ________________________________ Disclaimer: This e-mail (and any attachments to it) is confidential and intended solely for the named person/s to whom it is addressed. If you are not an intended recipient, please notify us immediately and delete the email from your system. Any review, dissemination or other use of it in these circumstances is prohibited.