Error With MySQL plugin

premudeshi · 27. Januar 2019

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.

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

Code

Error #0:
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
Broken pipe: fflush() in /usr/share/php/openmediavault/system/process.inc:175
Stack trace:
#0 /usr/share/openmediavault/engined/module/mysql.inc(93): OMV\System\Process->execute()
#1 /usr/share/openmediavault/engined/rpc/config.inc(168): OMV\Engined\Module\MySql->applyConfig()
#2 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array)
#3 /usr/share/php/openmediavault/rpc/serviceabstract.inc(123): call_user_func_array(Array, Array)
#4 /usr/share/php/openmediavault/rpc/serviceabstract.inc(149): OMV\Rpc\ServiceAbstract->callMethod('applyChanges', Array, Array)
#5 /usr/share/php/openmediavault/rpc/serviceabstract.inc(536): OMV\Rpc\ServiceAbstract->OMV\Rpc\{closure}('/tmp/bgstatusUC...', '/tmp/bgoutput3e...')
#6 /usr/share/php/openmediavault/rpc/serviceabstract.inc(159): OMV\Rpc\ServiceAbstract->execBgProc(Object(Closure))
#7 /usr/share/openmediavault/engined/rpc/config.inc(213): OMV\Rpc\ServiceAbstract->callMethodBg('applyChanges', Array, Array)
#8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array)
#9 /usr/share/php/openmediavault/rpc/serviceabstract.inc(123): call_user_func_array(Array, Array)
#10 /usr/share/php/openmediavault/rpc/rpc.inc(86): OMV\Rpc\ServiceAbstract->callMethod('applyChangesBg', Array, Array)
#11 /usr/sbin/omv-engined(536): OMV\Rpc\Rpc::call('Config', 'applyChangesBg', Array, Array, 1)
#12 {main}

Alles anzeigen

ryecoaaron · 28. Januar 2019

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.

premudeshi · 5. Februar 2019

Zitat von ryecoaaron

Just out of curiosity, why did you like your own post?

I really don't know lmao. Attention?

Zitat von ryecoaaron

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.

ryecoaaron · 5. Februar 2019

Weird. The plugin doesn't use that directory - https://github.com/OpenMediaVa…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

premudeshi · 6. Februar 2019

Zitat von ryecoaaron

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

Ill try that.

Zitat von ryecoaaron

I really would use docker though - Installation and Setup Videos - Beginning, Intermediate and Advanced

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

ryecoaaron · 6. Februar 2019

Zitat von premudeshi

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

premudeshi · 9. Februar 2019

I have used the apt-get purge to remove it, and I have successfully uninstalled it. I have also started to rebuild my system with Docker Compose!

FFrank · 20. Februar 2019

Zitat von ryecoaaron

I really would use docker though - Installation and Setup Videos - Beginning, Intermediate and Advanced

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

ryecoaaron · 20. Februar 2019

Zitat von FFrank

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.

Zitat von FFrank

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.

Jetzt mitmachen!