Error With MySQL plugin

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Error With MySQL plugin

      Hi,

      I have tried to install MySQL which happened successfully. However when I tried to enable it, I always get this error. I have tried several times to try uninstalling and reinstalling MySQL but it gives me issues as well. I really don't know what to do.

      [Blocked Image: https://i.imgur.com/bZ5kT7q.png]


      When I ask for more information, it gives me this:


      Source Code

      1. Error #0:
      2. OMV\ExecException: Failed to execute command 'export PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin; export LANG=C; omv-mkconf mysql 2>&1' with exit code '2': /usr/share/openmediavault/mkconf/mysql: 51: /usr/share/openmediavault/mkconf/mysql: cannot create /etc/mysql/conf.d/openmediavault-mysql.cnf: Directory nonexistent
      3. Broken pipe: fflush() in /usr/share/php/openmediavault/system/process.inc:175
      4. Stack trace:
      5. #0 /usr/share/openmediavault/engined/module/mysql.inc(93): OMV\System\Process->execute()
      6. #1 /usr/share/openmediavault/engined/rpc/config.inc(168): OMV\Engined\Module\MySql->applyConfig()
      7. #2 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array)
      8. #3 /usr/share/php/openmediavault/rpc/serviceabstract.inc(123): call_user_func_array(Array, Array)
      9. #4 /usr/share/php/openmediavault/rpc/serviceabstract.inc(149): OMV\Rpc\ServiceAbstract->callMethod('applyChanges', Array, Array)
      10. #5 /usr/share/php/openmediavault/rpc/serviceabstract.inc(536): OMV\Rpc\ServiceAbstract->OMV\Rpc\{closure}('/tmp/bgstatusUC...', '/tmp/bgoutput3e...')
      11. #6 /usr/share/php/openmediavault/rpc/serviceabstract.inc(159): OMV\Rpc\ServiceAbstract->execBgProc(Object(Closure))
      12. #7 /usr/share/openmediavault/engined/rpc/config.inc(213): OMV\Rpc\ServiceAbstract->callMethodBg('applyChanges', Array, Array)
      13. #8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array)
      14. #9 /usr/share/php/openmediavault/rpc/serviceabstract.inc(123): call_user_func_array(Array, Array)
      15. #10 /usr/share/php/openmediavault/rpc/rpc.inc(86): OMV\Rpc\ServiceAbstract->callMethod('applyChangesBg', Array, Array)
      16. #11 /usr/sbin/omv-engined(536): OMV\Rpc\Rpc::call('Config', 'applyChangesBg', Array, Array, 1)
      17. #12 {main}
      Display All
    • Just out of curiosity, why did you like your own post?

      While I want the plugin to go away in favor of docker, you need to tell us what version of OMV you are using. Since it isn't using the mariadb config directory, I am guessing OMV 3.x in which I will tell you to install or upgrade to OMV 4.x. Otherwise, you must be trying to use the OMV 3.x version of the plugin on OMV 4.x.
      omv 4.1.22 arrakis | 64 bit | 4.15 proxmox kernel | omvextrasorg 4.1.15
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!
    • ryecoaaron wrote:

      Just out of curiosity, why did you like your own post?
      I really don't know lmao. Attention?


      ryecoaaron wrote:

      While I want the plugin to go away in favor of docker, you need to tell us what version of OMV you are using. Since it isn't using the mariadb config directory, I am guessing OMV 3.x in which I will tell you to install or upgrade to OMV 4.x. Otherwise, you must be trying to use the OMV 3.x version of the plugin on OMV 4.x.
      Im using the Arrakis, 4.1.3.
    • Weird. The plugin doesn't use that directory - github.com/OpenMediaVault-Plug…diavault/mkconf/mysql#L24 What is the output of: dpkg -l | grep openm


      I really would use docker though - Installation and Setup Videos - Beginning, Intermediate and Advanced
      omv 4.1.22 arrakis | 64 bit | 4.15 proxmox kernel | omvextrasorg 4.1.15
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!
    • ryecoaaron wrote:

      Weird. The plugin doesn't use that directory - github.com/OpenMediaVault-Plug…diavault/mkconf/mysql#L24
      What is the output of: dpkg -l | grep openm
      Ill try that.


      I would love to switch over but I can't uninstall the SQL server. It keeps on giving me errors. Is there a way I can clear it from the Command line using sudo?

      If I can uninstall it, Ill happily run docker.

      Thanks,
      Prem
    • premudeshi wrote:

      It keeps on giving me errors. Is there a way I can clear it from the Command line using sudo?
      What errors? Yes, you can uninstall it from the command line. apt-get purge openmediavault-mysql
      omv 4.1.22 arrakis | 64 bit | 4.15 proxmox kernel | omvextrasorg 4.1.15
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!
    • Hi,
      I searched for a instruction video in your link - no luck...could you point me in the right direction. I want to install MySQL/Maria to manage my pictures via DigiKam and store the pictures/metadata on my NAS.
      Why do you prefer the docker approach over the plug-in?

      Thanks.
      Fabian
      MoBo: Fujitsu D3417-B
      CPU: Intel Celeron G3900
      RAM: Samsung DDR4 - 8 GB ECC
      Case: Fractal Design Node 80
      HDD: SSD 64GB (System), 2*3TB (Data) + 1*4TB (Parity). UnionFS + Snapraid
      OMV 4
    • FFrank wrote:

      I searched for a instruction video in your link - no luck...could you point me in the right direction.
      The videos were meant to give you a general idea of how to use docker. I think the nextcloud video creates a docker plugin.

      FFrank wrote:

      Why do you prefer the docker approach over the plug-in?
      I don't want to maintain the plugin anymore due to lack of time and problems people have. Both are solved by using docker.
      omv 4.1.22 arrakis | 64 bit | 4.15 proxmox kernel | omvextrasorg 4.1.15
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      Please don't PM for support... Too many PMs!