{"id":983,"date":"2018-12-06T11:33:13","date_gmt":"2018-12-06T07:33:13","guid":{"rendered":"https:\/\/bukleev.ru\/?page_id=983"},"modified":"2018-12-10T09:43:52","modified_gmt":"2018-12-10T05:43:52","slug":"%d0%be%d0%b1%d0%bd%d0%be%d0%b2%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-otrs-5-%d0%bd%d0%b0-otrs-6","status":"publish","type":"page","link":"https:\/\/bukleev.ru\/?page_id=983","title":{"rendered":"\u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 OTRS 5 \u043d\u0430 OTRS 6 Centos 7"},"content":{"rendered":"<p>\u0412 \u0446\u0435\u043b\u043e\u043c \u0432\u0441\u0435 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u043e, \u043d\u043e \u0435\u0441\u0442\u044c \u043d\u044e\u0430\u043d\u0441\u044b:<\/p>\n<p><a href=\"https:\/\/bukleev.ru\/mysql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80\/\">Mysql<\/a><\/p>\n<p>\u041e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u0441\u0435\u0440\u0432\u0438\u0441\u043e\u0432<\/p>\n<pre>systemctl stop httpd\r\nsystemctl stop crond\r\nsystemctl stop postfix\r\n\r\nsudo su - otrs -c \"\/opt\/otrs\/bin\/otrs.Daemon.pl stop\"\r\nsudo su - otrs -c \"\/opt\/otrs\/bin\/Cron.sh stop\"<\/pre>\n<p>update otrs 6<\/p>\n<pre>yum install perl-DateTime*\r\n\r\nrpm -Uvh otrs-6.0.14-01.noarch.rpm\r\n\u0438\u043b\u0438\r\nyum install --nogpgcheck otrs-6.0.14-01.noarch.rpm<\/pre>\n<p>\u0415\u0441\u043b\u0438 \u0432\u0438\u0441\u0438\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c otrs \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u043d\u0435 \u043f\u0440\u043e\u0439\u0434\u0435\u0442<\/p>\n<p>\u041d\u0430\u0445\u043e\u0434\u0438\u043c \u043f\u0440\u043e\u0446\u0435\u0441\u0441<\/p>\n<pre>ps -auxw | grep otrs<\/pre>\n<p>\u0423\u0431\u0438\u0432\u0430\u0435\u043c \u0435\u0433\u043e \u043f\u0440\u043e\u0446\u0435\u0441\u0441<\/p>\n<pre>kill -9 ID<\/pre>\n<p>\u041f\u043e\u0432\u0442\u043e\u0440\u044f\u0435\u043c \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435.<\/p>\n<p>\u0437\u0430\u043f\u0443\u0441\u043a \u0441\u043a\u0440\u0438\u043f\u0442\u0430<\/p>\n<pre class=\"screen\">cd \/opt\/otrs\/\r\nbin\/otrs.SetPermissions.pl\r\n\r\nsudo su - otrs -c \/opt\/otrs\/scripts\/DBUpdate-to-6.pl<\/pre>\n<p>\u0415\u0441\u043b\u0438 \u0432\u043e\u0437\u043d\u0438\u043a\u0430\u0435\u0442 \u043e\u0448\u0438\u0431\u043a\u0430<\/p>\n<p>Error: The setting character_set_database needs to be &#8216;utf8&#8217;.<\/p>\n<p>\u0422\u043e\u0433\u0434\u0430<\/p>\n<p>ALTER DATABASE otrs CHARACTER SET utf8 COLLATE utf8_general_ci;<\/p>\n<p>&nbsp;<\/p>\n<p>\u0417\u0430\u043f\u0443\u0441\u043a \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 \u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0439, \u043d\u0430 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0435 \u043d\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u0441\u044f, \u0442\u043e\u043b\u044c\u043a\u043e \u0447\u0435\u0440\u0435\u0437 \u043f\u0430\u043d\u0435\u043b\u044c<\/p>\n<pre>sudo su - otrs -c \/opt\/otrs\/bin\/otrs.Console.pl Admin::Package::UpgradeAll<\/pre>\n<p>\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u0441 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u043e\u0439 \u043f\u043e\u0447\u0442\u044b \u0447\u0435\u0440\u0435\u0437 mail.nic.ru.<br \/>\n\u041f\u043e\u043c\u043e\u0433\u043b\u0430 <a href=\"https:\/\/habr.com\/post\/281102\/\">\u0441\u0442\u0430\u0442\u044c\u044f<\/a><\/p>\n<p>\u0412 \u0438\u0442\u043e\u0433\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c \u0447\u0435\u0440\u0435\u0437 sendmail<\/p>\n<p>\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u043d\u0443\u0436\u043d\u044b\u0445 \u043f\u0430\u043a\u0435\u0442\u043e\u0432:<\/p>\n<pre><code class=\"bash hljs\">yum install sendmail sendmail-cf openssl cyrus-sasl cyrus-sasl-plain nano\r\n<\/code><\/pre>\n<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 SSL \u0441\u0435\u0440\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0432:<\/p>\n<pre><code class=\"bash hljs\">mkdir \/etc\/mail\/certs\r\nchmod 700 \/etc\/mail\/certs \r\n<span class=\"hljs-built_in\">cd<\/span> \/etc\/mail\/certs\r\nopenssl dsaparam 1024 -out dsa1024 -out dsa1024.pem\r\nopenssl req -x509 -nodes -days 3650 -newkey dsa:dsa1024.pem -out \/etc\/mail\/certs\/mycert.pem -keyout \/etc\/mail\/certs\/mykey.pem\r\nopenssl req -x509 -new -days 3650 -key \/etc\/mail\/certs\/mykey.pem -out \/etc\/mail\/certs\/mycert.pem\r\nln -s \/etc\/mail\/certs\/mycert.pem \/etc\/mail\/certs\/CAcert.pem\r\nchmod 600 \/etc\/mail\/certs\/*\r\n<\/code><\/pre>\n<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0444\u0430\u0439\u043b\u0430 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0434\u043b\u044f \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u0438:<\/p>\n<pre><code class=\"bash hljs\">nano \/etc\/mail\/auth\/authinfo\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre><code class=\"hljs css\"><span class=\"hljs-selector-tag\">AuthInfo<\/span><span class=\"hljs-selector-pseudo\">:mail.nic.ru<\/span> \"<span class=\"hljs-selector-tag\">U<\/span><span class=\"hljs-selector-pseudo\">:support@MYDOMEN.RU\"<\/span> \"<span class=\"hljs-selector-tag\">I<\/span><span class=\"hljs-selector-pseudo\">:support<\/span>@MYDOMEN.RU\" <span class=\"hljs-string\">\"P:PASSWORD\"<\/span>\r\nAuthInfo: <span class=\"hljs-string\">\"U:support@MYDOMEN.RU\"<\/span> <span class=\"hljs-string\">\"I:support@MYDOMEN.RU\"<\/span> <span class=\"hljs-string\">\"P:PASSWORD\"<\/span>\r\n<\/code><\/pre>\n<p>\u041a\u043e\u043d\u0432\u0435\u0440\u0442\u0438\u0440\u0443\u0435\u043c:<\/p>\n<pre><code class=\"hljs ruby\">makemap hash -r \/etc\/mail\/auth\/authinfo &lt; <span class=\"hljs-regexp\">\/etc\/mail<\/span><span class=\"hljs-regexp\">\/auth\/authinfo<\/span>\r\n<\/code><\/pre>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432 sendmail.mc \u043d\u0443\u0436\u043d\u0443\u044e \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044e (\u0432\u0430\u0436\u043d\u043e: \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u044d\u0442\u043e \u0434\u043e \u043f\u0435\u0440\u0432\u043e\u0433\u043e FEATURE):<\/p>\n<pre><code class=\"hljs perl\">dnl <span class=\"hljs-comment\"># Smtp relay<\/span>\r\ndefine(<span class=\"hljs-string\">`CERT_DIR', `<\/span>MAIL_SETTINGS_DIR<span class=\"hljs-string\">`'certs')\r\ndefine(`<\/span>confCACERT_PATH<span class=\"hljs-string\">', `CERT_DIR'<\/span>)\r\ndefine(<span class=\"hljs-string\">`confCACERT', `<\/span>CERT_DIR\/CAcert.pem<span class=\"hljs-string\">')\r\ndefine(`confSERVER_CERT'<\/span>, <span class=\"hljs-string\">`CERT_DIR\/mycert.pem')\r\ndefine(`<\/span>confSERVER_KEY<span class=\"hljs-string\">', `CERT_DIR\/mykey.pem'<\/span>)\r\ndefine(<span class=\"hljs-string\">`confCLIENT_CERT', `<\/span>CERT_DIR\/mycert.pem<span class=\"hljs-string\">')\r\ndefine(`confCLIENT_KEY'<\/span>, <span class=\"hljs-string\">`CERT_DIR\/mykey.pem')\r\ndnl #\r\ndnl # mail.nic.ru auth\r\ndefine(`<\/span>SMART_HOST<span class=\"hljs-string\">',`[mail.nic.ru]'<\/span>)dnl\r\ndefine(<span class=\"hljs-string\">`RELAY_MAILER_ARGS', `<\/span>TCP $h <span class=\"hljs-number\">587<\/span><span class=\"hljs-string\">')dnl\r\ndefine(`ESMTP_MAILER_ARGS'<\/span>, <span class=\"hljs-string\">`TCP $h 465')dnl\r\ndefine(`<\/span>confAUTH_OPTIONS<span class=\"hljs-string\">', `A p'<\/span>)dnl\r\nTRUST_AUTH_MECH(<span class=\"hljs-string\">`EXTERNAL DIGEST-MD5 CRAM-MD5 LOGIN PLAIN')dnl\r\ndefine(`<\/span>confAUTH_MECHANISMS<span class=\"hljs-string\">', `EXTERNAL GSSAPI DIGEST-MD5 CRAM-MD5 LOGIN PLAIN'<\/span>)dnl\r\nFEATURE(<span class=\"hljs-string\">`authinfo',`<\/span>hash -o \/etc\/mail\/auth\/authinfo.db<span class=\"hljs-string\">')dnl\r\n<\/span><\/code><\/pre>\n<p>\u041a\u043e\u043c\u043f\u0438\u043b\u0438\u0440\u0443\u0435\u043c \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044e, \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c sendmail \u0438 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0443 \u043f\u043e\u0447\u0442\u044b:<\/p>\n<pre>make -C \/etc\/mail\r\nservice sendmail restart<\/pre>\n<p>\u0412 OTRS \u0432\u044b\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0443 \u0447\u0435\u0440\u0435\u0437 Sendmail<\/p>\n<p>\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438<\/p>\n<pre class=\"screen\">sudo -u otrs \/opt\/otrs\/bin\/otrs.Console.pl Maint::Email::MailQueue --list<\/pre>\n<p>\u041c\u043e\u0436\u043d\u043e \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0438\u0437 \u043e\u0447\u0435\u0440\u0435\u0434\u0438<\/p>\n<pre> sudo -u otrs \/opt\/otrs\/bin\/otrs.Console.pl Maint::Email::MailQueue --delete --filter ID::540<\/pre>\n<p>\u0418\u043b\u0438 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0432\u0441\u0435<\/p>\n<p><code class=\"literal\">--delete-all<\/code><\/p>\n<p>\u0418\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u0432\u0437\u044f\u0442\u0430\u00a0<strong><a href=\"http:\/\/doc.otrs.com\/doc\/manual\/admin\/6.0\/ru\/html\/email-settings.html#email-sending\"> \u043e\u0442\u0441\u044e\u0434\u0430<\/a><\/strong><\/p>\n<p>\u041d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u0435\u0449\u0435 \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b, \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0431\u0430\u0437\u044b OTRS 6 \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u0434\u0440\u0443\u0433\u0430\u044f.<\/p>\n<pre>CREATE DEFINER=`root`@`%` PROCEDURE `DeleteArticleByID`(IN ID_article_id INT)\r\nBEGIN\r\n-- \u0423\u0434\u0430\u043b\u044f\u0435\u043c article\r\nSTART TRANSACTION;\r\n-- Provide the values of the primary key of the row to delete.\r\nSET @id_to_delete = ID_article_id;\r\n\r\nDELETE FROM article_data_mime\r\n    USING article_data_mime, article\r\n    WHERE `article`.`id` = `article_data_mime`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM article_data_mime_attachment\r\n    USING article_data_mime_attachment, article\r\n    WHERE `article`.`id` = `article_data_mime_attachment`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM article_data_mime_plain\r\n    USING article_data_mime_plain, article\r\n    WHERE `article`.`id` = `article_data_mime_plain`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM article_data_mime_send_error\r\n    USING article_data_mime_send_error, article\r\n    WHERE `article`.`id` = `article_data_mime_send_error`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM article_data_otrs_chat\r\n    USING article_data_otrs_chat, article\r\n    WHERE `article`.`id` = `article_data_otrs_chat`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM article_flag\r\n    USING article_flag, article\r\n    WHERE `article`.`id` = `article_flag`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM article_search_index\r\n    USING article_search_index, article\r\n    WHERE `article`.`id` = `article_search_index`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM mail_queue\r\n    USING mail_queue, article\r\n    WHERE `article`.`id` = `mail_queue`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM ticket_history\r\n    USING ticket_history, article\r\n    WHERE `article`.`id` = `ticket_history`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM time_accounting\r\n    USING time_accounting, article\r\n    WHERE `article`.`id` = `time_accounting`.`article_id`\r\n          AND article.id = @id_to_delete;\r\nDELETE FROM article\r\n    USING article\r\n    WHERE article.id = @id_to_delete;\r\nCOMMIT;\r\n    \r\n\r\nSELECT 1;\r\nEND<\/pre>\n<p>\u0438<\/p>\n<pre>CREATE DEFINER=`root`@`%` PROCEDURE `DeleteTicketByID`(IN ID_ticket_id INT)\r\nBEGIN\r\n-- \u0423\u0434\u0430\u043b\u044f\u0435\u043c ticket\r\nSTART TRANSACTION;\r\n-- Provide the values of the primary key of the row to delete.\r\nSET @id_to_delete = ID_ticket_id;\r\n\r\nDELETE FROM ticket_flag\r\n USING ticket_flag, ticket\r\n WHERE `ticket`.`id` = `ticket_flag`.`ticket_id`\r\n AND ticket.id = @id_to_delete;\r\nDELETE FROM ticket_history\r\n USING ticket_history, ticket\r\n WHERE `ticket`.`id` = `ticket_history`.`ticket_id`\r\n AND ticket.id = @id_to_delete;\r\nDELETE FROM ticket_index\r\n USING ticket_index, ticket\r\n WHERE `ticket`.`id` = `ticket_index`.`ticket_id`\r\n AND ticket.id = @id_to_delete;\r\nDELETE FROM ticket_lock_index\r\n USING ticket_lock_index, ticket\r\n WHERE `ticket`.`id` = `ticket_lock_index`.`ticket_id`\r\n AND ticket.id = @id_to_delete;\r\nDELETE FROM ticket_watcher\r\n USING ticket_watcher, ticket\r\n WHERE `ticket`.`id` = `ticket_watcher`.`ticket_id`\r\n AND ticket.id = @id_to_delete;\r\nDELETE FROM time_accounting\r\n USING time_accounting, ticket\r\n WHERE `ticket`.`id` = `time_accounting`.`ticket_id`\r\n AND ticket.id = @id_to_delete;\r\nDELETE FROM ticket\r\n USING ticket\r\n WHERE ticket.id = @id_to_delete;\r\nCOMMIT;\r\nSELECT 1;\r\nEND<\/pre>\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u0435\u0439 perl<\/p>\n<pre>sudo su - otrs -c \"\/opt\/otrs\/bin\/otrs.CheckModules.pl\"<code><\/code><\/pre>\n<p><strong><a href=\"https:\/\/opar.perl-services.de\/dist\/DisableOTRSBusinessNotification\">Disable OTRS business<\/a><\/strong><\/p>\n<p>\u0420\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f<\/p>\n<pre>\/opt\/otrs\/scripts\/backup.pl -d \/var\/backup<\/pre>\n<p><strong><a href=\"https:\/\/bukleev.ru\/%d1%81%d0%be%d0%b7%d0%b4%d0%b0%d0%bd%d0%b8%d0%b5-%d0%b7%d0%b0%d1%8f%d0%b2%d0%ba%d0%b8-otrs-%d1%87%d0%b5%d1%80%d0%b5%d0%b7-soap\/\">\u041f\u0440\u0438\u043c\u0435\u0440 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0437\u0430\u044f\u0432\u043a\u0438 \u0447\u0435\u0440\u0435\u0437 SOAP<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0412 \u0446\u0435\u043b\u043e\u043c \u0432\u0441\u0435 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u043e, \u043d\u043e \u0435\u0441\u0442\u044c \u043d\u044e\u0430\u043d\u0441\u044b: Mysql \u041e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u0441\u0435\u0440\u0432\u0438\u0441\u043e\u0432 systemctl stop httpd systemctl stop crond systemctl stop postfix sudo su &#8212; otrs -c &#171;\/opt\/otrs\/bin\/otrs.Daemon.pl stop&#187; sudo su &#8212; otrs -c &#171;\/opt\/otrs\/bin\/Cron.sh stop&#187; update otrs 6 yum install perl-DateTime* rpm<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-983","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=983"}],"version-history":[{"count":27,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/983\/revisions"}],"predecessor-version":[{"id":1025,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/983\/revisions\/1025"}],"wp:attachment":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}