missing setting MySQL-Data location

rals2007 · 2. Oktober 2016

Where did the option to allow us to set the location for the database?
it is now in /var/lib/mysql by dafault

Nibb31 · 2. Oktober 2016

The option was removed for some reason.
The easiest way to get around it is to create a symlink.

rals2007 · 2. Oktober 2016

What is did is edited /etc/mysql/my.cnf and change:

Code

FROM:
datadir         = /var/lib/mysql


TO:
datadir         = /media/xxxxxx/MySQL-Data

Also edited /etc/apparmor.d/usr.sbin.mysqld and rename all instances of /var/lib/mysql to t

Hope its a good idea

ryecoaaron · 2. Oktober 2016

All you have to do is put the datadir = /media/xxxxxx/MySQL-Data line in the extra options box.

caseyj · 10. April 2018

Since omv 3.0 I have all my drive in /srv ....

So for me I have something like :

Code

datadir = /srv/dev-disk-by-label-XXXXXX/Datas-ssd/mysql

Input in extra options and got this :

Code

Error #0: exception 'OMV\ExecException' with message 'Failed to execute command 'export PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin; export LANG=C; systemctl start 'mysql.service' 2>&1' with exit code '1': Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.' in /usr/share/php/openmediavault/system/process.inc:175 Stack trace: #0 /usr/share/php/openmediavault/system/systemctl.inc(86): OMV\System\Process->execute(Array, 1) #1 /usr/share/php/openmediavault/system/systemctl.inc(104): OMV\System\SystemCtl->exec('start', NULL, false) #2 /usr/share/openmediavault/engined/module/mysql.inc(107): OMV\System\SystemCtl->enable(true) #3 /usr/share/openmediavault/engined/rpc/config.inc(194): OMV\Engined\Module\MySql->startService() #4 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array) #5 /usr/share/php/openmediavault/rpc/serviceabstract.inc(124): call_user_func_array(Array, Array) #6 /usr/share/php/openmediavault/rpc/serviceabstract.inc(150): OMV\Rpc\ServiceAbstract->callMethod('applyChanges', Array, Array) #7 /usr/share/php/openmediavault/rpc/serviceabstract.inc(528): OMV\Rpc\ServiceAbstract->OMV\Rpc\{closure}('/tmp/bgstatusAE...', '/tmp/bgoutputnj...') #8 /usr/share/php/openmediavault/rpc/serviceabstract.inc(151): OMV\Rpc\ServiceAbstract->execBgProc(Object(Closure)) #9 /usr/share/openmediavault/engined/rpc/config.inc(213): OMV\Rpc\ServiceAbstract->callMethodBg('applyChanges', Array, Array) #10 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array) #11 /usr/share/php/openmediavault/rpc/serviceabstract.inc(124): call_user_func_array(Array, Array) #12 /usr/share/php/openmediavault/rpc/rpc.inc(86): OMV\Rpc\ServiceAbstract->callMethod('applyChangesBg', Array, Array) #13 /usr/sbin/omv-engined(536): OMV\Rpc\Rpc::call('Config', 'applyChangesBg', Array, Array, 1) #14 {main}

ryecoaaron · 10. April 2018

Probably a permissions/ownership issue with the files in the datadir.

caseyj · 10. April 2018

Oh Ok I see... I ll check it. Thank you.

Jetzt mitmachen!