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

Michael Jones m_g_j at michaelandholly.com
Sat Jul 2 00:17:40 EDT 2005


Marc, 

Thanks.. I'll give that part a shot..

However, 

Acutally I can only connect to the mysql database LOCALLY as root.. I can't
do squat from a remote front end (root or otherwise). .

I may have to dig into the bind addresses or something..

- Michael


> From: Marc Tousignant <drayson at net1plus.com>
> Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
> Date: Fri, 1 Jul 2005 21:34:45 -0400
> To: 'Discussion about mythtv' <mythtv-users at mythtv.org>
> Subject: RE: [mythtv-users] Frontends can't find database, can't connect
> 
> Mike,
> 
> Follow this
> yggdrasil ~ # mysql -uroot -p
> mysql> show databases;
> mysql> use mysql;
> mysql> select * from user where User = 'mythtv';
> 
> you should see atleast 2 records
> | %         | mythtv
> | localhost | mythtv
> 
> If you do not see the % one create a the user
> GRANT USAGE ON *.* TO 'mythtv'@'%' IDENTIFIED BY 'mythtv';
> % is the one that would allow the user to connect from a remote location
> 
> You say root can connect remotely so I do not thing the bind address needs
> to be changed.
> 
> 
>> -----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 8: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
>> 
>> 
> 
> 
> _______________________________________________
> 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