From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on sa.local.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-2.0 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM autolearn=ham autolearn_force=no version=3.4.1 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru; s=mail2; h=Content-Transfer-Encoding:Content-Type:In-Reply-To:MIME-Version:Date:Message-ID:References:To:From:Subject; bh=KN4R+9e4dr5PX4D8xiOQUnkSy8kfEVZpUcFBHIXE2qQ=; b=pA1eEJ3n2hjZAGtQQ3wlQgimzf1DJHFaj20M0xYPV5d19AMeIlq/7ufVN90yAOO+/CbPeh5taq3IqLvJ7ilELGGAOM3bNvyOGGB8MY3YYHbK8SyTJA1Pgrgwoa0ZwunwbyAo0+byepA5+r1GStqDYTN6dCgtuMXsD5Rj6vNdXkQ=; From: Vladimir Karpinsky To: sysadmins@lists.altlinux.org References: <3a9bafaf-2d59-87e3-46ff-7f91a1d2528d@mail.ru> <9A7F6F017E39DA45862D39A85281C601029262A53E@Exch2.smpbank> <8b3f418a-4e98-308e-0d5f-65e5d227008a@mail.ru> <20180606083314.GA21367@lks.home> <9A7F6F017E39DA45862D39A85281C601029262B020@Exch2.smpbank> <5b9cee0e-e720-f8ff-c194-f91d11904aea@mail.ru> <9A7F6F017E39DA45862D39A85281C601029262BBA0@Exch2.smpbank> <3fa22608-a65c-aa8e-f0e1-5301d97214be@mail.ru> <9A7F6F017E39DA45862D39A85281C601029262C09E@Exch2.smpbank> <1784b301-b5f6-85f9-202c-ae1ae31fe485@mail.ru> Message-ID: <737689eb-c317-ea98-8946-dfddb8129a44@mail.ru> Date: Sat, 30 Jun 2018 11:33:01 +0300 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=koi8-r; format=flowed Content-Language: Russian-English Content-Transfer-Encoding: 8bit Authentication-Results: smtp15.mail.ru; auth=pass smtp.auth=vkarpinsky@mail.ru smtp.mailfrom=vkarpinsky@mail.ru X-7FA49CB5: 0D63561A33F958A5351BD6108198A80590F0C1EEFE88DB0303796B6F138663890A6AB1C7CE11FEE34A7E03851CBA2956BA3038C0950A5D36B5C8C57E37DE458B4C7702A67D5C33162DBA43225CD8A89F616AD31D0D18CD5C5BCEC483924625CA84CD44695559C53343847C11F186F3C5E7DDDDC251EA7DABCC89B49CDF41148F53FDB0A1CE3EC88B3B503F486389A921A5CC5B56E945C8DA X-Mailru-Sender: 47CC51BD8988F123F49F813D96F3A78C6B33BC5D2C1FBCA41B16215823E074AA33359DCF93FA2130189086648D43AF80C77752E0C033A69E9629CB05D30F4213116F0678BC710751AE208404248635DF X-Mras: OK Subject: Re: [Sysadmins] MySQL 5.7 & Roundcube X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.12 Precedence: list Reply-To: ALT Linux sysadmins' discussion List-Id: ALT Linux sysadmins' discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 30 Jun 2018 08:33:05 -0000 Archived-At: List-Archive: 29.06.2018 22:24, Vladimir Karpinsky ÐÉÛÅÔ: > P.S. á Í.Â. ÌÕÞÛÅ ×ÏÏÂÝÅ ÎÁ íÁÒÉÀäâ ÐÅÒÅÊÔÉ É ÎÅ ÍÕÞÉÔØÓÑ Ó 5.7? üÔÏ ÏËÁÚÁÌÏÓØ ÐÒÏÝÅ... > 29.06.2018 14:38, Vladimir Karpinsky ÐÉÛÅÔ: >> úÄÒÁ×ÓÔ×ÕÊÔÅ! >> >> ÷ÔÏÒÏÊ ÐÏÄÈÏÄ: ÕÂÉÒÁÀ MySQL Ó ÚÁÍÏÒÏÚËÉ, ÏÂÎÏ×ÌÑÀ, ÄÁÌÅÅ: >> # service mysqld stop >> # /usr/sbin/mysqld -C utf8 --skip-grant-tables & >> # /usr/bin/mysql_upgrade >> ... >> roundcubemail.cache >> errorššš : Table rebuild required. Please do "ALTER TABLE `cache` FORCE" >> or dump/reload to fix it! >> roundcubemail.cache_index >> errorššš : Table rebuild required. Please do "ALTER TABLE `cache_index` >> FORCE" or dump/reload to fix it! >> roundcubemail.cache_messages >> errorššš : Table rebuild required. Please do "ALTER TABLE >> `cache_messages` FORCE" or dump/reload to fix it! >> roundcubemail.cache_shared >> errorššš : Table rebuild required. Please do "ALTER TABLE `cache_shared` >> FORCE" or dump/reload to fix it! >> roundcubemail.cache_thread >> errorššš : Table rebuild required. Please do "ALTER TABLE `cache_thread` >> FORCE" or dump/reload to fix it! >> roundcubemail.contactgroupmembers >> errorššš : Table rebuild required. Please do "ALTER TABLE >> `contactgroupmembers` FORCE" or dump/reload to fix it! >> roundcubemail.contactgroups >> errorššš : Table rebuild required. Please do "ALTER TABLE `contactgroups` >> FORCE" or dump/reload to fix it! >> roundcubemail.contacts >> errorššš : Table rebuild required. Please do "ALTER TABLE `contacts` >> FORCE" or dump/reload to fix it! >> roundcubemail.dictionaryšššššššššššššššššššššššššš OK >> roundcubemail.identities >> errorššš : Table rebuild required. Please do "ALTER TABLE `identities` >> FORCE" or dump/reload to fix it! >> roundcubemail.searchesšššššššššššššššššššššššššššš OK >> roundcubemail.session >> errorššš : Table rebuild required. Please do "ALTER TABLE `session` >> FORCE" or dump/reload to fix it! >> roundcubemail.systemšššššššššššššššššššššššššššššš OK >> roundcubemail.users >> errorššš : Table rebuild required. Please do "ALTER TABLE `users` FORCE" >> or dump/reload to fix it! >> sys.sys_configšššššššššššššššššššššššššššššššššššš OK >> ... >> `roundcubemail`.`cache` >> Runningš : ALTER TABLE `roundcubemail`.`cache` FORCE >> statusšš : OK >> `roundcubemail`.`cache_index` >> Runningš : ALTER TABLE `roundcubemail`.`cache_index` FORCE >> statusšš : OK >> `roundcubemail`.`cache_messages` >> Runningš : ALTER TABLE `roundcubemail`.`cache_messages` FORCE >> statusšš : OK >> `roundcubemail`.`cache_shared` >> Runningš : ALTER TABLE `roundcubemail`.`cache_shared` FORCE >> statusšš : OK >> `roundcubemail`.`cache_thread` >> Runningš : ALTER TABLE `roundcubemail`.`cache_thread` FORCE >> statusšš : OK >> `roundcubemail`.`contactgroupmembers` >> Runningš : ALTER TABLE `roundcubemail`.`contactgroupmembers` FORCE >> statusšš : OK >> `roundcubemail`.`contactgroups` >> Runningš : ALTER TABLE `roundcubemail`.`contactgroups` FORCE >> statusšš : OK >> `roundcubemail`.`contacts` >> Runningš : ALTER TABLE `roundcubemail`.`contacts` FORCE >> statusšš : OK >> `roundcubemail`.`identities` >> Runningš : ALTER TABLE `roundcubemail`.`identities` FORCE >> statusšš : OK >> `roundcubemail`.`session` >> Runningš : ALTER TABLE `roundcubemail`.`session` FORCE >> statusšš : OK >> `roundcubemail`.`users` >> Runningš : ALTER TABLE `roundcubemail`.`users` FORCE >> statusšš : OK >> Upgrade process completed successfully. >> >> Roundcube ÐÒÉ ÐÏÐÙÔËÅ ÐÏÄËÌÀÞÅÎÉÑ ÐÏ-ÐÒÅÖÎÅÍÕ ×ÙÄÁ£Ô: >> >> DATABASE ERROR: CONNECTION FAILED! >> Unable to connect to the database! >> Please contact your server-administrator. >> >> ÷ /var/log/httpd2/access: >> 192.168.5.100 - - [29/Jun/2018:14:11:46 +0300] "GET /roundcube/ HTTP/1.1" >> 200 2480 >> 192.168.5.100 - - [29/Jun/2018:14:11:46 +0300] "GET >> /roundcube/skins/classic/common.min.css?s=1516112807 HTTP/1.1" 304 - >> 192.168.5.100 - - [29/Jun/2018:14:11:46 +0300] "GET >> /roundcube/plugins/jqueryui/themes/classic/jquery-ui.css?s=1516112807 >> HTTP/1.1" 304 - >> 192.168.5.100 - - [29/Jun/2018:14:11:46 +0300] "GET >> /roundcube/program/js/jquery.min.js?s=1516112807 HTTP/1.1" 304 - >> 192.168.5.100 - - [29/Jun/2018:14:11:46 +0300] "GET >> /roundcube/program/js/common.min.js?s=1516112807 HTTP/1.1" 304 - >> 192.168.5.100 - - [29/Jun/2018:14:11:46 +0300] "GET >> /roundcube/program/js/app.min.js?s=1516112807 HTTP/1.1" 304 - >> 192.168.5.100 - - [29/Jun/2018:14:11:46 +0300] "GET >> /roundcube/skins/classic/images/roundcube_logo.png HTTP/1.1" 304 - >> >> ÷ /var/log/httpd2/ssl_request_log ÐÏÑ×ÌÑÅÔÓÑ ÉÎÆÏÒÍÁÃÉÑ Ï ÄÏÓÔÕÐÅ ÐÏ >> https, ÏÛÉÂÏË ÎÉÇÄÅ ÎÅÔ. ÷ /var/log/mysql ÎÉÞÅÇÏ ÎÅÔ. >> >>> ôÁË ÚÁÐÕÓÔÉÔÅ httpd × ÏÄÉÎ ÐÒÏÃÅÓÓ É strace ÎÁ ÎÅÇÏ - ÓÒÁÚÕ ÂÕÄÅÔ ×ÉÄÎÏ, >>> ÐÏÞÅÍÕ ÎÅ ÓÏÅÄÉÎÑÅÔÓÑ. >> >> ëÁË ÜÔÏ ÓÄÅÌÁÔØ? >> >> ðÒÉ ÐÏÐÙÔËÅ ÚÁÊÔÉ × âä: >> # mysql -uroundcube -p roundcubemail >> ÐÏÌÕÞÁÀ "Access denied" ÐÏÓÌÅ ××ÏÄÁ ÐÒÁ×ÉÌØÎÏÇÏ ÐÁÒÏÌÑ. ÷ ÌÏÇÁÈ MySQL É >> ÐÒÏ ÜÔÏ ÎÉÞÅÇÏ ÎÅÔ. >> > -- ó Õ×ÁÖÅÎÉÅÍ, ÷ÌÁÄÉÍÉÒ.