Odd Issues

Gadow, Shawn

21 Feb 2013 21 Feb '13

2:07 p.m.

I have a couple of odd issues. That started on the 20th of last month approximately 1 E-mails just stopped fetching automatically all of the sudden.. I don't remember how that works or how I set that up.. but I can manually fetch.. 2. the 7 day stats graph stopped showing closed tickets. It is only showing created. Both of these things happened at the same time we are currently running 3.1.9

Attachments:

attachment.html (text/html — 2.2 KB)

Show replies by date

Gerald Young

21 Feb 21 Feb

2:14 p.m.

cron has stopped. On Thu, Feb 21, 2013 at 9:07 AM, Gadow, Shawn wrote:

...

Gadow, Shawn

2:32 p.m.

I have restarted the box numerous times how do I manually start the cron job(s) and/or check them (on a windows box) From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 8:15 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues cron has stopped. On Thu, Feb 21, 2013 at 9:07 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I have a couple of odd issues. That started on the 20th of last month approximately 1 E-mails just stopped fetching automatically all of the sudden.. I don't remember how that works or how I set that up.. but I can manually fetch.. 2. the 7 day stats graph stopped showing closed tickets. It is only showing created. Both of these things happened at the same time we are currently running 3.1.9 --------------------------------------------------------------------- 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

Gerald Young

2:56 p.m.

You may start here to find the answer as it's the path I'd take. https://www.google.com/search?q=site:forums.otterhub.org+windows+cron On Thu, Feb 21, 2013 at 9:32 AM, Gadow, Shawn wrote:

...

Gadow, Shawn

3:11 p.m.

When I attempt to run postmaster mailbox from command prompt I get the following.. Microsoft Windows [Version 6.0.6002] Copyright (c) 2006 Microsoft Corporation. All rights reserved. H:\>C:\PROGRA~2/OTRS/StrawberryPerl/perl/bin/perl.exe C:/PROGRA~2/OTRS/OTRS/bin/ otrs.PostMasterMailbox.pl DBD::mysql::st execute failed: Table '.\otrs\process_id' is marked as crashed an d should be repaired at C:/PROGRA~2/OTRS/OTRS/Kernel/System/DB.pm line 618.

...

...

ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 09:08:04 2013 Message: Table '.\otrs\process_id' is marked as crashed and should be repaired, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?' Traceback (6556): Module: Kernel::System::PID::PIDDelete (v1.28) Line: 226 Module: Kernel::System::PID::PIDCreate (v1.28) Line: 150 Module: C:/PROGRA~2/OTRS/OTRS/bin/otrs.PostMasterMailbox.pl (v1.4) Line: 83 DBD::mysql::db do failed: Table '.\otrs\process_id' is marked as crashed and sho uld be repaired at C:/PROGRA~2/OTRS/OTRS/Kernel/System/DB.pm line 478.

...

ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 09:08:04 2013 Message: Table '.\otrs\process_id' is marked as crashed and should be repaired, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_c reate, process_change) VALUES (?, ?, ?, ?, ?)' Traceback (6556): Module: Kernel::System::PID::PIDCreate (v1.28) Line: 154 Module: C:/PROGRA~2/OTRS/OTRS/bin/otrs.PostMasterMailbox.pl (v1.4) Line: 83 NOTICE: PostMasterMailbox.pl is already running (use '-f 1' if you want to start it forced)! From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 8:56 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues You may start here to find the answer as it's the path I'd take. https://www.google.com/search?q=site:forums.otterhub.org+windows+cron On Thu, Feb 21, 2013 at 9:32 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I have restarted the box numerous times how do I manually start the cron job(s) and/or check them (on a windows box) From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 8:15 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues cron has stopped. On Thu, Feb 21, 2013 at 9:07 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I have a couple of odd issues. That started on the 20th of last month approximately 1 E-mails just stopped fetching automatically all of the sudden.. I don't remember how that works or how I set that up.. but I can manually fetch.. 2. the 7 day stats graph stopped showing closed tickets. It is only showing created. Both of these things happened at the same time we are currently running 3.1.9 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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

Gerald Young

3:21 p.m.

Believe the error. Fix the MySQL table. (Google the error.) On Thu, Feb 21, 2013 at 10:11 AM, Gadow, Shawn wrote:

...

