Solved Issue - Unable to connect to MythTV 0.26 with cmyth PVR Client

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
stratoscape Offline
Member
Posts: 50
Joined: Jun 2009
Reputation: 0
Question  Unable to connect to MythTV 0.26 with cmyth PVR Client
Post: #1
Seems to be a popular request, I even read all of the other threads requesting it but unlike the other threads I simply cannot figure out how get this thing working. I configured the addon to my MythTV server IP and port number, enabled it, enabled the liveTV setting in my xbmcbuntu settings but all I get is this error in XBMC when I enable the LiveTV settings

XBMC window:
Code:
MythTV cmyth Client
Failed to connect to MythTV MySQL dagtabase mythconverge@
access denied for user 'mythtv'@'xxx.xxx.xxx.37


XBMC Logs:
Code:
17:45:07 T:140668089394944  NOTICE: Thread Jobworker start, auto delete: true
17:45:07 T:140668089394944  NOTICE: PVRManager - starting up
17:45:07 T:140668732937984  NOTICE: Thread PVR manager start, auto delete: false
17:45:07 T:140665387337472  NOTICE: Thread PVR add-on updater start, auto delete: false
17:45:26 T:140665387337472   ERROR: PVR - couldn't get the capabilities for add-on 'unknown'. Please contact the developer of this add-on: Christian Fetzer, Jean-Luc Barrière, Tonny Petersen
17:45:27 T:140665387337472   ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_conn_connect: asked for version 8, got version 75
17:45:27 T:140665387337472   ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_conn_connect: asked for version 75, got version 75
17:45:27 T:140665387337472   ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_conn_connect: asked for version 8, got version 75
17:45:27 T:140665387337472   ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_conn_connect: asked for version 75, got version 75
17:45:27 T:140665387337472   ERROR: AddOnLog: MythTV cmyth PVR Client: Failed to connect to backend
17:45:27 T:140665387337472   ERROR: PVR - couldn't get the capabilities for add-on 'unknown'. Please contact the developer of this add-on: Christian Fetzer, Jean-Luc Barrière, Tonny Petersen
17:45:28 T:140669049481088  NOTICE: PVRManager - stopping
17:45:28 T:140668732937984   ERROR: PVRManager - Process - failed to load PVR data


from MythTV Logs:
Code:
Nov 24 17:45:27 strato-virtual-machine mythlogserver: mythbackend[1332]: W ProcessRequest mainserver.cpp:5841 (connectionClosed) MainServer: Unknown socket closing MythSocket(0xf3c8c0)
Nov 24 17:45:27 strato-virtual-machine mythlogserver: mythbackend[1332]: I ProcessRequest mainserver.cpp:1395 (HandleAnnounce) MainServer::ANN Playback
Nov 24 17:45:27 strato-virtual-machine mythlogserver: mythbackend[1332]: I ProcessRequest mainserver.cpp:1397 (HandleAnnounce) adding: JET-JAGUAR as a client (events: 1)
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: C ProcessRequest mainserver.cpp:1294 (HandleVersion) MainServer::HandleVersion - Client speaks protocol version 8 but we speak 75!
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: W ProcessRequest mainserver.cpp:5841 (connectionClosed) MainServer: Unknown socket closing MythSocket(0xf37540)
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: I ProcessRequest mainserver.cpp:1395 (HandleAnnounce) MainServer::ANN Playback
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: I ProcessRequest mainserver.cpp:1397 (HandleAnnounce) adding: JET-JAGUAR as a client (events: 0)
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: C ProcessRequest mainserver.cpp:1294 (HandleVersion) MainServer::HandleVersion - Client speaks protocol version 8 but we speak 75!
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: W ProcessRequest mainserver.cpp:5841 (connectionClosed) MainServer: Unknown socket closing MythSocket(0xf3db20)
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: I ProcessRequest mainserver.cpp:1395 (HandleAnnounce) MainServer::ANN Playback
Nov 24 17:45:28 strato-virtual-machine mythlogserver: mythbackend[1332]: I ProcessRequest mainserver.cpp:1397 (HandleAnnounce) adding: JET-JAGUAR as a client (events: 1)
Nov 24 17:48:32 strato-virtual-machine mythlogserver: mythbackend[1332]: I HouseKeeping housekeeper.cpp:221 (RunHouseKeeping) Running housekeeping thread

