Is there a way to do MySQL in V6.

In V5 MySQL was a plug in and it works with no problem but now with V6 I will still need SQL to do various things. It created its own share so I just need the understanding or plugin  to support what was put in the share.

Any ideas will be very helpful.

 

 

Thornwood

 

 

 

Thornwood

replace in plugin packages and depends from slackware 14.1 x64 repo

 

Slackware no longer supports a MySQL package - it has been replaced by MariaDB, which is supposed to be (almost?) fully compatible.  My intention is to wait for unRAID beta4 to be released before installing on my one and only (live) server.  I will then be looking at producing a plugin for MariaDB ... unless someone else beats me to it!

yeah im also waiting for beta4 after that i maybe compile myself latest mysql

- but im suppose is some reason replaced this package

http://pkgs.org/slackware-14.1/slackware-patches-x86_64/mariadb-5.5.35-x86_64-1_slack14.1.txz.html

 

just replacing the package in the PLG with one of these should do the trick

 

MariaDB is a backward compatible, drop-in replacement branch of the MySQL® Database Server. It includes all major open source storage engines, including the Aria storage engine.

Homepage: http://mariadb.org/

 

Kind of waiting myself for beta 4 to test it on one of my servers

Great because that is the only plugin I have left till I start moving to 6. Thank you

 

 

Thornwood

For those who want

 

I upgraded the Ikosa mysql plg for Mariadb 64Bit for Unraid 6

 

Although i didn't have any issue by just pointing it to my existing database and starting it.....  i would like to WARN everybody to be sure to have a backup

 

i didn't have to change anything but best read up on MariaDB website if you are running an older MYSQL version (unmenu versions.... ) as those need to be upgraded before you take it in use

 

Anyway as Always i just upgrade the scripts ..... if you have issues best put them in the original ikosa post

 

Will ask Ikosa to put this with the rest of his scripts so that the autoupdate function can work

 

Remove the .txt extension... copy to /boot/config/plugins and reboot or installplg /boot/config/plugins/MariaDB-ikosa_64bit.plg

MariaDB-ikosa_64bit.plg.txt

I see 1 download on here from the previous attached PLG...

Please download the new plg that i attached today 17th of March 2014

as the first one had 2 typo's which caused the mysql deamon not to stop when the array goes down.. which would give a problem to cleanly shutdown your unraid

 

all fixed in the new version

Thanks for fixing this.  That was my next plugin to get working and now I don't have too.  You can also add a line at the top of the mysqlctl.php file section that Tom posted in the APCUPSD for unRAID 6 thread to get rid of the php timezone message.

 

date_default_timezone_set(substr(readlink("/etc/localtime-copied-from"), 20));

 

This will parse your system's timezone from the symlink and set it for the php script.

updated that in the new version attached

 

was under the assumption that this would have been fixed with B4 but this works too

MariaDB-ikosa_64bit.plg.txt

I'm having problems with this plugin.

 

I'm trying to keep the db in /mnt/cache/mysql (I just created the folder myself).  I changed the datadir path in the .plg to reflect this, and everything seems to install OK.  I can't get MySQL to start though - on the console I get:

 

sh: /etc/rc.d/rc.mysql: No such file or directory

 

Then the usual mysqld isn't running errors.

 

I'm sort of at a loss now - should I not be setting the .plg to use that folder on the /mnt/cache drive?  Is it a permissions issue? 

Do you have a my.cnf in your mysql plugin directory or the one in /etc?  This needs to reflect the path too.

I decided to blow away my install, and start again (MySQL is the first thing I was installing).

 

Error I get is:

Mar 21 18:31:54 Tower useradd[2583]: failed adding user 'mysql', data deleted

Mar 21 18:31:54 Tower usermod[2585]: add 'mysql' to group 'users'

 

MySQL still won't start.

 

It's working.  Hint: Don't telnet to unRAID and start fiddling with files, it buggers up permissions big style. 

Just a heads up - the plugin (I'm using sacretagents modified version) doesn't play nice with v6 beta 4.

 

It seems to be to do with the changes regarding GET and POST. The mysqlctl.php page doesn't read the config values correctly, and also doesn't detect whether it has been run from emhttp or via a command line, so doesn't do the auto refresh of the settings page after performing an action.

 

It needs someone who knows some php-fu to take a look at it.

 

It also puts a rogue rc.mysqld file in to /etc/rc.d I say rogue because, when the php page is working properly it creates /etc/rc.d/rc.mysql (note the lack of a 'd' on the end of the filename) which is then used to start, stop etc the MySQL daemon.

Does anybody have this working yet?  I have no php-fu to speak of...

I have MariaDB running in an ArchVM, functioning just as well as MySQL was, using the same database, under V5.

Is your database on the cache drive or the array?  Mine are on the array, on a dedicated small ssd.

Is your database on the cache drive or the array?  Mine are on the array, on a dedicated small ssd.

 

Mine?  On ordinary magnetic disk via user share.

How did you get the mysql in the VM to use the user share as a data directory?  I was playing around with that last week, but couldn't get it to work.

How did you get the mysql in the VM to use the user share as a data directory?  I was playing around with that last week, but couldn't get it to work.

 

In /etc/mysql/my.cnf I set datadir = /net/tower/mnt/user/mysql

Just a heads up - the plugin (I'm using sacretagents modified version) doesn't play nice with v6 beta 4.

 

It seems to be to do with the changes regarding GET and POST. The mysqlctl.php page doesn't read the config values correctly, and also doesn't detect whether it has been run from emhttp or via a command line, so doesn't do the auto refresh of the settings page after performing an action.

 

It needs someone who knows some php-fu to take a look at it.

 

It also puts a rogue rc.mysqld file in to /etc/rc.d I say rogue because, when the php page is working properly it creates /etc/rc.d/rc.mysql (note the lack of a 'd' on the end of the filename) which is then used to start, stop etc the MySQL daemon.

I'm having this same problem (I think). The settings page doesn't do anything. No matter what I change, it doesn't get saved. And pressing "Start" does not start it.

Slackware no longer supports a MySQL package - it has been replaced by MariaDB, which is supposed to be (almost?) fully compatible.  My intention is to wait for unRAID beta4 to be released before installing on my one and only (live) server.  I will then be looking at producing a plugin for MariaDB ... unless someone else beats me to it!

 

it's not in the official repo but you can still get mysql for slackware.

updated for 6 beta 5

 

https://github.com/sacretagent/Unplugged_64Bit_Unraid.6/raw/master/Crashplan.3.6.3.64bit.plg right-click save as

 

be sure to first install the plg

then go to the settings page and click apply

after that it should start

 

still hoping somebody will have a look at this to maybe figure out other issues but mine is running OK so far

ok autostart and autostop on array mount /dismount is not working

been messing around to get it working but my php fu is not strong enough to figure it out....

so if somebody can have a look why it is not auto starting/stopping ?