Gerald Young

3:24 p.m.

also, the otrs.log can't be written to because of permissions. so allow "everyone" to write to the file. The error messages tell you exactly what the problem is. If a table is crashed, repair the table. If you have no permissions, give them. On Thu, Feb 21, 2013 at 10:21 AM, Gerald Young wrote:

...

Gadow, Shawn

3:36 p.m.

I understand all of that. And I have searched.. hence why I am posting here asking the question. All of my searches come back to run myisamchk on the table one says to run it in var/lib/otrs/ problem is there is no lib folder in the var folder so I am kind of at a loss there. I don't know how to go about running that command and all of the results I have found don't appear to fit my folder structure. From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 9:24 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues also, the otrs.log can't be written to because of permissions. so allow "everyone" to write to the file. The error messages tell you exactly what the problem is. If a table is crashed, repair the table. If you have no permissions, give them. On Thu, Feb 21, 2013 at 10:21 AM, Gerald Young mailto:crythias@gmail.com> wrote: Believe the error. Fix the MySQL table. (Google the error.) On Thu, Feb 21, 2013 at 10:11 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: When I attempt to run postmaster mailbox from command prompt I get the following.. Microsoft Windows [Version 6.0.6002] Copyright (c) 2006 Microsoft Corporation. All rights reserved. H:\>C:\PROGRA~2/OTRS/StrawberryPerl/perl/bin/perl.exe C:/PROGRA~2/OTRS/OTRS/bin/ otrs.PostMasterMailbox.plhttp://otrs.PostMasterMailbox.pl DBD::mysql::st execute failed: Table '.\otrs\process_id' is marked as crashed an d should be repaired at C:/PROGRA~2/OTRS/OTRS/Kernel/System/DB.pm line 618.

...

...

ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 09:08:04 2013 Message: Table '.\otrs\process_id' is marked as crashed and should be repaired, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?' Traceback (6556): Module: Kernel::System::PID::PIDDelete (v1.28) Line: 226 Module: Kernel::System::PID::PIDCreate (v1.28) Line: 150 Module: C:/PROGRA~2/OTRS/OTRS/bin/otrs.PostMasterMailbox.plhttp://otrs.PostMasterMailbox.pl (v1.4) Line: 83 DBD::mysql::db do failed: Table '.\otrs\process_id' is marked as crashed and sho uld be repaired at C:/PROGRA~2/OTRS/OTRS/Kernel/System/DB.pm line 478.

...

ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 09:08:04 2013 Message: Table '.\otrs\process_id' is marked as crashed and should be repaired, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_c reate, process_change) VALUES (?, ?, ?, ?, ?)' Traceback (6556): Module: Kernel::System::PID::PIDCreate (v1.28) Line: 154 Module: C:/PROGRA~2/OTRS/OTRS/bin/otrs.PostMasterMailbox.plhttp://otrs.PostMasterMailbox.pl (v1.4) Line: 83 NOTICE: PostMasterMailbox.pl is already running (use '-f 1' if you want to start it forced)! From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 8:56 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues You may start here to find the answer as it's the path I'd take. https://www.google.com/search?q=site:forums.otterhub.org+windows+cron On Thu, Feb 21, 2013 at 9:32 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I have restarted the box numerous times how do I manually start the cron job(s) and/or check them (on a windows box) From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Thursday, February 21, 2013 8:15 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Odd Issues cron has stopped. On Thu, Feb 21, 2013 at 9:07 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I have a couple of odd issues. That started on the 20th of last month approximately 1 E-mails just stopped fetching automatically all of the sudden.. I don't remember how that works or how I set that up.. but I can manually fetch.. 2. the 7 day stats graph stopped showing closed tickets. It is only showing created. Both of these things happened at the same time we are currently running 3.1.9 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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

Gerald Young

3:47 p.m.

do you know where otrs\process_id exists on your filesystem? Can you find it? http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html basically, you use any method to get to a mysql interface and follow the above instructions. Use MySQL Workbench (free download) or the mysql command line. On Thu, Feb 21, 2013 at 10:36 AM, Gadow, Shawn wrote:

...

4530

Age (days ago)

4530

Last active (days ago)

List overview

Download

8 comments

2 participants

participants (2)

Gadow, Shawn
Gerald Young

Odd Issues

tags

participants (2)