MythTV Version info:
Code:
mythbackend --version
Please attach all output as a file in bug reports.
MythTV Version : v0.26.0-41-gca8f5e7
MythTV Branch : fixes/0.26
Network Protocol : 75
Library API : 0.26.20120822-1
QT Version : 4.8.1
Options compiled in:
linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_crystalhd using_dvb using_firewire using_frontend using_hdhomerun using_ceton using_hdpvr using_iptv using_ivtv using_joystick_menu using_libcec using_libcrypto using_libdns_sd using_libxml2 using_lirc using_mheg using_opengl_video using_qtwebkit using_qtscript using_qtdbus using_v4l2 using_x11 using_xrandr using_xv using_bindings_perl using_bindings_python using_bindings_php using_mythtranscode using_opengl using_vaapi using_vdpau using_ffmpeg_threads using_live using_mheg using_libass using_libxml2


My MythTV setup was running fine, I read that it was recommended to upgrade to .26 so I did but didn't help as I am still missing something, about the permissions error in the XBMC cmyth client, I dont get it.. I can connect to myth using default credentials just fine from other systems just the one that matters is giving me the most fits :-\

Thanks in advance, I see a bunch of other similar threads about connectivity issue to mythv but seems like they all had something turned off or something, but I have no idea where else to look.

strato
(This post was last modified: 2012-11-25 07:19 by stratoscape.)
find quote
twojciac Offline
Junior Member
Posts: 22
Joined: Nov 2012
Reputation: 2
Post: #2
Have you tried manually logging in using the username and password with mysql? Also, are you certain you're using the proper case with the password?

Mytbuntu generates some terrible passwords at times, if you are using that... like using an I,l,and 1 in the same password. I manually changed the password on mine to something easier to type.
find quote
stratoscape Offline
Member
Posts: 50
Joined: Jun 2009
Reputation: 0
Information  RE: Unable to connect to MythTV 0.26 with cmyth PVR Client
Post: #3
Don't know if this will help anyone but I solved this myself, posting results so hopefully someone else may not have to troll twelve hours for it Frown

My problem was with my interpretation or the configuration info for the cmyth PVR Client add-on. When reading the setup information, the example listed "mythtv" for both MythTV Database Username as well as the MythTV Database Password. the example does state that if you have changed this then you will need to make the necessary change in "your" setup however I never made such a change and assumed this was the preset username/password

Quote:MythTV Database Username
The default is 'mythtv' but this will need updating if you have changed it in the MythTV settings.
MythTV Database Password
The default is 'mythtv' but this will need updating if you have changed it in the MythTV settings.

After trolling google all day I stumbled across a mysql thread where a user made reference to mysql.txt and it is here where I found

Code:
DBHostName=localhost
DBUserName=mythtv
DBName=mythconverg
DBPassword=xxxxxxxx

...ugh! it all came back to me, from wayyy back in the old original xbox xbmc days when I had this same exact problem then. Anyway, I used the DBPassword in my cmyth add-on database setting and everything connected right up. I have no idea if this is what happen with all the other threads in this section with connection issues as no one [solved] any of their post.

Note: I was getting weird port errors in xbmc client when connecting to my mythtv backend version 0.25 so reading version 0.26 was suggested I upgraded and that's when the errors in xbmc client changed to "denials" so if you may consider updating your myth backend to version 0.26 as well (just saying, it worked for me)

good luck,

strato
find quote
sirkingchase Offline
Junior Member
Posts: 19
Joined: Jun 2012
Reputation: 0
Post: #4
I was having the exact same problems. I looked at your post and saw mysql.txt and then I remembered that MythTV is stubborn about DBHostName being the exact same across all settings.

Try using "localhost" as the host in settings. The default 127.0.0.1 and my local ip address 192.168.1.101, did not work.
find quote
stratoscape Offline
Member
Posts: 50
Joined: Jun 2009
Reputation: 0
Post: #5
IP has to match in XBMC cmyth add-on and MythTV backend

