[00:07] <qwebirc66352> Sigh... nevermind, 6 hours of digging into the software... broken new ethernet patch cable
[00:57] <qwebirc52953> I'm about to go postal... I need serious help here.
[00:58] <qwebirc52953> anyone there?
[01:08] <qwebirc52953> not sure I can hang out for an hour...
[01:09] <qwebirc52953> I have multiple questions, but right now I'm trying to figure out why my XBMC client (cmyth) won't connect to my myth backend. I think it's the mysql password or maybe I haven't properly enabled external access to mysql
[01:15] <qwebirc52953> afk
[01:32] <qwebirc52953> hello?
[01:41] <SmallwoodDR82> can you login to the db through command line?
[01:42] <qwebirc52953> well, I used to be able to...
[01:43] <qwebirc52953> I've been fiddling with things that i found on the web while waiting for help here, and I've probably screwed it up
[01:43] <qwebirc52953> I can't start mysql now
[01:43] <qwebirc52953> I'm trying to undo what I did
[01:44] <qwebirc52953> damn.. not working
[01:44] <Zinn> qwebirc52953: Please watch your language.
[01:46] <qwebirc52953> are you still there?
[01:49] <SmallwoodDR82> you need to get your sql db fixed before even attempting to get xbmc to connect
[01:49] <qwebirc52953> ok, I'm back in business
[01:49] <qwebirc52953> had to restart the box, but I can now log in with the generated password in the config.xml file
[01:50] <qwebirc52953> I can watch TV with the local frontend client
[01:50] <SmallwoodDR82> ok now use those credentials on xbmc
[01:50] <qwebirc52953> I've done that, and it's failed... let me go check again to be certain nothing has changed, but I was at this point an hour ago
[01:50] <qwebirc52953> brb
[01:51] <qwebirc52953> no joy. it says "no PVR clients have started yet", but I've enabled the cymth and configured it. I've also enabled Live TV in Settings.
[01:51] <qwebirc52953> the adb logs say it can't connect
[01:52] <SmallwoodDR82> can you try command line from your XBMC box?
[01:52] <SmallwoodDR82> to your sql db
[01:52] <qwebirc52953> no... it's an Amazon Fire TV with XBMC app sideloaded - but it's not rooted
[01:52] <qwebirc52953> I can get to adb logs, but that's it
[01:53] <qwebirc52953> I can try from a terminal on my Mac, though
[01:53] <qwebirc52953> how would I do that?
[01:53] <SmallwoodDR82> i just use sequel pro on my mac
[01:53] <qwebirc52953> is that free?
[01:54] <SmallwoodDR82> http://www.sequelpro.com/
[01:54] <SmallwoodDR82> yes
[01:54] <qwebirc52953> isn't there some way I could just do this from a bash prompt?
[01:54] <qwebirc52953> ok, let me DL
[01:56] <qwebirc52953> says connection failed
[01:56] <qwebirc52953> do I need the DB name?
[01:56] <qwebirc52953> or the "Name" field?
[01:56] <qwebirc52953> I filled in the host, username (mythtv) and password (string in the config.xml)
[01:57] <qwebirc52953> and changed port to 6543
[01:57] <SmallwoodDR82> when you setup mythtv did you use 127.0.0.1? or the IP of the box?
[01:58] <qwebirc52953> IP of the box. Statically assigned by my router.
[01:58] <qwebirc52953> 192.168.1.120
[01:58] <qwebirc52953> crap, nevermind... had the wrong IP
[01:59] <qwebirc52953> I'm logged in now from sequelpro
[01:59] <qwebirc52953> let me make sure I didn't screw up the IP on xbmc.... brb
[01:59] <SmallwoodDR82> ok verify your xbmc config with IP
[02:01] <qwebirc52953> O...M...G...    somehow xbmc took the value "1192.168.1.198"..... note the extra "1"
[02:01] <SmallwoodDR82> :)
[02:01] <qwebirc52953> so, since I have a live human here...
[02:02] <qwebirc52953> as I was trying to debug this for hours, I found notes on the web about having to enable remote access to mysql
[02:02] <qwebirc52953> is this true?
[02:02] <qwebirc52953> the first thing I saw said to do this from mythbuntu control centre
[02:02] <SmallwoodDR82> correct
[02:03] <qwebirc52953> I selected "enable" on the mysql option for "master backend role"
[02:03] <qwebirc52953> then I saw lots of other stuff about modifying the my.cnf file for mysql, which is what I was trying to do when you found me
[02:03] <qwebirc52953> was any of that necessary??
[02:03] <SmallwoodDR82> i never "modified" any files with my setup
[02:04] <SmallwoodDR82> all done through GUI/myth setup
[02:04] <qwebirc52953> ok
[02:04] <SmallwoodDR82> i'm running xbmc as well
[02:04] <qwebirc52953> finally, is there a SIMPLE way to modify the myaql password? I don't like the generated one in the config file
[02:04] <SmallwoodDR82> not on FireTV but still...
[02:05] <SmallwoodDR82> there is a file you can change...
[02:05] <qwebirc52953> right, the config.xml file
[02:05] <qwebirc52953> that's it? just change the file and restart?
[02:05] <SmallwoodDR82> i feel like this is another step...let me see if I can find it
[02:05] <qwebirc52953> I saw all sorts of other posts about changing this password via mysql commands, and it was ugly
[02:06] <qwebirc52953> ok, great - thanks
[02:06] <SmallwoodDR82> .27?
[02:06] <qwebirc52953> ?
[02:06] <qwebirc52953> oh, yes
[02:06] <SmallwoodDR82> k
[02:10] <qwebirc52953> any luck?
[02:11] <qwebirc52953> I've got it working now.... so at this point, I'm going to go play with it a bit. If you find any info, please just post it here. I'll be in and out.
[02:11] <SmallwoodDR82> I'll post if I find it...
[02:11] <qwebirc52953> thank you so much for helping, even though it was just pilot error... I have a feeling I've been chasing all sorts of things in vain
[02:11] <SmallwoodDR82> some reason I can't find the post I'm looking for
[02:11] <SmallwoodDR82> no problem...happy to sorta assist :)
[02:12] <qwebirc52953> It took me a long while to figure out that the password wasn't "mythtv"
[02:12] <qwebirc52953> that's one of the big things I figured out tonight
[02:12] <qwebirc52953> I just hate the one it chose... I'm fine with "mythtv", if I can figure out how to change it
[02:13] <qwebirc52953> so  - thanks again, and thanks in advance if you find the post with the info
[02:37] <jac1d> Weird issue, remote works at command line with irw confirming correct keypresses, but nothing seems to make it in to the mythtv frontend process.  What is required to connect the two?  14.04 with an MCE remote on a CommandIR USB receiver