[mythtv-users] alt lightweight web servers for MythTV?

[George Nassas]

On Apr 16, 2015, at 1:44 PM, James Miller <gajs-f0el at dea.spamcon.org> wrote:

> No output when, having pasted that content into test.php in place of the former content, I curl that file. Just returns me to the command prompt.

That’s OK, output means problem, no output means success. We now know that php is able to talk to mysql and all the libraries are in place and so forth.

> Yeah, that's a lot of output. I can look at it using a graphical browser on localhost, but I don't get much out of it. See http://pastebin.com/45TRG0Pi <http://pastebin.com/45TRG0Pi>

I took a look at the versions to make sure it wasn’t a case of seeming like one version of php was in use while another one was actually running. Looks good.

> I did, in a bit of preliminary searching last night, run across this thread http://www.gossamer-threads.com/lists/mythtv/users/560108 where Mike Perkins claimed, a couple of years ago, that he'd resolved a problem like mine (see post #7). Does his resolution provide any helpful information?

You could try it, either by changing the fastcgi server parameter in the nginx config or by rerunning that test.php with the server changed:

<?php
    mysql_connect('127.0.0.1', 'mythtv', 'mythtv') or die('Could not connect: ' . mysql_error());
    mysql_select_db('mythconverg') or die('Could not select database');
    $row = mysql_fetch_assoc(mysql_query("select count(*) num from recorded"));
    echo $row["num"] . " recordings.";
?>
 
I also added some output for a successful run. I tried screwing up the credentials on my running mythweb instance but it failed in the “right” way - I got all sorts of output telling me my db config was screwed up etc. so the fact that yours is running through that code without complaint and then failing later on makes me wonder. It could be that something subtle has changed in php or you don’t have some php.ini setting the way mythweb wants and the database handle isn’t being saved as intended. I’ll look through the code for some place to put helpful logging and post back later.

> Thanks for sticking with me on this, George. I'd be totally lost without some guidance on things to try in hopes of resolving this.

No probs. If that info.php file is still in the mythweb directory you could try browsing to it from a computer on your network, I think the remote access problem is also solved and that would demonstrate it.

- George
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150417/520a30af/attachment.html>