proxysql supported operating systems on oraclelinux-7-x86_64 proxysql class without any parameters is expected to contain Service[proxysql] with hasstatus => true Failure/Error: it { is_expected.to contain_service('proxysql').with_hasstatus(true) } expected that the catalogue would contain Service[proxysql] with hasstatus set to true but it is set to nil

proxysql supported operating systems on oraclelinux-7-x86_64 proxysql class without any parameters is expected to contain Service[proxysql] with hasrestart => true Failure/Error: it { is_expected.to contain_service('proxysql').with_hasrestart(true) } expected that the catalogue would contain Service[proxysql] with hasrestart set to true but it is set to nil

proxysql supported operating systems on scientific-7-x86_64 proxysql class without any parameters is expected to contain Service[proxysql] with hasstatus => true Failure/Error: it { is_expected.to contain_service('proxysql').with_hasstatus(true) } expected that the catalogue would contain Service[proxysql] with hasstatus set to true but it is set to nil

proxysql supported operating systems on scientific-7-x86_64 proxysql class without any parameters is expected to contain Service[proxysql] with hasrestart => true Failure/Error: it { is_expected.to contain_service('proxysql').with_hasrestart(true) } expected that the catalogue would contain Service[proxysql] with hasrestart set to true but it is set to nil

proxysql supported operating systems on ubuntu-20.04-x86_64 proxysql class without any parameters is expected to contain Service[proxysql] with hasstatus => true Failure/Error: it { is_expected.to contain_service('proxysql').with_hasstatus(true) } expected that the catalogue would contain Service[proxysql] with hasstatus set to true but it is set to nil

proxysql supported operating systems on ubuntu-20.04-x86_64 proxysql class without any parameters is expected to contain Service[proxysql] with hasrestart => true Failure/Error: it { is_expected.to contain_service('proxysql').with_hasrestart(true) } expected that the catalogue would contain Service[proxysql] with hasrestart set to true but it is set to nil

proxysql supported operating systems on ubuntu-20.04-x86_64 proxysql class without any parameters is expected to contain Exec[wait_for_admin_socket_to_open] with command => "test -S /tmp/proxysql_admin.sock", unless => "test -S /tmp/proxysql_admin.sock", tries => 3, try_sleep => 10, require => "Service[proxysql]" and path => "/bin:/usr/bin" Failure/Error: is_expected.to contain_exec('wait_for_admin_socket_to_open').with( command: "test -S #{admin_socket}", unless: "test -S #{admin_socket}", tries: 3, try_sleep: 10, require: 'Service[proxysql]', path: '/bin:/usr/bin' ) expected that the catalogue would contain Exec[wait_for_admin_socket_to_open] with command set to "test -S /tmp/proxysql_admin.sock" but it is set to "test -S /var/lib/proxysql/proxysql_admin.sock", and parameter unless set to "test -S /tmp/proxysql_admin.sock" but it is set to "test -S /var/lib/proxysql/proxysql_admin.sock" Diff: @@ -1,4 +1,4 @@ -test -S /tmp/proxysql_admin.sock +test -S /var/lib/proxysql/proxysql_admin.sock -test -S /tmp/proxysql_admin.sock +test -S /var/lib/proxysql/proxysql_admin.sock

Process completed with exit code 1.

proxysql class Upgrading to version 2.0 works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'oracle7-64-puppet7.example.com' exited with 6 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_144018492.hUnteJ.pp Last 10 lines of output were: Warning: /Stage[main]/Proxysql::Service/Exec[wait_for_admin_socket_to_open]: Skipping because of failed dependencies Info: /Stage[main]/Proxysql::Service/Exec[wait_for_admin_socket_to_open]: Unscheduling all events on Exec[wait_for_admin_socket_to_open] Info: Class[Proxysql::Service]: Unscheduling all events on Class[Proxysql::Service] Warning: /Stage[main]/Proxysql::Admin_credentials/Exec[proxysql-admin-credentials]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Admin_credentials/File[root-mycnf-file]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Reload_config/Exec[reload-config]: Skipping because of failed dependencies Info: /Stage[main]/Proxysql::Reload_config/Exec[reload-config]: Unscheduling all events on Exec[reload-config] Info: Class[Proxysql]: Unscheduling all events on Class[Proxysql] Info: Stage[main]: Unscheduling all events on Stage[main] �[mNotice: Applied catalog in 188.51 seconds

proxysql class Upgrading to version 2.0 Service "proxysql" is expected to be running Failure/Error: it { is_expected.to be_running } expected Service "proxysql" to be running

proxysql class extended testing works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'oracle7-64-puppet7.example.com' exited with 6 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_144329143.gSM8qc.pp Last 10 lines of output were: Warning: /Stage[main]/Main/Proxy_mysql_user[tester1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_user[tester2]: Skipping because of failed dependencies Error: Could not prefetch proxy_mysql_server provider 'proxysql': Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT `hostname`, `port`, `hostgroup_id` FROM `mysql_servers`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/proxysql_admin.sock' (2) Warning: /Stage[main]/Main/Proxy_mysql_server[127.0.0.1:3307-1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_server[127.0.0.1:3307-2]: Skipping because of failed dependencies Error: Could not prefetch proxy_mysql_query_rule provider 'proxysql': Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT `rule_id` FROM `mysql_query_rules`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/proxysql_admin.sock' (2) Warning: /Stage[main]/Main/Proxy_mysql_query_rule[mysql_query_rule-1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_query_rule[mysql_query_rule-2]: Skipping because of failed dependencies Info: Stage[main]: Unscheduling all events on Stage[main] �[mNotice: Applied catalog in 90.80 seconds

proxysql class extended testing Service "proxysql" is expected to be running Failure/Error: it { is_expected.to be_running } expected Service "proxysql" to be running

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 1;"" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 1;"" stdout is expected to match "^localhost:3307-1$" Failure/Error: its(:stdout) { is_expected.to match '^localhost:3307-1$' } expected "" to match "^localhost:3307-1$"

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 2;"" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 2;"" stdout is expected to match "^localhost:3307-2$" Failure/Error: its(:stdout) { is_expected.to match '^localhost:3307-2$' } expected "" to match "^localhost:3307-2$"

proxysql class extended testing Command "mysql -NB -e 'SELECT comment FROM mysql_replication_hostgroups WHERE writer_hostgroup = 10 AND reader_hostgroup = 20;'" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e 'SELECT comment FROM mysql_replication_hostgroups WHERE writer_hostgroup = 10 AND reader_hostgroup = 20;'" stdout is expected to match "^Test MySQL Cluster 10-20$" Failure/Error: its(:stdout) { is_expected.to match '^Test MySQL Cluster 10-20$' } expected "" to match "^Test MySQL Cluster 10-20$"

Skipping EOL operating system RedHat 7

Skipping EOL operating system CentOS 7