Code:
Backend setup -> General-> IP Address -> xxx.xxx.xxx.xxx

This should be set to your devices actual IP and not 'localhost' or '127.0.0.1'
I believe you said yours is 192.168.1.101 so I would try providing that on both mythtv backend as well as the xbmc cmyth add-on client settings

good luck

strato
find quote
RichMR2 Offline
Junior Member
Posts: 16
Joined: Nov 2005
Reputation: 0
Post: #6
Nothing is fixing this issue for me.

I currently have the settings in XBMC correct, with the correct DB password (verified by logging in to MySQL through putty with the password).
XBMC has the host set to 192.168.0.111 which is the IP of the Mythbuntu box running Mythbuntu 12.04.1
The MythTV backend in Mythbuntu is set up with the backend IP as 192.168.0.111 also.

As far as I can tell all settings are correct in both XBMC and Mythbuntu but I still receive the "Failed to connect to MythTV MySQL database mythconverge@192.168.0.111 mythtv/password

Do I need to grant any access to other IPs as MythTV is not on the same machine as XBMC? Mythbuntu is 192.168.0.111 where as XBMC seats are 192.168.0.100 to 192.168.0.103. This issue happens on all XBMC seats tested (windows installs) I have no desire to become frustrated with the fourth (raspbmc).

Any help would be appreciated.

Edit: Reinstalling Mythbuntu for the third time allowed connection by XBMC
(This post was last modified: 2013-02-03 13:03 by RichMR2.)
find quote
sirkingchase Offline
Junior Member
Posts: 19
Joined: Jun 2012
Reputation: 0
Post: #7
(2013-02-02 19:52)RichMR2 Wrote:  Nothing is fixing this issue for me.

I currently have the settings in XBMC correct, with the correct DB password (verified by logging in to MySQL through putty with the password).
XBMC has the host set to 192.168.0.111 which is the IP of the Mythbuntu box running Mythbuntu 12.04.1
The MythTV backend in Mythbuntu is set up with the backend IP as 192.168.0.111 also.

As far as I can tell all settings are correct in both XBMC and Mythbuntu but I still receive the "Failed to connect to MythTV MySQL database mythconverge@192.168.0.111 mythtv/password

Do I need to grant any access to other IPs as MythTV is not on the same machine as XBMC? Mythbuntu is 192.168.0.111 where as XBMC seats are 192.168.0.100 to 192.168.0.103. This issue happens on all XBMC seats tested (windows installs) I have no desire to become frustrated with the fourth (raspbmc).

Any help would be appreciated.

Edit: Reinstalling Mythbuntu for the third time allowed connection by XBMC

You have to enable mysql connections from outside local host. I have different xbmc machines android, Windows, and mac. In order to access live TV from those devices I had to enable mysql to allow connections other than from local host.
find quote
djroketboy Offline
Senior Member
Posts: 110
Joined: Nov 2009
Reputation: 1
Post: #8
(2013-02-05 17:54)sirkingchase Wrote:  You have to enable mysql connections from outside local host. I have different xbmc machines android, Windows, and mac. In order to access live TV from those devices I had to enable mysql to allow connections other than from local host.

There are actually 2 parts to enable outside connections to MythTV.
First, sirkingchase is correct. In the mythbuntu control center (sudo apt-get install mythbuntu-control-centre) under the MySQL section you can enable outside connections.

Second, on the Mythbackend General settings make sure you use the IP of the master backend not the loopback or localhost addresses.
find quote
sirkingchase Offline
Junior Member
Posts: 19
Joined: Jun 2012
Reputation: 0
Post: #9
(2013-02-06 00:47)djroketboy Wrote:  There are actually 2 parts to enable outside connections to MythTV.
First, sirkingchase is correct. In the mythbuntu control center (sudo apt-get install mythbuntu-control-centre) under the MySQL section you can enable outside connections.

Second, on the Mythbackend General settings make sure you use the IP of the master backend not the loopback or localhost addresses.


Thanks for posting that, I had roll back my system to a previous state where I was having this issue again. The top address must be the real static ip address of your master backend. I could not figure this out, until I remembered that I posted about the issue here.
find quote