September 4, 201312 yr Is deleting mysql just as simple? Remove the plg file and remove the directory where it's installed (/mnt/cache/.mysql for me)? and a reboot will be good.
September 4, 201312 yr Does anybody have an idea why mysql settings pages output to the progressframe(bottom left) does not fit and has bigger fonts??? Edit: it should be monospace 10px but it is times new roman 16px
September 4, 201312 yr My beta version (0.1.0) of plugin is ready with a few fix & additions: i suggest backup before install. Changes: - my.cnf chmod fix, - plg update feature added, - start/restart/stop controls added, - my.conf typo fix, - filename changed to a static one for easy update, - page version changed to plugin version for maintance, - all contributers added to author section. Known Issues: - output does not fit to the progressFrame because of uncorrect font size.(need help) Download Plugin Installation: 1) stop mysql if installed a) run "/etc/rc.d/rc.mysql stop" from telnet b) press stop from control panel 2) make a bakup of your database 3) download my plugin (right click save target as) to /boot/config/plugins 4) make sure file name is mysql-ikosa.plg 5) run "installplg /boot/config/plugins/mysql-ikosa.plg" from telnet 6) start mysql from plugin page (http://tower/Settings/mysql) 7) check you database you can delete old mysql5_*.plg file or move to somewhere else. of course i take no credit, all credit goes to the original authors.
September 4, 201312 yr My beta version (0.1.0) of plugin is ready with a few fix & additions: i suggest backup before install. Changes: - my.cnf chmod fix, - plg update feature added, - start/restart/stop controls added, - my.conf typo fix, - filename changed to a static one for easy update, - page version changed to plugin version for maintance, - all contributers added to author section. Known Issues: - output does not fit to the progressFrame because of uncorrect font size.(need help) Download Plugin of course i take no credit, all credit goes to the original authors. Can't wait to give this a try. Install it but putting it in the plugin folder and rebooting? Do I need to have an gui other than the default installed? Thanks!
September 4, 201312 yr i add the install instructions to the upper post. of course you can resart your server instead of item #5 enjoy,
September 6, 201312 yr anybody also having a problem with missing tables after a reboot with this new plugin ? not sure what is going on but every reboot i lose all my tables ... the frm files are still there but all tables are gone... need to import backup every time ... checked the changes you made and don't really see what could cause this... importing db again and see if it happens again before returning to the old plugin
September 6, 201312 yr As you said I don't make any change to cause that. Can you post your my.cnf and mysql.cfg. I think Chmod on go file is useless because that way you try to chmod file before array and mysql started so before my.cfg created. Sent from my HTC Desire using Tapatalk 4
September 6, 201312 yr Can you post your my.cnf and mysql.cfg. And .err file Sent from my HTC Desire using Tapatalk 4
September 6, 201312 yr well what happened is that every reboot he made a new ibdata file not sure why but it seems to be resolved after i changed /mnt/user/mysql to /mnt/cache/mysql in my.cnf file i am updating xbmc now and once it is finished will make a new back up and reboot again
September 6, 201312 yr anybody also having a problem with missing tables after a reboot with this new plugin ? not sure what is going on but every reboot i lose all my tables ... the frm files are still there but all tables are gone... need to import backup every time ... checked the changes you made and don't really see what could cause this... importing db again and see if it happens again before returning to the old plugin i try again with my test setup and everythnig is ok after restart.
September 7, 201312 yr well it is solved.... i am thinking the timing could have been the issue let's say that mysql is started before all disks are mounted under /mnt/user ? anyway happy it is solved ...
September 7, 201312 yr well it is solved.... i am thinking the timing could have been the issue let's say that mysql is started before all disks are mounted under /mnt/user ? anyway happy it is solved ... No event handler starts mysql after array started. Sent from my HTC Desire using Tapatalk 4
September 9, 201312 yr Hello All, I'm proud to present new beta version (0.2.0) of mysql plugin with automated and manual backup options. For now ssmtp package has to be installed and configured manually (or from unmenu) for the mail function. Later maybe i will add it to the plugin. 0.1.0 users can update within the plugin other users can follow the instructions on my old post: http://lime-technology.com/forum/index.php?topic=20603.msg261789#msg261789 Although i double/triple check everything, dont forget that this is a beta plugin and may have errors. Use it with your own risk. And keep me posted about your experiance.
September 10, 201312 yr Also keep in mind that there is a security issue: Since i dont know a better way to do this plugin stores the mysql server password unencrypted in the cfg file.
September 11, 201312 yr Hi fairly new to this. I have been trying to get xbmc updater running for the past few days without any success I have MySQL running and xbmc updater running for the life of me not sure what to do next been reading and trying different methods to no success. I started by attaching my MySQL log files and also the xbmc log. Any help at this point would be great thanks Lou mysql_log.txt XBMC_log.txt
September 12, 201312 yr Hi fairly new to this. I have been trying to get xbmc updater running for the past few days without any success I have MySQL running and xbmc updater running for the life of me not sure what to do next been reading and trying different methods to no success. I started by attaching my MySQL log files and also the xbmc log. Any help at this point would be great thanks Lou Hi, i think this is not the right place to ask this, xbmc forums will be more relevant. But IMO you have to be sure that you can connect to mysql and you create the user xbmc with pass xbmc on mysql server. You can use something like heidisql if you are not comfortable with command line.
September 13, 201312 yr good to know that it is working without problems. I spoke to early it seems i seem to have an issue with 2.0 version after a reboot... not sure why as i went over your code to compare both versions and nothing jumps out basically what happens is that the package gets installed but copying the /etc/mysql/mysql.server file to rc.d/rc.mysql doesn't happen and also not the sed commands to update that file the My.cnf is also not copied to /etc/ can't figure out why though ... when i put version 1.0 then it works ... logs from 01 verion are OK ... can't reboot now for the 02 version log as the kids are watching a movie but will collect this afternoon
September 13, 201312 yr yesterday i had a similar issue after restart i my mysql is not started automaticly and cant start it with start button or even from the command line and some error like "The server quit without updating PID file". but if i hit apply from webgui server started without any porbs. it seems like it doenst copy the my.cnf file to the /etc/mysql directory. it is strange that: a) i dindt change the logic there i just add a chmod b) pretty much the same command is runnig both on reboot or manually hitting apply. also this logic or cmds not changed by me. i dont have time yesterday to look deep. I'll when i have more time.
September 13, 201312 yr that solved it THX for updating this the issue -> case 'Apply': old version had case 'apply':
September 13, 201312 yr another bug found and fixed. about clearing cfg file on reboot. pls update to 0.2.2 thx.
September 15, 201312 yr another bug found and fixed. about clearing cfg file on reboot. pls update to 0.2.2 thx. I downloaded from the link you posted, but I see this message in my settings page New version (0.2.0) is available Did I download the wrong version?
Archived
This topic is now archived and is closed to further replies.