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