| === _Jay2k1 is now known as Jay2k1 | ||
| === McGuyver_ is now known as McGuyver | ||
| 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? | 18:56 |
| jarnos | I am trying to start complete mythbuntu 14.04 box without internet connection. https://bugs.launchpad.net/mythbuntu/+bug/1038508 | 19:17 |
| tgm4883 | Yippee38: is mysql running on your backend? | 19:47 |
| tgm4883 | jarnos: can you pastebin your /etc/init/mythtv-backend.conf file? | 19:50 |
| Kwisher_wrk | Yippee38: there's a config.xml file in several places that needs to have the myth user info changed to match | 19:52 |
| Kwisher_wrk | start in your /home/.mythtv | 19:53 |
| Kwisher_wrk | write down the db name, username & password and enter it into the b/e setup | 19:55 |
| 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:58 |
| Kwisher_wrk | i'd start with the one in /home/mythtv/.mythtv/config.xml | 19:59 |
| jarnos | tgm4883, yes http://paste.ubuntu.com/9371929/ | 20:08 |
| tgm4883 | jarnos: ok, that looks good. So it's not starting at all without the network? | 20:09 |
| 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:12 |
| 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:13 |
| 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:16 |
| 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:17 |
| jarnos | tgm4883, I don't know about mysql IP, but backend seems to be 192.168.100.22 | 20:18 |
| tgm4883 | jarnos: and this box doesn't have any network connection? | 20:19 |
| 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:20 |
| 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:22 |
| 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:23 |
| tgm4883 | jarnos: essentially, that is the same thing | 20:24 |
| tgm4883 | Yippee38: what about this | 20:24 |
| 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:25 |
| 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:27 |
| 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:28 |
| Yippee38 | No | 20:29 |
| jarnos | tgm4883, What should I put to the IPv6 address field? | 20:29 |
| tgm4883 | jarnos: there is nothing in the installation/upgrade scripts that would change that IP | 20:30 |
| 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:31 |
| 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:32 |
| 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:33 |
| tgm4883 | jarnos: no | 20:34 |
| 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:35 |
| Yippee38 | tgm4883: The only thing in there is "bind-address=0.0.0.0" IIRC, that should be commented out, shouldn't it? | 20:36 |
| tgm4883 | Yippee38: 0.0.0.0 should be all ipv4 addresses, but IDK if that includes 127.0.0.1 | 20:37 |
| tgm4883 | Yippee38: check /etc/mysql/my.cnf for bind-address to | 20:38 |
| Yippee38 | tgm4883: That bind address is set to 127.0.0.1 | 20:40 |
| 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:41 |
| 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:45 |
| 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:52 |
| Yippee38 | tgm4883: So I need to have it listening on the specific IP of the backend then, as you suggested above? | 20:53 |
| tgm4883 | yes. You'll need to change the bind address back too | 20:54 |
| 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:55 |
| 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:58 |
| tgm4883 | jarnos: ah yes, that would be true, mythweb would still work | 20:59 |
| jarnos | tgm4883, but would it work outside the local network? | 21:01 |
| 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:03 |
| 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:10 |
| 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:14 |
| 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:16 |
| tgm4883 | Yippee38: stop teh backend "sudo service mythtv-backend stop" verify it's not running "ps aux | grep backend" | 21:17 |
| Yippee38 | tgm4883: Yeah. I just figured out that the backend was already running. DOH! | 21:19 |
| Yippee38 | tgm4883: Checking frontend | 21:19 |
| 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:21 |
| 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!! | 21:38 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!