[16:12] <kenni> FYI, in case you haven't noticed, it seems like mythmusic from the autobuilds is broken (http://svn.mythtv.org/trac/ticket/9186)
[16:12] <Zinn> [svn.mythtv.org] #9186 (MythMusic Plugin Missing in Frontend) â MythTV
[16:13] <kenni> :)
[18:46] <c-square> hi all, I have installed the latest mythbuntu, but when selecting directory as sort in mythmusic I am still unable to browse my directories
[18:47] <c-square> I have already cleaned the database and rescanned my whole music folder
[18:50] <c-square> okay strangely enough it seems to work now? :s :s
[20:18] <stevieman> I'm having a proble getting my remote workingwith sdlmame and I'm wondering if I am in the right place for help
[23:24] <castlec> is anyone available that can talk me through getting my myth/mysql setup correct?  I've been trying to get a second front-end working and started with no upnp on it.  Now I've hosed my local frontend
[23:25] <Chiwauwa> I've upgraded from Ubuntu (Mythbuntu) 10.04 to 10.10 - work perfect except for the fact that autostart of mythfronend doesn't work anymore. MCC can not correct it ... disable/apply/enable. Editing custom.conf and .gnomerc doesn't work either. Any suggestions?
[23:26] <Chiwauwa> castlec, do you have the primary frontend working with the backend?
[23:26] <castlec> not anymore.  I edited mysql.txt to change localhost to my ip and it decided it didn't want to work anymore even after changing it back
[23:26] <Chiwauwa> castlec, are they running on the same machine (backend/primary frontend)
[23:27] <castlec> yes, backend and primary frontend are on the same machine. i was attempting to add another frontend
[23:27] <mrand> castlec: Check the .xml file and make sure it matches your mysql.txt file.  mysql.txt is slowly being done away with.
[23:28] <castlec> slowly.... ick :)
[23:28] <castlec> which config? each user has one correct?
[23:29] <mrand> each user could have one, so each user that is launching a front end should match. .  And then /etc/mythtv has one as well I believe
[23:30] <castlec> so what is mysql.txt still used for?
[23:30] <mrand> mysql.txt is the old way.  It is the fallback if config.xml isn't present.
[23:31] <castlec> so, in actuality, I could delete it?
[23:32] <mrand> castlec: I thought I understood that is not present on new installs (if done with 10.04 or 10.10)
[23:33] <castlec> i upgraded from 9.04 so maybe it's a remnant
[23:33] <castlec> no dice on the config.xml update. It says unable to login
[23:35] <mrand> castlec: so you're saying that your config.xml has the correct IP, username, and password?
[23:35] <castlec> i believe so, yes
[23:35] <castlec> try to log in to mysql with it?
[23:39] <mrand> sure.  that'd be easy enough and would prove that out
[23:39] <castlec> getting access denied messages
[23:40] <castlec> successful to localhost rather than ip
[23:40] <mrand> your remote frontend works?
[23:40] <castlec> negative
[23:41] <castlec> since i started messing with it, I now have no frontends working
[23:43] <castlec> so again, locally, I can get into mysql -u mythtv -h localhost -p password
[23:44] <castlec> but not with -h ipaddress
[23:44] <castlec> my.cnf, bind-address            = 192.168.1.2
[23:45] <mrand> I was just about to ask about that
[23:45] <mrand> http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 (Modifying access to the MySQL database for multiple systems )
[23:45] <Zinn> [www.mythtv.org] MythTV, Open Source DVR
[23:46] <castlec> that's where I started and got myself into this mess :)
[23:46] <mrand> so you've done the grant all
[23:46] <castlec> question, what is the /etc/mysql/conf.d/mythtv.cnf for?
[23:46] <castlec> [mysqld]
[23:46] <castlec> bind-address=0.0.0.0
[23:47] <castlec> i did do the grant all, yes
[23:48] <castlec> my guess is that the mythtv.cnf is overwriting my already set bind-address
[23:48] <mrand> http://www.gossamer-threads.com/lists/mythtv/users/316686 mentions the two .cnf files
[23:48] <Zinn> [www.gossamer-threads.com] Remote frontend not working - Mythbuntu Control Centre option greyed out? | MythTV | Users
[23:48] <mrand> I think you may be onto something there
[23:49] <castlec> does a mysql restart require a backend restart?
[23:50] <castlec> still the same behavior
[23:51] <mrand> I assume that data corruption could occur if the backend is in the middle of writing something to the database, so my understanding is yes.
[23:51] <mrand> but only for that reason
[23:52] <castlec> i'll try the grant all again just to make sure
[23:52] <castlec> is there a way to check the address it is bound to?
[23:52] <mrand> sorry, we've about exhausted all of the mysql knowledge i have... I'll have to suggest you ask in #mythtv
[23:52] <mrand> errr
[23:52] <mrand> #mythtv-users
[23:52] <mrand> NOT #mythtv :-)
[23:53] <mrand> having said that, I am positive that others have encountered what you are, and have solved it, so it should be on the mythtv-users mailing list or forums.
[23:57] <castlec> accidentally restarted :)
[23:59] <castlec> still same behavior.  I can't access mysql with ip address