Re: [Sysadmins] MySQL 5.7 & Roundcube

[Vladimir Karpinsky <vkarpinsky@mail.ru>]

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 и про 
> это ничего нет.
> 

-- 
	С уважением,
		Владимир.