[mythtv-users] python

[James Linder]

> On 25 Feb 2015, at 4:53 am, mythtv-users-request at mythtv.org wrote:
> 
>>>> if anybody has walked this road and has any advice then please ?
>>>> I?m trying to build a dvd on my suse backend machine.
>>>> After finding a few python modules I got stuck. Clearly python cannot access the DB
> 
>>>> Traceback (most recent call last):
>>>>  File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py", line 5298, in <module>
>>>>    main()
>>>>  File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py", line 5165, in main
>>>>    defaultsettings = getDefaultParametersFromMythTVDB()
>>>>  File "/usr/local/share/mythtv/mytharchive/scripts/mythburn.py",
>>>> line 883, in getDefaultParametersFromMythTVDB
>>>>    cursor.execute(sqlstatement, configHostname)
>>>>  File "/usr/lib/python2.7/site-packages/MythTV/_conn_mysqldb.py", line 71, in execute
>>>>    raise MythDBError(MythDBError.DB_RAW, e.args)
>>>> MythTV.exceptions.MythDBError: MySQL error: not all arguments
>>>> converted during string formatting
> 
>>>> Thanks anyone
>>>> James
>>>> _______________________________________________
> 
>>> The error probably means it's missing a variable.
>>> The last line in /_conn_mysqldb.py is an error handler.
>>> Line 883 in mythburn.py is the execution of an sql statment. My guess
>>> is configHostname is invalid, so look at ~/.mythtv/config.xml for your
>>> hostname definition.
> 
> 
>>> Tot mails,
>>>  Hika                            mailto:hikavdh at gmail.com
> 
>> Looked a bit further:
>> configHostname = DB.gethostname()
>> So maybe an invalid hostname in your database
> 
>> Tot mails,
>>  Hika Alina Maria van den Hoven                            mailto:hikavdh at gmail.com
> 
> Just before the exception it logged the query that gave the error.
>        self.log_query(query, args)
> So check the log.

Hika thanks for the help, I’m out of my depth with python …

Changing the <LocalHostName> results in a new setup for each name (dur!!)
This all looks ok for the DB

    <PingHost>1</PingHost>
    <Host>192.168.5.35</Host>
    <UserName>mythtv</UserName>
    <Password>mythtv</Password>
    <DatabaseName>mythconverg</DatabaseName>
    <Port>3306</Port>
 
I made sure I have python Pillow, MythTV and MYSQL modules
This frontend is on the backend machine since I do nothing to export the files. I tried ‘localhost’ as well as the ‘192.168.5.35’ Host.
Except for MythArchive this frontend works as it ought.

I run mythfrontend --logpath /store/mythlogs --loglevel debug

Before trying to Optical Disks -> Make a DVD ie just starting frontend

...
2015-02-25 09:54:49.118244 N [23000/23000] CoreContext mythburn.cpp:280 (loadEncoderProfiles) - MythArchive: Loading encoding profiles from /usr/local/share/mythtv/mytharchive/encoder_profiles/ffmpeg_dvd_pal.xml
2015-02-25 09:55:04.981544 I [23000/23000] CoreContext mythmainwindow.cpp:2680 (LockInputDevices) - Locking input devices
2015-02-25 09:55:04.981561 N [23000/23000] CoreContext mythmainwindow.cpp:2737 (PauseIdleTimer) - Suspending idle timer
2015-02-25 09:55:05.162720 I [23000/23000] CoreContext mythmainwindow.cpp:2682 (LockInputDevices) - Unlocking input devices
2015-02-25 09:55:05.162741 N [23000/23000] CoreContext mythmainwindow.cpp:2742 (PauseIdleTimer) - Resuming idle timer
2015-02-25 09:55:22.843301 D [23000/23000] CoreContext housekeeper.cpp:662 (Run) - Running HouseKeeper.
2015-02-25 09:55:22.843319 D [23000/23000] CoreContext housekeeper.cpp:105 (CheckRun) - Checking to run HardwareProfiler

and after Quit

2015-02-25 09:55:59.020908 D [23000/23000] CoreContext mythcorecontext.cpp:1237 (SendReceiveStringList) - SendReceiveStringList(QUERY_IS_ACTIVE_BACKEND,poohcorner) called from UI thread
2015-02-25 09:56:07.786209 I [23000/23000] CoreContext main.cpp:262 (cleanup) - Shutting down UPnP client...
2015-02-25 09:56:08.115062 D [23000/23000] CoreContext mythuiwebbrowser.cpp:275 (~MythWebPage) - Refreshing DLManager's Cookie Jar
2015-02-25 09:56:08.115105 D [23000/23035] DownloadManager mythdownloadmanager.cpp:275 (run) - Updating DLManager's Cookie Jar
2015-02-25 09:56:08.115122 D [23000/23000] CoreContext mythdownloadmanager.cpp:1623 (save) - MythCookieJar: saving cookies to: /home/jam/.mythtv/MythBrowser/cookiejar.txt
2015-02-25 09:56:08.115506 I [23000/23000] CoreContext mythcontext.cpp:1194 (~MythContext) - Waiting for threads to exit.

A little worrying snippet from mythfrontend terminal output …

2015-02-25 09:53:20.765775 A  MMUnix:CheckMountable: DBus interface error: The name org.freedesktop.UDisks was not provided by any .service files
2015-02-25 09:53:21.266742 A  MMUnix:CheckMountable: DBus interface error: The name org.freedesktop.UDisks was not provided by any .service files
2015-02-25 09:53:21.767965 A  MMUnix:CheckMountable: DBus interface error: The name org.freedesktop.UDisks was not provided by any .service files
2015-02-25 09:53:22.268959 A  MMUnix:CheckMountable: DBus interface error: The name org.freedesktop.UDisks was not provided by any .service files

So any pointers will be gratefully received
James