What do the logs say? Chances are, you *still* have problems sending email. On Fri, Aug 3, 2012 at 10:10 AM, Gadow, Shawn wrote:

I got past that error I believe I noticed that the sendmail settings had been defaulted with the upgrade.. but now when I reply to a ticket it opens a blank window no error messages nothing just sits there.. when I close the window no e-mail has been sent and the status of the ticket has not changed however the response is noted****

** **

Thank you,****

Shawn Gadow****

Network Administrator****

Oregon CUSD 220****

** **

*“Security is when everything is settled*. *When nothing can happen to you. Security is the denial of life*.” – Germaine Greer****

** **

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gadow, Shawn *Sent:* Friday, August 03, 2012 8:55 AM *To:* otrs@otrs.org *Subject:* [otrs] Can't send e-mail replies after upgrade to 3.1.2****

** **

Every time I try to send an e-mail reply to a ticket I receive the following error..****

This was working prior to the upgrade to 3.1.2****

** **

Any help would be appreciated****

** **

*Error Message: Impossible to send message to: berickson@ocusd.net, .*

** **

Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Aug 3 08:49:27 2012 Message: Impossible to send message to: alarsen@ocusd.net, . Traceback (4452): Module: Kernel::System::Ticket::Article::ArticleSend (v1.309) Line: 2180 Module: Kernel::Modules::AgentTicketCompose::Run (v1.161) Line: 736 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31****

** **

** **

** **

Thank you,****

Shawn Gadow****

Network Administrator****

Oregon CUSD 220****

** **

*“Security is when everything is settled*. *When nothing can happen to you. Security is the denial of life*.” – Germaine Greer****

** **

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

