mysql_login_path fails when running mysql_config_editor for non root user

[jgrammen-agilitypr]

Describe the Bug

When setting up a mysql_login_path as a non root user the module fails to create the login_path with the error

Debug: Executing with uid=nagios: '/usr/bin/mysql_config_editor print --all'
Error: /Stage[main]/Mm::Mysql_config::Basic_config/Mysql_login_path[nagios]: Could not evaluate: Execution of '/usr/bin/mysql_config_editor print --all' returned 1:

Expected Behavior

creating a login path for any user should result in the .mylogin.cnf file been created and the appropriate login_path existing within the file

Steps to Reproduce

Steps to reproduce the behavior:

  mysql_login_path { 'nagios':
    ensure   => present,
    owner    => 'nagios',
    host     => 'localhost',
    user     => 'nagios',
    password => Sensitive($nagios_pass),
    port     => 3306,
    require  => [User['nagios']],
  }

puppet agent -t

Environment

• agent : 7.27.0-1jammy
• module: v15.0.0
• Ubuntu 22.04.2 LTS

Additional Context

Add any other context about the problem here.