[mythtv-users] Should a mythtv-0.20-148.fc5.at frontend be able to talk to a mythtv-0.20-146.fc6.at backend?

[Matt Emmott]

On 2/22/07, Nick Morrott <knowledgejunkie at gmail.com> wrote:
>
> On 19/02/07, Matt Emmott <memmott at gmail.com> wrote:
> > I'm running mythtv-0.20-146.fc6.at as a combined frontend/backend
> machine. I
> > just set up a mythdora 3.2 box as a test frontend, but I haven't been
> able
> > to get it to connect to the backend. If I go into mythtv status it can
> see
>
> What is the output of mythfrontend --version on backend and new
> frontend? If you know the revision of each installation, you can check
> the protocol version and library versions by checking
> http://cvs.mythtv.org/trac/browser/trunk/mythtv/libs/libmyth/mythcontext.h
> for each revision.


Frontend:

2007-02-24 16:59:52.881 Using runtime prefix = /usr
2007-02-24 16:59:52.889 DPMS is active.
2007-02-24 16:59:52.931 New DB connection, total: 1
2007-02-24 16:59:52.942 Connected to database 'mythconverg' at host:
192.168.2.98
2007-02-24 16:59:52.945 Total desktop dim: 1024x768, with 1 screen[s].
2007-02-24 16:59:52.949 Using screen 0, 1024x768 at 0,0
Library API version: 0.20.20060828-3
Source code version: Unknown
Options compiled in:
 linux release using_xvmcw using_lmsensors using_v4l using_oss using_alsa
using_arts using_jack using_ivt
v using_firewire using_dbox2 using_hdhr using_ip_rec using_freebox
using_live using_lirc using_joystick_m
enu using_dvb using_x11 using_xv using_xrandr using_xvmc using_xvmc_vld
using_opengl_vsync using_opengl u
sing_frontend using_backend

Backend:
2007-02-24 17:01:37.675 Using runtime prefix = /usr
2007-02-24 17:01:37.681 DPMS is disabled.
2007-02-24 17:01:37.693 New DB connection, total: 1
2007-02-24 17:01:37.698 Connected to database 'mythconverg' at host:
localhost
2007-02-24 17:01:37.699 Total desktop dim: 1024x768, with 2 screen[s].
2007-02-24 17:01:37.702 Using screen 0, 1024x768 at 0,0
Library API version: 0.20.20060828-3
Source code version: Unknown
Options compiled in:
 linux release using_xvmcw using_lmsensors using_v4l using_oss using_alsa
using_
arts using_jack using_ivtv using_firewire using_dbox2 using_hdhr
using_ip_rec us
ing_freebox using_live using_lirc using_joystick_menu using_dvb using_x11
using_
xv using_xrandr using_xvmc using_xvmc_vld using_frontend using_backend



> my backend's mythfilldatabase stats, but other than that I keep getting
> the
> > "cannot connect to backend database" errors.
>
> Can you connect to the database from the mythdora box from the command
> line? I'm thinking this is still a database permissions error rather
> than a MythTV protocol version from the error you noted. Check the
> mysql.txt file for the new system and make sure the details of the SQL
> server are correct, and ensure your SQL server has granted sufficient
> permissions for the new machine to connect. What SQL GRANT statement
> did you use to give access to the new box to the mythconverg database?


Here's the output when connecting from the frontend (backend is 192.168.2.98
):
[root at mythdora ~]# mysql -u mythtv -h 192.168.2.98 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 724 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

 I just went in and granted permissions again. I believe I had set them to
allow connections from any IP on my subnet, but I can't remember and have no
idea how to tell, so I explicitly granted access to my frontend's IP:

[root at mythbox ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 711 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    -> ON mythconverg.*
    -> TO 'mythtv'@'192.168.2.97'
    -> IDENTIFIED BY 'mythtv';
Query OK, 0 rows affected (0.07 sec)

mysql>


It seems that I can see "some" of the things on the backend. For example, if
I go to manage recordings I can see the previously recorded shows, but if I
go to Media Library - Watch Recordings I get the standard "could not connect
to the master backend server - is it running?" error message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070224/87728fa2/attachment.htm