Nevermind I found it This coincides with the time [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 9:53 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Which logs would I look in to find the error information? From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 9:31 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 What do the logs say? Chances are, you *still* have problems sending email. On Fri, Aug 3, 2012 at 10:10 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I got past that error I believe I noticed that the sendmail settings had been defaulted with the upgrade.. but now when I reply to a ticket it opens a blank window no error messages nothing just sits there.. when I close the window no e-mail has been sent and the status of the ticket has not changed however the response is noted Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 8:55 AM To: otrs@otrs.orgmailto:otrs@otrs.org Subject: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Every time I try to send an e-mail reply to a ticket I receive the following error.. This was working prior to the upgrade to 3.1.2 Any help would be appreciated Error Message: Impossible to send message to: berickson@ocusd.netmailto:berickson@ocusd.net, . Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Aug 3 08:49:27 2012 Message: Impossible to send message to: alarsen@ocusd.netmailto:alarsen@ocusd.net, . Traceback (4452): Module: Kernel::System::Ticket::Article::ArticleSend (v1.309) Line: 2180 Module: Kernel::Modules::AgentTicketCompose::Run (v1.161) Line: 736 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer --------------------------------------------------------------------- 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

It may be that the conversion didn't complete but did you upgrade from 3.0 or 3.1.1? It appears you didn't complete the schema changes on upgrade. On Fri, Aug 3, 2012 at 11:12 AM, Gadow, Shawn wrote:

Repaired the table and I am no longer receiving that error but now I get this.. unsure if its related or not.****

** **

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'****

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'****

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'****

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'****

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gadow, Shawn *Sent:* Friday, August 03, 2012 10:03 AM

*To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2****

** **

Nevermind I found it This coincides with the time****

** **

[Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ****

'2012-08-03 10:01:44'****

, ?, ****

'2012-08-03 10:01:44'****

, ?)'****

[Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ****

'2012-08-03 10:01:44'****

, ?, ****

'2012-08-03 10:01:44'****

, ?)'****

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gadow, Shawn *Sent:* Friday, August 03, 2012 9:53 AM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2****

** **

Which logs would I look in to find the error information?****

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gerald Young *Sent:* Friday, August 03, 2012 9:31 AM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2****

** **

What do the logs say? Chances are, you *still* have problems sending email. ****

On Fri, Aug 3, 2012 at 10:10 AM, Gadow, Shawn wrote:*** *

I got past that error I believe I noticed that the sendmail settings had been defaulted with the upgrade.. but now when I reply to a ticket it opens a blank window no error messages nothing just sits there.. when I close the window no e-mail has been sent and the status of the ticket has not changed however the response is noted****

****

Thank you,****

Shawn Gadow****

Network Administrator****

Oregon CUSD 220****

****

*“Security is when everything is settled*. *When nothing can happen to you. Security is the denial of life*.” – Germaine Greer****

****

****

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gadow, Shawn *Sent:* Friday, August 03, 2012 8:55 AM *To:* otrs@otrs.org *Subject:* [otrs] Can't send e-mail replies after upgrade to 3.1.2****

****

Every time I try to send an e-mail reply to a ticket I receive the following error..****

This was working prior to the upgrade to 3.1.2****

****

Any help would be appreciated****

****

*Error Message: Impossible to send message to: berickson@ocusd.net, .*****

****

Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Aug 3 08:49:27 2012 Message: Impossible to send message to: alarsen@ocusd.net, . Traceback (4452): Module: Kernel::System::Ticket::Article::ArticleSend (v1.309) Line: 2180 Module: Kernel::Modules::AgentTicketCompose::Run (v1.161) Line: 736 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31****

****

****

****

Thank you,****

Shawn Gadow****

Network Administrator****

Oregon CUSD 220****

****

*“Security is when everything is settled*. *When nothing can happen to you. Security is the denial of life*.” – Germaine Greer****

****

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

backup your database. and everything else. Read UPGRADING in your OTRS folder. You'll need to do three steps: a DBUpdate for schema, a perl update, and a post schema update, plus cache, config etc. This is assuming it hasn't been done already. I don't know the state of your database, especially since you had a crashed table. While the information should work, you should test it out before changing production. The information I've provided is not guaranteed for any purpose, and your situation may involve pieces that I can't guess from a mailing list. On Fri, Aug 3, 2012 at 11:28 AM, Gadow, Shawn wrote:

I upgraded from 3.0.****

** **

So it appears it is fixable then by running the update? yes? How would I do that?****

** **

I am running on a windows server ****

** **

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gerald Young *Sent:* Friday, August 03, 2012 10:24 AM

*To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2****

** **

It may be that the conversion didn't complete but did you upgrade from 3.0 or 3.1.1? It appears you didn't complete the schema changes on upgrade.*** *

On Fri, Aug 3, 2012 at 11:12 AM, Gadow, Shawn wrote:*** *

Repaired the table and I am no longer receiving that error but now I get this.. unsure if its related or not.****

****

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'****

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'****

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'****

[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'****

****

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gadow, Shawn *Sent:* Friday, August 03, 2012 10:03 AM****

*To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2****

****

Nevermind I found it This coincides with the time****

****

[Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ****

'2012-08-03 10:01:44'****

, ?, ****

'2012-08-03 10:01:44'****

, ?)'****

[Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ****

'2012-08-03 10:01:44'****

, ?, ****

'2012-08-03 10:01:44'****

, ?)'****

****

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gadow, Shawn *Sent:* Friday, August 03, 2012 9:53 AM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2****

****

Which logs would I look in to find the error information?****

****

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gerald Young *Sent:* Friday, August 03, 2012 9:31 AM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2****

****

What do the logs say? Chances are, you *still* have problems sending email. ****

On Fri, Aug 3, 2012 at 10:10 AM, Gadow, Shawn wrote:*** *

I got past that error I believe I noticed that the sendmail settings had been defaulted with the upgrade.. but now when I reply to a ticket it opens a blank window no error messages nothing just sits there.. when I close the window no e-mail has been sent and the status of the ticket has not changed however the response is noted****

****

Thank you,****

Shawn Gadow****

Network Administrator****

Oregon CUSD 220****

****

*“Security is when everything is settled*. *When nothing can happen to you. Security is the denial of life*.” – Germaine Greer****

****

****

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gadow, Shawn *Sent:* Friday, August 03, 2012 8:55 AM *To:* otrs@otrs.org *Subject:* [otrs] Can't send e-mail replies after upgrade to 3.1.2****

****

Every time I try to send an e-mail reply to a ticket I receive the following error..****

This was working prior to the upgrade to 3.1.2****

****

Any help would be appreciated****

****

*Error Message: Impossible to send message to: berickson@ocusd.net, .*****

****

Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Aug 3 08:49:27 2012 Message: Impossible to send message to: alarsen@ocusd.net, . Traceback (4452): Module: Kernel::System::Ticket::Article::ArticleSend (v1.309) Line: 2180 Module: Kernel::Modules::AgentTicketCompose::Run (v1.161) Line: 736 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31****

****

****

****

Thank you,****

Shawn Gadow****

Network Administrator****

Oregon CUSD 220****

****

*“Security is when everything is settled*. *When nothing can happen to you. Security is the denial of life*.” – Germaine Greer****

****

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

I ended up having to reinstall DBD::mysql then I finished the process.. however now I no longer get any errors in ortrs.log but mail still does not send and I am left with just a blank page as previously From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 11:30 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 When I execute the DBUpdate-to-3.1.mysql.sql script I get a few errors back all stating that the table already exists and no other errors so I would assume that means this step was already ran So I continue on and I'm not really sure how to run the pl script but when I start the script in command prompt I get the following c:\Program Files (x86)\OTRS\OTRS\scripts>DBUpdate-to-3.1.pl Migration started... install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: C:/Program Files (x86)/OTRS/OTRS/Custom C:/Program Files (x86)/OTRS/OTRS/Kernel/ cpan-lib C:/Program Files (x86)/OTRS/OTRS C:/Perl/site/lib C:/Perl/lib .) at (ev al 20) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQL ite, Sponge. at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/DB.pm line 256 c:\Program Files (x86)\OTRS\OTRS\scripts> the location of the mysql.pm file is C:\Program Files (x86)\OTRS\OTRS\Kernel\System\DB if that makes a difference From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 10:51 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 backup your database. and everything else. Read UPGRADING in your OTRS folder. You'll need to do three steps: a DBUpdate for schema, a perl update, and a post schema update, plus cache, config etc. This is assuming it hasn't been done already. I don't know the state of your database, especially since you had a crashed table. While the information should work, you should test it out before changing production. The information I've provided is not guaranteed for any purpose, and your situation may involve pieces that I can't guess from a mailing list. On Fri, Aug 3, 2012 at 11:28 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I upgraded from 3.0. So it appears it is fixable then by running the update? yes? How would I do that? I am running on a windows server From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 10:24 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 It may be that the conversion didn't complete but did you upgrade from 3.0 or 3.1.1? It appears you didn't complete the schema changes on upgrade. On Fri, Aug 3, 2012 at 11:12 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: Repaired the table and I am no longer receiving that error but now I get this.. unsure if its related or not. [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)' From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 10:03 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Nevermind I found it This coincides with the time [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 9:53 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Which logs would I look in to find the error information? From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 9:31 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 What do the logs say? Chances are, you *still* have problems sending email. On Fri, Aug 3, 2012 at 10:10 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I got past that error I believe I noticed that the sendmail settings had been defaulted with the upgrade.. but now when I reply to a ticket it opens a blank window no error messages nothing just sits there.. when I close the window no e-mail has been sent and the status of the ticket has not changed however the response is noted Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 8:55 AM To: otrs@otrs.orgmailto:otrs@otrs.org Subject: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Every time I try to send an e-mail reply to a ticket I receive the following error.. This was working prior to the upgrade to 3.1.2 Any help would be appreciated Error Message: Impossible to send message to: berickson@ocusd.netmailto:berickson@ocusd.net, . Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Aug 3 08:49:27 2012 Message: Impossible to send message to: alarsen@ocusd.netmailto:alarsen@ocusd.net, . Traceback (4452): Module: Kernel::System::Ticket::Article::ArticleSend (v1.309) Line: 2180 Module: Kernel::Modules::AgentTicketCompose::Run (v1.161) Line: 736 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer --------------------------------------------------------------------- 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

Yep everything looks just as it was before the upgrade in sendmail.. checking the logs again I do get the following notice [Fri Aug 3 13:05:56 2012][Notice][main::_AutoRestart] Scheduler service is stopping due a restart. [Fri Aug 3 13:06:27 2012][Notice][main::_start] Scheduler Service is starting...! [Fri Aug 3 13:06:28 2012][Notice][main::_start] Scheduler Service start! PID 2912 [Fri Aug 3 13:06:28 2012][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! Scheduler is restarting...! Unsure if that would relate to not being able to send e-mails or not.. I just find it odd that it act like everything is ok (if something is wrong in sendmail it gives me an error back saying it cant send) the thread will update but the ticket won't close and e-mail won't send. From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 1:00 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Edit Config Settings in Framework -> Core::Sendmail Check it out. See if it makes sense to you. Probably you don't want sendmail, but rather SMTP, and all the configuration that belongs to it. On Fri, Aug 3, 2012 at 1:37 PM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I ended up having to reinstall DBD::mysql then I finished the process.. however now I no longer get any errors in ortrs.log but mail still does not send and I am left with just a blank page as previously From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 11:30 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 When I execute the DBUpdate-to-3.1.mysql.sql script I get a few errors back all stating that the table already exists and no other errors so I would assume that means this step was already ran So I continue on and I'm not really sure how to run the pl script but when I start the script in command prompt I get the following c:\Program Files (x86)\OTRS\OTRS\scripts>DBUpdate-to-3.1.plhttp://DBUpdate-to-3.1.pl Migration started... install_driver(mysql) failed: Can't locate DBD/mysql.pmhttp://mysql.pm in @INC (@INC contains: C:/Program Files (x86)/OTRS/OTRS/Custom C:/Program Files (x86)/OTRS/OTRS/Kernel/ cpan-lib C:/Program Files (x86)/OTRS/OTRS C:/Perl/site/lib C:/Perl/lib .) at (ev al 20) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQL ite, Sponge. at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/DB.pm line 256 c:\Program Files (x86)\OTRS\OTRS\scripts> the location of the mysql.pmhttp://mysql.pm file is C:\Program Files (x86)\OTRS\OTRS\Kernel\System\DB if that makes a difference From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 10:51 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 backup your database. and everything else. Read UPGRADING in your OTRS folder. You'll need to do three steps: a DBUpdate for schema, a perl update, and a post schema update, plus cache, config etc. This is assuming it hasn't been done already. I don't know the state of your database, especially since you had a crashed table. While the information should work, you should test it out before changing production. The information I've provided is not guaranteed for any purpose, and your situation may involve pieces that I can't guess from a mailing list. On Fri, Aug 3, 2012 at 11:28 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I upgraded from 3.0. So it appears it is fixable then by running the update? yes? How would I do that? I am running on a windows server From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 10:24 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 It may be that the conversion didn't complete but did you upgrade from 3.0 or 3.1.1? It appears you didn't complete the schema changes on upgrade. On Fri, Aug 3, 2012 at 11:12 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: Repaired the table and I am no longer receiving that error but now I get this.. unsure if its related or not. [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)' From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 10:03 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Nevermind I found it This coincides with the time [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 9:53 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Which logs would I look in to find the error information? From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 9:31 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 What do the logs say? Chances are, you *still* have problems sending email. On Fri, Aug 3, 2012 at 10:10 AM, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: I got past that error I believe I noticed that the sendmail settings had been defaulted with the upgrade.. but now when I reply to a ticket it opens a blank window no error messages nothing just sits there.. when I close the window no e-mail has been sent and the status of the ticket has not changed however the response is noted Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 8:55 AM To: otrs@otrs.orgmailto:otrs@otrs.org Subject: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Every time I try to send an e-mail reply to a ticket I receive the following error.. This was working prior to the upgrade to 3.1.2 Any help would be appreciated Error Message: Impossible to send message to: berickson@ocusd.netmailto:berickson@ocusd.net, . Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Aug 3 08:49:27 2012 Message: Impossible to send message to: alarsen@ocusd.netmailto:alarsen@ocusd.net, . Traceback (4452): Module: Kernel::System::Ticket::Article::ArticleSend (v1.309) Line: 2180 Module: Kernel::Modules::AgentTicketCompose::Run (v1.161) Line: 736 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer --------------------------------------------------------------------- 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

Sorry, I meant under sendmail in the config and I am using SMTP with the following settings. Module = SMTP Host = odexc-01 (also tried via internal IP and odexc-01.ocusd.local) Port = 25 Username/pass are set If I change any of these to an incorrect setting I get unable to deliver errors.. but with these settings all I get is a blank popup pointing to index.pl From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Steven Carr Sent: Friday, August 03, 2012 1:22 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Are you really sure you're using sendmail? on Windows?! Have you got an SMTP server you can try to use to see if it works? Also if you haven't already make sure you completely restart Apache so that everything gets reloaded from scratch. Steve On 3 August 2012 19:10, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: Yep everything looks just as it was before the upgrade in sendmail.. checking the logs again I do get the following notice [Fri Aug 3 13:05:56 2012][Notice][main::_AutoRestart] Scheduler service is stopping due a restart. [Fri Aug 3 13:06:27 2012][Notice][main::_start] Scheduler Service is starting...! [Fri Aug 3 13:06:28 2012][Notice][main::_start] Scheduler Service start! PID 2912 [Fri Aug 3 13:06:28 2012][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! Scheduler is restarting...! Unsure if that would relate to not being able to send e-mails or not.. I just find it odd that it act like everything is ok (if something is wrong in sendmail it gives me an error back saying it cant send) the thread will update but the ticket won’t close and e-mail won’t send.

I guess popup is the wrong way to put it (I thought it was a popup but it’s not).. What happens is I choose close ticket from reply dropdown then the reply window opens url otrs/index.pl?ChallengeToken=36ee82aa8457a265c4e7280db8574b33&Action=AgentTicketCompose&TicketID=1188&ArticleID=4408&ReplyAll=&ResponseID=3 I change status to closed successful hit submit and the window refreshes blanks out and sits there pointing to otrs/index.pl I set the apache logging level to debug and I am not getting any errors back From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Steven Carr Sent: Friday, August 03, 2012 1:55 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 At what point do you get the popup window? When clicking send? Not sure what is causing that (certainly doesn't happen on any OTRS systems I've ever used), does the Apache logs indicate that it's tried to access something that doesn't exist and then redirects you back to index.plhttp://index.pl? (you may need to tweak the apache config to turn up your logging level). Steve On 3 August 2012 19:29, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: Sorry, I meant under sendmail in the config and I am using SMTP with the following settings. Module = SMTP Host = odexc-01 (also tried via internal IP and odexc-01.ocusd.local) Port = 25 Username/pass are set If I change any of these to an incorrect setting I get unable to deliver errors.. but with these settings all I get is a blank popup pointing to index.plhttp://index.pl From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Steven Carr Sent: Friday, August 03, 2012 1:22 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Are you really sure you're using sendmail? on Windows?! Have you got an SMTP server you can try to use to see if it works? Also if you haven't already make sure you completely restart Apache so that everything gets reloaded from scratch. Steve On 3 August 2012 19:10, Gadow, Shawn mailto:sgadow@ocusd.net> wrote: Yep everything looks just as it was before the upgrade in sendmail.. checking the logs again I do get the following notice [Fri Aug 3 13:05:56 2012][Notice][main::_AutoRestart] Scheduler service is stopping due a restart. [Fri Aug 3 13:06:27 2012][Notice][main::_start] Scheduler Service is starting...! [Fri Aug 3 13:06:28 2012][Notice][main::_start] Scheduler Service start! PID 2912 [Fri Aug 3 13:06:28 2012][Notice][main::_AutoRestart] Config.pm changed, unsafe to continue! Scheduler is restarting...! Unsure if that would relate to not being able to send e-mails or not.. I just find it odd that it act like everything is ok (if something is wrong in sendmail it gives me an error back saying it cant send) the thread will update but the ticket won’t close and e-mail won’t send. --------------------------------------------------------------------- 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

Impossible to send is impossible to send. If you're still getting that, your SMTP server is blocking your ability to send.

* Gadow, Shawn :

How would an upgrade to otrs affect the SMTP server settings/blocking? I apologize for my ignorance on the subject it just don't make sense to me that something that the SMTP which was working prior to upgrade would be changed post upgrade when it was not touched

Well, shit happens. Maybe OTRS now forgets to authenticate or uses a different sender address. Stuff like that. Shouldn't happen, yes, but who knows? What does the MTA log say? -- Ralf Hildebrandt Charite Universitätsmedizin Berlin ralf.hildebrandt@charite.de Campus Benjamin Franklin http://www.charite.de Hindenburgdamm 30, 12203 Berlin Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155

* David Boyes :

*Something* has clearly changed here.

Can you confirm that the SMTP server is running and listening on port 25 and/or 478?

478? That's a non-standard port for anything SMTP related. Check for port 25 (SMTP) or 465 (SSMTP) or 587 (Submission) -- Ralf Hildebrandt Charite Universitätsmedizin Berlin ralf.hildebrandt@charite.de Campus Benjamin Franklin http://www.charite.de Hindenburgdamm 30, 12203 Berlin Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155