php-install Digest 6 Sep 2001 08:12:45 -0000 Issue 446
Topics (messages 4209 through 4218):
PHP 4.0.x and Openlink ODBC and OpenIngres, on Solaris
4209 by: Andre Felipe
installation problem
4210 by: Lawonna Daves
4211 by: Rasmus Lerdorf
4212 by: Lawonna Daves
4213 by: Lawonna Daves
4214 by: Rasmus Lerdorf
Subject: I tried to call you, when can we talk?
4215 by: LDD Talk
"New" problem? PHP4, NES 3.6 SP3, Solaris 2.6
4216 by: Joe D'Andrea
Compile problem
4217 by: Lawonna Daves
Mysql + PHP4 problem
4218 by: Ronen Friedman
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Hello friends,
I compiled PHP 4.0.x with iodbc support (using Openlink 4.0 drivers) to access
OpenINGRES 2.0, all this on Sun Solaris (2.6 or 2.8).
When I try some little test the odbc_connect is ok (resource id is #1), but....
no matter what query I try, the odbc_prepare or odbc_exec always return the error:
SQL error: [OpenLink][ODBC][Ingres Server]E_US09C5 line 1, Syntax error on '2,3'.
(-31000), SQL state S1000 in SQLPrepare
There's no '2,3' on my query....
The ODBC trace debug shows the error as:
generic_ingresii: ** E_US09C5 line 1, Syntax error on '2,3'. (-31000)
generic_ingresii: scs_p_GetTblAttribs: DRV_DDTables failed (srhtb002).
Any of you had this problem? any of you have an environment like mine (Solaris,
Openlink ODBC, Openingres 2.0 and PHP 4 ) working ok?
For illustration, this same installation (Solaris, Openlink ODBC 4.0, Openingres 2.0)
, but with PHP 3.0.12, works REAL NICE.
So, the problem is with PHP 4 or with Openlink ODBC drivers?
Thanks in advance,
André Felipe
[EMAIL PROTECTED] wrote:
> Hi! This is the ezmlm program. I'm managing the
> [EMAIL PROTECTED] mailing list.
>
> I'm working for my owner, who can be reached
> at [EMAIL PROTECTED]
>
> Acknowledgment: I have added the address
>
> [EMAIL PROTECTED]
>
> to the php-install mailing list.
>
> Welcome to [EMAIL PROTECTED]!
>
> Please save this message so that you know the address you are
> subscribed under, in case you later want to unsubscribe or change your
> subscription address.
>
> --- Administrative commands for the php-install list ---
>
> I can handle administrative requests automatically. Please
> do not send them to the list address! Instead, send
> your message to the correct command address:
>
> For help and a description of available commands, send a message to:
> <[EMAIL PROTECTED]>
>
> To subscribe to the list, send a message to:
> <[EMAIL PROTECTED]>
>
> To remove your address from the list, just send a message to
> the address in the ``List-Unsubscribe'' header of any list
> message. If you haven't changed addresses since subscribing,
> you can also send a message to:
> <[EMAIL PROTECTED]>
>
> or for the digest to:
> <[EMAIL PROTECTED]>
>
> For addition or removal of addresses, I'll send a confirmation
> message to that address. When you receive it, simply reply to it
> to complete the transaction.
>
> If you need to get in touch with the human owner of this list,
> please send a message to:
>
> <[EMAIL PROTECTED]>
>
> Please include a FORWARDED list message with ALL HEADERS intact
> to make it easier to help you.
>
> --- Enclosed is a copy of the request I received.
>
> Return-Path: <[EMAIL PROTECTED]>
> Received: (qmail 16093 invoked from network); 5 Sep 2001 18:54:30 -0000
> Received: from unknown (HELO mamona.sede.embrapa.br) (200.202.168.1)
> by pb1.pair.com with SMTP; 5 Sep 2001 18:54:30 -0000
> Received: from arroz.sede.embrapa.br (arroz.sede.embrapa.br [10.10.10.31])
> by mamona.sede.embrapa.br (8.11.3/8.11.3) with ESMTP id f85INtC00725
> for
><[EMAIL PROTECTED]>;
> Wed, 5 Sep 2001 15:23:55 -0300 (EST)
> Received: from sede.embrapa.br (pc10106.sede.embrapa.br [10.10.10.106])
> by arroz.sede.embrapa.br (8.11.0/8.11.0) with ESMTP id f85INsv19439
> for
><[EMAIL PROTECTED]>;
> Wed, 5 Sep 2001 15:23:54 -0300 (EST)
> Message-ID: <[EMAIL PROTECTED]>
> Date: Wed, 05 Sep 2001 15:23:52 -0300
> From: Andre Felipe <[EMAIL PROTECTED]>
> X-Mailer: Mozilla 4.76 [en] (Win98; U)
> X-Accept-Language: en
> MIME-Version: 1.0
> To:
>[EMAIL PROTECTED]
> Subject: Re: confirm subscribe to [EMAIL PROTECTED]
> References: <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
> [EMAIL PROTECTED] wrote:
>
> > Hi! This is the ezmlm program. I'm managing the
> > [EMAIL PROTECTED] mailing list.
> >
> > I'm working for my owner, who can be reached
> > at [EMAIL PROTECTED]
> >
> > To confirm that you would like
> >
> > [EMAIL PROTECTED]
> >
> > added to the php-install mailing list, please send
> > an empty reply to this address:
> >
> >
>[EMAIL PROTECTED]
> >
> > Usually, this happens when you just hit the "reply" button.
> > If this does not work, simply copy the address and paste it into
> > the "To:" field of a new message.
> >
> > or click here:
> >
>mailto:[EMAIL PROTECTED]
> >
> > This confirmation serves two purposes. First, it verifies that I am able
> > to get mail through to you. Second, it protects you in case someone
> > forges a subscription request in your name.
> >
> > Some mail programs are broken and cannot handle long addresses. If you
> > cannot reply to this request, instead send a message to
> > <[EMAIL PROTECTED]> and put the
> > entire address listed above into the "Subject:" line.
> >
> > --- Administrative commands for the php-install list ---
> >
> > I can handle administrative requests automatically. Please
> > do not send them to the list address! Instead, send
> > your message to the correct command address:
> >
> > For help and a description of available commands, send a message to:
> > <[EMAIL PROTECTED]>
> >
> > To subscribe to the list, send a message to:
> > <[EMAIL PROTECTED]>
> >
> > To remove your address from the list, just send a message to
> > the address in the ``List-Unsubscribe'' header of any list
> > message. If you haven't changed addresses since subscribing,
> > you can also send a message to:
> > <[EMAIL PROTECTED]>
> >
> > or for the digest to:
> > <[EMAIL PROTECTED]>
> >
> > For addition or removal of addresses, I'll send a confirmation
> > message to that address. When you receive it, simply reply to it
> > to complete the transaction.
> >
> > If you need to get in touch with the human owner of this list,
> > please send a message to:
> >
> > <[EMAIL PROTECTED]>
> >
> > Please include a FORWARDED list message with ALL HEADERS intact
> > to make it easier to help you.
> >
> > --- Enclosed is a copy of the request I received.
> >
> > Return-Path: <[EMAIL PROTECTED]>
> > Received: (qmail 14779 invoked from network); 5 Sep 2001 18:52:35 -0000
> > Received: from unknown (HELO php2.chek.com) (208.247.106.187)
> > by pb1.pair.com with SMTP; 5 Sep 2001 18:52:35 -0000
> > Received: (qmail 15328 invoked by uid 99); 5 Sep 2001 18:16:19 -0000
> > Date: 5 Sep 2001 18:16:19 -0000
> > Message-ID: <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Subject: Website Subscription
> > From: [EMAIL PROTECTED]
> >
> > This was a request generated from the form at http://www.php.net/support.php.
>
> --
> André Felipe M. Carvalho
> Analista de Sistemas - Embrapa / DTI
> [EMAIL PROTECTED]
> http://www.embrapa.br
> ---------------------------
> Os internautas escolheram a Embrapa como Top Cadê.
> Veja o resultado!
> http://www.topcade.com.br/ciencia/votacienciaMar2001.shtm
--
André Felipe M. Carvalho
Analista de Sistemas - Embrapa / DTI
[EMAIL PROTECTED]
http://www.embrapa.br
---------------------------
Os internautas escolheram a Embrapa como Top Cadê.
Veja o resultado!
http://www.topcade.com.br/ciencia/votacienciaMar2001.shtm
I'm getting a syntax error that says apache can't load libphp4.so into
the server because it cannot load libmysqlclient.so.10 as a shared object
file. libmysqlclient.so.10 is on the system at
/usr/local/mysql/libmysqlclient.s0.10, but I don't know how to tell
Apache where to find it. Can anyone help?
I'm using Apache 1.3.19, PHP 4.0.4pl1 and MySQL 3.23.39 on RedHat Linux 7.1.
I uncommented the AddType appllication/x-httpd-php .php line in Apache and
copied /usr/local/php/php.ini-dist to /usr/local/lib/php.ini as per
instructions.
I added this line to /usr/local/php/sapi/apache "EXTRA_LIBS=-L. -.php4
-lgdbm -L/usr/local/mysql/libs/mysql -Lmysqlclient", but that didn't
solve the problem.
I also added "/usr/local/mysql/libs/mysql" to my /etc/lo.so.conf file,
but that didn't do anything either.
I've been configuring PHP with "--with-apxs=/usr/local/apache/bin/apxs"
rather than "--with-apache=/usr/local/apache". Does that make any
difference? I also specified the directory for MySQL as
"--with-mysql=/usr/local/mysql".
Originally, I had tried to install PHP as a dynamic module (which is what
I'd prefer), with the instructions from the PHP 4.0 install file and
various books with similar instructions, but when I tried to create a
phptest.php file with the phpinfo function and some other php code, the
browsers would show the html code but not the php code.
I verified that mod_so.c was enabled. I used "--enable-track-vars" in the
configuration.
Any assistance would be greatly appreciated as PHP looks great from what
I've read and I'd love to be able to use it soon. Thanks in advance!
Lawonna
> I'm getting a syntax error that says apache can't load libphp4.so into
> the server because it cannot load libmysqlclient.so.10 as a shared object
> file. libmysqlclient.so.10 is on the system at
> /usr/local/mysql/libmysqlclient.s0.10, but I don't know how to tell
> Apache where to find it. Can anyone help?
Add /usr/local/mysql to your /etc/ld.so.conf file and run ldconfig
> I added this line to /usr/local/php/sapi/apache "EXTRA_LIBS=-L. -.php4
> -lgdbm -L/usr/local/mysql/libs/mysql -Lmysqlclient", but that didn't
> solve the problem.
-Lmysqlclient is meaningless. It actually tells it to look for static
libaries in a directory named mysqlclient. -L has no effect on shared
library loading.
> I also added "/usr/local/mysql/libs/mysql" to my /etc/lo.so.conf file,
> but that didn't do anything either.
But you stated above that libmysqlclient.so was in /usr/local/mysql, so
that is the directory you need to add. And unless you ran ldconfig after
making the change it wouldn't have done anything.
> I've been configuring PHP with "--with-apxs=/usr/local/apache/bin/apxs"
> rather than "--with-apache=/usr/local/apache". Does that make any
> difference? I also specified the directory for MySQL as
> "--with-mysql=/usr/local/mysql".
No difference wrt. this problem. --with-apache builds PHP as a static
library that needs to be linked statically into your httpd binary.
Whereas --with-apxs builds PHP as a shared library that can be loaded into
Apache dynamically using a LoadModule line in Apache's httpd.conf file.
-Rasmus
Thanks for your quick response. I knew it was probably something simple
like this that I just didn't understand. This is another daft question,
but I'm not sure how to run ldconfig. When I typed "ldconfig" from the
command line in the /etc directory, nothing appeared to happen, and is it
"ldconfig" or "run ldconfig"? Thanks again! Lawonna
In article <[EMAIL PROTECTED]>,
"Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote:
>> I'm getting a syntax error that says apache can't load libphp4.so into
>> the server because it cannot load libmysqlclient.so.10 as a shared
>> object file. libmysqlclient.so.10 is on the system at
>> /usr/local/mysql/libmysqlclient.s0.10, but I don't know how to tell
>> Apache where to find it. Can anyone help?
> Add /usr/local/mysql to your /etc/ld.so.conf file and run ldconfig
>> I added this line to /usr/local/php/sapi/apache "EXTRA_LIBS=-L. -.php4
>> -lgdbm -L/usr/local/mysql/libs/mysql -Lmysqlclient", but that didn't
>> solve the problem.
> -Lmysqlclient is meaningless. It actually tells it to look for static
> libaries in a directory named mysqlclient. -L has no effect on shared
> library loading.
>
>> I also added "/usr/local/mysql/libs/mysql" to my /etc/lo.so.conf file,
>> but that didn't do anything either.
> But you stated above that libmysqlclient.so was in /usr/local/mysql, so
> that is the directory you need to add. And unless you ran ldconfig
> after making the change it wouldn't have done anything.
>> I've been configuring PHP with "--with-apxs=/usr/local/apache/bin/apxs"
>> rather than "--with-apache=/usr/local/apache". Does that make any
>> difference? I also specified the directory for MySQL as
>> "--with-mysql=/usr/local/mysql".
> No difference wrt. this problem. --with-apache builds PHP as a static
> library that needs to be linked statically into your httpd binary.
> Whereas --with-apxs builds PHP as a shared library that can be loaded
> into Apache dynamically using a LoadModule line in Apache's httpd.conf
> file. -Rasmus
>
Thanks for your quick response. I knew is was something simple like this
that I just wasn't getting right. This is daft, but when I ran "ldconfig"
on the command line in the /etc directory earlier today, nothing seemed
to happen, and is it "ldconfig" or "run ldconfig". Again, thanks! Lawonna
In article <[EMAIL PROTECTED]>,
"Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote:
>> I'm getting a syntax error that says apache can't load libphp4.so into
>> the server because it cannot load libmysqlclient.so.10 as a shared
>> object file. libmysqlclient.so.10 is on the system at
>> /usr/local/mysql/libmysqlclient.s0.10, but I don't know how to tell
>> Apache where to find it. Can anyone help?
> Add /usr/local/mysql to your /etc/ld.so.conf file and run ldconfig
>> I added this line to /usr/local/php/sapi/apache "EXTRA_LIBS=-L. -.php4
>> -lgdbm -L/usr/local/mysql/libs/mysql -Lmysqlclient", but that didn't
>> solve the problem.
> -Lmysqlclient is meaningless. It actually tells it to look for static
> libaries in a directory named mysqlclient. -L has no effect on shared
> library loading.
>
>> I also added "/usr/local/mysql/libs/mysql" to my /etc/lo.so.conf file,
>> but that didn't do anything either.
> But you stated above that libmysqlclient.so was in /usr/local/mysql, so
> that is the directory you need to add. And unless you ran ldconfig
> after making the change it wouldn't have done anything.
>> I've been configuring PHP with "--with-apxs=/usr/local/apache/bin/apxs"
>> rather than "--with-apache=/usr/local/apache". Does that make any
>> difference? I also specified the directory for MySQL as
>> "--with-mysql=/usr/local/mysql".
> No difference wrt. this problem. --with-apache builds PHP as a static
> library that needs to be linked statically into your httpd binary.
> Whereas --with-apxs builds PHP as a shared library that can be loaded
> into Apache dynamically using a LoadModule line in Apache's httpd.conf
> file. -Rasmus
> Thanks for your quick response. I knew it was probably something simple
> like this that I just didn't understand. This is another daft question,
> but I'm not sure how to run ldconfig. When I typed "ldconfig" from the
> command line in the /etc directory, nothing appeared to happen, and is it
> "ldconfig" or "run ldconfig"? Thanks again! Lawonna
ldconfig doesn't produce any output. Just run it and try starting Apache
again.
-Rasmus
We were referred to you by one of our existing customers who felt you
would use this service.
We are Long Distance Direct <http://www.lddtalk.com/>. and we offer 50%
or more of international long distance calling discounts over your existing
telephone service. Start saving TODAY visit our website
http://www.lddtalk.com/> or reply <mailto:[EMAIL PROTECTED]?subject=Tell
Me More!> to this email with the best time and telephone number for us to
contact you. You can subscribe on our website and start saving money
TODAY on your international long distance calls and receive our superior
customer service or we will call you and guide you through the easy steps
to become one of our loyal customers that saves money over the traditional
telephone services in your area. Thousands of customers around the
globe are saving already. We look forward to giving you our great
services and helping you save money.
Agents needed... click here to start earning money on anyone who makes
international calls. http://www.lddtalk.com/agents/agent.shtml
Thank you for your time.
Sincerely,
Staff at LDD Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
321.799.1010 U.S.
Greetings! Clue humbly requested ...
I followed oft-posted directions to the letter for getting PHP 4.0.6
setup on Solaris 2.6 with Netscape Enterprise Server 3.6 SP3.
All's well in the config and make logs (I think), but when I go to run the
NES daemon, I get back no confirmation that it actually started.
Sure enough, it didn't. The logs, however, show that things _did_ start up
just fine. Only sometime later it bailed out.
No errors to stdout or stderr (perhaps console but I can't get to it).
Nothing in the logs that looks awry. Zilch.
So I stuck "truss" in the start script and tried again to see what was up.
Sure enough this shows up right toward the end:
lwp_sigredirect(1, SIGUSR2) = 0
Received signal #17, SIGUSR2, in sigsuspend() [caught]
siginfo: SIGUSR2 pid=26209 uid=60001
So the "nobody" user tripped up somehow. Not sure what it tripped on though.
I know if I remove the inits for PHP4 it starts up again (natch). I also
checked my make output for PHP4 - looks great, EXCEPT for a few warnings
that are (hopefully) "mostly harmless:"
Making all in nsapi
make[2]: Entering directory `/tmp/php-4.0.6/sapi/nsapi'
make[3]: Entering directory `/tmp/php-4.0.6/sapi/nsapi'
/bin/sh /tmp/php-4.0.6/libtool --silent --mode=compile
gcc -I. -I/tmp/php-4.0.6/sapi/nsapi -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6
-I/opt/ns-es-3.6/include -I/tmp/php-4.0.6/Zend -I/opt/mysql/include -I/tmp/p
hp-4.0.6/ext/xml/expat/xmltok -I/tmp/php-4.0.6/ext/xml/expat/xmlparse -I/tmp
/php-4.0.6/TSRM -D_POSIX_PTHREAD_SEMANTICS -D_POSIX_PTHREAD_SEMANTICS -D_RE
ENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21 -I../TSRM -g -O2 -pthreads -c
nsapi.c
nsapi.c: In function `nsapi_request_dtor':
nsapi.c:440: warning: passing arg 1 of `nsapi_free' discards qualifiers
from pointer target type
nsapi.c:442: warning: passing arg 1 of `nsapi_free' discards qualifiers
from pointer target type
/bin/sh /tmp/php-4.0.6/libtool --silent --mode=link
gcc -I. -I/tmp/php-4.0.6/sapi/nsapi -I/tmp/php-4.0.6/main -I/tmp/php-4.0.6
-I/opt/ns-es-3.6/include -I/tmp/php-4.0.6/Zend -I/opt/mysql/include -I/tmp/p
hp-4.0.6/ext/xml/expat/xmltok -I/tmp/php-4.0.6/ext/xml/expat/xmlparse -I/tmp
/php-4.0.6/TSRM -D_POSIX_PTHREAD_SEMANTICS -D_POSIX_PTHREAD_SEMANTICS -D_RE
ENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21 -I../TSRM -g -O2 -pthreads -o
libsapi.la nsapi.lo
make[3]: Leaving directory `/tmp/php-4.0.6/sapi/nsapi'
make[2]: Leaving directory `/tmp/php-4.0.6/sapi/nsapi'
make[1]: Leaving directory `/tmp/php-4.0.6/sapi'
Upon seeing some other posts related to this, I checked for pthreads. The
configure log has:
checking for pthreads_flags... -pthreads
checking for pthreads_lib...
Notice there's no "yes" _or_ "no" in there, and no warning about not
finding it. Also, when I start NES I don't get a pclose error (or
anything, not in any of the logs or elsewhere).
I also checked my libphp4.so and even did an ldd on it. Nothing unusual
there either.
Clues?
(I'll also cross-post to the installation issues list as well.)
Thanks in advance for any ideas ...
- JD
I've been trying to get PHP 4.0.6 to compile with Apache 1.3.19 and MySQL
3.23.39. I have been unable to get PHP to work on localhost in any of my
browsers when I installed it with ./configure
--with-apxs=/usr/local/apache --with-mysql=/usr/local/mysql so I tried
compiling apache using ./configure
--activate-module=src/modules/php4/libphp4.a --enable-module=php4. Apache
said it made the php4 module and it shows up in the LoadModule section of
the httpd configuration file but all the modules that have been listed
there, i.e. LoadModule mmap_static_module, etc. have vanished. The
AddModule list is also missing.
Can the LoadModule and AddModule list be typed back into the
configuration file? Do the modules need to be manually loaded? Any
suggestions generally about how to get PHP installed?
When I try to start Apache, I get the following error message "syntax
error on line 205 of /usr/local/apache /libexec/libphp4.so into server:
libmysqlclient.so.10: cannot load shared object file: no such file or
directory". I added /usr/local/mysql to the /etc/lo.so.conf and ran
ldconfig.
Thanks! Lawonna
Greetings,
I'll appreciate any help on this:
PHP is installed and working, but refuses to acknowledge mysql.
Mysql. on the other hand, is working OK too (for Bugzilla).
Details:
Mandrake 8; PHP 4.0.6 (but reports 4.0.4pl1 on php -v) ; mysql 3.23.39
PHP was built with --with-mysql=/usr/local/mysql --with-apxs
php -h gives out a warning:
unable to load dynamic library '/usr/lib/php/extensions/mysql.so' .... file
not found.
(not that it really matters, but: httpd -l lists mod_so.c)
Now - I've tried to link the only mysql.so file in the system
(/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBD/mysql/..) to that
location
(though the location seems strange), but then failed on undefined refs in
that library.
Thanks in advance
Ronen
[EMAIL PROTECTED]
