Mine starts automatically and I didn't need to change the install directory from whatever it defaulted to.

 

Is your data directory on your cache drive?

Hi All.

 

Is there a way to run this without a cache drive and without putting it on my array? I don't really want the array spun up often because of one or two random accesses if I can avoid it.

Since I dont have a cache drive and dont plan to have one I put persistent application data to /mnt/user/app/...

 

 

Since I dont have a cache drive and dont plan to have one I put persistent application data to /mnt/user/app/...

 

Mine is on the cache drive and runs great. The array is spun down if not accessed for a while. Just change the default folder to /mnt/cache/apps/mysql or whatever you like on the /mnt/cache drive

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

 

 

 

Mine starts automatically and I didn't need to change the install directory from whatever it defaulted to.

 

Is your data directory on your cache drive?

 

Mine doesn't start automatically either.

 

Located in mnt/cache/.apps/mysql

 

Not a problem personally but wondered what others are finding happens, and perhaps help justi7ncase.

 

Sent from my iPad using Tapatalk HD

Mine is /mnt/cache/mysql it has its own share maybe that has something to do with it?

can somebody please help me get this going again. My stupid apps share got deleted and in working to get everything back up and running the only two plugins that wont start are Plex and MySQL. When I go to enable it nothing happens and the status still says stopped. In the unraid syslog I get "Apr 22 19:28:02 Tower useradd[830]: failed adding user 'mysql', data deleted " in the err log from mysql I get

 

130422 19:28:02 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/apps/mysql
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
130422 19:28:02 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130422 19:28:02 InnoDB: The InnoDB memory heap is disabled
130422 19:28:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130422 19:28:02 InnoDB: Compressed tables use zlib 1.2.5
130422 19:28:02 InnoDB: Using Linux native AIO
130422 19:28:02 InnoDB: Initializing buffer pool, size = 128.0M
130422 19:28:02 InnoDB: Completed initialization of buffer pool
130422 19:28:02 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /mnt/cache/apps/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
130422 19:28:02 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

 

I have deleted everything I can find and deleted everything that was referred to in a post a few pages ago and I still have this error. I have tried chown ing the /mnt/cache/apps/mysql folder and changing /tmp to 777 all with the exact same errors.

I had the exact same set up and the same issue. Originally MySQL was in /mnt/cache/apps/mysql, but it wont start after reinstall. It works fine when i put it in /mnt/cache/mysql and the only "downside" is that there is a mysql share now but just leave it be. Give it a shot.

I put mine in /mnt/cache/.mysql. Using the . prevents it from being added to your shares.

i'm thinking about adding this but are there any benefits to this vs the unmenu mysql? I'm running mysql with unmenu and everything is great, but i'm considering going to this if the benefit is worth it.

 

also, how hard would it be to transfer my current users and db tables over? or is it easier to just rebuild?

I know the plugins on unraid 5 have an easier time stopping. I noticed mysql via unmenu I have to manually stop it more times than not when im trying to stop the array. Might be worth it for that alone.

 

Sent from my SCH-I605 using Tapatalk 2

 

 

i cant start mysql service. i removed unmenu mysql. i install mysql from this plugin http://lime-technology.com/forum/index.php?action=dlattach;topic=20603.0;attach=15070 (from unraid plugins site). how can i see the error?

 

thanks.

i cant start mysql service. i removed unmenu mysql. i install mysql from this plugin http://lime-technology.com/forum/index.php?action=dlattach;topic=20603.0;attach=15070 (from unraid plugins site). how can i see the error?

 

thanks.

 

in the setting page of unraid GUI there should be an option for :MySQL server"

 

you can enable it in there.

been playing with this all night and i finally got it working.

 

if you're like me and you had the unmenu mysql installed and working, i think the default root pw will be whatever it was in the unmenu version. also you may be happy to note that if you specify the same data dir as your old install, you shouldn't lose anything.

 

hopefully this may help someone else.

in the setting page of unraid GUI there should be an option for :MySQL server"

 

you can enable it in there.

i did. in fact, this is how i enable it.

 

Attached mysql error log.

 

i isolate error message when i tried to enable mysql.

130429 18:26:21 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/.mysql
130429 18:26:21 InnoDB: The InnoDB memory heap is disabled
130429 18:26:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130429 18:26:21 InnoDB: Compressed tables use zlib 1.2.5
130429 18:26:21 InnoDB: Using Linux native AIO
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibnmmWV9' (Errcode: 13)
130429 18:26:21 InnoDB: Error: unable to create temporary file; errno: 13
130429 18:26:21 [ERROR] Plugin 'InnoDB' init function returned error.
130429 18:26:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130429 18:26:21 [ERROR] Unknown/unsupported storage engine: InnoDB
130429 18:26:21 [ERROR] Aborting

