Nginx & fcgiwrap, logging perl errors to error log

nginxperlspawn-fcgi

This is similar to this question, which got no responses:
How to debug CGI over fcgiwrap/nginx

How do I get perl errors to be automatically placed in the nginx error log? Right now, when there is any perl error, the following message goes in the error log:

2014/05/11 22:43:48 [error] 1730#0: *5 connect() failed (111: Connection refused) while connecting to upstream, client: localhost, server: localhost, request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "localhost"

This is completely useless for debugging. I can use something like CGI::Carp qw{fatalsToBrowser}, but this is not optimal. It would be better to have it logged to a server-side file.

Best Answer

You can use this solution to send both STDOUT and STDERR to any log file you have access to write to, including your nginx error.log. Though it'd likely be more helpful to send it to a different file. Simply remove the STDOUT entries, if you only want STDERR output.

Related Solutions

Nginx – How to get PHP 5.3.3 working with Nginx on CentOS 5.5

Ensure php-fpm is running (ps auxw | grep php or any number of ways)
Ensure php-fpm is actually listening on 9000. (check the configs)
Ensure your software firewall isn't blocking loopback connections on 9000.

I'm not an nginx guy, but the error message is pretty clear: nobody's answering the phone at 127.0.0.1:9000

Nginx + PHP-fastcgi + MySQL on CentOS: 502 Bad Gateway in all files with MySQL connection

Looks like PHP won't able to connect to MySQL dispute which http server you use and the way you ling php to http server.

First, check if your MySQL is running and listen at all (you may forget to run it). Simply run mysql from CLI, and see if it connects. You may need to use -h host key to point mysql client to right host.

Then, try to run the simplest script (like

<?php
$link = mysql_connect('hostname', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

so you'll see what's the error. If your MySQL listen on localhost (127.0.0.1), then use 'localhost' as hostname ('hostname' in the example), if it listen in socket, then use socket path (something like ':/tmp/mysql').

Good luck!

Best Answer

Related Solutions

Nginx – How to get PHP 5.3.3 working with Nginx on CentOS 5.5

Nginx + PHP-fastcgi + MySQL on CentOS: 502 Bad Gateway in all files with MySQL connection

Related Topic