On Sun, May 26, 2013 at 12:05 PM, Kaushal Shriyan <span dir="ltr">&lt;<a href="mailto:kaushalshriyan@gmail.com" target="_blank">kaushalshriyan@gmail.com</a>&gt;</span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

Hi,<div><br></div><div>When I do /etc/init.d/otrs status, I get the below issue. </div><div><br></div><div><div>[root@otrs log]# /etc/init.d/mysqld status</div><div>mysqld (pid 4664) is running...</div><div>[root@otrs log]# /etc/init.d/httpd status</div>


<div>httpd (pid  4780) is running...</div><div>[root@otrs log]# /etc/init.d/postfix status</div><div>master (pid  4769) is running...</div><div>[root@otrs log]# /etc/init.d/otrs status</div><div>httpd (pid  4780) is running...</div>


<div>Checking database connection... Trying to connect to database</div><div>DSN: DBI:mysql:database=otrs;host=localhost;</div><div>DatabaseUser: otrs</div><div><br></div><div>Connected.</div><div>Your storage engine is InnoDB.</div>


<div>These tables use a different storage engine:</div><div><br></div><div>article</div><div>article_attachment</div><div>article_flag</div><div>article_plain</div><div>article_search</div><div>article_sender_type</div><div>


article_type</div><div>auto_response</div><div>auto_response_type</div><div>customer_company</div><div>customer_preferences</div><div>customer_user</div><div>dynamic_field</div><div>dynamic_field_value</div><div>follow_up_possible</div>


<div>generic_agent_jobs</div><div>gi_debugger_entry</div><div>gi_debugger_entry_content</div><div>gi_object_lock_state</div><div>gi_webservice_config</div><div>gi_webservice_config_history</div><div>group_customer_user</div>


<div>group_role</div><div>group_user</div><div>groups</div><div>link_object</div><div>link_relation</div><div>link_state</div><div>link_type</div><div>mail_account</div><div>notification_event</div><div>notification_event_item</div>


<div>notifications</div><div>package_repository</div><div>personal_queues</div><div>postmaster_filter</div><div>process_id</div><div>queue</div><div>queue_auto_response</div><div>queue_preferences</div><div>queue_standard_response</div>


<div>role_user</div><div>roles</div><div>salutation</div><div>scheduler_task_list</div><div>search_profile</div><div>service</div><div>service_customer_user</div><div>service_preferences</div><div>service_sla</div><div>signature</div>


<div>sla</div><div>sla_preferences</div><div>smime_signer_cert_relations</div><div>standard_attachment</div><div>standard_response</div><div>standard_response_attachment</div><div>support_bench_test</div><div>system_address</div>


<div>ticket</div><div>ticket_flag</div><div>ticket_history</div><div>ticket_history_type</div><div>ticket_index</div><div>ticket_lock_index</div><div>ticket_lock_type</div><div>ticket_loop_protection</div><div>ticket_priority</div>


<div>ticket_state</div><div>ticket_state_type</div><div>ticket_type</div><div>ticket_watcher</div><div>time_accounting</div><div>user_preferences</div><div>users</div><div>valid</div><div>virtual_fs</div><div>virtual_fs_db</div>


<div>virtual_fs_preferences</div><div>web_upload_cache</div><div>xml_storage</div><div><br></div><div><b> *** Please correct these problems! *** </b></div><div><b><br></b></div><div><b> Error! </b></div><div><b> Maybe your database isn&#39;t configured yet? </b></div>


<div><b>Checking OTRS Scheduler service.... Not Running!</b></div><div><b> Error! </b></div><div><b> Maybe your database isn&#39;t configured yet? </b></div><div><b>Checking /opt/otrs/bin/<a href="http://otrs.PostMaster.pl" target="_blank">otrs.PostMaster.pl</a> ... (not active) failed.</b></div>


<div><b>Checking otrs spool dir... done.</b></div><div><br></div></div><div>Version Details are as below </div><div><br></div><div><div>[root@otrs log]# perl --version</div><div><br></div><div>This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi</div>


<div><br></div><div>Copyright 1987-2009, Larry Wall</div><div><br></div><div>Perl may be copied only under the terms of either the Artistic License or the</div><div>GNU General Public License, which may be found in the Perl 5 source kit.</div>


<div><br></div><div>Complete documentation for Perl, including FAQ lists, should be found on</div><div>this system using &quot;man perl&quot; or &quot;perldoc perl&quot;.  If you have access to the</div><div>Internet, point your browser at <a href="http://www.perl.org/" target="_blank">http://www.perl.org/</a>, the Perl Home Page.</div>


<div><br></div><div>[root@otrs log]# cat /etc/redhat-release </div><div>CentOS release 6.4 (Final)</div><div>[root@otrs log]# perl --version</div><div><br></div><div>This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi</div>


<div><br></div><div>Copyright 1987-2009, Larry Wall</div><div><br></div><div>Perl may be copied only under the terms of either the Artistic License or the</div><div>GNU General Public License, which may be found in the Perl 5 source kit.</div>


<div><br></div><div>Complete documentation for Perl, including FAQ lists, should be found on</div><div>this system using &quot;man perl&quot; or &quot;perldoc perl&quot;.  If you have access to the</div><div>Internet, point your browser at <a href="http://www.perl.org/" target="_blank">http://www.perl.org/</a>, the Perl Home Page.</div>


<div><br></div><div>[root@otrs log]# rpm -qa | grep httpd</div><div>httpd-tools-2.2.15-28.el6.centos.x86_64</div><div>httpd-2.2.15-28.el6.centos.x86_64</div><div>httpd-devel-2.2.15-28.el6.centos.x86_64</div><div>[root@otrs log]# rpm -qa | grep postfix</div>


