=== Muzer_ is now known as Muzer | ||
=== Shadow__1 is now known as Shadow__X | ||
qwebirc56669 | I've got a question about myth updates if anyone is available | 19:08 |
---|---|---|
Shadow__X | what type of questions | 19:08 |
qwebirc56669 | on some of the mythtv servers I maintain for people when I update to the new mythtv fixes it resets my mysql network setting back to disabled | 19:09 |
qwebirc56669 | I have to enable it after every mythtv update | 19:10 |
tgm4883 | qwebirc56669, how are you enabling it? | 19:10 |
qwebirc56669 | in the mythbuntu setup program | 19:10 |
tgm4883 | ok | 19:11 |
qwebirc56669 | mostly because I don't know what it's doing to mysql | 19:11 |
tgm4883 | qwebirc56669, I've heard it's caused by some corruption in the dpkg database. I've personally not looked into it | 19:12 |
tgm4883 | qwebirc56669, It would be mythtv-database that is causing it to get reset | 19:12 |
tgm4883 | specifically, this code http://pastebin.ubuntu.com/5647267/ | 19:13 |
tgm4883 | qwebirc56669, I'm guessing your question is how to make that stop getting reset? | 19:13 |
qwebirc56669 | yes :) | 19:13 |
qwebirc56669 | or at least what does clicking enabled do | 19:13 |
tgm4883 | qwebirc56669, basically, it runs this | 19:14 |
tgm4883 | sed -i -e 's/^#bind/bind/' /etc/mysql/conf.d/mythtv.cnf | 19:14 |
tgm4883 | technically, thats from the postinst of mythtv-commong | 19:15 |
qwebirc56669 | that pastebin was from mythbuntu-setup? | 19:15 |
tgm4883 | so what it probably does is, checks that file exists, runs that command, then restarts mysql | 19:15 |
tgm4883 | qwebirc56669, no, it was from mythtv-database | 19:15 |
tgm4883 | https://github.com/MythTV/packaging/blob/master/deb/debian/mythtv-database.postinst | 19:15 |
qwebirc56669 | oh | 19:15 |
qwebirc56669 | so maybe it's a permission problem on mythtv.cnf maybe? | 19:16 |
tgm4883 | qwebirc56669, does it work after you do it? | 19:16 |
tgm4883 | shouldn't be a permission issue, it's run as root | 19:16 |
tgm4883 | (the command that is) | 19:16 |
qwebirc56669 | basically every time I update myth I have to go into mythbuntu-setup and click enable under mysql...then it works | 19:17 |
tgm4883 | yea, not a permission isus | 19:17 |
tgm4883 | qwebirc56669, can you file a bug on that | 19:18 |
qwebirc56669 | sure....don't think I've done that before...what should I include? | 19:18 |
tgm4883 | qwebirc56669, for this issue, just explain what is happening and the version you are on | 19:18 |
tgm4883 | !bugs | 19:18 |
qwebirc56669 | my mythtv.cnf only has bind-address=0.0.0.0 and max_connections=100 in it | 19:19 |
tgm4883 | report it here https://bugs.launchpad.net/mythbuntu | 19:19 |
tgm4883 | qwebirc56669, yep | 19:19 |
tgm4883 | when it gets reset, bind-address=127.0.0.1 | 19:19 |
qwebirc56669 | ah...now I understand | 19:19 |
tgm4883 | when it works externally, bind-address=0.0.0.0 | 19:19 |
tgm4883 | qwebirc56669, so also, include a copy of mythtv.cnf when it's working, and also when it doesn't work | 19:20 |
qwebirc56669 | ok | 19:20 |
tgm4883 | qwebirc56669, oh, also, the output of 'ifconfig' | 19:21 |
qwebirc56669 | ok | 19:21 |
tgm4883 | qwebirc56669, sorry, looking though this I keep seeing more info | 19:21 |
tgm4883 | qwebirc56669, post the link to the bug report here when you've submitted it and I'll take a quick look | 19:23 |
qwebirc56669 | np...gotta figure out my launchpad login any ways | 19:23 |
qwebirc56042 | webchat kicked me out...here's the link to the bug report | 19:34 |
qwebirc56042 | https://bugs.launchpad.net/mythbuntu/+bug/1159992 | 19:34 |
tgm4883 | qwebirc56042, after the update, are you sure it's bind-address=127.0.0.1 and not #bind-address=0.0.0.0 ? | 19:54 |
qwebirc56042 | no I'm not....I didn't know what was being changed....I just copied what you said for completeness | 19:55 |
tgm4883 | ah | 19:55 |
tgm4883 | yea we'll need to see what it actually is then | 19:55 |
qwebirc56042 | I can see if I've got another server with the problem and try an update | 19:56 |
tgm4883 | that would explain why I can't see where that value was coming from :) | 19:56 |
tgm4883 | ok | 19:56 |
tgm4883 | that would be great | 19:56 |
qwebirc56042 | tgm4883, you were right...it's #bind-address=0.0.0.0 | 20:01 |
tgm4883 | cool | 20:02 |
tgm4883 | now to just figure out why it's doing that | 20:02 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!