[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