I initially had a series of Communication failure error messages until I disabled all but the most important services in OMV.
Now I need assistance in setting up NginX so that I stop having these communication failure error messages because each time I enable the service, the error messages start popping up so I deduced that I must have set the option wrong somehow.
I am trying to follow the guide written by ryecoaaron - Nginx but with save mysql, I am getting the following error message:
EError #4000:
exception 'OMVException' with message 'Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' start 2>&1': Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.' in /usr/share/php/openmediavault/initscript.inc:176
Stack trace:
#0 /usr/share/php/openmediavault/initscript.inc(141): OMVSysVInitScript->invoke('start')
#1 /usr/share/php/openmediavault/initscript.inc(61): OMVSysVInitScript->start()
#2 /usr/share/openmediavault/engined/module/mysql.inc(117): OMVSysVInitScript->exec()
#3 /usr/share/openmediavault/engined/rpc/config.inc(206): OMVModuleMySQL->startService()
#4 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array)
#5 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#6 /usr/share/php/openmediavault/rpcservice.inc(158): OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
#7 /usr/share/openmediavault/engined/rpc/config.inc(224): OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
#8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array)
#9 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#10 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
#11 /usr/sbin/omv-engined(500): OMVRpc::exec('Config', 'applyChangesBg', Array, Array, 1)
#12 {main}
Alles anzeigen
I am setting up mysqldb on pool - the pool I had initially setup using all the hdd. Is that wrong?
Also the bind address being used by mysql is the localhost address - 127.0.0.1
As a result of this error, I am stuck. Can anyone help? Please!
I am on OMV 3.x.
I then tried to reset the mysql password and got this load of errors:
Error #4000:
exception 'OMVException' with message 'Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' start 2>&1': Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
Starting MySQL database server: mysqldWarning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
.Warning: World-writable config file '/etc/mysql/conf.d/pw.cnf' is ignored
failed!
invoke-rc.d: initscript mysql, action "start" failed.' in /usr/share/php/openmediavault/initscript.inc:176
Stack trace:
#0 /usr/share/php/openmediavault/initscript.inc(141): OMVSysVInitScript->invoke('start')
#1 /usr/share/php/openmediavault/initscript.inc(61): OMVSysVInitScript->start()
#2 /usr/share/openmediavault/engined/module/mysql.inc(117): OMVSysVInitScript->exec()
#3 /usr/share/openmediavault/engined/rpc/config.inc(206): OMVModuleMySQL->startService()
#4 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array)
#5 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#6 /usr/share/php/openmediavault/rpcservice.inc(158): OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
#7 /usr/share/openmediavault/engined/rpc/config.inc(224): OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
#8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array)
#9 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#10 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
#11 /usr/sbin/omv-engined(500): OMVRpc::exec('Config', 'applyChangesBg', Array, Array, 1)
#12 {main}
Alles anzeigen
Syslog errors seem to indicate that it is attempting to communicate with my server which is on 192.168.0.11 but I deliberately used the ip address of the pc omv is on to bind mysql so I can't understand why it is attempting to reach the server. Syslog msg attached as text file to get under the 10K limit
ZitatAlles anzeigen
Mar 8 00:45:01 omv /USR/SBIN/CRON[13725]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Mar 8 00:45:01 omv rrdcached[3009]: Received FLUSHALL
Mar 8 00:45:36 omv avahi-daemon[3357]: Invalid response packet from host 192.168.0.11.
Mar 8 00:45:37 omv avahi-daemon[3357]: Invalid response packet from host 192.168.0.11.
Mar 8 00:45:37 omv avahi-daemon[3357]: Invalid response packet from host 192.168.0.11.
I am stumped.
I will really appreciate some assistance with this.