Fixed plugin

 

Fixed what??

The site where you get mysql from was http: instead of FTP: so that is what I changed.

I downloaded the plugin from the main page first and then tried the newer one mysql5_20130111.zip. Both are giving me the same error message and won't install. Am I doing something wrong? I'm running on the latest 5.0-rc11. Thanks for any clues.

 

root@SERVER:/boot/config/plugins# installplg /boot/config/plugins/Mysql-5*
installing plugin: Mysql-5*
xml parse error

LOL, I figured it out. That's what happens when you copy/paste instructions without reading it. The command should be installplg /boot/config/plugins/mysql5* not installplg /boot/config/plugins/Mysql-5*

 

BTW where does the server get installed by default? Also how to set up SWAP partition to not be on the USB flash? Thanks.

I installed plugin succesful but when i enter gui and click enable mysql, nothing happens

Status says : stopped

 

Any ideas?

I hope influencer can take this plugin over

Did you look at the log?  If it says can't write to temp file then do a chmod 777 /temp and it should get you up and running.

I was able to get this installed and running just fine, but I am unable to shut down my unraid server with it enabled. It will attempt to shut down and hang after mysql stops. If I goto the server and hit a key I am able to log in to the server and power it down.

Whoever is going to take over this plugin should find a different download site because this website updates the version of mysql often and deletes the previous version.  This site is now on 5.5.30

I agree, just had to update the plg to use the 5.5.30 package.  Not sure of the etiquette of that kind of thing although I see you have done it previously so haven't uploaded it, but happy to if someone so desires.

Please do post it. I'm sure it will help someone else out on a new or fresh install.

Please do post it. I'm sure it will help someone else out on a new or fresh install.

 

Here you go, note this will only work for anyone trying this out until the host updates the packages then you can no longer download it.  I'm just messing around with centralising my XBMC database so wanted to try things out.  Plugin worked for me, but I've never edited a plg before so your mileage may vary..

 

It is MySql 5.5.30

 

Edit: Well, worked well enough to sort out my XBMC Frodo database.

 

mysql5_20130227.zip

Thanks,  plan on playing with mysql again soon and will need that pkg.  Hopefully I get to it before they remove it.

 

Sent from my SAMSUNG-SGH-I727 using Tapatalk 2

 

 

Got mine working.  I now have 2 xbmc computers using the same video and music database.  Can stop/pause video in on one and start it on the other.

 

I had to delete everything I had from the previous install including the my.cnf file.

 

I then installed the plugin.  You may need to chmod 777 /tmp if you get an error about not being able to write to the temp file.

 

I then had to mysqladmin -u root password root

 

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';

 

Then GRANT ALL PRIVILEGES ON *.* TO xbmc@'%' IDENTIFIED BY 'xbmc' WITH GRANT OPTION;

 

Create a advancedsettings.xml file like this:

 

<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>(IP address)</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

    </videodatabase>

 

    <musicdatabase>

        <type>mysql</type>

        <host>(IP address)</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

    </musicdatabase>

 

    <videolibrary>

          <importwatchedstate>true</importwatchedstate>

    </videolibrary>

</advancedsettings>

 

I then readded all the videos and movies and I was all set.

I tried all the steps that were described here but I'm still getting:

Tower useradd[23996]: failed adding user 'mysql', data deleted

whenever I want to activate mySQL via the SimpleFeatures plugin. Any advise?

I solved my issue by going back to Mysql-5.1.66-i468-6atv.plg

 

Would have loved to update but for me this caused nothing but headaches. Thanks.

Hi guys

Im new to unraid and linux, I just finished building my unraid server and done with migration.

parity and cache done. Thanks to the multiple nice guides found within this forum.

 

my question: scared like a deer in front of a train , I want to install mysql to my cache drive in order to have 1 central database for my xbmc rasp pi database.

 

I couldnt find a guide for that, is there one?

My system is running well but I scared of screwing something up

 

any help would be appreciated

 

Thanks

M@Z

There are guides on how to setup mySQL. It has been a while since I've done it myself, but I followed one of many guides. There are some over on the XBMC forums and maybe even in the wiki. There isn't a specific unRaid guide in the wiki, but I could have sworn I saw something somewhere. The first step is just get mySQL install and running in unRAid 1st. Then we can walk you thru the rest of it.

Hi guys

Im new to unraid and linux, I just finished building my unraid server and done with migration.

parity and cache done. Thanks to the multiple nice guides found within this forum.

 

my question: scared like a deer in front of a train , I want to install mysql to my cache drive in order to have 1 central database for my xbmc rasp pi database.

 

I couldnt find a guide for that, is there one?

My system is running well but I scared of screwing something up

 

any help would be appreciated

 

Thanks

M@Z

 

Here's how I did it.

 

http://lime-technology.com/forum/index.php?PHPSESSID=0507fdd04a2b37383641e259411653de&topic=11473.msg229319#msg229319

 

 

Sent from my iPad using Tapatalk HD

im wondering for the ones that are running phpmyadmin...

 

which version should i be downloading from here for unraid...

 

http://www.phpmyadmin.net/home_page/downloads.php

 

i have newznab + spotweb running, but wanna try some of the custom mods from the newznab forums..

I am also having this issue, does anyone know how to fix it?

 

