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=qduphfBiRcu0qdEPfg6TeN5H8jW8SW2MjHkWHbbOEd0=; b=JaLFcfYE02HmSttiQLofqzklTOZgeJ1G4qjeXUSLaQ2bBMjbE6o6ZBpv57yhq8rrsijciyqbKLIDzyQQW8SlEjlVpgE0hpAJb/A7ScLceBjdb8Wrg7SrbUj+g5YfuvjG1Om5G54xXGbGgScLHQMCSi3teyGSKJnWnD1jKQ9Kjco=; 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: Date: Fri, 29 Jun 2018 22:24:33 +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: smtp36.i.mail.ru; auth=pass smtp.auth=vkarpinsky@mail.ru smtp.mailfrom=vkarpinsky@mail.ru X-7FA49CB5: 0D63561A33F958A5726163F1C7386EB24DE3ED44CDB7F4E573E4FCCDA1DA410A0A6AB1C7CE11FEE34A7E03851CBA2956BA3038C0950A5D36B5C8C57E37DE458B4C7702A67D5C33162DBA43225CD8A89F616AD31D0D18CD5C8A091E83291334A42435BB86DB05194943847C11F186F3C5E7DDDDC251EA7DABCC89B49CDF41148F53FDB0A1CE3EC88B3B503F486389A921A5CC5B56E945C8DA X-Mailru-Sender: 47CC51BD8988F123F49F813D96F3A78CFC96F036BD61429DEBF613C973B9E5F3F36D9CB914168FFE189086648D43AF80C77752E0C033A69E9629CB05D30F4213116F0678BC710751AE208404248635DF 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: Fri, 29 Jun 2018 19:24:38 -0000 Archived-At: List-Archive: 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 É ÐÒÏ > ÜÔÏ ÎÉÞÅÇÏ ÎÅÔ. > -- ó Õ×ÁÖÅÎÉÅÍ, ÷ÌÁÄÉÍÉÒ.