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