I updated the version, you can download it from the unRAID Plugin's Page in the wiki, see the original post for the link.  Now it will use the my.cf located in /boot/config/plugsins/mysql if it exists, insead of using medium-my.cf.  I didn't get a chance to test it yet, so let me know if it works.

 

SeeDrs

 

OK, small issue. It's "my.cnf", not "my.cf". So if I put a custom my.cnf file into /boot/config/plugsins/mysql it is copied to /etc/my.cf but mysql still uses the my.cnf file from the package.

 

 

Fixed

 

I updated the version, you can download it from the unRAID Plugin's Page in the wiki, see the original post for the link.  Now it will use the my.cf located in /boot/config/plugsins/mysql if it exists, insead of using medium-my.cf.  I didn't get a chance to test it yet, so let me know if it works.

 

SeeDrs

 

OK, small issue. It's "my.cnf", not "my.cf". So if I put a custom my.cnf file into /boot/config/plugsins/mysql it is copied to /etc/my.cf but mysql still uses the my.cnf file from the package.

 

 

Fixed

 

That was fast and it works perfectly now!

 

Thanks Again!

hi there,

 

i'm trying to install this plugin to my unRAID 5.0-beta13 but for some reason it won't work.

 

every time i run "installplg /boot/config/plugins/mysql-5.1.66-i468-6atv.plg" i get this error:

 

"Warning: simplexml_load_file(): I/O warning : failed to load external entity "/boot/config/plugins/screen-4.0.3-i468-1atv.plg" in /usr/local/sbin/installplg on line 13

xml parse error"

 

i tried it with a restart..but no luck.

what am i doing wrong?

 

thanks so much for your help

 

EDIT: i just upgraded to beta14 and now it suddenly works : )

hi there,

 

i'm trying to install this plugin to my unRAID 5.0-beta13 but for some reason it won't work.

 

every time i run "installplg /boot/config/plugins/mysql-5.1.66-i468-6atv.plg" i get this error:

 

"Warning: simplexml_load_file(): I/O warning : failed to load external entity "/boot/config/plugins/screen-4.0.3-i468-1atv.plg" in /usr/local/sbin/installplg on line 13

xml parse error"

 

i tried it with a restart..but no luck.

what am i doing wrong?

 

thanks so much for your help

 

EDIT: i just upgraded to beta14 and now it suddenly works : )

 

I'm having this problem too with beta12a - is it only working for 14?

 

EDIT: Worked it out - the OP said 'Copy to /boot/config/plugins and reboot or run "installplg /boot/config/plugins/mysql-5.1.66-i468-4atv.plg"' but the file I downloaded was 6atv at the end

Okay, I'd like to get an SQL server off my desktop machine and use it on my unRAID box. I'm running Beta 14 and things look to be smooth. I'm not an experienced SQL user and while I've used some of the add-on stuff in older V4 unRAID the new plug-in architecture is new to me....

 

Where does the data\tables get stored with this plug-in? I thought I saw reference to mnt/cache but nothing I've seen specifies this and I don't want to load the package to find out. I do not run a cache drive on this machine but I suppose I could add a drive for data such as this, do I need to? If possible having the files protected would be nice but in this case it's not critical (XBMC metadata). Do the downloaded files to support this package get stored on my USB stick ala unMENU when I was using that?

 

Thoughts on moving the existing SQL data out of my existing database and over to this one? I assume just copying files would be asking for trouble. Recreating is possible but I' prefer not to.

 

Thanks!

Shouldn't be any problem to transfer the files - no harm in trying it out    Worked for me going from OS X 10.6 Server (older version) to this. Just make sure none of the invisible files go with it. Also make sure the servers are stopped first.

 

On another note, SeeDrs, do you mind if I make a couple of subtle changes to the PLG file to improve the gui slightly?

 

Cheers!

Shouldn't be any problem to transfer the files - no harm in trying it out    Worked for me going from OS X 10.6 Server (older version) to this. Just make sure none of the invisible files go with it. Also make sure the servers are stopped first.

 

On another note, SeeDrs, do you mind if I make a couple of subtle changes to the PLG file to improve the gui slightly?

 

Cheers!

