[mythtv-users] Problem accessing files on remote backend

[H P Ladds]

>
> I'm starting to think about access permissions on my remote backend
> mysql or maybe my backend database doesn't know its real host name. I
> think I can feel the water reaching my chin. Boy am I seriously out of
> my depth.
> Mal
>
> [new extract of new log]
> 2006-10-16 22:49:55.332 Using runtime prefix = /usr
> 2006-10-16 22:49:55.355 DPMS is active.
> 2006-10-16 22:49:55.380 New DB connection, total: 1
> 2006-10-16 22:50:03.430 Unable to connect to database!
> 2006-10-16 22:50:03.430 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'192.168.0.6' (using password: YES)
>
> 2006-10-16 22:50:11.526 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-10-16 22:50:19.615 Unable to connect to database!
> 2006-10-16 22:50:19.615 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'192.168.0.6' (using password: YES)



Have tried the following from http://www.mythtv.org/docs/mythtv-HOWTO-6.html


Modifying access to the MySQL database for multiple systems

If you're going to have multiple systems accessing a master database, you
must grant access to the database from remote systems. By default, the
mc.sql script is only granting access to the local host.

To allow other hosts access to your master database, you can either set it
up for no security at all, or with more granularity. Note that the "%" is
the wildcard character in MySQL.

  *NOTE*: The "no security" option is *very* dangerous unless you're in a
controlled environment. This example has no security at all, and allows
access from any host.

$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
mysql> flush privileges;

For a more secure setup, you can restrict which machines or subnets have
access. If you have a complete DNS system operational, you could do the
following:

$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"%.mydomain.com"
identified by "mythtv";
mysql> flush privileges;

Finally, if you just want to restrict by IP subnet (in this example, the
192.168.1. network):

 $ mysql -u root mythconverg
mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified
by "mythtv";
mysql> flush privileges;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20061016/d279df7f/attachment.htm