130429 18:26:21 [Note] /usr/sbin/mysqld: Shutdown complete

130429 18:26:21 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

 

i forgot to mention that i used to use unmenu mysql. currently, im upgrading/updating my unraid box.

mysql_error_log.txt

i managed to solved the problem

googling

InnoDB: Error: unable to create temporary file; errno: 13

reveals that i need to do this to fix it.

chown nobody:user /tmp
chmod 1777 /tmp

what is the best tmp permission? by default, unraid set tmp permission to root. mysql doesnt work with this. after changing the owner to nobody:user, i can start mysql. but i cant execute mysql_secure_installation. i get this error "ERROR 1045 (28000): Access denied for user 'root'@'localhost'". what should i do?

 

as last resort, how can i delete all mysql traces so i can have fresh mysql installation?

 

thanks.

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

 

i did that until the last part where i got this error

 

root@Tower:/boot/config/plugins# mysqladmin -u root password root
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
root@Tower:/boot/config/plugins#

 

i checked that file /tmp/mysql.sock doesnt exist. since tmp folder is not persistent, i assume the file is created by plugins installer.

 

thanks.

i tried to login using root. this is what i get.

root@Tower:/boot/config/plugins# mysqld --user=mysql
mysqld: Table 'mysql.plugin' doesn't exist
130503  1:04:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130503  1:04:29 InnoDB: The InnoDB memory heap is disabled
130503  1:04:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130503  1:04:29 InnoDB: Compressed tables use zlib 1.2.5
130503  1:04:29 InnoDB: Using Linux native AIO
130503  1:04:29 InnoDB: Initializing buffer pool, size = 128.0M
130503  1:04:29 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130503  1:04:29  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130503  1:04:29  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130503  1:04:29  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130503  1:04:29  InnoDB: Waiting for the background threads to start
130503  1:04:30 InnoDB: 5.5.30 started; log sequence number 0
130503  1:04:30 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130503  1:04:30 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130503  1:04:30 [Note] Server socket created on IP: '0.0.0.0'.
130503  1:04:30 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
root@Tower:/boot/config/plugins#

 

setting up mysql using this plugin seems to be the most tiresome experience.

 

thanks.

My problem was that the MySQL plugin for Ver 14.14 Distrib 5.5.30 did not get started properly (I had it started from the go script).

 

To wrap it up my experience after adding a cache drive:

 

I moved all plugins to /boot/config/plugin and removed all installplg and /etc/rc.d/rc... stuff from /boot/config/go. I configure the app share to use the cache drive only. I also configured the array to get started on boot.

 

After booting the array is up and _all_ applications are available (including MySQL). Right as you would expect it to happen.

 

Wonderful!

 

publicenemy have you tried logging in like this?

 

root@Tower:~# mysql -u root -p

 

 

Also if you had the unraid mysql before this you need to delete all of the before using this plugin or atleast I had to.  If I were you I would delete anything that has to do with mysql and then reinstall the plugin.

Hi all - just installed this plugin - all seemed to go without an issue and the server seems to start fine using the simplefeatures page.

 

However, I can't login to mysql from the cmd line

 

If i type mysql -u root -p it then asks for the password, but when i enter root as the password, I get the following error:

 

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

The password is definitely root right? I've tried a bunch of other passwords (blank, admin, password etc) to no avail.

 

Any ideas??

 

EDIT - Nevermind I changed the directory from /mnt/cache/appdata/mysql to /mnt/cache/mysql and I can login now

I have just tried to install this and I am getting an error

 

file /boot/packages/mysql-5.5.28-i486-1gds.txz: downloading from http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.28-i486-1gds.txz ... http://ftp.sotirov-bg.net/pub/contrib/slackware/packagesslackware-13.37/mysql-5.5.28-i486-1gds.txz:

2013-05-22 09:44:12 ERROR 403: Forbidden.

 

I'm guessing the plg needs updating with a new link to mysql?

 

Being a unraid newbie I wouldnt know where to start.

 

Thanks

 

 

just open the plg in a text editor and update the link. make sure you update the filename and md5 as well.

I have just tried to install this and I am getting an error

 

file /boot/packages/mysql-5.5.28-i486-1gds.txz: downloading from http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.28-i486-1gds.txz ... http://ftp.sotirov-bg.net/pub/contrib/slackware/packagesslackware-13.37/mysql-5.5.28-i486-1gds.txz:

2013-05-22 09:44:12 ERROR 403: Forbidden.

 

I'm guessing the plg needs updating with a new link to mysql?

 

Being a unraid newbie I wouldnt know where to start.

 

Thanks

 

I updated the  plugin a couple of pages back for the 5.5.30 version.

 

http://lime-technology.com/forum/index.php?topic=20603.msg229248#msg229248