stephen_agent at jsw
Jan 23, 2012, 12:43 AM
Post #3 of 5
(500 views)
Permalink
|
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.
_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
|
