[02:05] Needing assistance with MYSQL: getting error mysqlcheck: Got error: 1045: Access denied for user 'mythbox'@'localhost' (using password: YES) when trying to connect [02:05] Text file: DBUserName=mythtv [02:05] reset your password [02:05] gomike: how is that done... bit of a noob [02:06] ill have to google it one moment [02:06] thanks [02:07] The mysql password is saved in the mysql.txt file. This file is usually in /etc/mythtv/mysql.txt or /home/mythtv/.mythtv/mysql.txt where mythtv is the user that runs the backend. [02:07] Just edit the line DBPassword= to the password you want to use and then change the password with mysqladmin to change the password in Mysql. [02:08] you can type locate mysql.txt to find out where that file is [02:08] then type sudo nano "file path" [02:09] I might be entering the command incorrectly; Mythconverg issue.... [02:09] `sudo dpkg-reconfigure mythtv-common` will do that too. [02:09] http://mythbuntu.pastebin.com/m5ce9881f [02:09] yep hads, thats the command i was looking for [02:10] guest31 do what hads said [02:10] k [02:10] can you check to see if I am entering the password and username correctly [02:11] pasted the mysql.txt [02:11] Just enter -p on the command line and then it will prompt for the password [02:12] `mysqlcheck -r -u mythtv -p mythconverg` [02:12] Note your mysql username is mythtv not mythbox [02:12] yah... [02:13] still getting the same error: using the correct username and password [02:13] fyi, if you do enter the password on the commandline, for some reason it has to be up against the -p (ex -pKkEjcOPh) [02:14] using this command" mythbox@mythbox-desktop:~$ mysqlcheck -r -u mythtv -phero12 mythconverg [02:14] mysqlcheck was interpreting your password as the database name instead of mythconverg [02:14] changed password to hero12 [02:16] any ideas? I am stumped.... cannot get the tv to work; mythconverg is showing in the log file: failing [02:17] I have used the above command prior on a different box and it was fixed... just getting this error. [02:17] *now getting this error [02:17] are you getting errors from mysqlcheck? maybe use the pastebin to show what the log file says is failing (if its more than one line) [02:18] FIRST: is this correct.... mysqlcheck -r -u mythtv -phero12 mythconverg [02:18] mysqlcheck -r -u mythtv -phero12 mythconverg [02:19] I am using PUTTY.com; remote connect.... [02:25] http://mythbuntu.pastebin.com/m6440f574 [02:25] Log from mythfrontend.log [02:26] nothing wrote to mysql.log [02:28] error running mysqlcheck: http://mythbuntu.pastebin.com/m72893c66 [02:33] MythbuntuGuest31: Is this a new install? [02:39] well ping me if you want help [02:57] tgm488_laptop: new install... was working than crapped put [02:58] tgm4883_laptop: yes, new installation. worked for an hour or so than nothing... [02:58] *watch live tv [03:05] MythbuntuGuest31: what changed from the time it was running to when it was broken? [03:08] nothing changed that I am aware of... was setting everything up... worked, then stopped working. If anything, could point from a connected monitor then switched to tv [03:08] Just have the TV connected at this time [03:09] tgm4883_laptop: what do you think? [03:09] hmm [03:10] so you were able to watch tv before huh? [03:10] I try to run mysqlcheck from a remote PC via PUTTY [03:12] sec [03:13] getting an errors: http://mythbuntu.pastebin.com/m44a2e4a4 [03:16] MythbuntuGuest31: this is a single backend/frontend? [03:19] yes... Front and Back on one box... [03:21] k [03:22] ok [03:22] did you set a root password for mysql during installation? [03:26] I dont recall [03:27] I used the command: sudo dpkg-reconfigure mythtv-common and now FRONTEND is down' [03:27] Restarting the system... [03:27] let me know when it's back up [03:27] k.... kinda working backwards.... arg [03:31] hi.. need help abot channel tuning [03:32] input source is not detecting digital cable signal [03:32] No UPnP backends found [03:32] this could get confusing [03:33] MythbuntuGuest31: do you have mythweb installed? [03:33] hold a sec [03:35] not sure - how do I check [03:35] : thought it was in MCC [03:35] oh boy [03:35] ohh no [03:35] ok [03:35] Fresh installation? [03:36] MythbuntuGuest31: not yet [03:36] first, try this [03:38] do "ps aux | grep msyql" [03:39] post the output of that here [03:39] and since I like to teach [03:39] that command tells us if mysql is running [03:39] tgm4883_laptop: UPDATE - local host was blanked... entered the IP address then get "cannot log into database" after runnnin " sudo dpkg-reconfigure mythtv-common " [03:40] mythbox@mythbox-desktop:~$ ps aux | grep msyql [03:40] mythbox 8150 0.0 0.0 3004 764 pts/0 S+ 20:40 0:00 grep msyql [03:40] thats all? [03:41] Thats all [03:41] interesting [03:41] sec [03:41] pastbin would be the same [03:41] pastebin the output of "sudo /etc/init.d/mysql status" [03:44] http://mythbuntu.pastebin.com/m78f7dafc [03:44] ok [03:44] looks to be running [03:44] for some reason I am unable to connect to the database.... [03:44] right [03:44] lets fix that ;) [03:45] do this commands [03:45] sudo dpkg-reconfigure mythtv-database [03:45] sudo dpkg-reconfigure mythtv-common [03:45] ohhh... there are commands... that may be the prob [03:45] huh? [03:46] someone told me to run just one of them.... [03:46] well the second one you can run in some cases [03:46] but i want you to run both [03:47] enable remote connectivity? [03:47] sure [03:47] jsut one box now... plan on adding [03:47] then yes [03:48] cannot log into database... [03:49] did you get that running one of those commands? [03:49] http://mythbuntu.pastebin.com/m4ba223ec === anubis is now known as darthanubis [03:51] unable to fetch schedule lineup Intrpeid [03:51] hmm [03:51] its shows progress of 50% then dies [03:52] hi tgm4883_laptop [03:52] hi MythbuntuGuest57 [03:52] I need help with making my tuner detect the digital cable signal [03:53] pls [03:53] MythbuntuGuest31: did you enter your root password when running the commands? [03:53] MythbuntuGuest57: what tuner? [03:53] darthanubis: error messages? [03:53] Hauppauge HVR 1600 [03:53] I'm getting them now [03:53] the card is detected [03:53] but after getting that far [03:53] now it wonn't login to the database oddly [03:54] even though I've setup myth a hundred times [03:54] I have the DB password and all [03:54] let me retract my steps [03:54] darthanubis: which version of mythbuntu? [03:54] MythbuntuGuest31: Which version of mythbuntu are you using? [03:55] I have never used mythbuntu [03:55] I'm running Intrepid with mythtv installed [03:55] darthanubis: ah ok [03:55] with the mythbuntu control centre [03:55] 8.04 [03:56] same problem? [03:56] doubt it [03:56] can't login to database [03:57] which app do I reconfigure again? [03:57] mythtv-common [03:57] MythbuntuGuest31: can you try this [03:57] or mythtv-database [03:57] or mysql5? [03:57] mysql -uroot [03:57] k [03:57] darthanubis: mythtv-database, mythtv-common [03:58] k [03:58] tgm4883_laptop, the password myth should use to access the database is in mysql.txt right? [03:59] yes [03:59] although the above commands will overwrite that [03:59] basically, you can choose your password right now [04:00] tgm4883_laptop: at mysql> prompt [04:00] MythbuntuGuest31: [04:00] MythbuntuGuest31: good deal [04:00] so you can login to mysql ;) [04:00] yah... but Frontend cannot [04:00] now we just have to get the other user to do it [04:00] :( [04:01] MythbuntuGuest31: when you ran those commands that I posted above (the dpkg-reconfigure commands) did they pop up a box on your screen or did it all stay command line? [04:01] ? [04:02] MythbuntuGuest57: it sees the card, but whats the problem? [04:02] MythbuntuGuest31: i'm wondering if the issue might be putty [04:02] well I cannot scan it [04:02] MythbuntuGuest57: error message? [04:02] it does not show on the input source.. tuner 1 -> none [04:03] & scan is not enabled [04:03] scan buton [04:03] mysql -uroot < what does this do? [04:03] I did get the "pop-up" box (blue) and was able to input the setup [04:03] using putty [04:03] i have taken the cable out from settop box of cox & connected to tuner card [04:03] MythbuntuGuest57: IIRC, tuner 1 is the input source, and the none means that you haven't linked it to a data source yet [04:04] darthanubis: logs you into mysql as root [04:04] ok so how do I do it [04:04] MythbuntuGuest57: where do you live? [04:04] MythbuntuGuest31: ok, then putty seems find [04:04] fine* [04:04] Fairfax county VA [04:05] MythbuntuGuest57: ok, have you heard about Schedules Direct? [04:05] yeah [04:05] MythbuntuGuest57: are you signed up for it? [04:05] no [04:05] How are you expecting to get guide data? [04:06] i dont expect guide data [04:06] but atleast tv output [04:06] ok [04:06] I mean scan the channels [04:06] MythbuntuGuest57: did you go into data sources and make a data source? [04:06] even though it's going to be none [04:06] you still have to make one [04:07] how to do it [04:07] !manual [04:07] http://mythbuntu.org/installation_manual [04:07] Connecting to webservices.schedulesdirect.tmsdatadirect.com|206.18.98.175|:80... connected. [04:07] HTTP request sent, awaiting response... [04:07] it stalls there [04:08] any ideas or should I do I fresh installation? [04:08] MythbuntuGuest31: try [04:08] MythbuntuGuest31: mysql -umythtv -p [04:08] guest31, you could have done a fresh install with how long you have been working on this :0D [04:10] thanks gomike [04:12] access denied [04:12] even after running: sudo dpkg-reconfigure mythtv-common [04:12] sorry i just had to say it, we have all been where you are [04:12] *setting tbe password [04:12] well not exactly where you are [04:13] :) I know... [04:13] hmm [04:13] tgm4884_laptop I think I am able to scan channels now [04:13] Did you have to use a password when you logged into the mysql server as root? [04:13] scanning it [04:14] nope [04:14] mysql -uroot... right [04:14] yep [04:14] yah... no password prompted [04:16] This happens after running the following... read postbin [04:16] http://mythbuntu.pastebin.com/m1e0452ad [04:16] STRANGE [04:18] MythbuntuGuest31: do this [04:18] mysql -uroot [04:18] then [04:18] show databases; [04:19] and pastebin the results [04:20] tgm4883_laptop: I can see the tv but its kinda frame by frame .. not smooth [04:20] MythbuntuGuest57: system specs? [04:21] its supposed to be a celeron dual core .. 1 ghz ram .. ati pro video card .. HVR 1600 [04:21] 3 ghz processor [04:21] a celeron dual core? [04:21] I didn't even know that existed [04:21] omeone sold it to me saying its this [04:21] :( [04:21] how do i check system spec in unix ? [04:21] MythbuntuGuest57: pastebin the output of cat /proc/cpuinfo [04:22] ok [04:23] http://mythbuntu.pastebin.com/m79de0018 [04:23] oh wait [04:23] f me [04:23] geniune intel : cpu family: 15.. Intel Celeron CPU 3.06 GHZ, cache 256 kb, fpu: yes, fpu extn: yes, cpuid leve 5 [04:24] MythbuntuGuest57: thats not exactly pastebin, but ok [04:24] not sure if it's dual core or not though [04:24] i am using my windows machine [04:24] for chat [04:24] sorry [04:24] ok [04:24] are you trying to watch HD or SD? [04:24] SD [04:24] ok [04:24] have a sony trinitron 27 [04:24] did you enable your restricted driver? [04:25] how to do it [04:25] use the restricted driver manager [04:27] it just says hardware drivers - device driver ati accelerated graphics drive - in use [04:27] so that would be "Yes i have the driver installed" [04:27] ok [04:27] http://mythbuntu.pastebin.com/m79de0018 [04:28] MythbuntuGuest31: get your mythtv password ready [04:30] armed and ready [04:30] ok [04:30] do [04:30] mysql -umythtv -p Dmythconverg [04:30] arg [04:30] mysql -umythtv -p -Dmythconverg [04:32] access denied [04:32] blarg [04:32] MythbuntuGuest31: I think it's time for a reinstall [04:33] "mythbuntuguest31" pulling his hair out [04:33] MythbuntuGuest57: you probably need to set up your playback profiles [04:33] I think your right [04:33] ok what do i need to set in payback profiles [04:35] MythbuntuGuest57: http://www.mythtv.org/wiki/index.php/Playback_profiles [04:38] anyone using intrepid here? [04:38] testing mythtv? [04:39] Is anyone else having bad playback issues? [04:39] tgm4883_laptop: thanks a lot for all ur help.. I will try to play with the playback profiles & see how it plays [04:40] appreciate ur help [04:40] When the OSD comes up, playback gets really choppy. And sometimes everything freezes up for a while, then continues. [04:40] MythbuntuGuest57: np [04:40] darthanubis: just have one intrepid machine right now, will be a frontend when I get around to installing mythtv [04:41] bronson: the OSD, or the guide? [04:41] tgm4883_laptop, osd. Like adjusting the volume. [04:41] Each press of the volume button freezes the video for 0.5 sec or so. [04:41] And occasionally it will freeze up for a good minute. [04:42] I shouldn't say freeze... the computer is fine if I switch to a different desktop. [04:42] But the playback goes totally black for a while then seems to recover on its own. [04:42] Pretty bizarre... wondering if it's pulseaudio related or something. [04:44] bronson: is this a new thing, or has it happened since you installed? [04:46] tgm4883_laptop, happened since I installed. [04:46] computer specs? [04:46] It didn't do it in Hoary but seems to on Feisty. [04:47] Intel(R) Core(TM)2 Duo CPU E7200 @ 2.53GHz, non-free nvidia drivers, 2GB ram. [04:47] CPU never goes above 30%, even when the video freezes. [04:49] interesting [04:50] I haven't seen that issue myself, but I don't use the built in volume [04:50] what happens if you just hit "i" during playback for info? [04:50] I'll try, brb [04:52] Wow, that was a good call. [04:52] It goes fast when I use the keyboard. [04:52] It's only slow when I use the remote. [04:53] the volume too? [04:53] yep [04:53] I didn't think to try using the keyboard. [04:53] interesting [04:53] what receiver? [04:53] Hauppauge HVR-950q, USB-connected. [04:53] Remote is USB too. [04:54] strange [04:54] lirc issue then i guess [04:54] sounds like it. [04:54] Guess I'll have to fiddle with it more. [05:05] It appears to be a bad interaction between Mythtv and LIRC. [05:06] Maybe my remote is hitting Myth with too many consecutive keypresses? [05:06] too quickly? [05:06] bronson: where did you get your lircrc from? [05:09] I'm pretty sure I had Mythbuntu generate it. [05:09] hmm [05:10] can you pastebin it? [05:10] Yep, it is. [05:10] sure [05:10] and what remote is it? [05:10] It's an MCEUSB2 [05:11] Repeat is 0 for each entry... should it be 3? [05:12] mine's 0 [05:12] for my MCEUSB2 [05:15] that shouldn't be a problem then. [05:15] http://pastie.org/269434 [05:15] Sorry for the delay, I had to install xclip. :) [05:15] did you edit this by hand at all? [05:16] I just added the Back entry at the very end. [05:18] I really doubt this is the problem, but you might need an extra blank line at the end of the file [05:18] looks fine though [05:18] some things are picky about those end lines being blank === rhpot1992 is now known as rhpot1991 [05:27] That's really strange then. [06:11] tgm4883_laptop, lmao [06:11] nice try ;) [06:11] tgm4883_laptop, comn now unban me [06:11] lol [06:12] I would [06:12] but I can't [06:12] sure you can [06:12] working on it [06:13] so what put it over the top where you figure out who I was? [06:13] when you quit and rejoined as a different name [06:13] and really, the Administrator user? [06:13] whats that? an XP machine? [06:14] its a laptop i "borrowed" from my office until I get my new laptop [06:14] sure [06:14] my Ubuntu laptop is dead [06:14] for real now [06:14] How do I skip commercials? My Myth-generated lirc file doesn't provide an End key. [06:15] (assuming the flagging went OK, which it normally doesn't) [06:15] bronson: the skip button? [06:15] right arrow skips forward 30 secs [06:15] or the skip button [06:15] or FFWD [06:15] haha, right. [06:16] but, "The End or Z key (by default) jump to the next commercial break marker." [06:16] I guess you guys don't bother with comm flagging? [06:16] bronson, skip on the remote usually is mapped to Z [06:16] is what I was trying to explain [06:17] oh, that makes sense. [06:17] tgm4883_laptop, wth??! you add a perm ban? [06:17] So that's asymmetric. [06:17] Skip to go forward, Home to go back. [06:18] depends on the the remote...I have no idea what remote you have and how it was treated by my mappings [06:18] MCEUSB2, mythbuntu-provided mappings [06:19] well then on the remote, use the skip buttons, like the DVD chapter skip buttons [06:20] bronson, I say my mappings because I wrote the dictionary that generates the auto generated mappings [06:20] tgm4883_laptop, comn! [06:20] foxbuntu: yea so, i can't unban you [06:20] it's not letting me [06:20] why? [06:20] * tgm4883_laptop shrugs [06:20] i'll keep digging into it [06:20] did you permantly do it [06:20] I blame Kubuntu [06:21] no, i can reverse any ban [06:21] ok [06:21] just let me grab the cs script [06:21] be back in a sec...I need to go start my server up [06:22] groovy, it seems to work. [06:23] bronson, it better :) I have that remote [06:23] tgm4883_laptop, why are you using KDE4 now? [06:25] tgm4883_laptop: I need advice for setting up my playback profile pls [06:25] MythbuntuGuest57, you will need to provide specs and setup of your machine to make any suggestions for that [06:25] foxbuntu, well, thanks for the bindings. :) [06:26] bronson, no problem, I always hated setting that up by hand ;) [06:26] foxbuntu: yep [06:26] let me restart [06:26] Is there any way to get an overview of where Mythtv found the commercial breaks? [06:26] bronson, nope [06:27] foxbuntu: system specs: geniune intel : cpu family: 15.. Intel Celeron CPU 3.06 GHZ, cache 256 kb, fpu: yes, fpu extn: yes, cpuid leve 5 [06:27] ATI pro 256 AGP card tv out [06:27] 1 GB ram [06:27] MythbuntuGuest57, is it a frontend/backend system? [06:28] its a back + front end primary system [06:28] MythbuntuGuest57, are you using Open Source or Closed Source Video Drivers? [06:29] I used ATI setip with hardy guide to do it [06:29] MythbuntuGuest57, pretty safe to say, you need to use the CPU-- / Slim playback profile [06:29] also, Setup the Guide to use the ECO (Low CPU) profile [06:30] set Userjobs in the Backend Setup to use Low CPU and no more than 2 jobs at a time [06:30] I changed Current video playback profile to Slim [06:30]