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

 

>> Can't write C:/PROGRA~2/OTRS/OTRS/var/log/otrs.log: Permission denied <<

 

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: 'SELECT process_name, process_id, process_host, process_create, process_ch

ange FROM process_id WHERE process_name = ? LIMIT 1'

 

Traceback (6556):

   Module: Kernel::System::PID::PIDGet (v1.28) Line: 184

   Module: Kernel::System::PID::PIDCreate (v1.28) Line: 124

   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.

 

>> Can't write C:/PROGRA~2/OTRS/OTRS/var/log/otrs.log: Permission denied <<

 

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.

 

>> Can't write C:/PROGRA~2/OTRS/OTRS/var/log/otrs.log: Permission denied <<

 

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