| LinHES Forums http://forum.linhes.org/ |
|
| myth.rebuilddatabase.pl problem http://forum.linhes.org/viewtopic.php?f=6&t=7989 |
Page 1 of 1 |
| Author: | Red5 [ Fri Jan 20, 2006 10:42 am ] |
| Post subject: | myth.rebuilddatabase.pl problem |
I get the following error when I try to run this: Code: # myth.rebuilddatabase.pl --dir /myth/tv
DBI connect('database=mythconverg:host=mythpoint','mythtv',...) failed: Can't connect to MySQL server on 'mythpoint' (111) at /usr/local/bin/myth.rebuilddatabase.pl line 128 Cannot connect to database () Does anyone know what is going on here? I am running R5A26. |
|
| Author: | cesman [ Fri Jan 20, 2006 11:55 am ] |
| Post subject: | |
Well, either MySQL isn't running or 'mythpoint' isn't your hostname... |
|
| Author: | Red5 [ Fri Jan 20, 2006 12:33 pm ] |
| Post subject: | |
I tried checking both of those. I logged in to MySQL. It is working fine. I tried using the command-line parameters to set both "host" and "dbhost" to the IP adresses. I also tried running it with the user and pass for "root". weird, eh... |
|
| Author: | Some Guy [ Thu Jan 26, 2006 10:59 pm ] |
| Post subject: | |
Red5, did you figure this out yet? I am having the exact same problem with R5A30.2. The backend and MySQL are definitely running, the hostname is correct and resolves to 127.0.0.1, etc... I'm not sure what else to try. |
|
| Author: | TilTNimpuS [ Thu Mar 09, 2006 5:39 pm ] |
| Post subject: | |
hi all to clear my database i used: mysql> delete from videometadata; #without the * and it worked !!! |
|
| Author: | Some Guy [ Thu Mar 09, 2006 5:56 pm ] |
| Post subject: | |
TilTNimpuS, I don't want to *clear* the database, I want to *rebuild* it. |
|
| Author: | Buckaroo Bonzai [ Sat Mar 11, 2006 10:48 am ] |
| Post subject: | |
I ran into the same problem. From the knoppmyth wiki, I ran: myth.rebuilddatabase.pl --dbhost=localhost http://www.knoppmythwiki.org/index.php? ... storeHowTo This worked, and allowed me to type in the names and descriptions of all the orphans on my computer. At the end of this process, all info on commericial cutting is lost, but you can still skip f/b in time while watching. Haven't tried burning yet. |
|
| Author: | neutron68 [ Thu Jun 15, 2006 5:10 pm ] |
| Post subject: | myth.rebuilddatabase.pl script still valid?? |
My friend just hit the RESTORE button in Mythtv and his database reverted back a month and he thus had orphaned mpg files on his hard drive that he couldn't access. I just tried this script on my friend's R5C7 KnoppMyth machine - same machine specs as mine. myth.rebuilddatabase.pl --dbhost=localhost It gives me the following feedback but does nothing: Code: These are the files stored in (/myth/tv) and will be checked against
your database to see if the exist. If they do not, you will be prompted for a title and subtitle of the entry, and a record will be created. I looked at the script and it seems to be looking for .nuv files. The newer revisions of Mythtv record to mpg files rather than nuv files. So is this script useless now? Does anyone have a modification of the script that works with the current KnoppMyth versions? Eric |
|
| Author: | neutron68 [ Sat Jun 24, 2006 10:01 am ] |
| Post subject: | found a fix |
In KnoppMyth R5C7, use the following command line to call the script: Code: myth.rebuilddatabase.pl --dbhost=localhost --ext mpg
Then, the script will look for orphan mpg files - critical for newer Mythtv versions. I just did this and it added a bunch of errored recordings to the database, then I was able to delete them from the harddrive. I also found a newer version of this script on the mythtv site, but I'm not sure if it's compatible with Knoppmyth R5C7 or not: http://cvs.mythtv.org/trac/browser/trunk/mythtv/contrib/myth.rebuilddatabase.pl?rev=10047 Enjoy! Eric |
|
| Author: | red321 [ Fri Jun 30, 2006 11:49 am ] |
| Post subject: | |
libtime-format-perl_1.00-1_all.deb is needed. once that is installed (doesnt have any nasty dependencies) http://cvs.mythtv.org/trac/browser/trun ... ?rev=10047 seems to run fine on RC57, and is much improved. |
|
| Author: | esurfer [ Mon Jul 03, 2006 1:55 am ] |
| Post subject: | |
How do you update/install libtime-format-perl_1.00-1_all.deb Thanks, esurfer |
|
| Author: | tjc [ Mon Jul 03, 2006 4:50 pm ] |
| Post subject: | |
Search for "apt-get". Also note that you don't want to do this naively or you may end up having to reinstall the whole system. There are instructions on the wiki for making sure you're pointed to the stable repositories, and other hints floating around here to make sure you don't hose yourself doing this. |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|