[mythtv-users] Frontends can't find database, can't connect

Korey Fort k.m.fort at gmail.com
Fri Jul 1 20:48:34 EDT 2005


Mythtv lacks permission to log in. Try reading this:
http://dev.mysql.com/doc/mysql/en/adding-users.html


-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Michael Jones
Sent: Friday, July 01, 2005 7:20 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Frontends can't find database, can't connect

Ok.. this is getting a little frustrating.. Sorry if this is a little
disjointed.. but my brain is bouncing around in my head trying to wrap
itself around this properly ;)



Note:

>From the machine running the masterbackend I can only access the database
as
root.. not mythtv as I am assuming I should be.

Everything *SEEMS* to work as root.. but maybe not really.

I can't log into mysql from the command line at all as 'mythtv'


Transcript: ... 

[root at myth database]# mysql -u root -p mythconverg
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 84 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from user where User = 'mythtv';
ERROR 1146: Table 'mythconverg.user' doesn't exist
mysql> 

Kinda weird.  Mysql says I don't have a table called 'user' (tried 'users'
too)????

------------------------------------------------------------
/etc/my.cnf file
------------------------------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = key_buffer = 16M
set-variable = table_cache = 128
set-variable = sort_buffer = 2M
set-variable = myisam_sort_buffer_size = 8M
#bind-address = 192.168.0.40

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
------------------------------------------------------------
if uncomment the bind-address entry into the mysqld area, mysqld won't start
up.  Is this a mysql4 command.. I'm still on 3 it appears.  I've tried
different variations with no changes

The only attempt that allowed me to start mysqld was to put the
bind-address=x.x.x.x in the [mysql.server] section, but it didn't change the
final outcome at all.

the error that I get from the mythtv-setup and mythfrontend entries are:

QMYSQL3: Unable to connect
Database Error Was:
Access denied for user: 'mythtv at fozzie.michaelandholly.com' (Using password:
YES)

I get the same result from other machines (a Windows machine running
WinMythtv and a MacOSX 10.4 (tiger) machine running MacMythtv frontend.

I've also tried setting it to connect as root (just for giggles) with the
same result. 

I've also tried the security setup described in
http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 with no joy (Tried all
3 levels.. none, domain level security and ip address security).

It almost seems as though the mythconverg database is all fubar'd.. but it
might be something simple..

Help? 

- Michael 


> From: Korey Fort <k.m.fort at gmail.com>
> Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
> Date: Fri, 1 Jul 2005 03:09:15 -0500
> To: 'Discussion about mythtv' <mythtv-users at mythtv.org>
> Subject: RE: [mythtv-users] Frontends can't find database, can't connect
> 
> 
> You can try mysqlaccess mythtv to see what access mythtv has or
>  Log into mysql then use mysql; select * from user where User = 'mythtv';
> This will show you where mythtv is allowed to connect from.
> 
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Michael Jones
> Sent: Friday, July 01, 2005 2:30 AM
> To: Discussion about mythtv
> Subject: [mythtv-users] Frontends can't find database, can't connect
> 
> When I try to configure a remote frontend (I've tried another FC3 box, a
Mac
> OSX box.. haven't tried the Windows front end yet) it tells me that it
can't
> find the database.
> 
> The messages that come up on screen say that the current user isn't
allowed
> to connect to the remote machine..
> 
> I'm not sure where to start looking for a solution to this.
> 
> Is there some portion of mysql that may not be running (i.e. the server?)
> when mysqld is started?
> 
> Any ideas. 
> 
> Thanks Much. 
> 
> - Michael
> 
> 
> 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users






More information about the mythtv-users mailing list