[mythtv-users] python
James Linder
jam at tigger.ws
Wed Feb 25 02:42:41 UTC 2015
> 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
More information about the mythtv-users
mailing list