[mythtv-users] New install and my problmes.

[Damian Surr]

> You might want to check whether you can use mysql as the 'root' user 
> (that is, 'root' for mysql, not the system root.) You can try this while 
> logged in as a normal linux user.
>
> Try 'mysql -u root -p  mysql;' It will ask for the password. On Fedora 
> the default is actually no password at all!. The mysql database keeps 
> all the system data. Then type:
>
> select host,user,password from user;
>
> You should get something like:
>
> +-------------------+----------+------------------+
> | host              | user     | password         |
> +-------------------+----------+------------------+
> | localhost         | root     |                  |
> | localhost         | geoff    | 330040e53766a829 |
> | localhost         | mythtv   | 0476fc026afffe24 |
> +-------------------+----------+------------------+
>
>   
Thanks for responding Geoff

To begin with, I was getting this:
mysql> select host,user,password from user;
+-----------+------------------+------------------+
| host      | user             | password         |
+-----------+------------------+------------------+
| localhost | root             |                  |
| MythBox   | root             |                  |
| localhost | debian-sys-maint | 4bfb03e20e6b2002 |
| localhost | mythtv           | 0476fc026afffe24 |
| %         | mythtv           | 0476fc026afffe24 |
+-----------+------------------+------------------+
5 rows in set (0.01 sec)

> This will at least tell you what your users are, and whether a password 
> has been set. If a password has been set for mysql user mythtv, you can 
> delete that user ( delete from user where user = 'mythtv';) (yes that is 
> confusing, one user is the table, and the other is the field).
>   
I followed your instructions and got this:
mysql> select host,user,password from user;
+-----------+------------------+------------------+
| host      | user             | password         |
+-----------+------------------+------------------+
| localhost | root             |                  |
| MythBox   | root             |                  |
| localhost | debian-sys-maint | 4bfb03e20e6b2002 |
+-----------+------------------+------------------+
3 rows in set (0.00 sec)

> Then go back and run the mysql setup script, mc.sql (the one that starts 
> 'create database if not exists mythconverg', That script creates the 
> 'mythtv' mysql user, and sets his/her/its password.
>   
I couldn't get anywhere with the above instructions. I'm sure it's 
completely obvious to anyone who knows, but I tried following the 
instructions and it didn't get me any further.

I searched the net for Mythtv and Mysql and looked for anything 
relevant. A couple of pages came up with a couple of things that I tried.
The end of one page had these commands that seemed to work ok:
sudo mythbackend &
sudo mythfilldatabase

I think it was after doing all of the above that going into the front 
end let me watch TV again. Result!, but still lots of problems.

Another page on the Ubuntu forums recommended this ..
sudo /usr/bin/mysql_install_db
sudo /usr/bin/mysqladmin -u root -h localhost password ''
sudo dpkg-reconfigure --force mythtv-database

All seemed to go well, but now I have:
mysql> select host,user,password from user;
+-----------+------------------+------------------+
| host      | user             | password         |
+-----------+------------------+------------------+
| localhost | root             |                  |
| MythBox   | root             |                  |
| localhost | debian-sys-maint | 4bfb03e20e6b2002 |
| %         | mythtv           | 32b1b1fb4cb0846d |
| localhost | mythtv           | 32b1b1fb4cb0846d |
+-----------+------------------+------------------+

Still, I had TV again, so that's something.

Just rebooted and I don't have TV again. Mythfrontend just gives me 
LOADS of errors like this:
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-02-02 10:33:32.384 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2007-02-02 10:33:33.996 Unable to connect to database!
2007-02-02 10:33:33.996 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-02-02 10:33:34.052 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2007-02-02 10:33:34.104 Failed to init MythContext, exiting.

> Now, your mythtv user should be able to access the mysql database.
> BTW this *is* in the documentation....
>   
Where in the documentation should I be looking? Sorry if I seem stupid, 
but I can usually find everything I need for anything on google within a 
minute or two. This has me stumped. I'm sure (and hope) it looks very 
simple from the outside, but not from here.

Is there a way to reset whatever's going on with mysql, or myth, or 
whatever the problem may be?

Is there any more information I can provide from my system that could 
help to work it out?

Thanks again fro your help Geoff.

Cheers
Damian