AVS Forum banner
1 - 20 of 30 Posts

·
Registered
Joined
·
49 Posts
Discussion Starter · #1 ·
I had updated to the latest kernel recently ( I have mythbuntu 8.04 installed ) and finally rebooted today and everything restarted just fine. For kicks I decided to try running the mysqlcheck to see if everything was ok in mysql. For some reason I couldn't get it to work... I stopped mythbackend, tried running mysqlcheck it complained about a password, I stopped/started mysql and finally gave up. I restarted the backend and went to start the frontend and it went to a screen asking to pick my language and the database login info.... it couldn't start the frontend.


I was able to connect to mysql as root and tried looking at the users table for the mythtv user and it said the mythconverg.users table doesn't exist? What did I do?
 

·
Registered
Joined
·
566 Posts
Don't know what you did, but you can simply add the table and users, or just reload the mythconverg database. Of course if you reload the db, you'll have to reconfigure everything. Not a big problem unless you have multiple frontends. Might be best anyway in case something else is missing.
 

·
Banned
Joined
·
2,107 Posts
From the mysqlcheck ref page --> http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html :
Quote:
Caution


It is best to make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data loss. Possible causes include but are not limited to filesystem errors.

So, apparently, this is what happened. Assuming nothing else got messed up in mythconverg, you should be able to add the mythtv user again. If it were me, though, I'd drop the database and start with a fresh one. And since I was starting with a fresh db, I'd take the opportunity to go ahead and upgrade to 8.10. That's just me, though -- you may have reasons for sticking with 8.04.
 

·
Banned
Joined
·
1,686 Posts
I suspect that you ran mysqlcheck while the backend was still running.


And I guess you other guys say don't update from hard experience, but I've done a couple updates to kernel and mythtv.svn without problems. Maybe they've fixed some glitches, and also you gotta stop everything Myth. My most recent svn compile advised that it has to upgrade the database schema, and that went without a hitch.


Scared to death at the moment tho, as they're saying my Seagate 1TB has defective firmware which could cause the drive to wink out. For a long time they said this only applies to the 1.5TB, but now they're saying also the 500GB and 1TB. Can't download the firmware, and of course Seagate is gone for the holidays.
 

·
Registered
Joined
·
4,894 Posts
^^^ I've had a 500GB Seagate for about a year now and have beat the hell out of it without it having any problems (knock on wood).


I've probably run 3TB of data through it so far since it's used to store HD captures and DVD rips until I get around to watching them.
 

·
Banned
Joined
·
1,686 Posts
I've been a Seagate acolyte for a long time, but check this:
http://www.avsforum.com/avs-vb/showt...php?p=15423940


I've read the major threads on AVS and Seagate forums, and there is indeed a serious problem with the 7200.11 class of drives. I've just ordered a Seagate 1.5TB for backups, and when the 1TB fails I'll get it replaced and sell it for another 1.5TB to build RAID.


May even return it before then. May rebuild anew with Hardy, as I hate KDE4... too limited.
 

·
Registered
Joined
·
1,591 Posts
Do you have a backup of your mythconverg db? If not, I'd vote for just redoing it if it isn't too much work - and then doing regular backups.


I'm too chicken to keep upgrading. Scarred from past experiences. All were fixable, but now I have too many machines to troubleshoot with upgrades, so I just keep one of my laptops upgraded to latest packages and versions of ubuntu, and my primary desktop keeps updated on the latest packages, but it is still on 8.04 (mint elyssa, but I only update the ubuntu packages after I had some problems with flash with the mint packages).
 

·
Registered
Joined
·
49 Posts
Discussion Starter · #14 ·
I was thinking of having a friend of mine send me the sql to recreate the users table to see if that works. I was hoping to stay on 8.04 just because that version of Ubuntu is the LTS one. I'm not completely opposed to wiping out the database... I've watched all the shows on there.... just resetting up all the options would be a pain.
 

·
Banned
Joined
·
2,107 Posts

Quote:
Originally Posted by kbrunsting /forum/post/15426053


I was thinking of having a friend of mine send me the sql to recreate the users table to see if that works. I was hoping to stay on 8.04 just because that version of Ubuntu is the LTS one. I'm not completely opposed to wiping out the database... I've watched all the shows on there.... just resetting up all the options would be a pain.
Code:
Code:
CREATE DATABASE IF NOT EXISTS mythconverg;
GRANT ALL ON mythconverg.* TO [email protected] IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO [email protected] IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
 

·
Registered
Joined
·
49 Posts
Discussion Starter · #16 ·
Should the character set be utf8 or latin1? there's an mc.sql file that shows latin1 instead.


So is the users table part of the mythconverg database or is that part of mysql? I run the grants listed above and it says 0 rows affected.
 

·
Banned
Joined
·
2,107 Posts

Quote:
Originally Posted by kbrunsting /forum/post/15426709


Should the character set be utf8 or latin1? there's an mc.sql file that shows latin1 instead.


So is the users table part of the mythconverg database or is that part of mysql? I run the grants listed above and it says 0 rows affected.

That is the mc.sql from svn, so I'd stick with utf8. From wikipedia --> http://en.wikipedia.org/wiki/UTF-8 :
Quote:
UTF-8 (8-bit UCS/Unicode Transformation Format) is a variable-length character encoding for Unicode. It is able to represent any character in the Unicode standard, yet the initial encoding of byte codes and character assignments for UTF-8 is backwards compatible with ASCII. For these reasons, it is steadily becoming the preferred encoding for e-mail, web pages,[1] and other places where characters are stored or streamed.

"0 rows affected" is the correct response for grants. Not 100% sure about the users table. I think mysql takes care of this when you set the grants and mythtv connects.


EDIT: make sure that your db password in mythtv and in the sql above (identified by) match.
 

·
Registered
Joined
·
49 Posts
Discussion Starter · #18 ·
ok, I'm getting closer... I tried running these


sudo dpkg-reconfigure mythtv-database

sudo dpkg-reconfigure mythtv-common


and it seemed to have restored the relationship between the mythconverg and mysql databases and things seem able to login to mythconverg now, but now the frontend is saying it can't connect to the backend... now I must have screwed something else up.
 

·
Banned
Joined
·
2,107 Posts
In the frontend, go to Utilities/Setup|Setup|General and verify that the password is the same that you used in the sql "identified by" that you used. Also, verify that mythbackend is running:
Code:
Code:
sudo /etc/init.d/mythtv-backend restart
 
1 - 20 of 30 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top