Re: [cobalt-users] new PHP, Apache, & mySQL .pkg's don't work together

[Nell Bolen <nell@xxxxxxxxxxxxxx>]

Paul Schmidt wrote:

> i just upgraded my RaQ4r with all of the latest security, bug, and software
> udates found at both <http://pkg.nl.cobalt.com/> and
> <http://www.cobalt.com/support/download/raq4.eng.html> last week. everything
> works ok except PHP will not communicate with mySQL. phpMyAdmin generates
> errors when trying to set up a new database and a shopping cart developed in
> PHP will not work either. i had older versions of both that worked fine
> together. my programmer tried everything listed below (no compiling has been
> done yet):
>
> > mgkimsal: I've got to pull down Apache and do a partial compile so the
> > headers are there
> > mgkimsal: so PHP can compile against them
> > mgkimsal: so I can compile PHP as a DSO
> > mgkimsal: to (hopefully) let it tie in with your current Apache
> > mgkimsal: and it also needs to link against mySQL
> > mgkimsal: which I had to pull down afresh and do last night
> > mgkimsal: but that broke the ODBC stuff for your netastic store
> > mgkimsal: and I dunno what, if anything else, it broke
> > mgkimsal: just doing the PKGs didn't work
> > mgkimsal: i erased mySQL
> > mgkimsal: and put on the binary tar.gz file from mysql.com
> > mgkimsal: and pointed it to /home/mySQL
> > mgkimsal: and it seems to work
> > mgkimsal: at least as good as it did before,
> > mgkimsal: but the unixODBC stuff is broke I think - I can't really tell
> BTW here is a bug report on PHP that could be related
> <http://www.php.net/bugs.php?id=4759>
>
> For anyone who can help with this, here's some additional stuff...
>
> <http://www.php.net/bugs.php?id=4759> describes the bug symptoms.
>
> Things get put in the database, but only the first SQL INSERT or UPDATE or
> DELETE command works - "SELECTs" work fine, but anything that needs to
> update the DB in any way breaks. It *works*, but PHP reports an error.
>
> What seems to be the case is that the client library compiled in to PHP is
> somewhat out of date, and the new mysql stuff doesn't talk properly with an
> old library. That's my hunch. The other related possibility is that there is
> another mysql client library loaded into Apache's RAM space which is
> conflicting with the PHP one. A possibility, because iHTML and unixODBC are
> on the box ( think).
>
> Has anyone else been able to simply use the cobalt PKG files for mysql and
> PHP and have them work together without this bug?
>
> Thanks...
>
> Paul Schmidt
> NETastic, Inc.
> 248.682.8600
>
> _______________________________________________

Yes, Paul Schmidt,

I just got a RAQ4i about a week ago that was supposed to already have MySql on
it. Nope. So ... I went to the Cobalt package place in Netherlands, downloaded
the most recent MySql  -- the topmost MySql package with the 7 in it  -- machine
already had PHP, 4.03 I think -- and let the RAQ interface install it. Am
thinking it works pretty well because I had done little with MySql beyond
scripting  and using it with PHP for website interaction.

I did have to try two or three times to get the interface between the two to
connect. What worked finally for me was to uninstall/install MySql, skip the ASP
server (ASP is enabled) add database steps, then telnet for root password and
install_db_tables, then use PhpAdmin to set up the privileges, etc.

First thing, all the transferred scripts, some PHP3 versions altered in
extension only, worked just fine, but they are fairly simple scripts.
Nevertheless, I feel like one lucky duck about it. Would have tried the final
method sooner except all the Cobalt literature I've read warns users away from
telnet -- use the panel, it says, and they might be right, but I don't know all
the things the panel is doing, and I can tell telnet what to do, so that worked
for me.

Best of luck -- Nell Bolen
nell@xxxxxxxxxxxxxx