XBMC Community Forum
New MythTV add-on using libcmyth - Printable Version

+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Development (/forumdisplay.php?fid=32)
+--- Forum: PVR Development (/forumdisplay.php?fid=136)
+--- Thread: New MythTV add-on using libcmyth (/showthread.php?tid=110694)



- stevellion - 2011-10-23 00:26

Ouch.. they all disappear back to just a few mythtv ones when I log out of XBMC.. and all come back again when I log back in.. something is up... Sad

Ok - Update. I think there have been some backend DB changes and as I'm storing music & video in mysql, there seems to be no ability to convert.. I've now switched back to non mysql and it's working well.

In the log, I saw this...


23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos42 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos42')
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos41
23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos41 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos41')
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos40
23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos40 [1040](Too many connections)
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos39
23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos39 [1040](Too many connections)
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos38
23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos38 [1040](Too many connections)
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos37
...

23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos2 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos2')
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos1
23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos1 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos1')
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:xbmc_video
23:38:57 T:140703467415520 NOTICE: Old database found - updating from version 0 to 56
23:38:57 T:140703467415520 ERROR: SQL: Can't create database for copy: 'xbmc_video' (1044)
23:38:57 T:140703467415520 ERROR: Unable to copy old database xbmc_video to new version MyVideos56
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos56
23:38:57 T:140703467415520 ERROR: Unable to open database: MyVideos56 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos56')
23:38:57 T:140703467415520 DEBUG: Connecting to mysql:localhost:MyVideos55
...

Eventually it falls back sqlite, but it's a problem. I guess should report this over on the mainline?


- tsp42 - 2011-10-23 01:01

I guess you will have to test mainline first and see if it is an issue that have been fixed after the last merge of mainline into XBMC PVR.


PVR/MythTV Live TV debug. - Weatherman - 2011-10-23 03:11

tsp42 Wrote:Weatherman: Could you post a link to the xbmc debug log (and please enable "Include more debug information in the log" in the mythtv cmyth add-on configuration and restart xbmc to let the changes take effect). It is otherwise a bit hard to figure out what is wrong Wink .

TSP42: Sure, no problem. Here is the debug/log information from running XBMC and going right into Live TV and trying to watch a channel where it will just just sit there at the "Working" prompt.

http://pastebin.com/7ZKCKTki

The only odd thing I saw was this:

ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_conn_connect: asked for version 8, got version 63

I'm sure it will make more sence to you.

Thanks!

- Mark


- ericminou - 2011-10-23 03:40

Weatherman Wrote:First, a big thank you to TSP for the fantastic work on the PVR/Myth work! I have tried many builds and this one works better than any I have tested with my setup. This is a must have for XBMC!

Notes on my setup:
Ubuntu 11.10 / TSP's XBMC/PVR build from git.
Very latest MythBuntu using my very new HDHomerun Prime (3 cable card tuners).

Using the myth:// setup under Video option, everything works fantastic! Live TC, channel changes and guide all work perfect from my testing.

When I try to use the Live TV option from the main menu of XBMC, I am unable to tune in any channels. It does pull in the channels from MythBuntu and has the guide information. When I select a channel, it just says "Working" forever.

What is strange is how it works fine under the myth:// option in Videos.

At this point in time, I just would love to have the Live TV and Guide information so I can start using my HDHomerun Prime with my (2) XBMC systems (which right now are running XBMC Live 10.1)

I'm doing all my testing in a VM.

Keep up the fantastic work.. I wish I could so more than just test.

- Mark

I had the same problem and I think I know the solution (I have a very similar setup). Do you have you channels named 12_1, 12_2, etc... in mythtv backend?


- ericminou - 2011-10-23 03:42

Weatherman Wrote:TSP42: Sure, no problem. Here is the debug/log information from running XBMC and going right into Live TV and trying to watch a channel where it will just just sit there at the "Working" prompt.

http://pastebin.com/7ZKCKTki

The only odd thing I saw was this:

ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_conn_connect: asked for version 8, got version 63

I'm sure it will make more sence to you.

Thanks!

- Mark

You can ignore that error. If you do some reading on the forum it is the expected behavior.


- stevellion - 2011-10-23 10:52

tsp42 Wrote:I guess you will have to test mainline first and see if it is an issue that have been fixed after the last merge of mainline into XBMC PVR.

Seems like it's being corroborated in Mainline too - now I posted it...


Live TV / MythTV / XBMC - Weatherman - 2011-10-23 15:49

ericminou Wrote:I had the same problem and I think I know the solution (I have a very similar setup). Do you have you channels named 12_1, 12_2, etc... in mythtv backend?

Mine are listed like "3 GOLF" and "4 MASN" in the channel editor in MythBuntu's backend setup.

I was wondering if it had something to due with the HDHomerun Prime's use of "virtual channels".

None of the PVR build I have tested display Live TV under that menu option on my setup - however, using the myth:// (MythTV Client) option in XBMC, all the channels work and display fine.

- Mark


- ericminou - 2011-10-23 16:00

Weatherman Wrote:Mine are listed like "3 GOLF" and "4 MASN" in the channel editor in MythBuntu's backend setup.

I was wondering if it had something to due with the HDHomerun Prime's use of "virtual channels".

None of the PVR build I have tested display Live TV under that menu option on my setup - however, using the myth:// (MythTV Client) option in XBMC, all the channels work and display fine.

- Mark

All the symptoms seem identical to mines. Just open mythtv-setup on the back end and make sure the channel number is a digit (like 2 or 3, 5, etc...). Name itself doesnt matter. Then try to watch that channel. If that works rename that for all the channels. It did the trick for me.


XBMC / MythTV / PVR - Weatherman - 2011-10-23 16:57

ericminou Wrote:All the symptoms seem identical to mines. Just open mythtv-setup on the back end and make sure the channel number is a digit (like 2 or 3, 5, etc...). Name itself doesnt matter. Then try to watch that channel. If that works rename that for all the channels. It did the trick for me.

Thanks!!! I just edited one of the channels in the MythBackend to just have the channel number listed as "3" instead of "3 GOLF" and it worked!!!

My only question now is what is different about using the myth:// style vs. the Live TV option where one handles that with no problem and the other doesn't.

If I want to fix this, I will have to edit some 800 channels.

- Mark


- robweber - 2011-10-23 17:12

Weatherman Wrote:Thanks!!! I just edited one of the channels in the MythBackend to just have the channel number listed as "3" instead of "3 GOLF" and it worked!!!

My only question now is what is different about using the myth:// style vs. the Live TV option where one handles that with no problem and the other doesn't.

If I want to fix this, I will have to edit some 800 channels.

- Mark

I believe in mythtv you can have a channel# and a callsign. The channel number should be a number only, while for the callsign you can have the station info. So you can still have the GOLF, ABC, NBC, etc in that area.

Take a look at this post: http://forum.xbmc.org/showpost.php?p=911846&postcount=85 it explains the behavior you are seeing. The XBMC PVR expects the channel # to be an integer only, not a string like myth lets you use. It looks like you may end up editing all 800 Channels. You could probably write some SQL to update the DB for you though, something along the lines of splitting the string on the space between the number and the station and then storing the number back into the field while moving the station info the callsign field.