php, mysql, ligthtpd, fastcgi and the like

[kaltsoplyn]

Hi all.

Ok, so I tried to set up my TC box to serve php through fastCGI and lighttpd.
It wouldn't work as I was getting all kinds of errors in the lighttpd errorlog, all coming from fastCGI which refused to start.
After resolving a number of issues, I started getting (persistently) this:

2011-11-06 22:44:03: (mod_fastcgi.c.1104) the fastcgi-backend /usr/local/bin/php-cgi failed to start:
2011-11-06 22:44:03: (mod_fastcgi.c.1108) child exited with status 127 /usr/local/bin/php-cgi
2011-11-06 22:44:03: (mod_fastcgi.c.1111) If you're trying to run your app as a FastCGI backend, make sure you're using the FastCGI-enabled version.
If this is PHP on Gentoo, add 'fastcgi' to the USE flags.
2011-11-06 22:44:03: (mod_fastcgi.c.1399) [ERROR]: spawning fcgi failed.
2011-11-06 22:44:03: (server.c.938) Configuration of plugins failed. Going down.

(sorry for the 'quote'. For some reason I'm not allowed to post code)

So I said that first thing's first, I should check to to see if I could get anything from php.
Being a - almost complete - newb in this area, I opened a terminal and gave a

/usr/local/bin/php -v

which returned (same error for php-cgi, of course):

/usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: no such file or directory

Indeed, there is no such file, since mysql libraries are at .18 rather than .16

Now to me this doesn't look good. Is this my problem?

[bmarkus]

Looks like php must be rebuild against current MySQL. As a temporary solution try symlink libmysqlclient.so.16 to libmysqlclient.so.18 It may work.

[kaltsoplyn]

hmm thanks, but no, it doesn't seem to work. Actually, after I create the symlinks, php still complains about libmysqlclient.so.16 no such file or directory.

This confuses me, though, because it could qualify as a kinda top level issue. I mean it's php, which is kind of a big deal, and if I get this right, if one installs TC today, with the existing TCZ for php and mysql, he just won't be able to get php running? Is this possible? Nobody else in the Tiny Core community is having problems with php + mysql.18 ?

[Rich]

Hi kaltsoplyn
The 4.x repository is still in the process of being built up. As extensions are moved from 3.x to 4.x
some of them are being updated so an occasional glitch will crop up.

[robc]

php still complains about libmysqlclient.so.16 no such file or directory.

if the symlink was made then it will not complain about it not being there. Did you run `sudo ldconfig` after creating the symlink?

php is on my to do list...along with many others

[kaltsoplyn]

Hi and thanks for the answers. I really appreciate the time you people put in this project and so does everybody else here (I guess). The situation struck me as kinda weird, that's all, so I thought I'd ask. Keep up guys.

As for the symlinks, well, I was toying with 2 linux boxes yesterday and, well, I got a little confused.
Guessed it? I made the symlinks in one box (the one I was browsing when I read bmarkus' post), forgot all about it and a couple hours later tried running php on my TC box, remembering that I had created symlinks...somewhere...
Not my proudest moment (not my dumbest, either)...

[kaltsoplyn]

symlinking

/usr/local/lib/libmysqlclient.so.16 to /usr/local/mysql/lib/libmysqlclient.so.18

and

/usr/local/lib/libgmp.so.3 to /usr/local/lib/libgmp.so.10

at least gets the server started. Simple php is served well; haven't tried anything elaborate, though.

So, this is what? Partially solved, workarounded or what?

P.S.: just a question, though, because I ain't got a clue about those things: Is it necessary for the binaries of something to be compiled against a certain version of a shared library? Is this standard practice? Doesn't it guarantee that this something will fail when the shared libraries are updated?

[curaga]

Worked around. There is a risk of incompatibility doing that.

Which version of a shared lib is linked against is decided by the upstream of that lib; if they keep a stable minor interface or whether each version will link differently, etc.

[robc]

symlinking

/usr/local/lib/libmysqlclient.so.16 to /usr/local/mysql/lib/libmysqlclient.so.18

and

/usr/local/lib/libgmp.so.3 to /usr/local/lib/libgmp.so.10

at least gets the server started. Simple php is served well; haven't tried anything elaborate, though.

gmp should already have the symlink: http://forum.tinycorelinux.net/index.php/topic,11813.0.html
updating your extensions should get rid of at least that one