ansible MySQL installation problem lab2a , lab2b

[burakyilmaz-db]

Hello, Lab2a and lab2b get an error like below ;

TASK [common : enable mysql80-community repo] ** changed: [lab2b]

TASK [common : Install mysql community server 8.0] ***** [DEPRECATION WARNING]: Invoking "yum" only once while using a loop via squash_actions is deprecated. Instead of using a loop to supply multiple items and specifying name: "{{ item }}", please use name: ['mysql-community- server-8.0.11-1.el7.x86_64'] and remove the loop. This feature will be removed in version 2.11. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. failed: [lab2b] (item=[u'mysql-community-server-8.0.11-1.el7.x86_64']) => {"changed": false, "item": ["mysql-community-server-8.0.11-1.el7.x86_64"], "msg": "Error: mysql-community-client-plugins conflicts with mysql-community-server-8.0.11-1.el7.x86_64\n", "rc": 1, "results": ["Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n base: mirror.ni.net.tr\n epel: mirror.bytemark.co.uk\n extras: centos.turhost.com\n updates: mirror.isimtescil.com.tr\nResolving Dependencies\n--> Running transaction check\n---> Package mysql-community-server.x86_64 0:8.0.11-1.el7 will be installed\n--> Processing Dependency: mysql-community-common(x86-64) = 8.0.11-1.el7 for package: mysql-community-server-8.0.11-1.el7.x86_64\n--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.11-1.el7.x86_64\n--> Running transaction check\n---> Package mysql-community-client.x86_64 0:8.0.25-1.el7 will be installed\n--> Processing Dependency: mysql-community-client-plugins = 8.0.25-1.el7 for package: mysql-community-client-8.0.25-1.el7.x86_64\n--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.25-1.el7.x86_64\n---> Package mysql-community-common.x86_64 0:8.0.11-1.el7 will be installed\n--> Running transaction check\n---> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be obsoleted\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: sysbench-1.0.14-2.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: MySQL-python-1.2.5-1.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: sysbench-1.0.14-2.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: MySQL-python-1.2.5-1.el7.x86_64\n---> Package mysql-community-client-plugins.x86_64 0:8.0.25-1.el7 will be installed\n---> Package mysql-community-libs.x86_64 0:8.0.25-1.el7 will be obsoleting\n--> Running transaction check\n---> Package Percona-XtraDB-Cluster-shared-compat-57.x86_64 0:5.7.33-31.49.1.el7 will be obsoleting\n---> Package postfix.x86_64 2:2.10.1-7.el7 will be updated\n---> Package postfix.x86_64 2:2.10.1-9.el7 will be an update\n---> Package sysbench.x86_64 0:1.0.14-2.el7 will be updated\n---> Package sysbench.x86_64 0:1.0.20-6.el7 will be an update\n--> Processing Conflict: mysql-community-client-plugins-8.0.25-1.el7.x86_64 conflicts mysql-community-server < 8.0.21\n--> Finished Dependency Resolution\n You could try using --skip-broken to work around the problem\n You could try running: rpm -Va --nofiles --nodigest\n"]} to retry, use: --limit @/ansible/master_local.retry

PLAY RECAP ***** lab2b : ok=7 changed=3 unreachable=0 failed=1

Ansible failed to complete successfully. Any error output should be visible above. Please fix these errors and try again. burakyilmaz@BURAKs-MBP lab2b %

[pboros]

Hi,

Use this repo: https://github.com/pboros/mysql8_administration_labs

This issue was fixed some time ago.

Peter (author)