Zypper fails to install multiple dependant RPMs e.g. mysql

Archives Ansible Project
1

Trying to install mysql on SLES 12 SP1 using Ansible 2.7

Following officail mysql documentation as per here:
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html

i.e. using the following command:

sudo zypper install mysql-community-{server,client,common,libs}-* --exclude='*minimal*'

This works fine on my SLES 12 at the command-line. But when using the Zypper module in Ansible it fails.
e.g.

Assuming RPM' are present in the folder /tmp with appropriate permissions and ownership etc...

The following three tasks:

1)

- name: install mysql
  become: true
  zypper:
    name: /tmp/mysql-community-{server,client,common,libs}-*
    state: present

Gives the following error:

Zypper run command failed with return code 4.
Problem occurred initializing or executing the search query: Invalid regular expression (/tmp/mysql-5.7.22-1/mysql-community-{server|client|common|libs}-*) regcomp returned 10.
See the above message for a hint. Running zypper refresh as root might resolve the problem.

2)

- name: install mysql
  become: true
  zypper:
    name: /tmp/mysql-community-common-5.7.22-1.sles12.x86_64.rpm \
          /tmp/mysql-community-libs-5.7.22-1.sles12.x86_64.rpm \
          /tmp/mysql-community-client-5.7.22-1.sles12.x86_64.rpm \
          /tmp/mysql-community-server-5.7.22-1.sles12.x86_64.rpm
    state: present

Give the following error:

Zypper run command failed with return code 3. Specified local path does not exist or is not accessible. Problem retrieving the specified RPM file. Malformed URI: Please check whether the file is accessible.
Problem with the RPM file specified as /tmp/mysql-community-common-5.7.22-1.sles12.x86_64.rpm \ /tmp/mysql-community-libs-5.7.22-1.sles12.x86_64.rpm \ /tmp/mysql-community-client-5.7.22-1.sles12.x86_64.rpm \ /tmp/mysql-community-server-5.7.22-1.sles12.x86_64.rpm, skipping. No valid arguments specified.

3)

- name: install mysql client
  become: true
  zypper:
    name: /tmp/mysql-community-*
    state: present

Gives the following error:

No provider of /tmp/mysql-community-* found.

I guess I could use shell or command module, running either Zypper or RPM, but would prefer to use the zypper module.

Any suggestions?
2

1)
- name: install mysql
  become: true
  zypper:
    name: /tmp/mysql-community-{server,client,common,libs}-*
    state: present

Gives the following error:
Zypper run command failed with return code 4.
Problem occurred initializing or executing the search query: Invalid regular expression (/tmp/mysql-5.7.22-1/mysql-community-{server|client|common|libs}-*) regcomp returned 10.
See the above message for a hint. Running zypper refresh as root might resolve the problem.

Documentation say you only can use * with state: latest and then the name can only be a '*' aka upgrade all.

2)

- name: install mysql
  become: true
  zypper:
    name: /tmp/mysql-community-common-5.7.22-1.sles12.x86_64.rpm \
          /tmp/mysql-community-libs-5.7.22-1.sles12.x86_64.rpm \
          /tmp/mysql-community-client-5.7.22-1.sles12.x86_64.rpm \
          /tmp/mysql-community-server-5.7.22-1.sles12.x86_64.rpm
    state: present

Give the following error:
Zypper run command failed with return code 3. Specified local path does not exist or is not accessible. Problem retrieving the specified RPM file. Malformed URI: Please check whether the file is accessible.
Problem with the RPM file specified as /tmp/mysql-community-common-5.7.22-1.sles12.x86_64.rpm \\ /tmp/mysql-community-libs-5.7.22-1.sles12.x86_64.rpm \\ /tmp/mysql-community-client-5.7.22-1.sles12.x86_64.rpm \\ /tmp/mysql-community-server-5.7.22-1.sles12.x86_64.rpm, skipping. No valid arguments specified.

There is no packed called
"/tmp/mysql-community-common-5.7.22-1.sles12.x86_64.rpm \ /tmp/mysql-community-libs-5.7.22-1.sles12.x86_64.rpm \ /tmp/mysql-community-client-5.7.22-1.sles12.x86_64.rpm \ /tmp/mysql-community-server-5.7.22-1.sles12.x86_64.rpm"

according to the documentation you need one name or package specifier, if you need more than one it takes a list.

3)
- name: install mysql client
  become: true
  zypper:
    name: /tmp/mysql-community-*
    state: present

Gives the following error:
No provider of /tmp/mysql-community-* found.

"A repeat of my first comment."

I guess I could use shell or command module, running either Zypper or RPM, but would prefer to use the zypper module.

Any suggestions?

Disclaimer:
Never used zypper just read the documentation
https://docs.ansible.com/ansible/latest/modules/zypper_module.html