[18:56] <Yippee38> I'm having trouble with mysql after an upgrade to mythbuntu.  My frontend can't find the files for any of my recordings or videos.  When I try to run mythbackend on the backend, I get "Cannot login to database", then "Would you like to configure the database connection now?".  It answers No on its own.  Finally, I get "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'"  I do not have that sock file
[18:56] <Yippee38>  on my system.  I'm completely confused and have no idea how to get this working correctly.  Can anybody help?
[19:17] <jarnos> I am trying to start complete mythbuntu 14.04 box without internet connection.  https://bugs.launchpad.net/mythbuntu/+bug/1038508
[19:47] <tgm4883> Yippee38: is mysql running on your backend?
[19:50] <tgm4883> jarnos: can you pastebin your /etc/init/mythtv-backend.conf file?
[19:52] <Kwisher_wrk> Yippee38: there's a config.xml file in several places that needs to have the myth user info changed to match
[19:53] <Kwisher_wrk> start in your /home/.mythtv
[19:55] <Kwisher_wrk> write down the db name, username & password and enter it into the b/e setup
[19:58] <Kwisher_wrk> i think there a 3 copies of that config.xml file, can't remember which one to edit first as one is symlinked to the others
[19:59] <Kwisher_wrk> i'd start with the one in /home/mythtv/.mythtv/config.xml
[20:08] <jarnos> tgm4883, yes http://paste.ubuntu.com/9371929/
[20:09] <tgm4883> jarnos: ok, that looks good. So it's not starting at all without the network?
[20:12] <jarnos> tgm4883, it just complains in the frontend that it can not connect to the backend and thus playback etc. does not work. I don't know, if scheduled recordings work. I guess not.
[20:13] <tgm4883> jarnos: in mythtv-setup, what did you set the master backend IP and mysql IP to?
[20:13] <jarnos> tgm4883, let me check
[20:16] <Yippee38> I have no idea if mysql is running on my backend.  I tried running "mysqladmin -u root -p status" and got...connect to server at 'localhost' failed, then got the socket error again.
[20:17] <Yippee38> My user ID and pwd for mysql (mythtv for both) is set in the backend and I verified it in the config.xml files.  I'm pretty sure the problem isn't with mythtv, but with mysql
[20:17] <tgm4883> Yippee38: try 'sudo service mysql status'
[20:18] <jarnos> tgm4883, I don't know about mysql IP, but backend seems to be 192.168.100.22
[20:19] <tgm4883> jarnos: and this box doesn't have any network connection?
[20:20] <jarnos> tgm4883, well now it has; I am writing this on the box, but sometimes I may want to start the box without internet connection just to watch or record video.
[20:20] <tgm4883> jarnos: ok. out of curiosity, how do you expect it to find 192.168.100.22 if there isn't any network connection?
[20:22] <jarnos> tgm4883, I don't expect. I may have had some other value for it, but maybe update has changed it?!
[20:22] <Yippee38> Yes.  MySQL is running
[20:22] <tgm4883> jarnos: no, an update did not change it
[20:22] <jarnos> tgm4883, I just can not remember.
[20:22] <tgm4883> jarnos: you'll want to use 127.0.0.1
[20:23] <tgm4883> Yippee38: ok, can you connect to mysql if you use 'mysql -u mythtv -pmythtv mythconverg'
[20:23] <Yippee38> Nope.  I get:  Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
[20:23] <jarnos> tgm4883, why not 127.0.1.1?
[20:24] <tgm4883> jarnos: essentially, that is the same thing
[20:24] <tgm4883> Yippee38: what about this
[20:25] <tgm4883> Yippee38: ok, can you connect to mysql if you use 'mysql -u mythtv -pmythtv -hlocalhost mythconverg'
[20:25] <tgm4883> Yippee38: or you can also try replacing localhost with your ip address
[20:27] <jarnos> tgm4883, I guess I changed the address to be either of them some time, and it worked then, but I have no idea what changed it back to 192...
[20:27] <Yippee38> If I replace localhost with my ip address, I can get into mysql
[20:27] <Yippee38> localhost gives me the same socket error
[20:28] <tgm4883> Yippee38: ok, so it's not listening on localhost. That's fine, unless you want to run without a network connection. Do you?
[20:29] <Yippee38> No
[20:29] <jarnos> tgm4883, What should I put to the IPv6 address field?
[20:30] <tgm4883> jarnos: there is nothing in the installation/upgrade scripts that would change that IP
[20:31] <tgm4883> Yippee38: then run mythtv-setup and set those to your IP address, then run mythfrontend and do the same when it asks for the location
[20:31] <tgm4883> jarnos: IIRC, "::1" means listen on all
[20:32] <Yippee38> tgm4883:  If I use the ip address, will that cause problems if say I am rebooting my router and mythtv wants to do something (record a show, playback a recording, etc)?
[20:33] <tgm4883> Yippee38: potentially
[20:33] <Yippee38> tgm4883:  Is there a way I can get it to listen on localhost again?  It used to.
[20:33] <jarnos> tgm4883, ok, If I change these values, can I still use another frontend, if I turn on network modem and restart the backend?
[20:34] <tgm4883> jarnos: no
[20:35] <tgm4883> Yippee38: look in /etc/mysql/conf.d/mythtv.cnf and see what bind-address is set to
[20:35] <jarnos> tgm4883, can I then playback the content on another machine via network by other means?
[20:35] <tgm4883> you could share the recordings directory, but the filenames would be meaningless to you
[20:36] <Yippee38> tgm4883:  The only thing in there is "bind-address=0.0.0.0"  IIRC, that should be commented out, shouldn't it?
[20:37] <tgm4883> Yippee38: 0.0.0.0 should be all ipv4 addresses, but IDK if that includes 127.0.0.1
[20:38] <tgm4883> Yippee38: check /etc/mysql/my.cnf for bind-address to
[20:40] <Yippee38> tgm4883:  That bind address is set to 127.0.0.1
[20:41] <tgm4883> Yippee38: sounds like the one in mythtv.cnf is overriding it. Try commenting it out and restarting mysql
[20:41] <tgm4883> (commenting out the one in mythtv.cnf)
[20:41] <Yippee38> tgm4883:  I'm almost positive that everything I've read says to comment out the bind-address line in my.cnf
[20:41] <Yippee38> tgm4883:  Ok.
[20:45] <Yippee38> tgm4883:  Commenting out the one in mythtv.cnf allows me to run the first command to start mysql that you gave me.  Going to check frontend
[20:52] <Yippee38> tgm4883:  That's not working.  The backend starts fine, but the frontend can't connect to it.  I keep getting a "no address defined for 'localhost'" even though, in the frontend setup, I have it set to the IP of the backend, NOT localhost
[20:52] <tgm4883> Yippee38: you can't have the backend work on localhost if you have a separate frontend. Sorry, I didn't realize you had the frontend on a separate system
[20:53] <Yippee38> tgm4883:  So I need to have it listening on the specific IP of the backend then, as you suggested above?
[20:54] <tgm4883> yes. You'll need to change the bind address back too
[20:55] <Yippee38> tgm4883:  Just so I understand, I need MySQL listening on my ip address, right?  That's what we're talking about?
[20:55] <tgm4883> Yippee38: everything will need to be
[20:58] <jarnos> tgm4883, I did the IP changes and still am able to view the recordings in another machine in the local network using Mythweb.
[20:59] <tgm4883> jarnos: ah yes, that would be true, mythweb would still work
[21:01] <jarnos> tgm4883, but would it work outside the local network?
[21:03] <tgm4883> jarnos: technically yes, but I wouldn't make mythweb accessible to the internet. The usual way of doing that is to use an SSH tunnel
[21:10] <Yippee38> tgm4883:  Ok.  I changed the bind-address in both the /etc/mysql/my.cnf file and the /etc/mysql/conf.d/mythtv.cnf file to my ip address.  When I run mythbackend It still fails listening on 127.0.0.1 and exits
[21:10] <tgm4883> Yippee38: you cant use 127.0.0.1 and the local ip. you have to pick one or the other
[21:14] <Yippee38> tgm4883:  I'm not.  I set both of them to the local IP.  I don't know why mythbackend is still trying to access 127.0.0.1.  It says, "Listening on TCP 127.0.0.1:6544", then "Listening on TCP 10.6.2.51:6544".  The error though, says, "Failed listening on TCP 127.0.0.1:6543 - Error 8:  The bound address is already in use"
[21:16] <Yippee38> tgm4883:  I just checked in mytht-setup.  The local backend and the master backend are both set to the local IP address, NOT localhost or 127.0.0.1
[21:17] <tgm4883> Yippee38: stop teh backend "sudo service mythtv-backend stop" verify it's not running "ps aux | grep backend"
[21:19] <Yippee38> tgm4883:  Yeah.  I just figured out that the backend was already running.  DOH!
[21:19] <Yippee38> tgm4883:  Checking frontend
[21:21] <Yippee38> tgm4883:  Ok.  I commented out the bind-address in both of those files.  When I ran mythbackend (when it wasn't already running), it started normally, and the frontend is working fine.
[21:21] <Yippee38> The file not found error is gone.
[21:38] <Yippee38> tgm4883:  I was having a problem with the root privileges of MySQL, but I fixed it!
[21:38] <tgm4883> cool
[21:38] <Yippee38> tgm4883:  Thank you very much! for helping me get this fixed!!