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=kC7ZHFR+hNysb+fxPTdRGWYkxhbh2rAGUY/DaGWvJuk=; b=TKal48LFJl2fUmv5yCE8YE7Ay8rwPXJjbFfFr650MjrkZGBb/QsGqK2+rnJV85LO2F7eNxJGbiWPosnbp2Q/YhUP0Kilq3cpyA2bBU8HYCvYyVn1naCFbK2cLIlrVGIe/8tI8VqG9ff7z+NLPmEapNO11u11LNKxi5sNsoqfDBE=; 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 14:38:08 +0300 User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:52.0) Gecko/20100101 Thunderbird/52.8.0 MIME-Version: 1.0 In-Reply-To: <1784b301-b5f6-85f9-202c-ae1ae31fe485@mail.ru> Content-Type: text/plain; charset=koi8-r; format=flowed Content-Language: Russian-English Content-Transfer-Encoding: 8bit Authentication-Results: smtp37.i.mail.ru; auth=pass smtp.auth=vkarpinsky@mail.ru smtp.mailfrom=vkarpinsky@mail.ru X-7FA49CB5: 0D63561A33F958A59113FBF1736603280C23542A4FDEE7B49C6389B67E84BA280A6AB1C7CE11FEE3A5ED62E35AC703CCBA3038C0950A5D36B5C8C57E37DE458B4C7702A67D5C33162DBA43225CD8A89FF841BD135A60A31748A5B9AE89E5778F6B0B6A749F1976AFC4224003CC836476C0CAF46E325F83A50BF2EBBBDD9D6B0F2AF38021CC9F462D574AF45C6390F7469DAA53EE0834AAEE X-Mailru-Sender: 47CC51BD8988F1239F557003D4A8B6C59C69D20FA5D15C773AA4FBC541AF11ABB8C4E2D7BE1C0E53189086648D43AF80C77752E0C033A69E9629CB05D30F4213116F0678BC710751AE208404248635DF 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 11:38:12 -0000 Archived-At: List-Archive: Здравствуйте! Второй подход: убираю 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 и про это ничего нет. -- С уважением, Владимир.