Failed to install mysql using chef recipe












0















I want to install and set initial root password to mysql server by using chef recipe. I have included depends 'mysql', '~> 8.5.1' in metadtata.rb file. And my default.rb looks like this.



mysql_service 'default' do
initial_root_password 'Password@123'
action [:create, :start]
end


Installation process is successful but setting root password not working getting error.



192.168.94.186 Running handlers:
192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Running exception handlers
192.168.94.186 Running handlers complete
192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Exception handlers complete
192.168.94.186 Chef Client failed. 4 resources updated in 07 seconds
192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out
192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Mixlib::ShellOut::ShellCommandFailed: mysql_service[default] (sql_test::default line 10) had an error: Mixlib::ShellOut::ShellCommandFailed: mysql_service_manager_systemd[default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service.rb line 50) had an error: Mixlib::ShellOut::ShellCommandFailed: service[mysql-default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service_manager_systemd.rb line 81) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
192.168.94.186 ---- Begin output of /bin/systemctl --system start mysql-default ----
192.168.94.186 STDOUT:
192.168.94.186 STDERR: Job for mysql-default.service failed because the control process exited with error code. See "systemctl status mysql-default.service" and "journalctl -xe" for details.
192.168.94.186 ---- End output of /bin/systemctl --system start mysql-default ----
192.168.94.186 Ran /bin/systemctl --system start mysql-default returned 1









share|improve this question



























    0















    I want to install and set initial root password to mysql server by using chef recipe. I have included depends 'mysql', '~> 8.5.1' in metadtata.rb file. And my default.rb looks like this.



    mysql_service 'default' do
    initial_root_password 'Password@123'
    action [:create, :start]
    end


    Installation process is successful but setting root password not working getting error.



    192.168.94.186 Running handlers:
    192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Running exception handlers
    192.168.94.186 Running handlers complete
    192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Exception handlers complete
    192.168.94.186 Chef Client failed. 4 resources updated in 07 seconds
    192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out
    192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
    192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Mixlib::ShellOut::ShellCommandFailed: mysql_service[default] (sql_test::default line 10) had an error: Mixlib::ShellOut::ShellCommandFailed: mysql_service_manager_systemd[default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service.rb line 50) had an error: Mixlib::ShellOut::ShellCommandFailed: service[mysql-default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service_manager_systemd.rb line 81) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
    192.168.94.186 ---- Begin output of /bin/systemctl --system start mysql-default ----
    192.168.94.186 STDOUT:
    192.168.94.186 STDERR: Job for mysql-default.service failed because the control process exited with error code. See "systemctl status mysql-default.service" and "journalctl -xe" for details.
    192.168.94.186 ---- End output of /bin/systemctl --system start mysql-default ----
    192.168.94.186 Ran /bin/systemctl --system start mysql-default returned 1









    share|improve this question

























      0












      0








      0








      I want to install and set initial root password to mysql server by using chef recipe. I have included depends 'mysql', '~> 8.5.1' in metadtata.rb file. And my default.rb looks like this.



      mysql_service 'default' do
      initial_root_password 'Password@123'
      action [:create, :start]
      end


      Installation process is successful but setting root password not working getting error.



      192.168.94.186 Running handlers:
      192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Running exception handlers
      192.168.94.186 Running handlers complete
      192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Exception handlers complete
      192.168.94.186 Chef Client failed. 4 resources updated in 07 seconds
      192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out
      192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
      192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Mixlib::ShellOut::ShellCommandFailed: mysql_service[default] (sql_test::default line 10) had an error: Mixlib::ShellOut::ShellCommandFailed: mysql_service_manager_systemd[default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service.rb line 50) had an error: Mixlib::ShellOut::ShellCommandFailed: service[mysql-default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service_manager_systemd.rb line 81) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
      192.168.94.186 ---- Begin output of /bin/systemctl --system start mysql-default ----
      192.168.94.186 STDOUT:
      192.168.94.186 STDERR: Job for mysql-default.service failed because the control process exited with error code. See "systemctl status mysql-default.service" and "journalctl -xe" for details.
      192.168.94.186 ---- End output of /bin/systemctl --system start mysql-default ----
      192.168.94.186 Ran /bin/systemctl --system start mysql-default returned 1









      share|improve this question














      I want to install and set initial root password to mysql server by using chef recipe. I have included depends 'mysql', '~> 8.5.1' in metadtata.rb file. And my default.rb looks like this.



      mysql_service 'default' do
      initial_root_password 'Password@123'
      action [:create, :start]
      end


      Installation process is successful but setting root password not working getting error.



      192.168.94.186 Running handlers:
      192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Running exception handlers
      192.168.94.186 Running handlers complete
      192.168.94.186 [2019-01-16T12:40:01+05:30] ERROR: Exception handlers complete
      192.168.94.186 Chef Client failed. 4 resources updated in 07 seconds
      192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Stacktrace dumped to /var/chef/cache/chef-stacktrace.out
      192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
      192.168.94.186 [2019-01-16T12:40:01+05:30] FATAL: Mixlib::ShellOut::ShellCommandFailed: mysql_service[default] (sql_test::default line 10) had an error: Mixlib::ShellOut::ShellCommandFailed: mysql_service_manager_systemd[default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service.rb line 50) had an error: Mixlib::ShellOut::ShellCommandFailed: service[mysql-default] (/var/chef/cache/cookbooks/mysql/libraries/mysql_service_manager_systemd.rb line 81) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
      192.168.94.186 ---- Begin output of /bin/systemctl --system start mysql-default ----
      192.168.94.186 STDOUT:
      192.168.94.186 STDERR: Job for mysql-default.service failed because the control process exited with error code. See "systemctl status mysql-default.service" and "journalctl -xe" for details.
      192.168.94.186 ---- End output of /bin/systemctl --system start mysql-default ----
      192.168.94.186 Ran /bin/systemctl --system start mysql-default returned 1






      chef






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Jan 16 at 7:21









      JanithJanith

      798




      798






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "89"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1110175%2ffailed-to-install-mysql-using-chef-recipe%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Ask Ubuntu!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1110175%2ffailed-to-install-mysql-using-chef-recipe%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924

          How to change which sound is reproduced for terminal bell?

          Can I use Tabulator js library in my java Spring + Thymeleaf project?