some problems with my config (mysql, autoshutdown, tevii dvb card)

kio · 27. Februar 2015

hey guys.

got omv on my small n54and it works quite good, but there are some problems.

first: i can't get mysql to work fine. everytime i will apply the changes it sends me an error #4000

second: the autoshutdown plugin doesn't shutdown the server. i just added one client (my htpc) and it is offline, but still after an hour the server ist still running.

third: i want my server to be a tv server. installing tvheadend was quite easy for me, and no the but: my dvb-s2 card (tevii s471) is not working. After some reserche i found out, that this card is supported with the 3.5 kernel out of the box. omv uses 3.2, so, ist there a way to install this card or do i have to wait untill omv uses kernel 3.5? buying another card is no option!!!

thanks for your help!

---------------------

Servus!

Hab OMV auf meinem kleinen N54L laufen und soweit auch nur ein paar Probleme:

1. Mysql lässt sich nicht aktivieren. bekomme dort nach dem apply immer fehler #4000 ausgegeben.

2. autoshutdown fährt auch nach der angegebenen zeit den server nicht herunter. nur mein htpc ist als client eingetragen.

3. Der Server soll zusätzlich noch als tv server dienen (zZ ist die DVB Karte im HTPC und läuft dort problemlos). Es handelt sich um eine Tevii s471 die ab kernel 3.5 bei Linux out of the box läuft. OMV läuft zur Zeit noch mit Kernel 3.2 - gibts trotzdem einen Möglichkeit die Karte ans laufen zu bringen oder muss ich zwangsweise auf das Kernelupdate warten?

Besten Dank!

Greetings,
kio

ryecoaaron · 27. Februar 2015

Zitat von kio

first: i can't get mysql to work fine. everytime i will apply the changes it sends me an error #4000

What is the rest of the error?

Zitat von kio

third: i want my server to be a tv server. installing tvheadend was quite easy for me, and no the but: my dvb-s2 card (tevii s471) is not working. After some reserche i found out, that this card is supported with the 3.5 kernel out of the box. omv uses 3.2, so, ist there a way to install this card or do i have to wait untill omv uses kernel 3.5? buying another card is no option!!!

You can install the backports 3.16 kernel with the button in omv-extras. If it works with the 3.5 kernel, it should work with the 3.16 kernel.

kio · 27. Februar 2015

thanks for the quick answer.

this is die error:
Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database server: mysqld failed! invoke-rc.d: initscript mysql, action "stop" failed.

and the details:

Code

Fehler #4000:
exception 'OMVException' with message 'Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.' in /usr/share/php/openmediavault/initscript.inc:176
Stack trace:
#0 /usr/share/php/openmediavault/initscript.inc(148): OMVSysVInitScript->invoke('stop')
#1 /usr/share/php/openmediavault/initscript.inc(53): OMVSysVInitScript->stop()
#2 /usr/share/openmediavault/engined/module/mysql.inc(126): OMVSysVInitScript->exec()
#3 /usr/share/openmediavault/engined/rpc/config.inc(164): OMVModuleMySQL->stopService()
#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

kio · 27. Februar 2015

and another problem:

i can't give the system ssd a name to use it for the mysql database. i know, that it is possible because with my first installation of omv it works, after reinstalling this option is gone -.-

ryecoaaron · 27. Februar 2015

What is the output of:
dpkg -l | grep mysql
omv-showkey mysql

You can't use the system drive for data. If it worked on your first installation, you must have created another partition on the ssd. That is the only way.

kio · 27. Februar 2015

First One:

Code

ii  libdbd-mysql-perl                         4.021-1+b1                    amd64        Perl5 database interface to the MySQL database
ii  libmysqlclient18:amd64                    5.5.41-0+wheezy1              amd64        MySQL database client library
ii  mysql-client-5.5                          5.5.41-0+wheezy1              amd64        MySQL database client binaries
ii  mysql-common                              5.5.41-0+wheezy1              all          MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-server                              5.5.41-0+wheezy1              all          MySQL database server (metapackage depending on the latest version)
ii  mysql-server-5.5                          5.5.41-0+wheezy1              amd64        MySQL database server binaries and system database setup
ii  mysql-server-core-5.5                     5.5.41-0+wheezy1              amd64        MySQL database server binaries
ii  openmediavault-mysql                      1.0.15                        all          MySQL plugin for OpenMediaVault.
rc  php5-mysqlnd                              5.4.36-0+deb7u3               amd64        MySQL module for php5 (Native Driver)

Second:

Code

<mysql><enable>0</enable><enable_networking>1</enable_networking><port>3306</port><bind_address>127.0.0.1</bind_address><data.sharedfolderref/><extra_options/><enable_management_site>0</enable_management_site><show_tab>0</show_tab><disable_aio>0</disable_aio></mysql></

Thanks for the information, than thats the reason why.

ryecoaaron · 27. Februar 2015

You don't have a data directory set? You will probably need to apt-get install php5-mysqlnd as well.

C0mmanda · 27. Februar 2015

mySQL-Data Directory stored on a Data-Share which was created by OMV?

Seems to be necessary, there where a lot of people with this problem these days....

kio · 27. Februar 2015

no, it was created by win and it is ntfs.

i would like to create a partition in omv but there is no way i see.

i would prefer to create a partition of the system ssd. is it possible?

the tevii card works with die other kernel!

ryecoaaron · 27. Februar 2015

Most services will not work with ntfs.

Boot gparted-live and you should be able to repartition the OS drive.

