[mythtv-users] Fixing minor errors in Myth database

[Fred Hamilton]

Quick update in case it helps anyone:  I found that mythbackend wasn't
launching at boot (or after running mythtv-setup) because I had changed the
mythtv database password to "mythtv" from the "dtageld5"-like password my
system originally had.

I had changed the password for mythconverg in:
 - the mysql database,
 - /etc/apache2/sites-available/mythweb.conf
 - mythtv-setup
 - mythtv/mysql.txt

And if I manually launched mythbackend everything worked fine.  But I could
not get it to go back to launching at startup until I changed the password
back to the one I was using before the --partial_restore...



On Sun, Apr 28, 2013 at 5:48 PM, Michael T. Dean <mtdean at thirdcontact.com>wrote:

> On 04/28/2013 08:42 PM, Fred Hamilton wrote:
>
>> Thanks Mike, "gzip -d -c mythconverg-1264-**20130425182924.sql.gz | sed
>> '/INSERT INTO `recordedmarkup`/d' > /tmp/mythconverg-no_**recordedmarkup.sql"
>> seemed to do the trick!  All my shows are right where they should be and
>> play back fine.
>>
>> Now I'm just tackling the fallout (mythbackend backend is no longer
>> automatically starting, fetch channels from listings source works for cable
>> but not for broadcast,
>>
>
> "Fetch channels from listings source" can only be used for analog capture
> and "non-scannable" inputs (such as firewire or HDHR Prime, etc.).  Since
> broadcast would be ATSC and captured using the DVB API, you must do a
> proper channel scan (then set XMLTV IDs, then run mythfilldatabase, or skip
> setting XMLTV IDs and run mythfilldatabase and hope that the garbage the
> broadcaster sent is close enough that mythfilldatabase can guess which
> channel is which--so I always recommend setting the XMLTV ID properly to
> /tell/ mythfilldatabase which channel is which).
>
>
>  no mythweb yet, rebuilding the seek tables and commflag as you mentioned,
>> etc.).  But I can see the light at the end of the tunnel!  Really
>> appreciate all the help!
>>
>
> Good luck.
>
>
> Mike
> ______________________________**_________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/**listinfo/mythtv-users<http://www.mythtv.org/mailman/listinfo/mythtv-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130428/f3d43452/attachment.html>