On 10/30/07, <b class="gmail_sendername">Steve Peters - Priority Electronics</b> <<a href="mailto:steve@priorityelectronics.com">steve@priorityelectronics.com</a>> wrote:<div><span class="gmail_quote"></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
From: <a href="mailto:mythtv-users-bounces@mythtv.org">mythtv-users-bounces@mythtv.org</a><br>[mailto:<a href="mailto:mythtv-users-bounces@mythtv.org">mythtv-users-bounces@mythtv.org</a>] On Behalf Of Ralf Kleineisel<br>Sent: Tuesday, October 30, 2007 2:46 PM
<br>To: Discussion about mythtv<br>Subject: Re: [mythtv-users] mythbackend looking for wrong ip address<br><br>Steve Peters - Priority Electronics wrote:<br><br>> You can verify this to be the problem by attempting to restart
<br>> the backend:<br>> sudo /etc/init.d/mythtv-backend restart<br>> Then checking that the backend successfully started:<br>> ps -p `cat /var/run/mythtv/mythbackend.pid`
<br>><br>> That gave me this message (among a bunch of other stuff)...<br>> Can't connect to MySQL server on '<a href="http://192.168.1.2">192.168.1.2</a>' (113) ...my<br>> mysql.txt file is setup for
192.168.1.3...so where could this<br>> <a href="http://192.168.1.2">192.168.1.2</a> setting be stored? When i just run mythbackend as root,<br>> all works great, when i run mythtv-backend start, it fails. why and<br>
> how is this happening?<br><br>>>Does Ubuntu have something like /etc/sysconfig/mythbackend? This is<br>>>where the init.d configs go in Fedora.<br><br>Not that I know of<br>-Steve</blockquote><div><br>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.<br><br>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.
<br><br>-=Venkat=-<br></div></div><br>