<div>postfix-2.6.6-2.2.el6_1.x86_64</div><div>[root@otrs log]# rpm -qa | grep mysql</div><div>mysql55-5.5.31-1.ius.centos6.x86_64</div><div>mysqlclient16-5.1.61-1.ius.centos6.x86_64</div><div>mysql55-libs-5.5.31-1.ius.centos6.x86_64</div>


<div>mysql55-server-5.5.31-1.ius.centos6.x86_64</div><div>php-mysql-5.3.3-22.el6.x86_64</div><div>You have mail in /var/spool/mail/root</div><div>[root@otrs log]# rpm -qa | grep otrs</div><div>otrs-3.2.7-01.noarch</div><div>


[root@otrs log]# </div></div><div>[root@otrs log]# ps aux | grep otrs</div><div><div>root      5137  0.0  0.0 103244   828 pts/1    S+   12:02   0:00 grep otrs</div><div>You have mail in /var/spool/mail/root</div><div>[root@otrs log]# ps aux | grep mysql</div>


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


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


<div>root      5139  0.0  0.0 103248   836 pts/1    S+   12:02   0:00 grep mysql</div><div>[root@otrs log]# ps aux | grep httpd</div><div>root      4780  0.1  0.4 410628 78328 ?        Ss   11:51   0:00 /usr/sbin/httpd</div>


<div>apache    4830  0.0  0.5 447484 91376 ?        S    11:51   0:00 /usr/sbin/httpd</div><div>apache    4831  0.0  0.5 445696 89500 ?        S    11:51   0:00 /usr/sbin/httpd</div><div>apache    4832  0.0  0.5 449580 91608 ?        S    11:51   0:00 /usr/sbin/httpd</div>


<div>apache    4833  0.0  0.5 447200 91264 ?        S    11:51   0:00 /usr/sbin/httpd</div><div>apache    4834  0.3  0.6 465828 107688 ?       S    11:51   0:01 /usr/sbin/httpd</div><div>apache    4835  0.0  0.4 411192 73348 ?        S    11:51   0:00 /usr/sbin/httpd</div>


<div>apache    4836  0.0  0.4 410760 72956 ?        S    11:51   0:00 /usr/sbin/httpd</div><div>apache    4837  0.0  0.4 410760 72956 ?        S    11:51   0:00 /usr/sbin/httpd</div><div>root      5141  0.0  0.0 103248   836 pts/1    S+   12:02   0:00 grep httpd</div>


<div>[root@otrs log]# ps aux | grep postfix</div><div>root      4769  0.0  0.0  79284  3480 ?        Ss   11:51   0:00 /usr/libexec/postfix/master</div><div>postfix   4777  0.0  0.0  79364  3492 ?        S    11:51   0:00 pickup -l -t fifo -u</div>


<div>postfix   4778  0.0  0.0  79536  3604 ?        S    11:51   0:00 qmgr -l -t fifo -u</div><div>postfix   4974  0.0  0.0  79508  3600 ?        S    11:54   0:00 cleanup -z -t unix -u</div><div>postfix   4976  0.0  0.0  79660  4188 ?        S    11:54   0:00 local -t unix</div>


<div>postfix   4977  0.0  0.0  79400  3536 ?        S    11:54   0:00 bounce -z -t unix -u</div><div>root      5143  0.0  0.0 103248   832 pts/1    S+   12:02   0:00 grep postfix</div><div>[root@otrs log]# </div></div><div>


<br></div><div>Let me know if anyone needs any additional information. Any suggestions for the below issue.</div><div><br></div><div><br></div><div><div><b>*** Please correct these problems! *** </b></div><div><b><br></b></div>


<div><b> Error! </b></div><div><b> Maybe your database isn&#39;t configured yet? </b></div><div><b>Checking OTRS Scheduler service.... Not Running!</b></div><div><b> Error! </b></div><div><b> Maybe your database isn&#39;t configured yet? </b></div>


<div><b>Checking /opt/otrs/bin/<a href="http://otrs.PostMaster.pl" target="_blank">otrs.PostMaster.pl</a> ... (not active) failed.</b></div><div><b>Checking otrs spool dir... done.</b></div></div><div><b><br></b></div><div>

Regards,</div>
<div><br></div><div>Kaushal</div>
</blockquote></div><div><br></div>Hi again,<div><br><div><div>/etc/init.d/otrs status</div><div>httpd (pid  4780) is running...</div><div>Checking database connection... Trying to connect to database</div><div>DSN: DBI:mysql:database=otrs;host=localhost;</div>

<div>DatabaseUser: otrs</div><div><br></div><div>Connected.</div><div>done.</div><div>Checking OTRS Scheduler service.... Not Running!</div><div> Error!</div><div> Maybe your database isn&#39;t configured yet?</div><div>
Checking /opt/otrs/bin/<a href="http://otrs.PostMaster.pl">otrs.PostMaster.pl</a> ... (not active) failed.</div>
<div>Checking otrs spool dir... done.</div><div>[root@otrs ~]# ll /opt/otrs/bin/<a href="http://otrs.PostMaster.pl">otrs.PostMaster.pl</a></div><div>-rw-r--r-- 1 otrs apache 4080 May 17 12:55 /opt/otrs/bin/<a href="http://otrs.PostMaster.pl">otrs.PostMaster.pl</a></div>

</div></div><div><br></div><div>cat /etc/init.d/otrs -&gt; <a href="http://paste.fedoraproject.org/14613/55835613/">http://paste.fedoraproject.org/14613/55835613/</a> </div><div><br></div><div>Any suggestions please?</div>

<div><br></div><div>Regards,</div><div><br></div><div>Kaushal</div>