[mythtv-users] mythbackend looking for wrong ip address

[G Venkataraman]

On 10/30/07, Steve Peters - Priority Electronics <
steve at priorityelectronics.com> wrote:

> From: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Ralf Kleineisel
> Sent: Tuesday, October 30, 2007 2:46 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] mythbackend looking for wrong ip address
>
> Steve Peters - Priority Electronics wrote:
>
> >         You can verify this to be the problem by attempting to restart
> > the backend:
> >                 sudo /etc/init.d/mythtv-backend restart
> >         Then checking that the backend successfully started:
> >                 ps -p `cat /var/run/mythtv/mythbackend.pid`
> >
> > That gave me this message (among a bunch of other stuff)...
> >             Can't connect to MySQL server on '192.168.1.2' (113) ...my
> > mysql.txt file is setup for 192.168.1.3...so where could this
> > 192.168.1.2 setting be stored? When i just run mythbackend as root,
> > all works great, when i run mythtv-backend start, it fails. why and
> > how is this happening?
>
> >>Does Ubuntu have something like /etc/sysconfig/mythbackend? This is
> >>where the init.d configs go in Fedora.
>
> Not that I know of
> -Steve


I have seen multiple copies of the mysql.txt file on my combined
frontend/backend system too. Fortunately for me, all of them are consistent.

Is it the case that when you interactively start mythbackend as root, it
looks for (and finds) the correct mysql.txt based on the $HOME environment
variable of the root user (/root/.mythtv/mysql.txt). And when mythbackend is
started as part of the system startup, there is no $HOME environment
variable set explicitly and hence it will not find the mysql.txt under the
root user or any other user's home directory. Consequently, it falls back to
the system/global mysql.txt (/usr/share/mythtv/mysql.txt), which in your
case had the incorrect IP address of the DB server.

-=Venkat=-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071030/4ed254ca/attachment.htm