[mythtv-users] Getting more debug info out of mythweb?

[Tom Harris]

On Tue, Feb 28, 2017 at 5:06 AM, Mark Perkins <perkins1724 at hotmail.com>
wrote:

> On 28 February 2017 7:24:15 AM Tom Harris <thom.j.harris at gmail.com> wrote:
>
> > My mythweb has been broken for months, since I upgraded my mythbuntu from
> > 0.27 (14.04) to 0.28 (16.04).  I have tried several times to dig into the
> > system and figure out what the hangup is, I've never gotten it working.
> >
> > Mythweb complains about my DB:
> >      !!NoTrans: SQL Error: No database selected [#1046]!!
> >
> > I've checked and re-checked my mythweb.conf and
> > /etc/apache2/sites-enabled/mythweb.conf.   My DB name, credentials, etc.
> > are all correct.  So, I'm looking for some way to get more debug info out
> > of mythweb to verify where it's looking for the DB credentials and what
> it
> > thinks they are.
> >
> > Anyone already win this fight? Any tips?
> >
> >
> >
>
>
> Check for any other conf files that might be in play in
> /etc/apache2/sites-enabled/
>
> Otherwise post the contents of your mythweb.conf and probably my.conf
> (obscure pw etc) and see if anyone spots something.
>
> What does:
> netstat -peanut | grep 3306
>
> Return from a terminal on your backend?
>
Thanks for the response.  Some good points there, but I had already cleaned
out the apache server configs and verified mysql was working correctly.

I finally got it working again.  I'm not sure exactly what the issue was,
but I progressively removed and re-installed more and more packages and
eventually after fixing some apache issues in the re-installed packages by
hand, it began working again.  I removed mythweb, apache, and php and
cleaned out any related files.

So, for anyone running into this in the future (judging from all the
questions posed in various forums, this seems to be a recurring problem
with every version upgrade) - my advice is to purge everything related to
mythweb, re-install it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170305/78d9eb55/attachment.html>