Hello,

 

 

as the current versions of MySQL get lost in the MySQL 5.1.56-thread, I thought I would create a new one for the 5.5-branch.

This PLG is merely an amended version of SeeDrs' (http://lime-technology.com/forum/index.php?action=profile;u=14071) 5.1.56-plugin, so all credit goes to him.

 

Current version of Plugin will install MySQL-version: 5.5.28

 

Installation:

1) Copy PLG-file to /boot/config/plugins (Windows Path: \\SERVERHOSTNAME\flash\config\plugins)

 

2a) and reboot

or

2b) Run "installplg /boot/config/plugins/Mysql-5*" via telnet-session

 

3) Configure and enable via unraid web-interface

 

4) Optional: Set MySQL root passwort according to http://www.thegeekstuff.com/2009/07/change-reset-mysql-root-password-on-unix-linux/ via Method 2 (initial root password is "root")

 

5) Done.

 

 

If you want to use MySQL for XBMC-centralization please see my post here: http://lime-technology.com/forum/index.php?topic=11473.msg177796#msg177796

 

 

Enjoy,

p1lot

mysql5_20120805.zip

I'm trying to install this today, but the link in the .plg is not responding.

 

http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.24-i486-1gds.txz

Is this site no longer around?

 

I found a version at another site and edited the plugin to use it:

<!--install mysql-->
<FILE Name="/boot/packages/mysql-5.5.25-i486-1gds.txz" Run="upgradepkg --install-new">
<URL>http://slackpack.ludost.net/packages/13.37/mysql-5.5.25-i486-1gds.txz</URL>
<MD5>4cdb326c0888f68a6bdc36095993898b</MD5>
</FILE>

Hopefully that does not break anything for my first use of this.

Thanks for pointing that out, plugin has been updated.

I still didn't have any luck getting it running with my edits, but at least the download worked.

 

I configured it and enabled it in the web interface, but I got some sort of error in the log and my SQL would not run.

 

I'm going to try yours now. And see if I have any better luck with it.

Looks like I am getting somewhere now, thanks to your version. Thank you for the quick update.

You are welcome. Keep this thread updated please because I haven't test 5.5.25 myself.

 

I think about hosting the MySQL-package myself because they package-mirrors update the packages quite frequently and there is no necessity of having the latest version of MySQL running for most users here I assume. Mostly it's getting used as XBMC-database, so the version is basically irrelevant.

Setting it up for XBMC is exactly what I am trying to do now. I stumbling thru old guides and such now.

 

Is it absolutely necessary to change the default password after the initial install from 'root'?

Nope you don't have to.

 

BTW, here I wrote a guide for XBMC Eden, maybe it will help:

http://lime-technology.com/forum/index.php?topic=11473.msg177796#msg177796

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.

This plugin is broken in terms of "clean powerdown" doesn't shutdown even though all processes are terminated. This functionality is a necessity if you use a UPS like I do.

 

An error message like "ERROR: MySQL PID doesn't exist" is shown in the terminal window and at the end of the shutdown sequence "INIT: No more processes left" is displayed.

 

Does anybody know how to fix that?

You might want to host it yourself or elsewhere, it has slowed to 5.6k download speed for me. Its been running for about 15 minutes now, lol.

 

You'll probably end up getting users freaking out in posts that their server slowed to a 20 minute startup.

I may be wrong, haven't actually ran the plug-in, but from looking at the files, it appears that the rc.d file only stops the user "mysql". If you create another user, like in your tutorial, it might not be stopping that user.

Thanks for your fast reply! Are you referring to the user under whom the server daemon is running? I will be investigating further tonight.

I might be completely wrong never used MySQL in this capacity, but the stop command runs with the flag --user=mysql , if thats the user it runs under them it probably isn't the issue

 

Sent from my HTC Vivid

When I first ran this plugin yesterday, everything seemed to install quickly, but on the SimpleFeatures Settings page, MySQL would not start. I looked over what happened after I ran installplg & found that http://slackpack.ludost.net/packages/13.37/mysql-5.5.25-i486-1gds.txz only partially downloaded & failed the install.

 

From the /boot/packages/ directory I ran

curl -O http://slackpack.ludost.net/packages/13.37/mysql-5.5.25-i486-1gds.txz

to download it & reran the plugin.

 

That worked. Not sure why the plugin only partially downloaded the file, but wanted to post in case anyone else had issues. (did not seem to have any power or Internet interruptions at the time to cause the partial download, but maybe there was)

 

Thank you for the plugin! It is working great for me now 

It may have just timed out during the download. As Influencer stated the site can be quite slow sometimes.

It may have just timed out during the download. As Influencer stated the site can be quite slow sometimes.

 

Makes sense. It took some time for it to download through curl.

 

Hopefully if anyone else has the same issue, knowing to download it directly & retry the plugin will help.

I am hosting the Slackware-package in my Dropbox now, please report back if it works better. PLG has been updated.

I am hosting the Slackware-package in my Dropbox now, please report back if it works better. PLG has been updated.

 

The old site downloads a 8.3MB file in 11 minutes.

Here are my download stats from it:

/mnt/cache/.tmp# curl -O http://slackpack.ludost.net/packages/13.37/mysql-5.5.25-i486-1gds.txz
curl: /usr/lib/libidn.so.11: no version information available (required by /usr/lib/libcurl.so.4)
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 8419k  100 8419k    0     0  13046      0  0:11:00  0:11:00 --:--:-- 13432

 

The new dropbox location downloads a 4.3MB file in 3 seconds.

Here are my download stats for it:

/mnt/cache/.tmp/new# curl -O https://dl.dropbox.com/u/3110608/unRAID/mysql-5.5.25-i486-1gds.txz
curl: /usr/lib/libidn.so.11: no version information available (required by /usr/lib/libcurl.so.4)
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 4371k  100 4371k    0     0  1221k      0  0:00:03  0:00:03 --:--:-- 1239k

 

Am I getting a partial file from the new dropbox location? (have not tried to install it as I have a working version). It is definitely faster. 

Yeah, there does seem to be a big file size difference. You are grabbing the full file from DropBox. Maybe the file itself is not complete.

Yeah, there does seem to be a big file size difference. You are grabbing the full file from DropBox. Maybe the file itself is not complete.

 

After having the old plg not download the whole mysql tgz file (on my first attempt) & seeing a difference in file size with the new one today... was getting worried about my connection. Glad the file size difference is not just me (whew).

Damn the file I uploaded is incorrect, I will re-upload it.

Re-uploaded to my Dropbox.

That looks more like it. 8.3MB from dropbox in 6 seconds (huge improvement over the 11 minutes from previous location)

/mnt/cache/.tmp/new# curl -O https://dl.dropbox.com/u/3110608/unRAID/mysql-5.5.25-i486-1gds.txz
curl: /usr/lib/libidn.so.11: no version information available (required by /usr/lib/libcurl.so.4)
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 8419k  100 8419k    0     0  1349k      0  0:00:06  0:00:06 --:--:-- 1949k

Thanks for the efforst p1lot.