Mar 21 13:51:03 SERVER useradd[15394]: failed adding user 'mysql', data deleted
Mar 21 13:51:03 SERVER usermod[15396]: add 'mysql' to group 'users'
Mar 21 13:51:17 SERVER useradd[15825]: failed adding user 'mysql', data deleted

I am also having this issue, does anyone know how to fix it?

 

Mar 21 13:51:03 SERVER useradd[15394]: failed adding user 'mysql', data deleted
Mar 21 13:51:03 SERVER usermod[15396]: add 'mysql' to group 'users'
Mar 21 13:51:17 SERVER useradd[15825]: failed adding user 'mysql', data deleted

 

Did you have a previous mysql install?

Yes I did. Originally I had it installed in /mnt/cache/mysql but then I copied the folder and moved it to /mnt/cache/apps/mysql together with my other applications. MySQL was working fine for a week or so, then my XBMC stopped working because it couldn't connect to the server. Somehow the database got corrupted even thought it was working fine for few days after i moved the folder. Long story short, i deleted everything from /mnt/cache/apps/mysql, re-instaleld MySQL, started fresh and re-scraped all my media from XBMC, created a whole new database. It took forever and I lost all my "watched" status for everything, but oh well. Then I rebooted the server for something else and my database got corrupted again. MySQL would not even start unless I changed the path back to /mnt/cache/mysql, which is what it is set to right now. I did another re-scrape for all my media and its is functioning at the moment, but MySQL would not start if I change the path to /mnt/cache/apps/mysql which is where I want it. I did delete the mysql plg and mysql folders completely from /boot/config/plugins and both /mnt/cache/mysql and /mnt/cache/apps/mysql , as well as the mysql package from /flash/packages. I thought that should be everything related to MySQL, rebooted few times and I can install mysql-5.5.30-i486-1gds now, but it will only work if it is set to /mnt/cache/mysql and not /mnt/cache/mysql . Go figure, there must be something else that needs to be cleaned for complete removal of the plugin

Looking at the plugin code, see it in post #77, it appears that you edit the file /etc/my.cnf to limit or change the bin file creation and then copy the new version to /boot/config/plugins/mysql/my.cnf so that it sticks after a reboot.

 

 

It was posted before, but is it possible to change the plugin to run mysql as user nobody instead of user mysql so that the permissions can match everything else on the server?

 

Post#77 is why

 

@kricker, I know this is a "problem" now, but do you really need to access mysql-files via windows explorer?

 

The problem is, if S set rights to nobody, the db-repairs don't work anymore. The only thing that is possible to set rights to 777, read and write for everybody? What do the other people think here?

Yes I did. Originally I had it installed in /mnt/cache/mysql but then I copied the folder and moved it to /mnt/cache/apps/mysql together with my other applications. MySQL was working fine for a week or so, then my XBMC stopped working because it couldn't connect to the server. Somehow the database got corrupted even thought it was working fine for few days after i moved the folder. Long story short, i deleted everything from /mnt/cache/apps/mysql, re-instaleld MySQL, started fresh and re-scraped all my media from XBMC, created a whole new database. It took forever and I lost all my "watched" status for everything, but oh well. Then I rebooted the server for something else and my database got corrupted again. MySQL would not even start unless I changed the path back to /mnt/cache/mysql, which is what it is set to right now. I did another re-scrape for all my media and its is functioning at the moment, but MySQL would not start if I change the path to /mnt/cache/apps/mysql which is where I want it. I did delete the mysql plg and mysql folders completely from /boot/config/plugins and both /mnt/cache/mysql and /mnt/cache/apps/mysql , as well as the mysql package from /flash/packages. I thought that should be everything related to MySQL, rebooted few times and I can install mysql-5.5.30-i486-1gds now, but it will only work if it is set to /mnt/cache/mysql and not /mnt/cache/mysql . Go figure, there must be something else that needs to be cleaned for complete removal of the plugin

 

I would uninstall the plugin again then delete:

your mysql data directory folder

/etc/my.conf

/boot/config/plugins/mysql

/boot/packages and delete any mysql packages

/etc/passwd and delete the mysql line

 

then reinstall the mysql plugin.  You may have to do a chmod 777 on /tmp if when you hit start the status still says stopped. 

 

I then had to mysqladmin -u root password root

 

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';

 

Then GRANT ALL PRIVILEGES ON *.* TO xbmc@'%' IDENTIFIED BY 'xbmc' WITH GRANT OPTION;

 

Create a advancedsettings.xml file like this:

 

<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>(IP address)</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

    </videodatabase>

 

    <musicdatabase>

        <type>mysql</type>

        <host>(IP address)</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

    </musicdatabase>

 

    <videolibrary>

          <importwatchedstate>true</importwatchedstate>

    </videolibrary>

</advancedsettings>

 

Then re add your all your stuff.

 

Hi there,

 

using /usr/bin/mysql Ver 14.14 Distrib 5.5.30

 

When booting I have mysql install from /boot/config/go, so the array is already started and it finds it data dir.

 

However, installing the plugin does not start the mysql server, even though it is set to "enabled" in the plugin. So i have to manually start the server every time I reboot.

 

could the plugin not simply start the server if it is enabled?

 

Thanks for caring,

JC