[mythtv-users] mythfrontend client can't connect to database on the backend server

Chris Funk cfunk30myth at gmail.com
Thu Apr 12 19:29:21 UTC 2007


On 4/12/07, r2d2 <r2d2z4j6y8 at gmail.com> wrote:
>
> Hello
>
> There is no other mysql.txt file.
>
> So, I tried adding a symbolic link ~/.mythtv/mysql.txt -> ~/mysql.txt but
> doesn't work either.
>
> I decided to analyze traffic with ethereal from the client.
>
> When I try using mysql client, I can see frames going to my mythtvbox.
> But, when I launch the frontend, no traffic to my mythtvbox from the network
> device (eth2) of the client.
>
> I don't know what's wrong.
>
> Regards.
>
> On 4/12/07, Noah Markon <nmarkon at gmail.com> wrote:
> >
> > i had to put a mysql.txt (or link) in my home directory (~/ ), not in
> > ~/.mythtv/
> >
> > On 4/11/07, Chris Funk <cfunk30myth at gmail.com> wrote:
> > >
> > >
> > >
> > > On 4/11/07, r2d2 <r2d2z4j6y8 at gmail.com> wrote:
> > > >
> > > > Hello,
> > > >
> > > > I am trying to configure a frontend machine to connect to a backend
> > > server.
> > > >
> > > > The client machine is a ubuntu dapper drake with frontend compile
> > from
> > > mythtv-0.20-fixes: revision 13203.
> > > > Here is the configure line I passed :
> > > > ./configure --disable-dvb --disable-xvmc --disable-firewire
> > > --disable-freebox --disable-dbox2 --disable-hdhomerun
> > --disable-crciprec
> > > --disable-ivtv --disable-joystick-menu --disable-v4l
> > > >
> > > > The backend server is a ubuntu edgy eft with backend compile from
> > > mythtv-0.20-fixes: revision 13110.
> > > >
> > > > I have disable firewalls on both sides.
> > > > I am able to connect to mysql database from the client : mysql -h
> > > mythtvbox -u mythtv -pmythtv mythconverg
> > > >
> > > > Here is my ~/.mythtv/mysql.txt:
> > > > ------------------------------------
> > > > DBHostName=mythtvbox
> > > > DBUserName=mythtv
> > > > DBPassword=mythtv
> > > > DBName=mythconverg
> > > > DBType=QMYSQL3
> > > > -------------------------------------
> > > >
> > > > When running mythfrontend from the client I am retrieving the
> > following
> > > error :
> > > >
> > >
> > ---------------------------------------------------------------------------
> > > > 2007-04-09 17:26:16.995 Using runtime prefix = /usr/local
> > > > 2007-04-09 17:26:17.018 DPMS is disabled.
> > > > 2007-04-09 17:26:17.025 New DB connection, total: 1
> > > > 2007-04-09 17:26: 17.025 Unable to connect to database!
> > > > 2007-04-09 17:26:17.026 No error type from QSqlError?  Strange...
> > > > 2007-04-09 17:26:17.089 DB Error (KickDatabase):
> > > > Query was:
> > > > SELECT NULL;
> > > >
> > >
> > ----------------------------------------------------------------------------
> > > >
> > > > I appreciate some help.
> > > >
> > > > Regards.
> > > >
> > > > _______________________________________________
> > > > mythtv-users mailing list
> > > > mythtv-users at mythtv.org
> > > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > > >
> > > >
> > >
> > >
> > > Does  "locate mysql.txt"  find any other files?  I usually seem to
> > have one
> > > that gets put in /.mythtv/mysql.txt
> > >
> > >  Chris
> > >
> > >
> > >
> > > _______________________________________________
> > > mythtv-users mailing list
> > > mythtv-users at mythtv.org
> > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > >
> > >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
This is a complete guess, and I don't know if it applies to the frontend,
but do you have qt-mysql?  I'm pretty sure the backend needs it, but again,
not sure on the frontend.

Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070412/325a21fc/attachment.htm 


More information about the mythtv-users mailing list