[mythtv-users] mysql issue when accessing backend from a remotefrontend

[Andy Barr]

On 8/20/06, Andy Barr <ajbarr at gmail.com> wrote:
> On 8/19/06, William Munson <wmunson at rochester.rr.com> wrote:
> > >
> > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > >
> > > mysql> select host, user, password from user;
> > > +--------------+------------------+------------------+
> > > | host         | user             | password         |
> > > +--------------+------------------+------------------+
> > > | localhost    | root             | 121900c5120ed8d8 |
> > > | mythtv       | root             |                  |
> > > | localhost    | debian-sys-maint | 417a15742dd5e8e5 |
> > > | localhost    | mythtv           | 0476fc026afffe24 |
> > > | %            | mythtv           | 0476fc026afffe24 |
> > > | 192.168.2.%% | mythtv           | 0476fc026afffe24 |
> > > | 192.168.2.50 | mythtv           | 67457e226a1a15bd |
> > > | 192.168.2.%  | mythtv           | 0476fc026afffe24 |
> > > | xbox         | mythtv           | 0476fc026afffe24 |
> > > +--------------+------------------+------------------+
> > > 9 rows in set (0.00 sec)
> > >
> > > I suspect this is some mysql configuration issue but I searched and
> > > tried every suggestion I saw.  Does anyone have any more ideas?
> > > Thanks,
> > > Andy
> > >
> >
> > This may seem a bit obvious, is your network on 192.168.2.%?  Most are
> > on .1.%
> >
> > Another option would be to install webmin and use it to configure mysql
> > in a nice gui. You should be able to verify if the server is working. by
> > telneting to your backend on the mysql port from your remote machine and
> > see what your login attempt does.
> >
>
> Yes my network is 192.168.2.%.
>
> I installed webmin and as best I can tell permissions are correct.
> Under user permissions it says,
> mythtv 192.168.2.% permissions=All
> Under database permissions it says the same thing with database of mythconverg.
> Nothing is listed under Host permissions.  Is that correct?
>
> This is what I get from telnetting.
>
> xbox:~/.ssh# telnet 192.168.2.253 3306
> Trying 192.168.2.253...
> Connected to 192.168.2.253.
> Escape character is '^]'.
> G
> 5.0.22-Debian_0ubuntu6.06'a6*j]p<wfvA"$/\bXt^
> Connection closed by foreign host.
>
> Thanks for the help.
> Andy
>
I just noticed that my xbox is running mysql client 4.0.22 but my
backend is running mysql 5.0.  Could this be causing the issue?