<br><br><div><span class="gmail_quote">On 2/22/07, <b class="gmail_sendername">Nick Morrott</b> <<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 19/02/07, Matt Emmott <<a href="mailto:memmott@gmail.com">memmott@gmail.com</a>> wrote:<br>> I'm running <a href="http://mythtv-0.20-146.fc6.at">mythtv-0.20-146.fc6.at</a> as a combined frontend/backend machine. I
<br>> just set up a mythdora 3.2 box as a test frontend, but I haven't been able<br>> to get it to connect to the backend. If I go into mythtv status it can see<br><br>What is the output of mythfrontend --version on backend and new
<br>frontend? If you know the revision of each installation, you can check<br>the protocol version and library versions by checking<br><a href="http://cvs.mythtv.org/trac/browser/trunk/mythtv/libs/libmyth/mythcontext.h">http://cvs.mythtv.org/trac/browser/trunk/mythtv/libs/libmyth/mythcontext.h
</a><br>for each revision.</blockquote><div><br>Frontend: <br><br>2007-02-24 16:59:52.881 Using runtime prefix = /usr<br>2007-02-24 16:59:52.889 DPMS is active.<br>2007-02-24 16:59:52.931 New DB connection, total: 1<br>2007-02-24 16:59:
52.942 Connected to database 'mythconverg' at host: <a href="http://192.168.2.98">192.168.2.98</a><br>2007-02-24 16:59:52.945 Total desktop dim: 1024x768, with 1 screen[s].<br>2007-02-24 16:59:52.949 Using screen 0, 1024x768 at 0,0
<br>Library API version: 0.20.20060828-3<br>Source code version: Unknown<br>Options compiled in:<br> linux release using_xvmcw using_lmsensors using_v4l using_oss using_alsa using_arts using_jack using_ivt<br>v using_firewire using_dbox2 using_hdhr using_ip_rec using_freebox using_live using_lirc using_joystick_m
<br>enu using_dvb using_x11 using_xv using_xrandr using_xvmc using_xvmc_vld using_opengl_vsync using_opengl u<br>sing_frontend using_backend<br><br>Backend: <br>2007-02-24 17:01:37.675 Using runtime prefix = /usr<br>2007-02-24 17:01:
37.681 DPMS is disabled.<br>2007-02-24 17:01:37.693 New DB connection, total: 1<br>2007-02-24 17:01:37.698 Connected to database 'mythconverg' at host: localhost<br>2007-02-24 17:01:37.699 Total desktop dim: 1024x768, with 2 screen[s].
<br>2007-02-24 17:01:37.702 Using screen 0, 1024x768 at 0,0<br>Library API version: 0.20.20060828-3<br>Source code version: Unknown<br>Options compiled in:<br> linux release using_xvmcw using_lmsensors using_v4l using_oss using_alsa using_
<br>arts using_jack using_ivtv using_firewire using_dbox2 using_hdhr using_ip_rec us<br>ing_freebox using_live using_lirc using_joystick_menu using_dvb using_x11 using_<br>xv using_xrandr using_xvmc using_xvmc_vld using_frontend using_backend
<br><br><br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">> my backend's mythfilldatabase stats, but other than that I keep getting the
<br>> "cannot connect to backend database" errors.<br><br>Can you connect to the database from the mythdora box from the command<br>line? I'm thinking this is still a database permissions error rather<br>
than a MythTV protocol version from the error you noted. Check the<br>mysql.txt file for the new system and make sure the details of the SQL<br>server are correct, and ensure your SQL server has granted sufficient<br>permissions for the new machine to connect. What SQL GRANT statement
<br>did you use to give access to the new box to the mythconverg database?</blockquote><div><br>Here's the output when connecting from the frontend (backend is <a href="http://192.168.2.98">192.168.2.98</a>):<br>[root@mythdora
~]# mysql -u mythtv -h <a href="http://192.168.2.98">192.168.2.98</a> -p<br>Enter password:<br>Welcome to the MySQL monitor. Commands end with ; or \g.<br>Your MySQL connection id is 724 to server version: 5.0.22<br><br>
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br><br>mysql><br><br> 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:
<br><br>[root@mythbox ~]# mysql -u root -p<br>Enter password:<br>Welcome to the MySQL monitor. Commands end with ; or \g.<br>Your MySQL connection id is 711 to server version: 5.0.22<br><br>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
<br><br>mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP<br> -> ON mythconverg.*<br> -> TO 'mythtv'@'<a href="http://192.168.2.97">192.168.2.97</a>'<br> -> IDENTIFIED BY 'mythtv';
<br>Query OK, 0 rows affected (0.07 sec)<br><br>mysql><br><br></div><br>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.
<br></div><br>