I upgraded to RC9a yesterday. MySQL appears to be working fine, at least XBMC's access is working. I've not tried to login to MySQL. I will try that now, if I can remember the root password.

 

I just check my permissions. MySQL is set to:

drwxrwxrwx  6 nobody users 424 2013-01-09 19:55 .mysql/

 

5.5.28 is no longer available.

 

I updated the plugin with 5.5.29

mysql5_20130111.zip

I still can't access mysql but atleast now it is installed.

 

Is your process running as mysql or something else?

 

This is mine:

 

mysql    23156 22853  0 16:42 ?        00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/mnt/user/appdata/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/mnt/user/appdata/mysql/Tower.err --pid-file=/var/run/mysql/mysql.pid --socket=/tmp/mysql.sock --port=3306

I upgraded to RC9a yesterday. MySQL appears to be working fine, at least XBMC's access is working. I've not tried to login to MySQL. I will try that now, if I can remember the root password.

 

I just check my permissions. MySQL is set to:

drwxrwxrwx  6 nobody users 424 2013-01-09 19:55 .mysql/

 

I was talking about your data directory on this.

That is my data directory for MySQL.

 

I'm not sure about your other question. How do I check that?

I can change mine so it is nobody:users but if I restart mysql it goes back to mysql:users.

 

Your data directory is whatever you put in for the plugin.  Mine is /mnt/user/appdata/mysql.  So if that is your data directory then there is something wrong with the plugin that I have because I can't do that.

Mine is set as follows:

/mnt/cache/.mysql

And that is where it is installed.

I too was having issues with unraid, mysql, and openelec.  My issue was that openelec was trying to read the database before the network was online.  To correct this, I followed this post to create a startup script to delay boot until it could reach the unraid box.

 

http://forum.xbmc.org/showthread.php?tid=149071&pid=1276169#pid1276169

updated plg file with new mysql.tgz address included. no other changes made.

 

mysql5.5.28_20132201.plg.zip

5.5.28 is no longer available.

 

I updated the plugin with 5.5.29

 

this is the latest one right?

installing plugin: mysql5.5.28_20132201

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.29-i486-1gds.txz ... bad download, deleting

 

I got that message when trying to install the last .plg file you post

updated plg file with new mysql.tgz address included. no other changes made.

 

How about using ISO standard on the date format, yyyymmdd?

installing plugin: mysql5.5.28_20132201

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.29-i486-1gds.txz ... bad download, deleting

 

I got that message when trying to install the last .plg file you post

 

I get the same with 5.5.29 in the link on page 7

Try this.

mysql5_20130111.zip

downloaded...  and...

 

You don't have permission to access http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/ on this server.

 

because it is not an http but an ftp server, so changing http into ftp inside the plg file makes it work

makes me wonder if anybody tests anything before dumping it online

downloaded...  and...

 

You don't have permission to access http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/ on this server.

 

because it is not an http but an ftp server, so changing http into ftp inside the plg file makes it work

makes me wonder if anybody tests anything before dumping it online

 

I didn't test it because I don't use mysql.  If you found a mistake with the plg why not change it and repost instead of complaining.

I would like to see many more function in this plugin, most for maintenance, for example backup, restore ........

 

Is this interesting ? maybe the author is not longer maintain this plugin, so some one else can take over?

 

//Petr

I would like to see many more function in this plugin, most for maintenance, for example backup, restore ........

 

Is this interesting ? maybe the author is not longer maintain this plugin, so some one else can take over?

 

//Petr

 

+1

Maybe influencer is willing to...

Afterall hes doing a fantastic job with sabnzb, couchpotato....... etc etc

I would like to see many more function in this plugin, most for maintenance, for example backup, restore ........

 

Is this interesting ? maybe the author is not longer maintain this plugin, so some one else can take over?

 

//Petr

 

+1

Maybe influencer is willing to...

Afterall hes doing a fantastic job with sabnzb, couchpotato....... etc etc

 

And theone do a very great job on his new plugins as well! :-)

Maybe he or influencer would take over this plugin ?

 

So we have a maintenance function in the web UI

 

//Peter

 

 

 

I have try several ways to make mysql don't create mysql-bin files, but can't get it to work, any ides how to solve this?

 

There is a setting you can add to the .conf file to limit how many bins it makes and supposedly to stop making them at all. I didn't have luck stopping them, but limiting them to 5 worked.

There is a setting you can add to the .conf file to limit how many bins it makes and supposedly to stop making them at all. I didn't have luck stopping them, but limiting them to 5 worked.

 

Here is an article on the issue

 

http://www.cyberciti.biz/faq/what-is-mysql-binary-log/

 

found it interesting .. i think i disabled them but can't restart mysql now as xbmc is scanning my music library

i purged them though already

using this

PURGE BINARY LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 7 DAY);

 

and that worked

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?

Fixed plugin

mysql5_20130111.zip

I still have the same problem as I did before where it doesn't set my root password so I can't get into mysql.