[/quote

 

If you need any testers... pm me . Will be testing your web server out heavily tomorrow and was going to install this older plugin for xbmc DB backend...  would love to have the latest and greatest

If anyone is interested, just did some minor updates to the gui to add in logs. Nothing else changed, see screenshot for details.

 

Is there a reason we can't get the latest mySQL for unraid? 5.5+?

I use to use the mySQL package and when I switched to this plugin mySQL complains that my database is from a different version.  How do I upgrade my database?

I'd recommend exporting your databases and re-importing back into mySQL via phpMyAdmin or other utility.

Is there a reason we can't get the latest mySQL for unraid? 5.5+?

 

Not at all! I've got a working plugin for version 5.5.22, just waiting on SeeDrs to check & ok the changes.

Haven't heard from SeeDrs 

 

Either way, I hope this is slightly beneficial to both SeeDrs and the community. Here is an update for the MySQL plugin. Runs MySQL 5.5.22, have been running on my system for at least a week without issue.

Mysql-5.5.22-i486-1gds.plg.zip

Thanks s_a. You really should bring all your plugins to this thread!

Hey sorry, i seem to be having a rather strange error.

 

Version: '5.5.22-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution

120504 18:05:21 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/.mysql

/usr/sbin/mysqld: /usr/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)

120504 18:05:21 InnoDB: The InnoDB memory heap is disabled

120504 18:05:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins

120504 18:05:21 InnoDB: Compressed tables use zlib 1.2.5

120504 18:05:21 InnoDB: Using Linux native AIO

/usr/sbin/mysqld: Can't create/write to file '/tmp/ibPzNl2h' (Errcode: 13)

120504 18:05:21 InnoDB: Error: unable to create temporary file; errno: 13

120504 18:05:21 [ERROR] Plugin 'InnoDB' init function returned error.

120504 18:05:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

120504 18:05:21 [ERROR] Unknown/unsupported storage engine: InnoDB

120504 18:05:21 [ERROR] Aborting

 

120504 18:05:21 [Note] /usr/sbin/mysqld: Shutdown complete

 

120504 18:05:21 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

 

Seems to not have access to the /tmp/ directory? Means mysql fails to startup, seemed to work fine before updating to the newer plugin you've posted

What other plugins are you using? Only thing that was changed in the backend was the official MySQL package, can almost guarantee that doesn't kill permissions on tmp folder :-)

Haven't heard from SeeDrs 

 

Either way, I hope this is slightly beneficial to both SeeDrs and the community. Here is an update for the MySQL plugin. Runs MySQL 5.5.22, have been running on my system for at least a week without issue.

 

Good work!

I am using your plugin without problems since yesterday to serve the media database to my XBMC-clients.

Haven't heard from SeeDrs 

 

Either way, I hope this is slightly beneficial to both SeeDrs and the community. Here is an update for the MySQL plugin. Runs MySQL 5.5.22, have been running on my system for at least a week without issue.

 

Have downloaded and moved to /boot/config/plugins but get a 404 when installplg runs:

 

root@server:/boot/config/plugins# installplg Mysql-5.5.22-i486-1gds.plg 
installing plugin: Mysql-5.5.22-i486-1gds
file /boot/packages/mysql-5.5.22-i486-1gds.txz: downloading from http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.22-i486-1gds.txz ... http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.22-i486-1gds.txz:
2012-05-15 22:04:18 ERROR 404: Not Found.
bad download, deleting

 

Am I doing something wrong / stupid?

Haven't heard from SeeDrs 

 

Either way, I hope this is slightly beneficial to both SeeDrs and the community. Here is an update for the MySQL plugin. Runs MySQL 5.5.22, have been running on my system for at least a week without issue.

 

Have downloaded and moved to /boot/config/plugins but get a 404 when installplg runs:

 

root@server:/boot/config/plugins# installplg Mysql-5.5.22-i486-1gds.plg 
installing plugin: Mysql-5.5.22-i486-1gds
file /boot/packages/mysql-5.5.22-i486-1gds.txz: downloading from http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.22-i486-1gds.txz ... http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.22-i486-1gds.txz:
2012-05-15 22:04:18 ERROR 404: Not Found.
bad download, deleting

 

Am I doing something wrong / stupid?

 

mysql-5.5.22-i486-1gds.txz is no longer available on that site. Update plg to point to http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.24-i486-1gds.txz and its <MD5>4a56a2643d78e3247028b0e419d67f56</MD5> should fix the error.

