[01:02] <homebrewcider> hi, 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 help
[17:10] <kkek> I 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] <kkek> In 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:11] <kkek> Mythwelcome'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 idea
[17:12] <Jay2k1> did you call it as user mythtv?
[17:14] <kkek> I 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:15] <Jay2k1> hmm, i'll see what i have configured, gimme a moment
[17:19] <kkek> "sudo /usr/bin/setwakeup.sh" (run as mythtv user) does in fact set the time, without prompting for a password
[17:21] <Jay2k1> hmm ok...
[17:21] <Jay2k1> i directly call nvram-wakeup
[17:21] <kkek> Its 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:23] <Jay2k1> i'm not sure
[17:24] <Jay2k1> i 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] <Jay2k1> and i believe the command you enter in mythbackend setup has nothing to do with what mythshutdown does, except you set mythshutdown as command there
[17:24] <Jay2k1> my config is as follows
[17:25] <Jay2k1> command to set wakeup time: sudo /usr/sbin/nvram-wakeup -A -s $time -C /etc/nvram-wakeup.conf -w 0
[17:25] <Jay2k1> shutdown command: sudo grub-set-default PowerOff && sudo /sbin/reboot
[17:26] <Jay2k1> and as shutdown check i call a script which not only asks mythshutdown if it is safe to shutdown but also looks for ssh sessions
[17:27] <kkek> sounds 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] <Jay2k1> i 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 setup
[17:28] <Jay2k1> OR i leave mythfrontend running which goes in some kind of standby mode after a certain of inactivity, also resulting in the same steps
[17:36] <kkek> relevent database settings posted here http://pastebin.ubuntu.com/5853194/
[17:37] <kkek> and after calling "mythshutdown -t" by hand,  | MythShutdownNextScheduled   | 2013-07-07T19:58:00         | NULL     | gets set
[17:47] <kkek> interesting... after calling "mythshutdown -t" and "sudo mythshutdown --shutdown" by hand, it does correctlyset the wake time
[17:48] <kkek> so it appears mythshutdown is properly configured, and the problem lies in my mythwelcome / mythbackend setup
[17:48] <Jay2k1> that sounds weird
[19:07] <kkek> solved 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:29] <qwebirc67585> hello, 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?thanks
[19:32] <kkek> if 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 "<>" characters
[19:33] <kkek> if you can connect, then mysql is at least running
[19:35] <kkek> also, when you say start the backend, are you talking the master backend, or is this a slave backend?
[19:37] <qwebirc67585> it is a master backend, i will run command now
[19:41] <kkek> if 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:44] <qwebirc67585> i get unknown option '--user-mythtv'
[19:46] <kkek> should be an = between --user and mythtv
[19:46] <kkek> (and between --password and your password)
[19:47] <qwebirc67585> when i type show tables it simply moves to the next line, nothing appears
[19:47] <kkek> in that case it looks like your database was never set up properly during the install
[19:47] <kkek> you can try running mythtv-setup and see if that poppulates the database
[19:48] <kkek> (that should guide you through configuring the backend)
[19:49] <qwebirc67585> ERROR 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 2
[19:49] <qwebirc67585> that is the error i get. i have ran through the setup. what part is setting up the database?
[19:51] <tgm4883> kkek, qwebirc67585 you need 'show tables;'
[19:52] <kkek> qwebirc67585: I thought you said nothing appears on "show tables;"  what were you running that gave that error.
[19:53] <qwebirc67585> nothing ran on "show tables" i get that error on "show tables;"
[19:54] <tgm4883> qwebirc67585, try it again
[19:54] <tgm4883> kkek, I'm pretty sure mysql thinks he typed 'show tables\nshow tables;'
[19:54] <qwebirc67585> i come up woth same error, but it says line one this time
[19:54] <tgm4883> weird
[19:55] <kkek> what version of mythbuntu are you running
[19:55] <qwebirc67585> 12.04
[19:55] <qwebirc67585> i have tried installing it twice,and have the same issues both times. would a issue in the capture card be an issue?
[19:55] <kkek> interesting... same version I am, and the version of mysql installed definitely supports "show tables;"
[19:56] <tgm4883> qwebirc67585, IMHO, it sounds like your doing/did something wrong
[19:57] <tgm4883> qwebirc67585, you're on the master backend?
[19:57] <kkek> qwebirc67585: also, have you run mythtv-setup?
[19:57] <qwebirc67585> yes 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:58] <tgm4883> that shouldn't matter
[19:59] <qwebirc67585> yes i have ran through it. although i did not change any settings
[19:59] <tgm4883> qwebirc67585, what if you do 'status;'
[20:00] <qwebirc67585> that 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:01] <tgm4883> qwebirc67585, are you on a linux pc?
[20:02] <qwebirc67585> i am running windows with the computer i am talking to you on. I just ran 'sudo mythbackend' and it stopped with
[20:02] <qwebirc67585> mediaserver; ;HttpServer Create error
[20:03] <tgm4883> I'm not sure why you would ever run 'sudo mythbackend'. Don't do that
[20:03] <qwebirc67585> Failed listening on TCP 127.0.0.1:6543 - error 8: the bound address is already in use
[20:03] <tgm4883> qwebirc67585, do this. 'sudo service mythtv-backend stop'  then 'sudo service mysql restart' then 'sudo service mysql status'
[20:05] <qwebirc67585> ERROR 1045 928000): Access denied for user 'root'@'localhost' using password: NO)
[20:06] <qwebirc67585> sudo service mysql restart ran fine
[20:07] <tgm4883> where/when did you get that error?
[20:08] <qwebirc67585> scratch that, after 'sudo service mysql status' mysql start/running, process 3497
[20:09] <tgm4883> qwebirc67585, ok
[20:10] <tgm4883> qwebirc67585, so now do this 'sudo service mythtv-backend start' and then 'sudo service mythtv-backend status'
[20:11] <qwebirc67585> mythtv-backend start/running, process 3848
[20:11] <tgm4883> qwebirc67585, ok, mythbackend is running
[20:11] <tgm4883> qwebirc67585, eg. don't try to start mythbackend improperly next time ;)
[20:12] <qwebirc67585> how to i connect with a frontend?
[20:13] <tgm4883> qwebirc67585, is it on the same machine?
[20:13] <qwebirc67585> no
[20:13] <tgm4883> qwebirc67585, did you already go though mythtv-setup?
[20:14] <qwebirc67585> yes
[20:14] <tgm4883> qwebirc67585, what IP address did you use when you went though mythtv-setup?
[20:14] <qwebirc67585> 127.0.0.1.
[20:15] <tgm4883> you 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 loopback
[20:17] <qwebirc67585> i do not see a mythtv service. only ssh samba nfs and vnc. i chose to install mythtv service during install
[20:18] <tgm4883> qwebirc67585, it's on the mysql tab
[20:19] <tgm4883> qwebirc67585, actually, it's been renamed since the last time I looked at it
[20:19] <qwebirc67585> yes, i do not see it
[20:19] <tgm4883> qwebirc67585, you've got to enable the master backend role on the mysql tab
[20:19] <qwebirc67585> it is enabled
[20:19] <tgm4883> good
[20:20] <tgm4883> does your master backend have a static IP or DHCP?
[20:20] <qwebirc67585> the loopback adress is still set though. do i need to change it to my lan? it is static
[20:20] <tgm4883> qwebirc67585, 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:21] <tgm4883> then fire up the frontend, put in the right credentials and IPs and you should be fine
[20:22] <qwebirc67585> it says it cannot connect to backend
[20:23] <tgm4883> is the frontend you are trying to connect from running linux?
[20:24] <qwebirc67585> i 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 homenetwork
[20:25] <tgm4883> qwebirc67585, are you using the android app?
[20:26] <qwebirc67585> yes
[20:27] <tgm4883> qwebirc67585, 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] <qwebirc67585> i 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 siganl
[20:28] <tgm4883> yea this is a good spot.
[20:28] <tgm4883> two routers could complicate things, but as long as you can forward the ports correctly you should be fine
[20:29] <qwebirc67585> ok 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 again