Uploaded image for project: 'Image Builder'
  1. Image Builder
  2. COMPOSER-2121

Errors when adding MS SQL repo as a content source

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Undefined Undefined
    • None
    • None
    • None
    • False
    • None
    • False
    • Testable

      When adding the MS SQL Server 2022 repo as a content source to RHEL image builder, it fails with the following errors:

      [tbowling@rhel9latest ~]$ journalctl -fu osbuild-composer.service 
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/projects/source/info/*}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/rhel9-demo}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/rhel-9-latest-CIS-L2}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/ACME_RHEL_Immutable}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/grp-test}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/rhel-9-latest-PCI-DSS}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/rhel-91}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/rhel-9-latest-ms-sql-server-2022}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/rhel9-demo}}
      {{Jan 11 07:40:18 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:40:18 GET /api/v0/blueprints/info/rhel-91-edge}}
      {{Jan 11 07:41:31 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:41:31 POST /api/v0/projects/source/new}}
      {{Jan 11 07:41:38 rhel9latest.example.com osbuild-composer[878]: 2024/01/11 07:41:38 GET /api/v0/blueprints/depsolve/rhel-9-latest-ms-sql-server-2022}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: Traceback (most recent call last):}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: File "/usr/libexec/osbuild-composer/dnf-json", line 386, in <module>}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: main()}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: File "/usr/libexec/osbuild-composer/dnf-json", line 378, in main}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: result, err = solve(request, cachedir)}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: File "/usr/libexec/osbuild-composer/dnf-json", line 275, in solve}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: solver = Solver(}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: File "/usr/libexec/osbuild-composer/dnf-json", line 56, in {}init{}}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: self.base.repos.add(self._dnfrepo(repo, self.base.conf))}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: File "/usr/libexec/osbuild-composer/dnf-json", line 75, in _dnfrepo}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: assert False}}
      {{Jan 11 07:41:39 rhel9latest.example.com osbuild-composer[14116]: AssertionError}}

       

      Package versions installed:

      [root@rhel9latest ~]# cat /etc/redhat-release 
      Red Hat Enterprise Linux release 9.3 (Plow)
      [root@rhel9latest ~]# rpm -qa |grep -e osbuild -e composer
      python3-osbuild-93-1.el9.noarch
      osbuild-selinux-93-1.el9.noarch
      osbuild-93-1.el9.noarch
      osbuild-luks2-93-1.el9.noarch
      osbuild-lvm2-93-1.el9.noarch
      osbuild-ostree-93-1.el9.noarch
      cockpit-composer-47-1.el9.noarch
      osbuild-composer-dnf-json-88.2-1.el9_3.x86_64
      osbuild-composer-core-88.2-1.el9_3.x86_64
      osbuild-composer-worker-88.2-1.el9_3.x86_64
      osbuild-composer-88.2-1.el9_3.x86_64

      I have followed the following documentation instructions at https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-change-repo?view=sql-server-linux-ver16&pivots=ld2-rhel

      Using those instructions as a regular repo on the host to test.

      [root@rhel9latest ~]# cat /etc/yum.repos.d/mssql-server.repo
      [packages-microsoft-com-mssql-server-2022]
      name=packages-microsoft-com-mssql-server-2022
      baseurl=https://packages.microsoft.com/rhel/9.0/mssql-server-2022/
      enabled=1
      gpgcheck=1
      gpgkey=https://packages.microsoft.com/keys/microsoft.asc

      DNF verifies the repo works and lists the contents:

      [root@rhel9latest ~]# dnf repoquery {}queryformat '%{name}%{version}%{release}{-}%{arch} : %{reponame}' --disablerepo=* --enablerepo=packages-microsoft-com-mssql-server-2022
      Updating Subscription Management repositories.
      packages-microsoft-com-mssql-server-2022                                                                                     5.2 kB/s | 5.3 kB     00:01    
      mssql-server-16.0.4095.4-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-16.0.4100.1-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-extensibility-16.0.4095.4-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-extensibility-16.0.4100.1-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-fts-16.0.4095.4-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-fts-16.0.4100.1-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-ha-16.0.4095.4-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-ha-16.0.4100.1-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-polybase-16.0.4095.4-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-polybase-16.0.4100.1-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-selinux-16.0.4095.4-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-selinux-16.0.4100.1-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-sqliosim-16.0.4095.4-1-x86_64 : packages-microsoft-com-mssql-server-2022
      mssql-server-sqliosim-16.0.4100.1-1-x86_64 : packages-microsoft-com-mssql-server-2022

       When adding the repo as a Source to image builder, I am leaving the SSL and GPG key checks disabled for compatibility, and only setting:

      name=packages-microsoft-com-mssql-server-2022
      URL=https://packages.microsoft.com/rhel/9.0/mssql-server-2022/
      type=YUM repo

            obudai@redhat.com Ondrej Budai
            rhn-support-tbowling Terry Bowling
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: