LinHES Forums
http://forum.linhes.org/

Stupid myth.rebuilddatabase.pl question
http://forum.linhes.org/viewtopic.php?f=5&t=11665		 Page 1 of 1
Author:  dothedog [ Sat Sep 16, 2006 3:36 pm ]
Post subject:  Stupid myth.rebuilddatabase.pl question
I did a stupid thing and restored an old backup and now I am missing about 2 months of recorded shows in Myth. I found myth.rebuilddatabase.pl and it looks like it will do what I want. I tried this:

myth.rebuilddatabase.pl --user mythtv --pass mythtv --dir /mnt/video/TV --host localhost

and I get the following error:
DBI connect('database=mythconverg;host=tv','mythtv'....) failed; Can't connect MySQL server on 'tv' (111)at /usr/local/bin/myth.rebuilddatabase.pl line 120 Cannot connect to database ()

Line 120 in myth.rebuilddatabase.pl is:
'pass='=>\#pass, (or some such, its hard to read on the tv screen;)

Any ideas?

Thanks for the help.

Rob
Author:  nigelpearson [ Sun Sep 17, 2006 6:07 am ]
Post subject: 
I suspect the problem is something to do with your machine's network setup, because it is getting the name 'tv' when you specify 'localhost'.

What happens if you do:
Code:
myth.rebuilddatabase.pl --try_defaults
(maybe with --dir /mnt/video/TV if that is needed due to reconfig)
Author:  manicmike [ Sun Sep 17, 2006 7:20 am ]
Post subject: 
nigelpearson wrote:
I suspect the problem is something to do with your machine's network setup, because it is getting the name 'tv' when you specify 'localhost'.

What happens if you do:
Code:
myth.rebuilddatabase.pl --try_defaults
(maybe with --dir /mnt/video/TV if that is needed due to reconfig)


I tried using that script after upgrading to r5d1, and it failed totally because it was looking only for .nuv files (line #193). I attempted to quickly modify it (clearly it is no longer good for recent upgrades).

I'm going to work on a newer version that uses bash, sed, awk and mysql client. I'll post it when it's done.

Mike
Author:  tjc [ Sun Sep 17, 2006 9:20 am ]
Post subject: 
There is (or used to be) an option to tell it what file types to look for...

Searching for the name of the script should turn up a thread with the details. There have been 2-3 recently.
Author:  nigelpearson [ Mon Sep 18, 2006 1:38 am ]
Post subject: 
manicmike wrote:
I tried using that script after upgrading to r5d1, and it failed totally because it was looking only for .nuv files


Yes, KnoppMyth currently has an old version. For now, grab the latest from here:

http://cvs.mythtv.org/trac/browser/bran ... format=raw
Author:  manicmike [ Mon Sep 18, 2006 9:37 am ]
Post subject: 
nigelpearson wrote:
manicmike wrote:
I tried using that script after upgrading to r5d1, and it failed totally because it was looking only for .nuv files


Yes, KnoppMyth currently has an old version. For now, grab the latest from here:

http://cvs.mythtv.org/trac/browser/bran ... format=raw


Darn. Someone beat me to it. I fixed it tonight.

Incidentally, the nuv format not only had the different extension, but the files also had start *and end* times in the file name. This also tripped up the perl script, since it extracted this data from the name then stuck it into the database.

Nice little script :-) Saves bucket loads of time. I previously copied all the tv files into the video directory then rename them. Very tedious indeed!

Mike
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/