Re: [Sysadmins] MySQL 5.7 & Roundcube
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
Re: [Sysadmins] [[Infiniband]]
On Fri, Jun 29, 2018 at 10:14:37PM +0300, Andrey Savchenko wrote: > > > Ниже инструкция по установке и настройке > > Как по мне так её стоит после удаления минимума > > специфики конкретного случая на altlinux.org/RDMA! > Готово: https://www.altlinux.org/Infiniband > > RDMA — это всего лишь частный случай технологии, > работающей поверх Infiniband. Спасибо! Проанонсирую-ка в sysadmins@ и sisyphus@ :) -- WBR, Michael Shigorin / http://altlinux.org -- http://opennet.ru / http://anna-news.info ___ Sysadmins mailing list Sysadmins@lists.altlinux.org https://lists.altlinux.org/mailman/listinfo/sysadmins
Re: [Sysadmins] MySQL 5.7 & Roundcube
Здравствуйте! Второй подход: убираю 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
