From: Vladimir Karpinsky <vkarpinsky@mail.ru> To: sysadmins@lists.altlinux.org Subject: Re: [Sysadmins] MySQL 5.7 & Roundcube Date: Sat, 30 Jun 2018 11:33:01 +0300 Message-ID: <737689eb-c317-ea98-8946-dfddb8129a44@mail.ru> (raw) In-Reply-To: <c3573800-fe0b-10eb-db7d-a2c5ac621432@mail.ru> 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 и >> про это ничего нет. >> > -- С уважением, Владимир.
prev parent reply other threads:[~2018-06-30 8:33 UTC|newest] Thread overview: 17+ messages / expand[flat|nested] mbox.gz Atom feed top 2018-06-05 15:17 Vladimir Karpinsky 2018-06-05 15:42 ` Andrey Cherepanov 2018-06-05 16:12 ` Michael Shigorin 2018-06-05 17:08 ` Vladimir Karpinsky 2018-06-05 15:53 ` Гусев Владислав Юрьевич 2018-06-05 17:11 ` Vladimir Karpinsky 2018-06-06 8:10 ` Гусев Владислав Юрьевич 2018-06-06 8:33 ` Konstantin Lepikhov 2018-06-06 8:42 ` Гусев Владислав Юрьевич 2018-06-06 12:22 ` Vladimir Karpinsky 2018-06-06 14:30 ` Гусев Владислав Юрьевич 2018-06-06 15:39 ` Vladimir Karpinsky 2018-06-06 16:05 ` Гусев Владислав Юрьевич 2018-06-06 17:12 ` Vladimir Karpinsky 2018-06-29 11:38 ` Vladimir Karpinsky 2018-06-29 19:24 ` Vladimir Karpinsky 2018-06-30 8:33 ` Vladimir Karpinsky [this message]
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=737689eb-c317-ea98-8946-dfddb8129a44@mail.ru \ --to=vkarpinsky@mail.ru \ --cc=sysadmins@lists.altlinux.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux sysadmins discussion This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/sysadmins/0 sysadmins/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 sysadmins sysadmins/ http://lore.altlinux.org/sysadmins \ sysadmins@lists.altlinux.org sysadmins@lists.altlinux.ru sysadmins@lists.altlinux.com public-inbox-index sysadmins Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.sysadmins AGPL code for this site: git clone https://public-inbox.org/public-inbox.git