[BUG] pkg.installed should install dependencies when directly installing .deb files (#10107 striked back)

[amato-gianluca]

Description
pkg.installed should install dependencies when directly installing .deb files with the source parameter. This used to work fine for many releases, after issue #10107 was fixed, but the problem seems to be back for Salt 3005.1 Onedir on Ubuntu 22.04.

Setup

The server runs Salt 3005.1 on a CentsOS 8 Stream VM (package salt-3005-1.el8.noarch). The client runs Salt 3005.1 Onedir on Ubuntu 22.04 VM (package 3005.1+ds-1). I have the following SLS file:

mysql-workbench-community:
  pkg.installed:
    - sources:
      - mysql-workbench-community: salt://mysql-workbench-community_8.0.31-1ubuntu22.04_amd64.deb

Although this example is based on MySQL Workbench, I don't think there is anything specific about it.

Steps to Reproduce the behavior

The command ''salt state.apply mysql-workbench-community'' ends with the following error:

          ID: mysql-workbench-community
    Function: pkg.installed
      Result: False
     Comment: Problem encountered installing package(s). Additional info follows:
              
              errors:
                  - Running scope as unit: run-r43687132895d487aad4a60437855eb20.scope
                    dpkg: dependency problems prevent configuration of mysql-workbench-community:
                     mysql-workbench-community depends on libpcrecpp0v5 (>= 7.7); however:
                      Package libpcrecpp0v5 is not installed.
                     mysql-workbench-community depends on libproj22 (>= 7.2.0); however:
                      Package libproj22 is not installed.
                    
                    dpkg: error processing package mysql-workbench-community (--install):
                     dependency problems - leaving unconfigured
                    Errors were encountered while processing:
                     mysql-workbench-community
     Started: 18:23:29.925520
    Duration: 6364.328 ms
     Changes:   

In the client, the package manager is in a broken state: mysql-workbench-community is installed without its dependencies. It can be fixed with apt -f install.

Expected behavior
The package mysql-workbench-community is installed together with its dependencies.

Note
From what I understand, when the source parameter is used, the package is installed using dpkg instead of apt, although apt is perfectly able to install single deb packages and resolve dependencies at the same time.

[welcome]

Hi there! Welcome to the Salt Community! Thank you for making your first contribution. We have a lengthy process for issues and PRs. Someone from the Core Team will follow up as soon as possible. In the meantime, here’s some information that may help as you continue your Salt journey.
Please be sure to review our Code of Conduct. Also, check out some of our community resources including:

• Community Wiki
• Salt’s Contributor Guide
• Join our Community Slack
• IRC on LiberaChat
• Salt Project YouTube channel
• Salt Project Twitch channel

There are lots of ways to get involved in our community. Every month, there are around a dozen opportunities to meet with other contributors and the Salt Core team and collaborate in real time. The best way to keep track is by subscribing to the Salt Community Events Calendar.
If you have additional questions, email us at saltproject@vmware.com. We’re glad you’ve joined our community and look forward to doing awesome things with you!

[whytewolf]

this most likely is a consequence of onedir. aptpkg presently uses the apt python module found only within system python on debian and ubuntu.

We need to decouple this from those system python packages that are not available outside of system python.