[mythtvnz] tv_grab_nz-py set up, details

[Stephen Worthington]

On Mon, 23 Jan 2012 18:13:34 +1300, you wrote:

>>> >  FYI here is the output of the script...
>>> >
>>> >  $ ./updateEPG.sh
>>> >  --2012-01-23 12:56:48--http://nzepg.org/freeview.xml.gz
>>> >  Resolving nzepg.org... 74.207.253.88
>>> >  Connecting to nzepg.org|74.207.253.88|:80... connected.
>>> >  HTTP request sent, awaiting response... 200 OK
>>> >  Length: 197214 (193K) [application/x-gzip]
>>> >  Saving to: `freeview.xml.gz'
>>> >
>>> >  100%[======================================>] 197,214      148K/s   in
>>> >  1.3s
>>> >
>>> >  2012-01-23 12:56:51 (148 KB/s) - `freeview.xml.gz' saved [197214/197214]
>>> >
>>> >  2012-01-23 12:56:52.665 Bypassing grabbers, reading directly from file
>>> >  2012-01-23 12:56:52.678 Using runtime prefix = /usr
>>> >  2012-01-23 12:56:52.678 Using configuration directory =
>>> >  /home/lounge/.mythtv
>>> >  2012-01-23 12:56:52.713 Empty LocalHostName.
>>> >  2012-01-23 12:56:52.713 Using localhost value of mythdu
>>> >  2012-01-23 12:56:52.757 New DB connection, total: 1
>>> >  2012-01-23 12:56:52.762 Connected to database 'mythconverg' at host:
>>> >  localhost
>>> >  2012-01-23 12:56:52.786 Closing DB connection named 'DBManager0'
>>> >  2012-01-23 12:56:52.787 Connected to database 'mythconverg' at host:
>>> >  localhost
>>> >  2012-01-23 12:56:52.790 Current locale en_NZ
>>> >  2012-01-23 12:56:52.812 No locale defaults file for en_NZ, skipping
>
>
>Is this an important error?  I expect this is unimportant

No, it is not important.  I always get this and my updates work.

>>> >  2012-01-23 12:56:52.847 Loading en_us translation for module mythfrontend
>>> >  2012-01-23 12:56:52.871 Current MythTV Schema Version (DBSchemaVer): 1264
>>> >  2012-01-23 12:56:53.198 New DB connection, total: 2
>>> >  2012-01-23 12:56:53.198 Connected to database 'mythconverg' at host:
>>> >  localhost
>>> >  2012-01-23 12:56:53.752 IconData: Updating icons for sourceid: 1
>>> >  2012-01-23 12:56:53.891 New DB connection, total: 3
>>> >  2012-01-23 12:56:53.891 Connected to database 'mythconverg' at host:
>>> >  localhost
>>> >  2012-01-23 12:57:03.414 Updated programs: 749 Unchanged programs: 2498
>
>Here it seems the process is actually loading data.  There are 3,250 ish 
>programmes....
>
>>> >  2012-01-23 12:57:03.448 Adjusting program database end times.
>>> >  2012-01-23 12:57:03.527     0 replacements made
>>> >  2012-01-23 12:57:03.527 Marking generic episodes.
>>> >  2012-01-23 12:57:03.568     Found 111
>>> >  2012-01-23 12:57:03.568 Fudging non-unique programids with multiple
>>> >  parts.
>>> >  2012-01-23 12:57:03.579     Found 0
>>> >  2012-01-23 12:57:03.579 Marking repeats.
>>> >  2012-01-23 12:57:03.612     Found 0
>>> >  2012-01-23 12:57:03.612 Unmarking new episode rebroadcast repeats.
>>> >  2012-01-23 12:57:03.616     Found 0
>
>0 repeats?  That does not seem right.

Yes, that is OK, it is what I get.

>>> >  2012-01-23 12:57:03.723 Marking episode first showings.
>>> >  2012-01-23 12:57:05.311     Found 1416
>>> >  2012-01-23 12:57:05.312 Marking episode last showings.
>>> >  2012-01-23 12:57:06.880     Found 1416
>>> >  2012-01-23 12:57:06.883
>
>1,416 first episodes, that does not seem right.

Yes, that looks as though it is OK.  I think it has to do with how the
USA epg data works, and does not do anything for us.

>>> >  ===============================================================
>>> >  | Attempting to contact the master backend for rescheduling.  |
>>> >  | If the master is not running, rescheduling will happen when |
>>> >  | the master backend is restarted.                            |
>>> >  ===============================================================
>>> >  2012-01-23 12:57:06.890 MythCoreContext: Connecting to backend server:
>>> >  192.168.1.14:6543 (try 1 of 1)
>>> >  2012-01-23 12:57:06.892 Using protocol version 63
>>> >  2012-01-23 12:57:07.126 Received a remote 'Clear Cache' request
>>> >  2012-01-23 12:57:08.125 mythfilldatabase run complete.
>>> >  2012-01-23 12:57:08.140 DataDirect: Deleting temporary files
>>> >

What user are you running the epg updates script as?  It should be
done from the same user that mythtv runs from, or the frontend runs
from.

>How do I access the MySQL database?  I expect the problem lies in my 
>settings in MythTV and there is a database full of programme listings.
>
>cheers
>Worik

Here is the script I use to get access to the mythconverg database:

#!/bin/bash

# Run MySQL to access the mythconverg database.

source /etc/mythtv/mysql.txt
mysql -u $DBUserName -p$DBPassword -h $DBHostName $DBName

It should work for any user with access to the /etc/mythtv/mysql.txt
file.