Arch Linux

86turbodsl

Member

Registered: 2006-10-11

Posts: 7

mysql problems with network connectivity / mythtv

I'm having big problems that I can't solve with my mysql install.  I'm running the most current mysql packages, and trying to install mythtv on top of it.

I can install and run my mythbackend script no problem as long as I use localhost as the parameter for backend connections.  As soon as I try to use my IP address in .mythtv/mysql.txt I get the following error:

[mythtv@mythtv .mythtv]$ mythbackend
2006-10-11 00:34:01.871 Using runtime prefix = /usr/local
2006-10-11 00:34:01.881 New DB connection, total: 1
2006-10-11 00:34:01.886 Unable to connect to database!
2006-10-11 00:34:01.887 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'mythtv' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-10-11 00:34:01.942 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-11 00:34:01.997 Failed to init MythContext, exiting.
[mythtv@mythtv .mythtv]$

I made sure I had skip-networking commented out in my /etc/my.cnf file,
I see from some posts that tcpwrappers is a potential pitfall, so I checked my hosts/deny/allow files and they are as follows:

#
# /etc/hosts.allow
#
sshd: 192.168.123.0/255.255.255.0
mysqld: 192.168.123.0/255.255.255.0
mysqld-max : ALL : ALLOW
# End of file

#
# /etc/hosts.deny
#

ALL: ALL: DENY

# End of file

Does anyone have any ideas?  I have been through ALL of the mysql help site at http://dev.mysql.com/doc/refman/5.0/en/ … enied.html
and nothing seems to work.  I'm completely stumped and I'd like to get this working, as I use a remote connection on my internal net to connect to the mysql database for mythtv usage, and this is preventing it.

Thanks in advance.
Mark

luca

Member

From: Rome

Registered: 2005-10-30

Posts: 280

Re: mysql problems with network connectivity / mythtv

Hi 86turbodsl,
try with this:
within mysql command prompt assign permissions to mythtv user:

grant all privileges on <dbname>.* to 'mythtv'@'mythtv' identified by '<user>'

86turbodsl

Member

Registered: 2006-10-11

Posts: 7

Re: mysql problems with network connectivity / mythtv

Ok, this is what I entered:

mysql>  grant all privileges on mythconverg.*  to 'mythtv'@'%'  identified by 'mythtv';
mysql> flush privileges;

I changed to % for hostname so I could get on anywhere.

This is my output when running mythbackend:

[mythtv@mythtv ~]$ mythbackend
2006-10-11 12:43:32.792 Using runtime prefix = /usr/local
2006-10-11 12:43:32.802 New DB connection, total: 1
2006-10-11 12:43:32.807 Unable to connect to database!
2006-10-11 12:43:32.807 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'mythtv' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-10-11 12:43:32.866 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-10-11 12:43:32.922 Failed to init MythContext, exiting.
[mythtv@mythtv ~]$

OK, I just tried it again by granting privileges EXACTLY as you suggested, and find it now works.  BUT, I don't understand WHY.   Shouldn't the mythtv@mythtv restrict my usage to that particular hostname?

luca

Member

From: Rome

Registered: 2005-10-30

Posts: 280

Re: mysql problems with network connectivity / mythtv

The % char has special meaning in mysql (it means all host) but '%' is interpreted as an host with name %