Re: [Sysadmins] MySQL 5.7 & Roundcube

Fri, 29 Jun 2018 12:25:23 -0700 

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



--
        С уважением,
                Владимир.
_______________________________________________
Sysadmins mailing list
Sysadmins@lists.altlinux.org
https://lists.altlinux.org/mailman/listinfo/sysadmins

Ответить