[00:00] what database should I look at repairing? === aclose is now known as aclose|away [00:00] I'm still pretty green on myth's backend [00:07] actually poking around seems to have revealed more of the problem [00:08] * Starting MySQL database server mysqld [ OK ] [00:08] * Checking for corrupt, not cleanly closed and upgrade needing tables. [00:08] landon@MythBox:~$ ERROR 126 (HY000) at line 1: Incorrect key file for table '/tmp/#sql_1cb6_0.MYI'; try to repair it [00:08] the reason the sql database has an error is because it's in the /tmp directory [00:08] upon reboot /tmp is cleared so the database Does not exist [00:09] The database name should be mythconverg [00:10] but why would the system be trying to open a database in a temp directory [00:10] No idea, might be something to do with how the init script checks tables. [00:11] I think what I want to do is remove the file location from mysql's database listing (or something like that) [00:11] I think it was referenced when the system hung [00:12] since I rebooted the machine the database dne [00:12] so I have to tell mysql that it does not exist anymore, stop trying to access it [00:12] mysqlcheck -A will check all database tables [00:14] tat command comes back as all clean [00:15] hmmmm [00:15] maybe a reboot is in order === aclose|away is now known as aclose [00:50] This may be a very stupid question! If I install Mythbuntu, does it boot straight to Myth TV & not go through all the Ubuntu desktop stuff? Thanks [01:10] ok guys, I rebooted and no dice [01:10] I get the error [01:10] Database error was: No database selected [01:11] even when I run mythbackend-setup [01:12] Anyone have any ideas on how to fix this [01:12] if I can't configure the backend what can I do to fix the software? [01:51] slick666, which iso did you use to install? [01:53] Mythbuntu 8.04 [01:53] a while ago [01:53] been upgrading ever since [01:54] I think I figured out the configuration for the database with the exception of the password [02:05] Score, I think the loging should be -u root -p '' [02:05] (blank password) [02:05] at least mythfilldatabase is doing something [02:46] !mysql [02:46] If you are having problems connecting to your mysql database, you can perform the following to reconfigure it: 1. sudo dpkg-reconfigure mysql-server-5.0 (pay attention to the root password you set, you will need it for the next step) 2. sudo dpkg-reconfigure mythtv-database 3. sudo dpkg-reconfigure mythtv-common [02:46] !password [02:46] Sorry I don't know about password [02:46] !default [02:46] Sorry I don't know about default [02:46] hmm [02:47] !help [02:47] !help For a complete list of my knowledge visit: http://www.baablogic.net/Zinn.cgi Other available commands: !status, !about, !bug [bug_number]. [02:47] slick666, in /var/mythtv [02:47] there is mysql.txt that has the mythtv password [02:47] for root i am not sure but running as a user root you should beable to switch it [03:16] is there a way to unformat a drive [03:21] Hey, is there something special that I have to do to get the music player in mythbuntu 8.04 to work? I figured I'd just point it at an .mp3 file, which it sees, but when I click play, nothing happens...the pause button lights up, when I try to escape out it says something like "do you want to leave the music playing?"...but I get nothing [03:21] videos will play through vlc on the box without a single problem (with sound too) [10:30] Is the ubuntu forums down for anybody else? [10:32] haha I dont know if it was me but I tried to do a wget from an attached file. Next thing no PC's in my place get get to the forums at all due to a 'Database Error' [11:06] Looks like its up and running again now [14:21] your sound problems could be due to any number of things... including the sound being on mute. '-) [15:58] Good Morning! Has anyone here had success at running User Jobs? I would like to convert my .mpg's to .mp4 with HandBrakeCLI after a recording has finished. Ant ideas? [15:59] tracypeek: I can help you out with the user job portion, but not with the handbrake portion [15:59] tracypeek: http://www.mythtv.org/wiki/User_job [15:59] also you can look at the user job portions of this: https://help.ubuntu.com/community/MythExport_old [16:00] Thanks for the info ... I will look at that first! Thanks Again! [16:00] yell if you have any questions [17:44] I set up ACPI sleep/wake as per: http://www.mythtv.org/wiki/ACPI_Wakeup [17:44] System woke up last night and recorded a show. very nice [17:44] but it didn't go back to sleep again [17:44] Do I need to make sure the frontend doesn't autostart if I want it to go back to sleep? [18:48] asphere, yes, i believe you need to use and adjust the settings in mythwelcome [18:49] asphere, but I am not positive on that [18:51] Thanks. Checking into mythwelcome. I think it's the ticket [19:20] hello [19:20] for some reason i can't get channel changer to work with comcast [22:41] anyone recommend a dtv converter box?