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 <[email protected]> wrote: > Believe the error. Fix the MySQL table. (Google the error.) > > > On Thu, Feb 21, 2013 at 10:11 AM, Gadow, Shawn <[email protected]> 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:* [email protected] [mailto:[email protected]] *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 <[email protected]> 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:* [email protected] [mailto:[email protected]] *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 <[email protected]> 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
