[Sysadmins] MySQL 5.7 & Roundcube

[Vladimir Karpinsky]

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

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