[mythtv-users] UK Commercial Detection (Clusters)

[Phill Edwards]

>
> I've put a new version (v2.0) of the cluster script on the wiki
>
> http://www.mythtv.org/wiki/Commercial_detection_with_silence_for_UK_freeviewHD#Cluster_Detecting_Version
>
> There's a new silence.py, silence.cpp & Makefile; catagrower.cpp is unchanged.
>
> It's a re-design that;
>
> - flags adverts shortly after they end
> - fixes segfaults
> - makes use of Myth headers optional
> - has improved Makefile
>
>

I've been trying to test out this script by running ot from the
command line first off (before setting it up as a job in MythTV). I'm
having trouble getting it working. I'm using these programs from the
recordedprogram table as the test bed:

mysql> select chanid, starttime, title from recordedprogram where
title like "Modern%";
+--------+---------------------+---------------+
| chanid | starttime           | title         |
+--------+---------------------+---------------+
|   2573 | 2013-04-10 09:30:00 | Modern Family |
|   2573 | 2013-03-31 08:00:00 | Modern Family |
|   2573 | 2013-04-17 09:30:00 | Modern Family |
|   2573 | 2013-03-27 08:30:00 | Modern Family |
|   2573 | 2013-04-03 08:30:00 | Modern Family |
|   2573 | 2013-04-14 09:00:00 | Modern Family |
+--------+---------------------+---------------+

So I then execute this from the command line but get a failure to log
into MySQL (I think that's why it's failing):

$ silence.py --chanid 2573 --starttime 20130410093000 --loglevel debug
2013-04-29 20:22:30.912538 D [18671] Python Database Connection Trying
database credentials from: /home/phill/config.xml
2013-04-29 20:22:30.923958 D [18671] Python Database Connection Trying
database credentials from: /home/phill/config.xml
2013-04-29 20:22:30.940568 E [18671] m mythcommflag: Could not find recording

/home/phill/config.xml exists and is a symbolic link to /etc/mythtv/config.xml.

I'm running Ubuntu 12.04 & Myth 0.26. All of my storage group
directory names have slashes on the end. I'm doing this in Australia
(is this a UTC issue?) Can anyone see why this is failing? What dumb
mistake am I making here?