lighttpd + php5 + mysql

[StarFishes]

Hallo,

I'm planning to run the configuration lighttpd, php5 and mysql on my plug. Yesterday I tried to install each component and so far everything went just fine.

But when I tried to edit the lighttpd.config and inserted the fastcgi module and the fastcgi.server-entry lighty seems to crash because no webpage can be opened any more.

I try to get it started on the pre-installed jaunty without any kernel modifications, does anybody have a clue what's causing the problem? I've already went through the same procedure on my NSLU2 with Debian Lenny without any problems. Is there a difference in the configuration?

Thank you in advance,
StarFishes

[davall]

Have a running debian lenny on the plug with php-fcgi, lighttpd and mysql.
--
sudo apt-get install mysql-server mysql-client php5-cgi php5-mysql lighttpd
--
should also do the trick on ubuntu.

in lighttpd.conf you should have:
-----------------------
server.modules              = (
            "mod_access",
            "mod_alias",
            "mod_fastcgi",
            "mod_accesslog",
            "mod_compress"
)
## fastcgi server
fastcgi.server = ( ".php" => ((
                     "bin-path" => "/usr/bin/php-cgi",
                     "socket" => "/tmp/php.socket"
                 )))
---------------------

You can check everything with info.php which should look like
---------------------
<?php
phpinfo();
?>
---------------------
The output of the third row then looks like --->
Server API    CGI/FastCGI

Hope this helps,

davall

[StarFishes]

Hallo again,

thank you for your fast reply!

The way you described is exactly what I did. Installing the web server works properly, the index-page appers then entering the ip of the plug.

But as soon as I add the fastcgi-mod it doesn't work any more, not even the index-page opens. When deleting the fast-cgi-lines the page opens again.

I really don't unterstand what the problem could be. I've also inserted the "cgi.path_info = 1"-line into the php.ini but still the same problem.

Any suggestions?

Greetz,
StarFishes

[davall]

If i rember right you are on ubuntu jaunty and not on debian.
I would do an apt-get remove --purge lighttpd php-cgi ....
and afterwards reinstall everything.
If this doesn't work it seems to be jaunty related.
Another idea is to check the logs in /var/log/lighttpd/ and find some usefull infos.

Good luck!

-davall

[StarFishes]

Hallo davall,

thank you for your support!

The hint with the logs was a good hint, because it says

2009-06-26 19:01:34: (mod_fastcgi.c.904) bind failed for: unix:/tmp/php.socket-0 Permission denied
2009-06-26 19:01:34: (mod_fastcgi.c.1358) [ERROR]: spawning fcgi failed.
2009-06-26 19:01:34: (server.c.908) Configuration of plugins failed. Going down.

in there. So I see that the permissions are not set right, do you know what and how to change? Or anybody else? :-)

Thank you and best regards,
StarFishes

[davall]

With the help of a search engine i only found this hint:
https://bugzilla.redhat.com/show_bug.cgi?id=493383

Seems to be the same on your machine?
Hope this helps,

-davall

[StarFishes]

Thank you very much for the link!

I could resolve the problem with the simple chmod on the /tmp-folder. Problem is that you have to grant writing access for everybody, but at least it works that way. Maybe I'll follow the steps descriped in the link previously mentioned.

But so far, there seems the be a solution at last! :-)

[davall]

StarFishes, good to hear!
Please be so kind and mark this topic as solved to help others with this kind of problem.

-davall

[sanjayayogi]

I have all the same errors, I do not want  to install mysql for now, I installed lighttpd, no problems, it was stable uptil I added the php-cgi, uncommented the fastcgi mod in php.ini, then:
lighttpd-enable-mod fastcgi
/etc/init.d/lighttpd force-reload
tail /var/log/lighttpd/error.log
2009-08-21 21:54:50: (log.c.75) server started
2009-08-21 21:54:50: (mod_fastcgi.c.904) bind failed for: unix:/tmp/php.socket-0 Permission denied
2009-08-21 21:54:50: (mod_fastcgi.c.1358) [ERROR]: spawning fcgi failed.
2009-08-21 21:54:50: (server.c.908) Configuration of plugins failed. Going down.
lighttpd-disable-mod
remove the fastcgi
/etc/init.d/lighttpd force-reload
2009-08-21 22:02:22: (log.c.75) server started
So it is definitely a permissions problem:
Would somebody please post the work around again. I really need to have php running properly, I was hoping to use lighttpd instead of apache2 - Responses anyone? THX!
Oh I am running the Ubuntu default: 9.04 that came with my sheevaplug with updates installed as of today.

[minaya]

In Debian /tmp is writable for everyone by default. But if you don't want to let everyone touch /tmp, you should look for other directory where lighty user can write php socket. It's well documented in http://redmine.lighttpd.net/wiki/lighttpd/Docs:ModFastCGI

[birdman]

If you don't make /tmp world-writeable (with the sticky-bit set) then it will be more than php that has problems.

[sanjayayogi]

chmod 1777 /tmp ??

[minaya]

chmod 1777 /tmp ??

yes. It should look like drwxrwxrwt

[torami]

I would also recommend that you disable logging after you have installed everything (and got it working ofcourse )
you can do this simply by commenting out these lines

#server.errorlog            = "/var/log/lighttpd/error.log"
#accesslog.filename         = "/var/log/lighttpd/access.log"

in  /etc/lighttpd/lighttpd.conf

most of you know why, but to those of you who don't:
A NAND flash or a SD-card (uses flash based storage as well) wears out fairly quickly if there's lots of writes to it, so this will just make your plug last a bit longer...

[Digmecy09]

Am Back Guys

Recently im working on a new site. PHPNuke but am stuck with this frustrate message:

There seems to be a problem with the MySQL server, sorry for the inconvenience.

We should be back shortly.

I already checked my config.php file, everything seems to be ok,

IS THERE ANYTHING ELSE THAT I SHOULD BE CONCERN ABOUT



Thanks in Advanced