I'm trying to use mySQL for my openlec XBMC database but not having any success. I don't see changes being made to the mySQL database. Every time I start mysql 5.5.24, this message "useradd[7768]: failed adding user 'mysql', data deleted" comes up in my unRAID syslog.

 

*I was able to create an xbmc user and granted all rights to it. I also created xbmc_music and xbmc_video databases but later learned that they don't need to be created since latest versions of openelec creates them automatically.

 

Problem solved and not related to this plugin. Sorry! XBMC/openelec can now access the mySQL database after removing "<name>xbmc_video</name>" and "<name>xbmc_music</name>" from the advancedsettings.xml. After restarting openelec,  MyMusic18 and MyVideos60 was created automatically in mySQL  :D

Haven't heard from SeeDrs 

 

Either way, I hope this is slightly beneficial to both SeeDrs and the community. Here is an update for the MySQL plugin. Runs MySQL 5.5.22, have been running on my system for at least a week without issue.

 

Trying to install and getting this error

 

installing plugin: Mysql-5.5.22-i486-1gds
file /boot/packages/mysql-5.5.22-i486-1gds.txz: downloading from http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.22-i486-1gds.txz ... http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.22-i486-1gds.txz:
2012-05-29 13:00:45 ERROR 404: Not Found.
bad download, deleting

 

EDIT: Sorry, need to learn to read properly....

Here you can find the PLG-file for MySQL 5.5.24: http://lime-technology.com/forum/index.php?topic=20603.0

This plugin works ok, however there's one big issue: while it does a great job at ensuring the mysql user exists and starting mysqld with this user, it chowns the data directory to nobody:users. MySQL runs ok because its user is added to the "users" group, but you get permissions errors in MySQL when it attempts to access files.

 

I had to hand-edit this line in the .plg file (around line 240):

"chown -hR mysql:mysql $DATADIR"

 

I had originally attempted to fix this with the "go" script, but to no avail. You could also set MySQL to run as the "nobody" user, but that has additional security implications.

Having problems getting MySQL  mysql5_20120805.plg to run.

 

Installed as part of Influencer's Newznab plugin.

 

Unraid server operating on 5.0-rc8a

 

The plugin appears to install correctly and folders and files are created in a cache only share. The status for the program is "Stopped"

 

here is the contents of the log file

 

121218 13:33:34 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/apps/mysql

121218 13:33:34 InnoDB: The InnoDB memory heap is disabled

121218 13:33:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins

121218 13:33:34 InnoDB: Compressed tables use zlib 1.2.5

121218 13:33:34 InnoDB: Using Linux native AIO

/usr/sbin/mysqld: Can't create/write to file '/tmp/ibgR7xik' (Errcode: 13)

121218 13:33:34 InnoDB: Error: unable to create temporary file; errno: 13

121218 13:33:34 [ERROR] Plugin 'InnoDB' init function returned error.

121218 13:33:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

121218 13:33:34 [ERROR] Unknown/unsupported storage engine: InnoDB

121218 13:33:34 [ERROR] Aborting

 

121218 13:33:34 [Note] /usr/sbin/mysqld: Shutdown complete

 

121218 13:33:34 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

121218 13:38:47 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/apps/mysql

121218 13:38:47 InnoDB: The InnoDB memory heap is disabled

121218 13:38:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins

121218 13:38:47 InnoDB: Compressed tables use zlib 1.2.5

121218 13:38:47 InnoDB: Using Linux native AIO

/usr/sbin/mysqld: Can't create/write to file '/tmp/ibOXAE1f' (Errcode: 13)

121218 13:38:47 InnoDB: Error: unable to create temporary file; errno: 13

121218 13:38:47 [ERROR] Plugin 'InnoDB' init function returned error.

121218 13:38:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

121218 13:38:47 [ERROR] Unknown/unsupported storage engine: InnoDB

121218 13:38:47 [ERROR] Aborting

 

121218 13:38:47 [Note] /usr/sbin/mysqld: Shutdown complete

 

121218 13:38:47 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

 

 

 

It appears that it is unable to create a directory in the /tmp folder.

 

I am not sure what to try next. 

 

 

try this:

chown 1777 /tmp

that will make /tmp writable by all.