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 <sga...@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-boun...@otrs.org [mailto:otrs-boun...@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-boun...@otrs.org [mailto:otrs-boun...@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 <sga...@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-boun...@otrs.org [mailto:otrs-boun...@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 <sga...@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-boun...@otrs.org [mailto:otrs-boun...@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-boun...@otrs.org [mailto:otrs-boun...@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-boun...@otrs.org [mailto:otrs-boun...@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 <sga...@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-boun...@otrs.org [mailto:otrs-boun...@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: berick...@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: alar...@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 >
--------------------------------------------------------------------- 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
