[mythtv-users] Orphaned files
Brian Walter
blwalter at gmail.com
Thu Jun 14 16:36:35 UTC 2007
Mitch Gore wrote:
>
>
> On 6/14/07, *David Watkins* <watkinshome at gmail.com
> <mailto:watkinshome at gmail.com>> wrote:
>
> > Well i figured out how to drop the password. but now i get this
> error...
> >
> > [root at mythtv contrib]# perl myth.find_orphans.pl
> > DBI
> > connect('database=mythconverg:host=mythtv','mythtv',...)
> > failed: Unknown MySQL server host 'mythtv' (1) at
> myth.find_orphans.pl line
> > 99
> > Cannot connect to database mythconverg on host mythtv:
> > [root at mythtv contrib]#
> >
>
> Looks like you dropped a more than just the password.
>
> You could have a look here
>
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html
>
> at the bit about the 'grant all' command.
> _______________________________________________
>
>
>
> ok, i redid the passwords and everything but still it doesnt work...
>
>
> mysql> UPDATE user SET Password="" WHERE user='mythtv';
> Query OK, 2 rows affected (0.05 sec)
> Rows matched: 2 Changed: 2 Warnings: 0
>
> mysql> select host, user, password from user;
> +-------------+--------+------------------+
> | host | user | password |
> +-------------+--------+------------------+
> | localhost | root | 43e881156edcc165 |
> | Mitchell_MC | root | 43e881156edcc165 |
> | localhost | mythtv | |
> | % | mythtv | |
> +-------------+--------+------------------+
> 4 rows in set (0.00 sec)
>
> mysql> exit
> Bye
> [root at mythtv contrib]# perl myth.find_or*
> DBI connect('database=mythconverg:host=mythtv','mythtv',...) failed:
> Unknown MySQL server host 'mythtv' (1) at myth.find_orphans.pl line 99
> Cannot connect to database mythconverg on host mythtv:
> [root at mythtv contrib]#
>
> The password is definately not there but i still get the same error.
> Does this script for sure with with atrpms-bleeding .21?
>
>
>
> Mitchell
>
Out of curiosity, is the machine name actually 'mythtv'? Is it defined
in /etc/hosts? Can you connect via ip address?
Brian
More information about the mythtv-users
mailing list