kio · 27. Februar 2015

thank you!

will try it tomorrow, first i need a monitor (installed it at the office )

the other open question is, why autoshutdown does not wort. maybe the wrong settings?

edit: disabling the ULDL setting is new, just a try.

C0mmanda · 27. Februar 2015

cat /var/log/autoshutdown.log

kio · 27. Februar 2015

Code

Feb 27 21:39:09 homeserver logger: autoshutdown[24034]: INFO: ' sleep for 180s.'


Feb 27 21:42:09 homeserver logger: autoshutdown[24034]: INFO: '------------------------------------------------------'


Feb 27 21:42:09 homeserver logger: autoshutdown[24034]: INFO: ' new supervision cycle started - check active hosts or processes'


Feb 27 21:42:09 homeserver logger: autoshutdown[24034]: INFO: ' retrieve list of active IPs for 'eth0' ...'


Feb 27 21:42:23 homeserver logger: autoshutdown[24034]: INFO: ' Found IP 192.168.0.3 as active host.'


Feb 27 21:42:23 homeserver logger: autoshutdown[24034]: INFO: ' Found IP 192.168.0.11 as active host.'


Feb 27 21:42:23 homeserver logger: autoshutdown[24034]: INFO: ' Found IP 192.168.0.14 as active host.'


Feb 27 21:42:23 homeserver logger: autoshutdown[24034]: INFO: ' Found IP 192.168.0.12 as active host.'


Feb 27 21:42:23 homeserver logger: autoshutdown[24034]: INFO: ' Found IP 192.168.0.13 as active host.'


Feb 27 21:42:23 homeserver logger: autoshutdown[24034]: INFO: ' Found IP 192.168.0.2 as active host.'


Feb 27 21:42:23 homeserver logger: autoshutdown[24034]: INFO: ' sleep for 180s.'

Alles anzeigen

and again and again.
i'm not sure if i understand it right. does he think all the ip's are necessery to stay online? the host, that is needed to stay the server online ist not online ...

kio · 27. Februar 2015

changed the language to english und clean up the ip to only "18",
now it seems to work.

Code

Feb 27 21:51:46 homeserver logger: autoshutdown[27874]: INFO: '---------------- script started ----------------------'


Feb 27 21:51:46 homeserver logger: autoshutdown[27874]: INFO: ' 2 test cycles until shutdown is issued.'


Feb 27 21:51:46 homeserver logger: autoshutdown[27874]: INFO: ' Waiting 5 min until the first check'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' X Version: 0.9.9.10'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' Initialize logging to local6'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' /etc/autoshutdown.conf loaded'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' ------------------------------------------------------'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' Checking config'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' LOADPROCNAMES is set to: 'smbd,nfsd,transmission-daemon,mt-daapd,forked-daapd' (default)'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' TEMPPROCNAMES is set to: in.'tftpd' (default)'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' If you want more processes monitored, please have a look at the expert-settings'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: WARN: ' ULDLCHECK is set to false'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: WARN: ' Ignoring ULDLRATE'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' SHUTDOWNCOMMAND is set to 'pm-hibernate''


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' Your Kernel supports the following modes from pm-utils:'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' Kernel supports HIBERNATE (SUSPEND to DISK)'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: WARN: ' LOADAVERAGECHECK is set to false'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: WARN: ' Ignoring LOADAVERAGE'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' ------------------------------------------------------'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' Reading NICs ,IPs, ...'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' NIC 'bond0' not found, skipping 'bond0''


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' NIC 'eth0' found: try to get IP'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' _check_networkconfig(): Run: #1: IP-Adress found'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' 'eth0' has IP: 192.168.0.19'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' NIC 'eth1' not found, skipping 'eth1''


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: '---------------- script started ----------------------'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' 2 test cycles until shutdown is issued.'


Feb 27 21:51:57 homeserver logger: autoshutdown[28074]: INFO: ' Waiting 5 min until the first check'


Feb 27 21:56:57 homeserver logger: autoshutdown[28074]: INFO: ' script is doing checks for NIC: eth0 - 192.168.0.19'


Feb 27 21:56:57 homeserver logger: autoshutdown[28074]: INFO: '------------------------------------------------------'


Feb 27 21:56:57 homeserver logger: autoshutdown[28074]: INFO: ' new supervision cycle started - check active hosts or processes'


Feb 27 21:56:57 homeserver logger: autoshutdown[28074]: INFO: ' retrieve list of active IPs for 'eth0' ...'


Feb 27 21:56:58 homeserver logger: autoshutdown[28074]: INFO: ' No active IPs in the specified IP-Range found'


Feb 27 21:56:58 homeserver logger: autoshutdown[28074]: INFO: ' Check Connections for 'eth0''


Feb 27 21:56:58 homeserver logger: autoshutdown[28074]: INFO: ' There is a user (locally) connected -> no shutdown'


Feb 27 21:56:58 homeserver logger: autoshutdown[28074]: INFO: ' It is 'root' on/from '192.168.0.11''


Feb 27 21:56:58 homeserver logger: autoshutdown[28074]: INFO: ' Found 1 active socket(s) from Port(s): 80'


Feb 27 21:56:58 homeserver logger: autoshutdown[28074]: INFO: ' sleep for 120s.'

Alles anzeigen

C0mmanda · 27. Februar 2015

Yes, I already thought that the IP-Setting was the Problem.
You have to set the last block of the IP only.

Jetzt mitmachen!