July 8, 201213 yr Author You bet, hopefully I will get the PID error fixed today or tomorrow so I can declare this plugin 100% stable. lainie and kricker: Do you use clean powerdown by any chance or could you try a clean powerdown with this script? http://code.google.com/p/unraid-powercontrol/downloads/detail?name=powerdown-1.02-noarch-unRAID.tgz&can=2&q= It is already included in unmenu btw.
July 8, 201213 yr I'm not sure if I've powered down since getting it working properly with XBMC. I'll try to night without the script first. In my efforts to get mySQL working I can't recall and power down issues.
July 8, 201213 yr Author Well, the "normal" powerdown and reboot does work perfectly, but the clean powerdown script which is using along with the APC UPS daemon does not work. This script is crucial as it unmounts the array first and thus there is no parity check needed upon reboot.
July 8, 201213 yr Author I found a fast mirror for the MySQL 5.5 slackware-package, just replace your old PLG-files and you are set.
July 8, 201213 yr lainie and kricker: Do you use clean powerdown by any chance or could you try a clean powerdown with this script? http://code.google.com/p/unraid-powercontrol/downloads/detail?name=powerdown-1.02-noarch-unRAID.tgz&can=2&q= It is already included in unmenu btw. I have not used it before or read much about it. I previously went into each plugin on the SimpleFeatures settings page & individually changed the setting for "enable <plugin name>" from "Yes" to "No" (waited for each plugin to show it was not running), then stopped my array on the "Main" page of SimpleFeatures, then told the server to shutdown. This works fine, but is a little tedious. Before I started using plugins to shut down my running applications, I modified some bash scripts to shut them down. Just now used unmenu to download & install clean powerdown (powerdown-1.02-noarch-unRAID.tgz). So now I just need to run "/sbin/powerdown"? Or do I try to stop the array with the plugins enabled? Or will either work to determine what you want to know?
July 8, 201213 yr Author Thanks. I've done almost everything, but mySQL is binding to 0.0.0.0. The my.conf file in etc appears to be blank, so I'm not quite sure what I should do about that. You probably already have resolved this, but 0.0.0.0 just means the MySQL-server is bound to all interfaces.
July 8, 201213 yr Author lainie and kricker: Do you use clean powerdown by any chance or could you try a clean powerdown with this script? http://code.google.com/p/unraid-powercontrol/downloads/detail?name=powerdown-1.02-noarch-unRAID.tgz&can=2&q= It is already included in unmenu btw. I have not used it before or read much about it. I previously went into each plugin on the SimpleFeatures settings page & individually changed the setting for "enable <plugin name>" from "Yes" to "No" (waited for each plugin to show it was not running), then stopped my array on the "Main" page of SimpleFeatures, then told the server to shutdown. This works fine, but is a little tedious. Before I started using plugins to shut down my running applications, I modified some bash scripts to shut them down. Just now used unmenu to download & install clean powerdown (powerdown-1.02-noarch-unRAID.tgz). So now I just need to run "/sbin/powerdown"? Or do I try to stop the array with the plugins enabled? Or will either work to determine what you want to know? Thanks for helping me out here. /sbin/powerdown is exactly what you have to do and then tell me if the server shuts down or hangs at a screen called "INIT: no more processes left in this runlevel"
July 8, 201213 yr /sbin/powerdown is exactly what you have to do and then tell me if the server shuts down or hangs at a screen called "INIT: no more processes left in this runlevel" It shutdown successfully. That saves some time Here is the output: /# /sbin/powerdown Capturing information to syslog. Please wait... version[24465]: Linux version 2.6.37.6-unRAID (root@Develop) (gcc version 4.4.4 (GCC) ) #4 SMP Sat Aug 6 03:25:42 MDT 2011 ls: cannot access /dev/hd[a-z]: No such file or directory ls: cannot access /dev/hd[a-z]: No such file or directory status[24545]: State: STARTED status[24545]: D# Model / Serial Status Device status[24545]: 0 / DISK_OK sdh status[24545]: 1 / DISK_OK sda status[24545]: 2 / DISK_OK sdc status[24545]: 3 / DISK_OK sdg status[24545]: 4 / DISK_OK sdf status[24545]: 5 / DISK_NP rdevName. status[24545]: 6 / DISK_NP rdevName. status[24545]: 7 / DISK_NP rdevName. status[24545]: 8 / DISK_NP rdevName. status[24545]: 9 / DISK_NP rdevName. status[24545]: 10 / DISK_NP rdevName. status[24545]: 11 / DISK_NP rdevName. status[24545]: 12 / DISK_NP rdevName. status[24545]: 13 / DISK_NP rdevName. status[24545]: 14 / DISK_NP rdevName. status[24545]: 15 / DISK_NP rdevName. status[24545]: 16 / DISK_NP rdevName. status[24545]: 17 / DISK_NP rdevName. status[24545]: 18 / DISK_NP rdevName. status[24545]: 19 / DISK_NP rdevName. status[24545]: 20 / DISK_NP rdevName. status[24545]: SMART overall health assessment ls: cannot access /dev/hd[a-z]: No such file or directory status[24545]: /dev/sda: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: Device is in STANDBY mode, exit(2) status[24545]: /dev/sdb: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: /dev/sdb: Unknown USB bridge [0x0951:0x168a (0x100)] status[24545]: Smartctl: please specify device type with the -d option. status[24545]: Use smartctl -h to get a usage summary status[24545]: /dev/sdc: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: SMART overall-health self-assessment test result: PASSED status[24545]: /dev/sdd: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: SMART overall-health self-assessment test result: PASSED status[24545]: /dev/sde: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: /dev/sde: Unknown USB bridge [0x14dd:0x0002 (0x001)] status[24545]: Smartctl: please specify device type with the -d option. status[24545]: Use smartctl -h to get a usage summary status[24545]: /dev/sdf: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: Device is in STANDBY mode, exit(2) status[24545]: /dev/sdg: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: Device is in STANDBY mode, exit(2) status[24545]: /dev/sdh: smartctl 5.40 2010-10-16 r3189 [i486-slackware-linux-gnu] (local build) status[24545]: Copyright (C) 2002-10 by Bruce Allen, http://smartmontools.sourceforge.net status[24545]: Device is in STANDBY mode, exit(2) status[24545]: ACTIVE PIDS on the array status[24545]: root 12920 1 0 Jul07 ? 00:00:19 /bin/bash /usr/sbin/cache_dirs -w -e .* status[24545]: root 24541 12920 0 18:21 ? 00:00:00 sleep 2 ls: cannot access /boot/logs/syslog*.txt: No such file or directory Saving current syslog: /boot/logs/syslog-20120708-182235.txt -rwxrwxrwx 1 root root 172045 2012-07-08 18:22 /boot/logs/syslog-20120708-182235.txt adding: syslog.txt (deflated 90%) Broadcast message from root (pts/0) (Sun Jul 8 18:22:35 2012): The system is going down for system halt NOW! I powered the server on & it did not require a parity check (so looks good to me)
July 8, 201213 yr Author Damn now I am very sure this has nothing to do with the MySQL-plugin, so I need to go and find the error with one of my unRAID-settings. Thanks for your time and doing the testing!
July 8, 201213 yr Damn now I am very sure this has nothing to do with the MySQL-plugin, thanks for your time and doing the testing! Glad to help. Thank you for the great plugin & fast updates.
July 8, 201213 yr Author Are there any wishes for this plugin? I can add some options to the web inteface if you would like, like changing the root password, "prepare the database for xbmc" and things like that.
July 9, 201213 yr Are there any wishes for this plugin? I can add some options to the web inteface if you would like, like changing the root password, "prepare the database for xbmc" and things like that. Most people on these forums will be installing mysql for xbmc "room to room" watching. So if you give them a nice option to create the "xbmc_videos" & "xbmc_music" databases & grant user "xbmc" with pass "xbmc" full access to them... that would shave a few steps off for people. Not sure how complicated that would make things for you, but it would help those looking for a plugin instead of diving in to command line themselves. I went an extra step & installed phpmyadmin for the nice gui. Probably did not need to install it, but I usually have it on servers with mysql, a web server & php.
July 9, 201213 yr I just got back home. Looks like you don't need me to test the powerdown script, as lainie beat me to it. I don't use unMenu so I never tried the clean power down script. Even now with my plugins, I do not do the steps lainie does. I just stop the array and then choose power down. Everything stops and reboots without needing any parity checks. Changing root password and setting up for XBMC would be nice to have. FYI, for setting up the XBMC stuff you don't even need to create the xbmc_videos & XBMC_music. Just creating the xbmc user and giving it full access is enough. There are some settings that supposedly allow mySQL to be better optimized for XBMC. I do not know much about this yet, but I read various tips in different forums/threads. I don't understand it enough yet to know what those are. But if these tweaks are helpful, it would be nice to have those done or adjustable for the user. I did figure out what binding to 0.0.0.0 meant and it was not really my problem. The XBMC wiki mentioned editing the my.cnf file for binding and mine was blank after installing this plugin, so that was confusing me. I found another person's my.cnf file and loaded it up editing it for the binding, and it still didn't work. The binding was still going to 0.0.0.0. I finally went back to the XBMC wiki and figured out I did not grant full access to the xbmc user. Type in: GRANT ALL ON *.* TO 'xbmc'; and press return Once I did that, everything starting working. XBMC created two new libraries, so I deleted the xbmc_videos and xbmc_music that I had created earlier as they seemed no longer necessary.
July 9, 201213 yr Author Yeah I am working on those 2 features already, preparing mysql for xbmc shouldn't be a problem. Changing root password neither, will be done in a few days.
July 9, 201213 yr Nice. I look forward to trying it out. Once done, I'll try to take the time to make a new write-up for XBMC and mySQL.
July 9, 201213 yr Ran into a conflict with this plugin. I previously installed openssh & openssl through unmenu. Instead of telnet, I have been using ssh to connect to my unraid server. I installed this plugin successfully without rebooting while connected through ssh. After restarting to test with the clean powerdown, I could not get back in to my server via ssh (the server refused the connection). Not too big a deal, as I could still telnet in. Restarted a few times with this mysql plugin installed & still no ssh. I changed the extension of this plugin to add ".txt" (so it would not reinstall on reboot), left clean powerdown to reinstall with reboot in unmenu & restarted the server. Could connect with ssh again. Most people use telnet instead of ssh, so this should not be an issue for most. There seems to be a plugin for ssh (which I have not used yet), perhaps it will not have a conflict. May play around with it if I get some time, but not sure how much time I will have. I have been researching Crashplan & Crashplan GUI plugins, but have not tried installing anything with them yet. I think I have seen people talking about needing ssh for something to do with Crashplan (maybe it is connecting from a computer outside their home network?). Here are the dependencies for ssh. Perhaps a conflict there? root@tower:~# which sshd /usr/sbin/sshd root@tower:~# ldd /usr/sbin/sshd linux-gate.so.1 => (0xb78c0000) libresolv.so.2 => /lib/libresolv.so.2 (0xb789f000) libcrypto.so.0 => /lib/libcrypto.so.0 (0xb7759000) libutil.so.1 => /lib/libutil.so.1 (0xb7755000) libz.so.1 => /usr/lib/libz.so.1 (0xb7741000) libnsl.so.1 => /lib/libnsl.so.1 (0xb7727000) libcrypt.so.1 => /lib/libcrypt.so.1 (0xb76f4000) libc.so.6 => /lib/libc.so.6 (0xb7591000) libdl.so.2 => /lib/libdl.so.2 (0xb758d000) /lib/ld-linux.so.2 (0xb78c1000)
July 9, 201213 yr Author ldd /usr/sbin/mysqld /usr/sbin/mysqld: /usr/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld) linux-gate.so.1 => (0xb778c000) libpthread.so.0 => /lib/libpthread.so.0 (0xb776d000) libaio.so.1 => /lib/libaio.so.1 (0xb776b000) libz.so.1 => /usr/lib/libz.so.1 (0xb7757000) librt.so.1 => /lib/librt.so.1 (0xb774e000) libcrypt.so.1 => /lib/libcrypt.so.1 (0xb771a000) libdl.so.2 => /lib/libdl.so.2 (0xb7716000) libssl.so.0 => /lib/libssl.so.0 (0xb76ce000) libcrypto.so.0 => /lib/libcrypto.so.0 (0xb7588000) libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7498000) libm.so.6 => /lib/libm.so.6 (0xb7472000) libgcc_s.so.1 => /usr/lib/libgcc_s.so.1 (0xb7454000) libc.so.6 => /lib/libc.so.6 (0xb72f1000) /lib/ld-linux.so.2 (0xb778d000)
July 10, 201213 yr I'm having a problem with MySQL plugin, the same happened with the old plugin as well. I'm using fever on it (an RSS client reader attached to a MySQL db) but many times a couple of tables get corrupt. I got in touch with the developer and he told me that auto repair features are in place so that shouldn't be a problem. The fact is that, but I'm not sure of it yet, that probably a repair table command gets issued. This repeair table command issue though can't be executed due to this problem: Can't change ownership of the file '/mnt/disk1/services/mysql/fever/fever_items.MYD' (Errcode: 1) It seems to be related to the permissions set for the database. I checked and everything is set to nobody:users. Even if I change the ownership of all my files to mysql:mysql - and then the command works - when MySQL starts the deamon resets everything to nobody:users. I think that is a little issue. Any thoughts on this?
July 10, 201213 yr Author I will fix that issue. I could add mysql to the group users or let mysql run as nobody which is what ill do. Sent from my GT-N7000 using Tapatalk 2
July 10, 201213 yr Since a significant number of those reading this topic may be XBMC users, I wonder whether I might make a plea for your advice here.
July 10, 201213 yr I'm having a problem with MySQL plugin, the same happened with the old plugin as well. I'm using fever on it (an RSS client reader attached to a MySQL db) but many times a couple of tables get corrupt. I got in touch with the developer and he told me that auto repair features are in place so that shouldn't be a problem. The fact is that, but I'm not sure of it yet, that probably a repair table command gets issued. This repeair table command issue though can't be executed due to this problem: Can't change ownership of the file '/mnt/disk1/services/mysql/fever/fever_items.MYD' (Errcode: 1) It seems to be related to the permissions set for the database. I checked and everything is set to nobody:users. Even if I change the ownership of all my files to mysql:mysql - and then the command works - when MySQL starts the deamon resets everything to nobody:users. I think that is a little issue. Any thoughts on this? got same issue ... I put Chown -R mysql:mysql /mnt/cache/mysql in the go script also if you are using hamachi then hamachi somehow changes the permissions on /tmp i tried figuring out how but it is above my paygrade.... with the permissions changed mysql will not start.... so i added a chmod 777 /tmp as last line in my go script too for the rest no issuws
July 12, 201213 yr Author Fixed the permission-issue, will fine-tune parameters and then upload the updated plugin. EDIT: Uploaded fixed plugin. Next things to follow is the XBMC-preparation-script and setting root password from webUI.
July 13, 201213 yr p1lot still getting this in my logs after a reboot Jul 13 09:01:53 P8H67 useradd[10221]: failed adding user 'mysql', data deleted (Minor Issues) Jul 13 09:01:53 P8H67 usermod[10223]: add 'mysql' to group 'users' the chown to mysql is working though....
Archived
This topic is now archived and is closed to further replies.