[02:09] <jeffery> how do I get my initial myth database setup? I install the alternative cd and when I launch the mythtv-setup it says could not connect to the database. I checked the database and the mythtv database is not there
[02:53] <MythbuntuGuest20> hiya.  i dont have any sound after an upgrade to mythbuntu 8.10
[02:54] <stevetv> haha.. sorry wrong nick. again. no sound after fresh install of 8.10
[02:54] <stevetv> i don't really know where to start looking to fix it
[02:54] <stevetv> thanks
[03:24] <wilberfan> occasionally i get an .avi where the sound is out of sync when i play it in myth...but is fine if i play it in, say, VLC
[03:24] <wilberfan> any idea what that's about--or how to re-sync it in myth?
[03:47] <stevetv> wilberfan.. what player are you uSING for avi files?
[03:47] <wilberfan> you mean in myth?   I don't remember 'selecting' one...which one is 'standard'?
[03:55] <wilberfan> it's been several months since i configured it (probably when 'heron' came out?)...i don't remember specifically
[04:26] <ajhtiredwolf> Hey, anyone that is good with lirc, I am trying to configure a button to launch mythtv, but it doesnt seem to work right, most of the sample configs i see launch a script instead of just the program ,is there a public script available that anyone knows about?
[04:42] <rhpot1991> ajhtiredwolf: I may be of some assistance
[04:42] <rhpot1991> !pastebin
[04:42] <Zinn> when pasting more than 5 lines of data please use http://mythbuntu.pastebin.com so you don't flood the channel.  Then please post the link in the channel.
[04:42] <rhpot1991> http://mythbuntu.pastebin.com/m4274adb0
[04:42] <rhpot1991> that goes in: /usr/bin/start-myth
[04:43] <rhpot1991> http://mythbuntu.pastebin.com/m1043eec3
[04:43] <rhpot1991> goes at the end of your ~/.lirc/mythtv
[04:44] <ajhtiredwolf> rhpot1991, awesome one sec let me check that out
[04:45] <ajhtiredwolf> rhpot1991, hmm I dont have a file named start-myth,
[04:46] <rhpot1991> make it
[04:46] <rhpot1991> I am checking to see if anything has to be setup for irexec
[04:47] <ajhtiredwolf> rhpot1991, I think that I have a problem with irexec as well, I think that the daemon must keep crashing, I have to start it manually, and after I do it doesnt seem to work for long
[04:48] <hads> rhpot1991: Did you know that if you use 'grep mythfronten[d]' you will only need the one grep.
[04:49] <rhpot1991> hads: nope, I didn't write that either :)
[04:50] <rhpot1991> tgm4883 got it from somewhere and passed it on
[04:50] <ajhtiredwolf> hmm that config didnt seem to work for me
[04:50] <rhpot1991> ajhtiredwolf: wait a minute, I'm still checking something
[04:50] <hads> rhpot1991: Cool, just like sharing little tips.
[04:50] <ajhtiredwolf> no problemo
[04:51] <ajhtiredwolf> I just installed vista through Virtualbox and it about blue my sox off, the features that virtual box offers for vista are so cool, not to mention everyhting just worked native :p
[04:51] <ajhtiredwolf> sorry had to share
[04:53] <ajhtiredwolf> be right back, two seconds
[04:57] <wilberfan> what kind of features does VB offer for vista?
[04:58] <rhpot1991> ajhtiredwolf: did it work at all or what happened?
[04:59] <rhpot1991> I thought I had to do something to enable irexec or make it work, but I can't seem to find what
[04:59] <hads> You should just need to start it when you login from memory.
[04:59] <ajhtiredwolf> nahhh didnt do anything when i press the button set to launch it
[05:00] <ajhtiredwolf> wilberfan, well it has this semless mode, where you keep your ubuntu background but the taskbar stays as vista, and you can drag and drop files between vista and linux, its very strange but cool and probably will be usefull
[05:01] <rhpot1991> ajhtiredwolf: I think it does that with xp as well
[05:01] <ajhtiredwolf> rhpot1991, possibly, I might have just not been able to get it to work with xp
[05:01] <rhpot1991> have you verified you mapped the correct button for your config and so on, your button might not be the same as mine
[05:01] <wilberfan> I have xp running virtual on my Sidux box...  Ironically, it was Vista that made me switch to Ubuntu!  :)
[05:02] <ajhtiredwolf> hate of vist? :p
[05:02] <ajhtiredwolf> rhpot1991, yeah minei s power too
[05:02] <ajhtiredwolf> rhpot1991, everyhting i set it as my remote and my button
[05:02] <ajhtiredwolf> remote = mceusb2
[05:02] <ajhtiredwolf> button = power
[05:03] <wilberfan> when i heard that you could only install it 3 times, i threw up my hands and said, "That's it!!  I'm done!"
[05:04] <ajhtiredwolf> wilberfan, well I feel so retarded.. I bought it... I dont know why, but i did, i had already been using ubuntu pretty much all together, then i foudn out that i get it for free through my university
[05:04] <ajhtiredwolf> wilberfan, makes me feel sick to my stomach hah
[05:04] <wilberfan> i gave up on Vista BEFORE it was released...  :)  Mid-'07, I think...
[05:05] <wilberfan> Started with Ubuntu, but then discovered Sidux...
[05:05] <wilberfan> But I LOVE my MythBuntu!!
[05:05] <ajhtiredwolf> wilberfan, I havent heard of Sidux, what are its adventages?
[05:05] <ajhtiredwolf> rhpot1991, I dunno man it just seems like lirc wont work for me hah, ive tinkered with it for so long
[05:06] <wilberfan> It's Debian based, like 'buntu...but it's easier to keep it almost cutting-edge in terms of updates, etc...
[05:06] <ajhtiredwolf> wilberfan, I like how easy to use ubuntu is.
[05:07] <wilberfan> Plus, it's got the friendliest, most-helpful irc channel i've ever been in...
[05:07] <ajhtiredwolf> wilberfan, that is a nice twist on linux support hah :P, people in ubuntu and here are pretty nice
[05:07] <ajhtiredwolf> but have you ever been in say... #mythtv ?
[05:07] <wilberfan> Ubuntu worked so well, and was so easy to use...i found i was getting a little bored with it!
[05:07] <doje> superm1: you around? - we talked about a control panel for LCDproc
[05:08] <wilberfan> Oh, the Ubuntu *Forums* are awesome...
[05:08] <ajhtiredwolf> wilberfan, EVERY single time i have gone into mythtv, ive gotten that " I am god because I have more time to waste on mythtv and know more than you, how dare you ask a question to me"
[05:08] <ajhtiredwolf> I just get called noob allot in so many linux places
[05:09] <rhpot1991> #mythtv is just too busy
[05:09] <wilberfan> i usually confess to being a noob before they can throw that at me...
[05:09] <ajhtiredwolf> I am a noob undoubtfully but ... im confused as to how that is a bad thing? Linux attracting new people must be a very bad thing..
[05:09] <ajhtiredwolf> we wouldnt want it to spread and grow now would we? :-P
[05:09] <wilberfan> But, yeah...i hate that attitude of "what do you mean you don't understand my instruction?  what are you, stupid?"
[05:10] <hads> Some channels are just angry places.
[05:10] <wilberfan> boy, howdy...
[05:10] <ajhtiredwolf> yeah, you ask a question to clarify something and they call you a moron
[05:11] <wilberfan> now that this room has woken up a bit, i'd like to ask my question again:
[05:11] <wilberfan> I occasionally get .avi's (downloads) where the sound is a second or two behind the picture...
[05:11] <ajhtiredwolf> anyway, rhpot1991 I just changed the config = line to gedit instead, and it was able to launch gedit
[05:11] <ajhtiredwolf> rhpot1991, " although I had to start the irexec daemon manually again
[05:12] <rhpot1991> ajhtiredwolf: interesting, so the irexec is actually launching it
[05:12] <wilberfan> ...when played in mythbuntu...  but they're fine if I play them outside of myth (say, with VLC)...
[05:12] <ajhtiredwolf> wilberfan, which program are you using to veiw them?
[05:12] <rhpot1991> well try to run start-myth by hand
[05:12] <ajhtiredwolf> wilberfan, I had that problem until I told mythbuntu to use xine instead
[05:12] <wilberfan> whatever one is 'standard' with mythbuntu hardy?
[05:12] <rhpot1991> it will only start if the frontend isn;t currently running
[05:13] <wilberfan> it's been so long since i've configured it...do you remember where to find that configure screen...?
[05:13] <ajhtiredwolf> rhpot1991, its not, and .. huh it says command not found, but it IS there
[05:13] <ajhtiredwolf> wilberfan, yar i do, one second
[05:13] <wilberfan> kewl
[05:13] <rhpot1991> ajhtiredwolf: verify it is in /usr/bin/start-myth
[05:13] <rhpot1991> and the names match up
[05:13] <wilberfan> what does myth use by default?  mplayer, or...??
[05:14] <rhpot1991> john@ultramagnus:~$ ls -la /usr/bin/start-myth
[05:14] <rhpot1991> -rwxr-xr-x 1 root root 222 2008-05-18 17:35 /usr/bin/start-myth
[05:14] <rhpot1991> check your perms so they are that ^
[05:14] <rhpot1991> wilberfan: internal player
[05:14] <wilberfan> is that the config option, or what the default player is called..?
[05:15] <ajhtiredwolf> wilberfan, movie player i think
[05:15] <ajhtiredwolf> alright it is in
[05:16] <rhpot1991> internal player is normally used by most things in myth, its the built in mythtv player
[05:16] <ajhtiredwolf> wilberfan, utilities setup      setup          media settings        video settings     player settings
[05:16] <wilberfan> :)
[05:16] <rhpot1991> some things like mythvideo may use different players
[05:16] <rhpot1991> like mplayer for avi I think is default
[05:16] <ajhtiredwolf> wilberfan, then if you wnat to use xine, xine -pfhq --no-splash worked for me
[05:16] <hads> I use Internal for everything myself
[05:17] <rhpot1991> I use internal for everything as well
[05:17] <rhpot1991> I like having the same look and feel for all my stuff, plus internal is much improved anymore
[05:17] <rhpot1991> I used to use xine for my iso's
[05:17] <wilberfan> you guys never have the sound-sync problem...?
[05:17] <rhpot1991> wilberfan: in what recordings/videoes?
[05:17] <hads> Haven't come across it no.
[05:17] <ajhtiredwolf> rhpot1991, yeah its in there sudo gedit /usr/bin/start-myth brought it up
[05:18] <ajhtiredwolf> wilberfan, usually it only happens in very large avi files
[05:18] <wilberfan> rhpot1991: downloaded .avi's...
[05:18] <rhpot1991> ajhtiredwolf: it might be persmissions if it wont run then
[05:18] <ajhtiredwolf> rhpot1991, probably, let me change them sec
[05:18] <rhpot1991> wilberfan: I don't do much of them, mostly recordings and iso's here
[05:18] <wilberfan> ajhtiredwolf: i've got one that's just a 28 minute tv episode...
[05:18] <ajhtiredwolf> wilberfan, I mostly noticed it on large xvid avis
[05:19] <ajhtiredwolf> wilberfan, but that was just my experience
[05:19] <wilberfan> i download a lot of tv episodes, and about 1 in 10 has the sync problem...
[05:19] <wilberfan> i COULD just watch it on the puter monitor (with VLC, where it's fine)--but i wondered if there was something i could do in myth to prevent that problem...
[05:20] <wilberfan> a 'slider' to adjust the timing would be great!  ;)
[05:21] <ajhtiredwolf> wilberfan, there actually is one in mplayer
[05:21] <ajhtiredwolf> wilberfan, but its annoying having to do that all the time :P xine fixed the probelm for me
[05:21] <wilberfan> let me drag the keyboard and mouse in here and see if i can find that config setting...
[05:22] <ajhtiredwolf> rhpot1991, ok i got the permissions set right, what was it ? start-myth& ?
[05:23] <rhpot1991> just try start-mythtv
[05:23] <rhpot1991> errr start-myth
[05:24] <rhpot1991> just typing that should start it or at least tell you something
[05:24] <ajhtiredwolf> oh yeah it starts now
[05:24] <ajhtiredwolf> but i mean in the config file
[05:24] <wilberfan> are those xine settings in the front end or back end?
[05:25] <ajhtiredwolf> wilberfan, front
[05:26] <ajhtiredwolf> rhpot1991, k yeah that let me launch it thank you :), but ims sitll running into two problem I was before, I have to start the irexec -d manually and there seems to be a delay from the button press... actually more than a delay, it makes it freeze temporarily
[05:28] <rhpot1991> ajhtiredwolf: here it takes a second or two to launch, but no problems other than that
[05:29] <ajhtiredwolf> rhpot1991, i seem to have the problem no matter what, before i had irexec launch it. like if im turning up the volume, each time i press it the picture will freeze for a moment, or if im moving up or down selecting somehting, it is delayed
[05:29] <ajhtiredwolf> wilberfan, tell me if xine starts at min volume for you when you use it in myth, i have that problem
[05:30] <wilberfan> alright...i'm just about to test...
[05:30] <rhpot1991> ajhtiredwolf: weird sounds like maybe lirc is hogging cpu or something?
[05:31] <ajhtiredwolf> rhpot1991, mmmm I guess maybe, but like if im using xine, it doesnt do that
[05:32] <ajhtiredwolf> rhpot1991, and do you have to start irexec -d when your computer starts too?
[05:32] <wilberfan> ajhtiredwolf: woah...  no problem with the volume on THIS vid!!
[05:32] <ajhtiredwolf> wilberfan, lol, well did the audio sync problem go away?
[05:32] <wilberfan> that's next... hang on...
[05:34] <wilberfan> well, the lord giveth...and the lord taketh away...
[05:34] <wilberfan> it fixed the sync problem...but i can't jump forward or back now!
[05:34] <ajhtiredwolf> lol, well at least some good news, xine has weird bindings
[05:34] <wilberfan> AND the sound started at zero volume...
[05:34] <ajhtiredwolf> I think that forward is..
[05:34] <ajhtiredwolf> hmm
[05:35] <ajhtiredwolf> well the config is     config = SeekRelative+15
[05:35] <wilberfan> jeez...now it IS jumping foward and back...
[05:35] <ajhtiredwolf> ever feel like you just cant win? :p
[05:36] <wilberfan> constantly!
[05:36] <wilberfan> mplayer responded to two buttons foward and two back...it looks like xine only has 1 each...?
[05:36] <ajhtiredwolf> I guess it is oru own fault htough, we ARE trying to watch tv on our computer by using a community built dvr
[05:37] <wilberfan> i ain't complaining!  (well, not MUCH anyway...)
[05:37] <ajhtiredwolf> wilberfan, want me to send you my xine config?
[05:37] <wilberfan> ;)
[05:37] <wilberfan> uh...sure   what do i do with it?
[05:37] <ajhtiredwolf> wilberfan, oh wait you arent using a remote are you? hah
[05:38] <wilberfan> a remote, like a remote control..? yes i am...!
[05:38] <wilberfan> i'm using a hauppage...god, what is it...a 350?
[05:39] <ajhtiredwolf> alright yeah, so take this http://pastebin.com/m62bb4ee2
[05:39] <ajhtiredwolf> and put it in either your lircrc, or make a seperaite file and include that file in your lircrc
[05:39] <ajhtiredwolf> you will have to tune it to your buttons too
[05:40] <ajhtiredwolf> have you ever used elisa?
[05:40] <wilberfan> it's been awhile since i've done any of that!  MythHardy has been very reliable!
[05:40] <wilberfan> elisa?  me...?  no...
[05:40] <ajhtiredwolf> alrighty
[05:41] <ajhtiredwolf> well first make sure that you dont already have a xine config open sudo pico ~/.lircrc
[05:41] <ajhtiredwolf> check and see if there is a xine config file listed in there
[05:44] <wilberfan> i do see an 'include ~./xine line there...
[05:45] <wilberfan> ~/.lirc/xine
[05:45] <ajhtiredwolf> yeah
[05:45] <ajhtiredwolf> alrighy, look in that file
[05:45] <ajhtiredwolf> You can add any of the options that are in my config in there to increase functionality
[05:46] <ajhtiredwolf> as for xine starting at 0 volume, if you ever figure out how to fix that make certain you tell me :p
[05:47] <wilberfan> can i just tack your list onto the end of mine, or do i have to pick and choose...?
[05:47] <ajhtiredwolf> You cna but you will have to change some things reguardless
[05:47] <ajhtiredwolf> where it says button =
[05:47] <ajhtiredwolf> the name wont be the same
[05:47] <ajhtiredwolf> you can check the names of your buttons by typign irw in a terminal
[05:48] <wilberfan> kewl
[05:48] <wilberfan> will this all change in a couple of weeks when Ibex is out??
[05:49] <wilberfan> ;)
[05:49] <wilberfan> and more importantly:
[05:49] <wilberfan> will i be able to update...or will i have to re-install????
[05:49] <ajhtiredwolf> No idea what ibex is haha
[05:49] <ajhtiredwolf> oh
[05:49] <hads> The next version of Ubuntu
[05:49] <ajhtiredwolf> the new version of ubuntu
[05:49] <wilberfan> right...
[05:49] <hads> And yes you can upgrade
[05:49] <wilberfan> i've always heard dicey results with upgrades...
[05:49] <ajhtiredwolf> yeah I dont think that lirc would change
[05:50] <wilberfan> guess it's worth a try!
[05:50] <ajhtiredwolf> well
[05:50] <ajhtiredwolf> I dont think that it is necessarily the upgrade
[05:50] <ajhtiredwolf> just that when it first comes out its bound to have issues
[05:50] <ajhtiredwolf> so if you wait a month or so after it has been released you will probably be safer
[05:50] <ajhtiredwolf> That is what I always did with fedora
[05:51] <hads> My desktop is a Dapper -> Edgy -> Fiesty -> Gutsy -> Hardy -> Intrepid upgrade.
[05:51] <wilberfan> wonder how that will work... will the update manager let me know when ibex is ready, or...?
[05:51] <ajhtiredwolf> I would have never switched to ubuntu if fedora had not neglected to support my onboard lan
[05:52] <hads> I believe update-manager will notify you yes.
[05:52] <wilberfan> do i change my repos after the end of the month...?  i've always just done a clean-install...
[05:52] <wilberfan> Ah... "Dapper"... that was my first buntu!  :)
[05:52] <ajhtiredwolf> Hardy is my first true try at ubuntu :p
[05:52] <ajhtiredwolf> I like fedora in the passed, and one thing I do kinda miss is KDE
[05:52] <ajhtiredwolf> kde kinda blows monkey chunks in ubuntu
[05:53] <wilberfan> KDE is 'native' in Sidux...
[05:53] <wilberfan> and (drumroll) it only takes 7 1/2 minutes to install!  :)
[05:53] <ajhtiredwolf> Installing KDE in ubuntu vs just doing kubuntu was a big ****** mistake
[05:53] <wilberfan> (YMMV)
[05:55]  * wilberfan goes to see if his porn runs with xine
[05:56] <ajhtiredwolf> geeze this stupid delay is annoying
[05:57] <ajhtiredwolf> rhpot1991, do you know how to check how much cpu lirc might be using and more importantly how to limit it?
[06:18] <wilberfan> boy, it sure got quiet in here in a hurry!
[06:21] <wilberfan> thanks, everyone, for your help...
[07:51] <FisherPrice> Um I'm trying to import a DVD, I'm using mythbuntu 8.04 and I've checked the /dev/dvd link and it's pointing to /dev/scd0 but I can't seem to transcode anything
[10:20] <Sisco> nice!
[12:42] <xukun> !upgrade
[12:42] <Zinn> Sorry I don't know about upgrade
[12:42] <xukun> !update
[12:42] <Zinn> Sorry I don't know about update
[12:42] <xukun> hoi is it possible to upgrade from mythbuntu 8.04 to 8.10?
[14:15] <MythbuntuGuest60> Hello. Trying to install Mythbuntu 8.10 but the installation stalls at the screen where i select the keyboard layout.
[14:16] <MythbuntuGuest60> When i press next the clock cursor comes up but nothing more is happening
[17:36] <dick-richardson> I have a ga-73PVM and can't get audio through the optical out...where should I be looking?
[18:18] <hansoffate> Hi, my oldrecorded mysql database needs to be repaired.
[18:18] <hansoffate> i usually just repair/optimize tables through the webui
[18:19] <hansoffate> does anyone have any suggestion?
[18:37] <hansoffate> Hi, my 'oldrecorded' mysql database needs to be repaired, which usually i repair/optimize with the mythweb ui.
[18:38] <hansoffate> however, i can't even access the website, is there a way to do it within the mysql shell?
[18:40] <MythbuntuGuest90> Is it posible to install a TV tuner in a backend server, and access it for several frontend servers, simultaneusly. The purpose, watch TV in several TVs simultaneously using one TV tuner.
[18:49] <MacNean> was wondering if anyone could help me with 2 things, i recently installed mythbuntu on an AppleTV but I have no sound still, also after a period of time with no activity the AppleTV seems to go to sleep, my TV says no signal, i can VNC into it and if i change display settings it will come backc up, i just don't want it to go to sleep ever
[18:55] <MacNean> was wondering if anyone could help me with 2 things, i recently installed mythbuntu on an AppleTV but I have no sound still, also after a period of time with no activity the AppleTV seems to go to sleep, my TV says no signal, i can VNC into it and if i change display settings it will come backc up, i just don't want it to go to sleep ever
[19:33] <mlester> Good day mythbuntu channel is anyone active at the moment
[19:36] <mlester> !help
[19:36] <Zinn> Use ! followed by a topic to get help on the topic (if it exists) example: !logs.  Other available commands: !status, !about, !bug [bug_number].  For a  complete list of my knowledge visit: http://www.baablogic.net/Zinn.cgi
[19:36] <mlester> !logs
[19:36] <Zinn> MythTV logs are stored in /var/log/mythtv/
[19:37] <mlester> Question: what is a solid cheap tv card I could use for a mythbuntu system
[19:58] <MacNean> i use the pvr500
[19:59] <MacNean> well actually i have 2 pvr250's and 1pvr500 for4 recordings
[19:59] <MacNean> but that's only analog/cable
[19:59] <mlester> ok
[19:59] <MacNean> if you want HD diff story
[19:59] <MacNean> it pulls 720x480 and my wife things it looks just like watching normal tv, i only use HD for sports anyways
[19:59] <MacNean> thinks not things
[19:59] <mlester> gotcha which card does hd
[20:00] <MacNean> most only do OTA
[20:00] <MacNean> look at HDHomeRUn
[20:00] <MacNean> Hauppauge has a new device
[20:00] <MacNean> that will pull the HD from the cable box over component
[20:00] <mlester> because I don't have hd at the moment
[20:00] <MacNean> depends what you think cheap is tho, both those run around $200 IIRC
[20:00] <mlester> but I am just thinking in advanced
[20:01] <mlester> I am thinking more less than 80
[20:01] <MacNean> my father bought a pvr 500 cause it pulls 2 channels from 1 input
[20:01] <mlester> ah thats pretty cook
[20:01] <mlester> cool
[20:03] <MacNean> problem is i odn't know if they make them anymore, and I haven't kept on the ivtv development (the linux drivers to run the hauppauge cards) to know if the newer cards are supported
[20:04] <mlester> I see
[20:04] <MacNean> also I know pinaccle has a card that does HD over cable/air (unencrptyed) and i think also pulls normal channels
[20:05] <mlester> whats it called
[20:06] <mlester> or what would be equivalent to the pvr500
[20:07] <MacNean> it's pctv hd but don't know about linux support
[20:07] <mlester> yeah and the pinnacle card looks like it gets bad reviews on newegg
[20:07] <MacNean> there's also some pvr500's on ebay usually
[20:07] <MacNean> i bout a pvr250 on ebay, and it went bad like 8 months later, hauupage replaced it free (i just had to ship it to em)
[20:08] <mlester> thats cool
[20:08] <MacNean> i really like hauppage, they've replaced 2 bad cards, like one was 2 years after i bought it new
[20:08] <MacNean> no problems for my father and me with the pvr500's we have
[20:08] <MacNean> anyways back to hacking my appletv
[20:08] <mlester> have u heard anything about http://www.newegg.com/Product/Product.aspx?Item=N82E16815122008
[20:08] <MacNean> i can't figure out how to get it not to go to sleep
[20:09] <MacNean> no sorry
[20:09] <MacNean> !help
[20:09] <Zinn> Use ! followed by a topic to get help on the topic (if it exists) example: !logs.  Other available commands: !status, !about, !bug [bug_number].  For a  complete list of my knowledge visit: http://www.baablogic.net/Zinn.cgi
[21:17] <hansoffate> anyone know how to fix the mysql db?
[21:17] <hansoffate> Fatal Error at /usr/share/mythtv/mythweb/objects/Database/Query/mysql.php, line 83:
[21:17] <hansoffate> SQL Error: Table './mythconverg/oldrecorded' is marked as crashed and should be repaired [#145]
[21:22] <Arthur> hi people. I have horizontal lines while watching my analog TV on mythtv. any ideas why?
[22:35] <rhpot1991> hansoffate: run /usr/share/doc/mythtv-backend/contrib/optimize_mythdb.pl
[22:37] <hansoffate>  rhpot1991 i'm in the contrib folder, there is no optimize_mythdb.pl
[22:38] <rhpot1991> it might be compressed see if there is anything with a similiar name
[22:38] <hads> hads@snowman:~$ dpkg -S /usr/share/doc/mythtv-backend/contrib/optimize_mythdb.pl
[22:38] <hansoffate> nevermind.  i found it with locate.  i ran it with: perl optimize_mythdb.pl
[22:38] <hads> mythtv-backend: /usr/share/doc/mythtv-backend/contrib/optimize_mythdb.pl
[22:39] <hansoffate> but it said cannot connect to database
[22:39] <hads> hmysqlcheck will do the same thing
[22:39] <hads> erm, mysqlcheck
[22:40] <hads> Are you running it as a user that can run mythtv?
[22:40] <hansoffate> hads: i found optimie_mythdb.pl
[22:40] <hansoffate> yup
[22:40] <baggar11> updated system to 2.6.27-7 and now I lost sound. alsamixer seems to be pointing to saa7134 audio instead of onboard audio. Any help?
[22:40] <hansoffate> sudo perl optimize_mythdb.pl
[22:40] <hansoffate> DBI connect('database=mythconverg:host=localhost;port=3306','mythtv',...) failed: Access denied for user 'mythtv'@'localhost' (using password: YES) at /usr/share/perl5/MythTV.pm line 337
[22:40] <hansoffate> Cannot connect to database:
[22:40] <hansoffate> i just tried it with sudo, and it gave the same error
[22:41] <hads> Yeah sudo won't help
[22:41] <hads> I'm not sure why you would be able to run mythfrontend but not that though I don't know how the perl bindings does it's lookup.
[22:41] <hansoffate> i can just connect to the myswl database and run the commands it says in the script though
[22:42] <hads> Yeah but you would have to do it for each table.
[22:42] <hansoffate> i'll login with the mysql root account and run the Repair and Optimize table on the table thats having the issue
[22:42] <hads> `mysqlcheck -r mythconverg` will do it.
[22:42] <hansoffate> i'm only getting a problem with the "oldrecorded" table
[22:43] <hads> It's worthwhile running over all the tables though, if one is corrupt then chances are others are.
[22:45] <hansoffate> i ran it with `mysqlcheck -u root -p -r mythconverg`  instead so i can login
[22:45] <rhpot1991> I wonder if your mysql isn't running, it can crash and stop running if the hard drive gets filled or other problems happen
[22:46] <hansoffate> hads:  thanks, that command worked.  It fixed the oldrecorded table( only one) and now mythweb works
[22:46] <hansoffate> good to know that mysqlcheck command too, i'm sure ti'll come in handy later
[22:47] <hads> Cool. Not sure why the perl bindings can't connect on your system though.