/srv/irclogs.ubuntu.com/2013/07/07/#ubuntu-mythtv.txt

homebrewciderhi, okay, what am I NOT getting? On my Mythbuntu box, I'd like to be  able to record movies into a folder called "Movies", say, Seinfeld into a folder called "Seinfeld". How do I do this please. I keep going round in circles. I'm not thinking straight, I'll screw it up. Do I make new folder in the recordings folder? Do I make a new recording profile? PLease help01:02
kkekI posted a question in mythtv-users, but I'll ask here as well (no answer there).  I'm using Mythbuntu 12.04 (mythtv 0.25, configured to use mythwelcome).  I'm having problems setting up my ACPI auto wake in mythtv.   I've tested (by manually setting /sys/classes/rtc/rtc0/wakealarm) that my computer can wake when the RTC alarm is set (which works), but I can't seem to be able to get mythtv to properly set it.17:10
kkekIn mythtv's backend setup, I've got the set wakeup time, shutdown, and pre-shutdown commands set to "mythshutdown --setwakeup $time", "mythshutdown --shutdown", and "mythshutdown --check".17:10
kkekMythwelcome's commands are my custom /usr/bin/setwakeup.sh, and shutdown -h.  I added some logging to my /usr/bin/setwakeup.sh, and it never seems to get called (although my machine does shut down when mythwelcome is not locked).  /var/log/auth.log also doesn't indicate any permissions errors with my sudo settings.  If I call my /usr/bin/setwakeup.sh by hand, and then shutdown the computer, it does auto-power back on... any idea17:11
Jay2k1did you call it as user mythtv?17:12
kkekI didn't try that (Let me power on my machine and I will), but what I didn't methion is that I have sudo in front of all the commands in mythwelcome (sorry -- re-typing on a different machine).  I have sudo configured for nopasswd on those programs (and /var/log/auth.log doesn't show any sudo attempt to call /usr/bin/setwakeup.sh)17:14
Jay2k1hmm, i'll see what i have configured, gimme a moment17:15
kkek"sudo /usr/bin/setwakeup.sh" (run as mythtv user) does in fact set the time, without prompting for a password17:19
Jay2k1hmm ok...17:21
Jay2k1i directly call nvram-wakeup17:21
kkekIts a little unclear to me exactly what the relationship between mythwelcome and mythshutdown is.  Near as I can tell mythshutdown --setwakeup $time does not call the script to set the alarm, but instead just populates a database entry for what time the system should be woken.  I believe mythshutdown --shutdown is then supposed to call setwakeup.sh if the database is populated prior to actually calling the shutdown tcommand.17:21
Jay2k1i'm not sure17:23
Jay2k1i think (but don't know) that mythshutdown --setwakeup indeed just writes a db entry and mythshutdown --shutdown *writes the set wakeup time to nvram*.17:24
Jay2k1and i believe the command you enter in mythbackend setup has nothing to do with what mythshutdown does, except you set mythshutdown as command there17:24
Jay2k1my config is as follows17:24
Jay2k1command to set wakeup time: sudo /usr/sbin/nvram-wakeup -A -s $time -C /etc/nvram-wakeup.conf -w 017:25
Jay2k1shutdown command: sudo grub-set-default PowerOff && sudo /sbin/reboot17:25
Jay2k1and as shutdown check i call a script which not only asks mythshutdown if it is safe to shutdown but also looks for ssh sessions17:26
kkeksounds similar to my setup... let me double-check my settings for the backend  -- its almost as if mythshutdown --shutdown is not getting called (and shutdown -h now is)17:27
Jay2k1i never manually shutdown the box, i either exit mythfrontend (which brings me to mythwelcome) and the backend then times out at some point, executing the shutdown check, set wakeup time and shutdown commands configured in backend setup17:27
Jay2k1OR i leave mythfrontend running which goes in some kind of standby mode after a certain of inactivity, also resulting in the same steps17:28
kkekrelevent database settings posted here http://pastebin.ubuntu.com/5853194/17:36
kkekand after calling "mythshutdown -t" by hand,  | MythShutdownNextScheduled   | 2013-07-07T19:58:00         | NULL     | gets set17:37
=== kkek_ is now known as kkek
kkekinteresting... after calling "mythshutdown -t" and "sudo mythshutdown --shutdown" by hand, it does correctlyset the wake time17:47
kkekso it appears mythshutdown is properly configured, and the problem lies in my mythwelcome / mythbackend setup17:48
Jay2k1that sounds weird17:48
=== tgm4883_ is now known as tgm4883
kkeksolved in mythtv-users... appears to be a timezone issue between the various timestamps passed from the backend to mythshutdown to the database to my script... I dropped mythwelcome from the set wakeup time command (and just called my wakeup script directly), and only use mythwelcome/mythshutdown for shutdown management (locking out shutdown on idle)19:07
qwebirc67585hello, I just installed mythbuntu, i ran all of the updates. when i try to start mythbackend it says cannot connect to database. i have not changed any settings. what am i doing wrong?thanks19:29
kkekif you want to see if the database is up and running properly, you can try to attach to it from the command line (be very careful not to change anything directly in the database doing this), with the following command:       mysql --user=mythtv --password=<password> -D mythconverg        look in /etc/mythtv/mysql.txt for the password, and enter it without the "<>" characters19:32
kkekif you can connect, then mysql is at least running19:33
kkekalso, when you say start the backend, are you talking the master backend, or is this a slave backend?19:35
qwebirc67585it is a master backend, i will run command now19:37
kkekif you get a mysql prompt, you can use "show tables;" to make sure the database was correctly set up... you should see the following tables (or at least a large subset of them):  http://pastebin.ubuntu.com/5853517/19:41
qwebirc67585i get unknown option '--user-mythtv'19:44
kkekshould be an = between --user and mythtv19:46
kkek(and between --password and your password)19:46
qwebirc67585when i type show tables it simply moves to the next line, nothing appears19:47
kkekin that case it looks like your database was never set up properly during the install19:47
kkekyou can try running mythtv-setup and see if that poppulates the database19:47
kkek(that should guide you through configuring the backend)19:48
qwebirc67585ERROR 1064 (42000) You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near 'show tables' at line 219:49
qwebirc67585that is the error i get. i have ran through the setup. what part is setting up the database?19:49
tgm4883kkek, qwebirc67585 you need 'show tables;'19:51
kkekqwebirc67585: I thought you said nothing appears on "show tables;"  what were you running that gave that error.19:52
qwebirc67585nothing ran on "show tables" i get that error on "show tables;"19:53
tgm4883qwebirc67585, try it again19:54
tgm4883kkek, I'm pretty sure mysql thinks he typed 'show tables\nshow tables;'19:54
qwebirc67585i come up woth same error, but it says line one this time19:54
tgm4883weird19:54
kkekwhat version of mythbuntu are you running19:55
qwebirc6758512.0419:55
qwebirc67585i have tried installing it twice,and have the same issues both times. would a issue in the capture card be an issue?19:55
kkekinteresting... same version I am, and the version of mysql installed definitely supports "show tables;"19:55
tgm4883qwebirc67585, IMHO, it sounds like your doing/did something wrong19:56
tgm4883qwebirc67585, you're on the master backend?19:57
kkekqwebirc67585: also, have you run mythtv-setup?19:57
qwebirc67585yes this is a master backend,i chose to install front end also though. i do not have a capture card or video source set up though.19:57
tgm4883that shouldn't matter19:58
qwebirc67585yes i have ran through it. although i did not change any settings19:59
tgm4883qwebirc67585, what if you do 'status;'19:59
qwebirc67585that does come up with some info. however i am talking on a different pc from the mythbuntu setup.what info would you like to know?20:00
tgm4883qwebirc67585, are you on a linux pc?20:01
qwebirc67585i am running windows with the computer i am talking to you on. I just ran 'sudo mythbackend' and it stopped with20:02
qwebirc67585mediaserver; ;HttpServer Create error20:02
tgm4883I'm not sure why you would ever run 'sudo mythbackend'. Don't do that20:03
qwebirc67585Failed listening on TCP 127.0.0.1:6543 - error 8: the bound address is already in use20:03
tgm4883qwebirc67585, do this. 'sudo service mythtv-backend stop'  then 'sudo service mysql restart' then 'sudo service mysql status'20:03
qwebirc67585ERROR 1045 928000): Access denied for user 'root'@'localhost' using password: NO)20:05
qwebirc67585sudo service mysql restart ran fine20:06
tgm4883where/when did you get that error?20:07
qwebirc67585scratch that, after 'sudo service mysql status' mysql start/running, process 349720:08
tgm4883qwebirc67585, ok20:09
tgm4883qwebirc67585, so now do this 'sudo service mythtv-backend start' and then 'sudo service mythtv-backend status'20:10
qwebirc67585mythtv-backend start/running, process 384820:11
tgm4883qwebirc67585, ok, mythbackend is running20:11
tgm4883qwebirc67585, eg. don't try to start mythbackend improperly next time ;)20:11
qwebirc67585how to i connect with a frontend?20:12
tgm4883qwebirc67585, is it on the same machine?20:13
qwebirc67585no20:13
tgm4883qwebirc67585, did you already go though mythtv-setup?20:13
qwebirc67585yes20:14
tgm4883qwebirc67585, what IP address did you use when you went though mythtv-setup?20:14
qwebirc67585127.0.0.1.20:14
tgm4883you need to use your private IP address, not your loopback. Which probably means you also need to fire up mythbuntu-control-centre and enable the mythtv service so it's not just listening on the loopback20:15
qwebirc67585i do not see a mythtv service. only ssh samba nfs and vnc. i chose to install mythtv service during install20:17
tgm4883qwebirc67585, it's on the mysql tab20:18
tgm4883qwebirc67585, actually, it's been renamed since the last time I looked at it20:19
qwebirc67585yes, i do not see it20:19
tgm4883qwebirc67585, you've got to enable the master backend role on the mysql tab20:19
qwebirc67585it is enabled20:19
tgm4883good20:19
tgm4883does your master backend have a static IP or DHCP?20:20
qwebirc67585the loopback adress is still set though. do i need to change it to my lan? it is static20:20
tgm4883qwebirc67585, yes, you need to set it to your private LAN IP address. Then you need to restart the backend 'sudo service mythtv-backend restart'20:20
tgm4883then fire up the frontend, put in the right credentials and IPs and you should be fine20:21
qwebirc67585it says it cannot connect to backend20:22
tgm4883is the frontend you are trying to connect from running linux?20:23
qwebirc67585i have successfully connected. thank you for all your help. one more question that you might be able to answer, can i set up a 'away profile' on my mobile phone using the static ip adress? using port forwards to connect to my backend when i am not on my homenetwork20:24
tgm4883qwebirc67585, are you using the android app?20:25
qwebirc67585yes20:26
tgm4883qwebirc67585, ok, you'll want to do SSH forwarding (not just opening the ports for mythweb and/or mythtv. That is a BAD idea). Take a look at https://github.com/MythTV-Clients/MythTV-Android-Frontend   It talks precisely about that in the section "Connecting to Mythtv Backend via SSH"20:27
qwebirc67585i am not looking to set it up now. but i will be later. is this spot a good spot to ask the question at a later time? also i have two routers. one that is from my ISP and another that does my wireless siganl20:27
tgm4883yea this is a good spot.20:28
tgm4883two routers could complicate things, but as long as you can forward the ports correctly you should be fine20:28
qwebirc67585ok thanks a lot i really appreciate it. my simple mistakes haha i have used linux forever but never had become over confident with it. i have read guides about port forwarding through double routers but i will worry about that at a later time. thanks again20:29

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!