December 11, 201312 yr # Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # # MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You can copy this option file to one of those # locations. For information about these locations, see: # http://dev.mysql.com/doc/mysql/en/option-files.html # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the "--help" option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-external-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the "enable-named-pipe" option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin=mysql-bin # binary logging format - mixed recommended binlog_format=mixed # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - # the syntax is: # # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>, # MASTER_USER=<user>, MASTER_PASSWORD=<password> ; # # where you replace <host>, <user>, <password> by quoted strings and # <port> by the master's port number (3306 by default). # # Example: # # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, # MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then # start replication for the first time (even unsuccessfully, for example # if you mistyped the password in master-password and the slave fails to # connect), the slave will create a master.info file, and any later # change in this file to the variables' values below will be ignored and # overridden by the content of the master.info file, unless you shutdown # the slave server, delete master.info and restart the slaver server. # For that reason, you may want to leave the lines below untouched # (commented) and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 - 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted #server-id = 2 # # The replication master for this slave - required #master-host = <hostname> # # The username the slave will use for authentication when connecting # to the master - required #master-user = <username> # # The password the slave will authenticate with when connecting to # the master - required #master-password = <password> # # The port the master is listening on. # optional - defaults to 3306 #master-port = <port> # # binary logging - not required for slaves, but recommended #log-bin=mysql-bin # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /mnt/user/mysql #innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /mnt/user/mysql # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 16M #innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 5M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout The only difference I see between my cnf and the one you published earlier are the two line items with the home directory # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /mnt/user/mysql #innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /mnt/user/mysql vs. # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /mnt/user/No_move/mysql #innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /mnt/user/No_move/mysql
December 12, 201312 yr Author Soana, Just to be sure are you using the latest 0.2.2 version? Because i fix smtg about this in version 0.2.1. http://lime-technology.com/forum/index.php?topic=20603.msg263310#msg263310 pls compare the file /etc/my.cnf with your my.cnf file, to be sure it is copied properly and running at the correct home directory. did you try the original mysql plugin? lastly i find a suspicious line about permissions at the plg file (which comes from the original plg) and removed it. You can test the attached version. googling "unknown variable 'table_open_cache=64'" and "The server quit without updating PID file" and trying some suggested solutions should also help. mysql-ikosa.plg.zip
December 17, 201312 yr Hi Ikosa, Today I decided to reinstall unraid and mysql 0.2.2 on my test server and everything works OK! Not sure what I did different but all of the sudden the sql server is working as intended I even tried several reboots and no issues. Next step is to update the main server as soon as I can get some downtime on it. I will keep you posted on the results. Also I hope I can figure out what stars aligned to make it work... I have a feeling that maybe I was not using the correct shutdown/reboot procedure. Thank you, soana.
December 18, 201312 yr Author Hi soana, thanks for the update. Good to hear finally it is working for you too.
January 5, 201412 yr hello i tried to install the mysql-server everything seems to be working, but i can't start the server when i try to login with telenet using: mysql -u mysql -p then i get error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) what is wrong here??
January 6, 201412 yr yes, i did. i tried another mysql-server with better luck so i don't know why yours isn't working....
January 6, 201412 yr I got this plugin setup and running fine, got my OpenELEC machines configured and the database is working great. However I am running into an error when doing backups of the MySQL database. I have ssmtp setup and working via unmenu, I have MySQL setup to do weekly backups and sent email to root. Below are the errors I am getting in the email: #1 - MySQL backup error: "File not found or corrupt!" mysqlbackup_2014_01_06-03_30.sql.gz #2 --Warning: Skipping the data of table MySQL.event. Specify the --events option explicitly. When I go to my backup location the backups are present. I am running unRAID 5.0.4 and installed MySQL thru control panel. Attached is a screen shot of the MySQL config page, any information on this would be great. Thanks
January 6, 201412 yr Author Your backup file is smaller than the min file size (defined in config page/webgui). If you are sure that your backup is OK you can lower your min file size to match your backup size. Second error is not really an error just a warning we don't/can't backup event tables while mysql is running. And I guess we don't need them.
January 6, 201412 yr Author yes, i did. i tried another mysql-server with better luck so i don't know why yours isn't working.... I m not sure but it can be related about permissions. Can you check folder permissions. There is info about this a few post above.
January 6, 201412 yr Your backup file is smaller than the min file size (defined in config page/webgui). If you are sure that your backup is OK you can lower your min file size to match your backup size. Second error is not really an error just a warning we don't/can't backup event tables while mysql is running. And I guess we don't need them. I adjusted the min file size and am now getting the success email after backup, I'm certain the backup is OK as I'm still building my media library so its not very big at the moment. Thanks for the info and your work on this plugin.
January 11, 201412 yr I'm getting the following error when installing the plugin installing plugin: mysql-ikosa file /boot/packages/mysql-5.5.30-i486-1gds.txz: downloading from ftp://sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.30-i486-1gds.txz ... bad download, deleting Tried multiple times but keep getting the same error.
January 12, 201412 yr I got the same... just google for a different download location and change the plg.
January 12, 201412 yr Author mysql link was down for some reason i changed the link and update the plugin.
January 12, 201412 yr Download and installed the plg OK, but MySQL won't start, returns this in the unraid terminal "sh: /etc/rc.d/rc.mysql: No such file or directory" EDIT: Got it going, I think I might have neglected to click "apply", It's running now and and have created user, also MySQL has restarted on reboot.
January 14, 201412 yr Author thats pitty i saw your edit after working for an hour to run my test setup properly and testing my plugin several times to get the same error. i figure out why and come here to reply your post and boom see you edit. whatever i'm happy to see that it is working for you too... i guess i have too add this apply step to the first post.
January 15, 201412 yr Apologies for any inconvenience I caused, after reading several threads I realized I might not have hit "apply"
January 18, 201412 yr I ran into a number of permissions issues, which this thread helped with. I am now able to get my XBMC data to scrape into the correct MySQL DBs. However, I am unable to access the mysql and mysql/backup folders on my network. Is there some setting in the plugin config that blocks access to these folders, as smb shares on the network? Any help would be appreciated.
January 19, 201412 yr Just wanted to say a quick thanks for this plugin. I was just able to install it with ease and now have my 2 xbmc machines using the mysql database and have the plugin backing up the databases to one of my shares at 12.00am each night. Silly question time now though, how do I restore the backed up database in the event of a problem with my mysql database, I have no experience with mysql yet.
January 22, 201412 yr Author I ran into a number of permissions issues, which this thread helped with. I am now able to get my XBMC data to scrape into the correct MySQL DBs. However, I am unable to access the mysql and mysql/backup folders on my network. Is there some setting in the plugin config that blocks access to these folders, as smb shares on the network? Any help would be appreciated. can you check mysql folders permissions from telnet with "ls -l"
January 22, 201412 yr Author Just wanted to say a quick thanks for this plugin. I was just able to install it with ease and now have my 2 xbmc machines using the mysql database and have the plugin backing up the databases to one of my shares at 12.00am each night. Silly question time now though, how do I restore the backed up database in the event of a problem with my mysql database, I have no experience with mysql yet. Plugin dont have restore options. I dont want to mess things. You have to restore it manually. Hope you never need it: http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/
February 4, 201412 yr Think I may have a permissions problem with my install. Using this plugin to replace the package installed version I have been using with my XBMC machines for some time. The plugin installs and starts no problem and then I can connect via telnet and add the xvmc user etc. However my XBMC machines do not sen to make a connection and import any media to a library and I can't browse to the mysql older on my cache drive. plus the back email I received said; Mysql backup error: "File not found or corrupt!" mysqlbackup_2014_02_04-00_00.sql.gz Sorry for being a bit vague here but I'm in the middle of trying to fix my old MySQL install so I can export the library plus get this one working soI can import that library, neither is working!
May 1, 201412 yr Hello, by default, where is your swap file? Do I need to change it? Do I need to change swap file size? Thanks
Archived
This topic is now archived and is closed to further replies.