slick666 | what database should I look at repairing? | 00:00 |
---|---|---|
=== aclose is now known as aclose|away | ||
slick666 | I'm still pretty green on myth's backend | 00:00 |
slick666 | actually poking around seems to have revealed more of the problem | 00:07 |
slick666 | * Starting MySQL database server mysqld [ OK ] | 00:08 |
slick666 | * Checking for corrupt, not cleanly closed and upgrade needing tables. | 00:08 |
slick666 | landon@MythBox:~$ ERROR 126 (HY000) at line 1: Incorrect key file for table '/tmp/#sql_1cb6_0.MYI'; try to repair it | 00:08 |
slick666 | the reason the sql database has an error is because it's in the /tmp directory | 00:08 |
slick666 | upon reboot /tmp is cleared so the database Does not exist | 00:08 |
hads | The database name should be mythconverg | 00:09 |
slick666 | but why would the system be trying to open a database in a temp directory | 00:10 |
hads | No idea, might be something to do with how the init script checks tables. | 00:10 |
slick666 | I think what I want to do is remove the file location from mysql's database listing (or something like that) | 00:11 |
slick666 | I think it was referenced when the system hung | 00:11 |
slick666 | since I rebooted the machine the database dne | 00:12 |
slick666 | so I have to tell mysql that it does not exist anymore, stop trying to access it | 00:12 |
hads | mysqlcheck -A will check all database tables | 00:12 |
slick666 | tat command comes back as all clean | 00:14 |
slick666 | hmmmm | 00:15 |
slick666 | maybe a reboot is in order | 00:15 |
=== aclose|away is now known as aclose | ||
mib_gvq4gmer | 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 | 00:50 |
slick666 | ok guys, I rebooted and no dice | 01:10 |
slick666 | I get the error | 01:10 |
slick666 | Database error was: No database selected | 01:10 |
slick666 | even when I run mythbackend-setup | 01:11 |
slick666 | Anyone have any ideas on how to fix this | 01:12 |
slick666 | if I can't configure the backend what can I do to fix the software? | 01:12 |
tgm4883 | slick666, which iso did you use to install? | 01:51 |
slick666 | Mythbuntu 8.04 | 01:53 |
slick666 | a while ago | 01:53 |
slick666 | been upgrading ever since | 01:53 |
slick666 | I think I figured out the configuration for the database with the exception of the password | 01:54 |
slick666 | Score, I think the loging should be -u root -p '' | 02:05 |
slick666 | (blank password) | 02:05 |
slick666 | at least mythfilldatabase is doing something | 02:05 |
Shadow__X | !mysql | 02:46 |
Zinn | 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 |
Shadow__X | !password | 02:46 |
Zinn | Sorry I don't know about password | 02:46 |
Shadow__X | !default | 02:46 |
Zinn | Sorry I don't know about default | 02:46 |
Shadow__X | hmm | 02:46 |
Shadow__X | !help | 02:47 |
Zinn | !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 |
Shadow__X | slick666, in /var/mythtv | 02:47 |
Shadow__X | there is mysql.txt that has the mythtv password | 02:47 |
Shadow__X | for root i am not sure but running as a user root you should beable to switch it | 02:47 |
thedarkone | is there a way to unformat a drive | 03:16 |
MythbuntuGuest26 | 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 |
MythbuntuGuest26 | videos will play through vlc on the box without a single problem (with sound too) | 03:21 |
wombo1 | Is the ubuntu forums down for anybody else? | 10:30 |
wombo1 | 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' | 10:32 |
wombo1 | Looks like its up and running again now | 11:06 |
JEDIDIAH__ | your sound problems could be due to any number of things... including the sound being on mute. '-) | 14:21 |
tracypeek | 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:58 |
rhpot1991 | tracypeek: I can help you out with the user job portion, but not with the handbrake portion | 15:59 |
rhpot1991 | tracypeek: http://www.mythtv.org/wiki/User_job | 15:59 |
rhpot1991 | also you can look at the user job portions of this: https://help.ubuntu.com/community/MythExport_old | 15:59 |
tracypeek | Thanks for the info ... I will look at that first! Thanks Again! | 16:00 |
rhpot1991 | yell if you have any questions | 16:00 |
asphere | I set up ACPI sleep/wake as per: http://www.mythtv.org/wiki/ACPI_Wakeup | 17:44 |
asphere | System woke up last night and recorded a show. very nice | 17:44 |
asphere | but it didn't go back to sleep again | 17:44 |
asphere | Do I need to make sure the frontend doesn't autostart if I want it to go back to sleep? | 17:44 |
foxbuntu | asphere, yes, i believe you need to use and adjust the settings in mythwelcome | 18:48 |
foxbuntu | asphere, but I am not positive on that | 18:49 |
asphere | Thanks. Checking into mythwelcome. I think it's the ticket | 18:51 |
thedarkone | hello | 19:20 |
thedarkone | for some reason i can't get channel changer to work with comcast | 19:20 |
tgm4883 | anyone recommend a dtv converter box? | 22:41 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!