[PHP] Problem Configuring With MySQL
Hi, Now that I've successfully built PHP (thanks to Brian Clark) I can no longer access mysql! I get the following: #mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) This has got to have something to do with the way I built PHP. How do I begin trouble-shooting it? TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Why Can't I Get PHP to Work with MySQL??
At 02:32 PM 12/23/01 -0600, you wrote: >At 12:16 PM 12/23/2001 -0800, Ben Ocean wrote: >>Hi; >>I get this error when I try to restart Apache: >> >>Syntax error on line 236 of /etc/httpd/conf/httpd.conf: >>Cannot load /etc/httpd/libexec/libphp4.so into server: >>/etc/httpd/libexec/libphp4.so >> >>The above file does, of course, exist. I'm running RH71 i386 with MySQL >>and PHP installed from source files. Here's my config script: >> >>./configure --with-apxs=/etc/httpd/bin/apxs --with-mysql=/usr/local/mysql >>--with-kerberos=/usr/kerberos --with-ldap=/usr/local/openldap >> >>So, what gives? I've googled this one and it appears there's a lot of >>folks with this question unanswered! > > From the PHP INSTALL file: > > >Note 3! If you are on Linux and have installed shared libraries, make >sure the location of these shared libraries are listed in your >/etc/ld.so.conf file. For example, if you have: > > /usr/local/lib/mysql/libmysqlclient.so > >Make sure /etc/ld.so.conf contains: > > /usr/local/lib/mysql > >Then run ldconfig. > > >Do the above and this should take care of it. Well, I'm afraid I've done all of that and the problem remains :( I recalled I also had to hard-code something in the configure script that wasn't working properly: # BENO'S CHANGE: LAST LINE BELOW COMMENT AS WELL... # for i in lib lib/mysql; do # str="$MYSQL_DIR/$i/libmysqlclient.*" # for j in `echo $str`; do #if test -r $j; then # MYSQL_LIB_DIR=$MYSQL_DIR/$i # break 2 #fi # done # # done MYSQL_LIB_DIR=/usr/local/lib (starts at around line 3350). I was getting this error: configure: error: Cannot find mysqlclient library under /usr/local/mysql whereas the library is actually found under /usr/local/lib/mysql. At any rate, made the edit and the error message disappeared, so I assume I did something right, but the fact that I had to make an edit makes me suspicious. Any more ideas? TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Why Can't I Get PHP to Work with MySQL??
Hi; I get this error when I try to restart Apache: Syntax error on line 236 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/libexec/libphp4.so into server: /etc/httpd/libexec/libphp4.so The above file does, of course, exist. I'm running RH71 i386 with MySQL and PHP installed from source files. Here's my config script: ./configure --with-apxs=/etc/httpd/bin/apxs --with-mysql=/usr/local/mysql --with-kerberos=/usr/kerberos --with-ldap=/usr/local/openldap So, what gives? I've googled this one and it appears there's a lot of folks with this question unanswered! TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Config Problems
At 12:24 PM 12/22/01 -0500, you wrote: >* Ben Ocean ([EMAIL PROTECTED]) [Dec 22. 2001 11:54]: > > > Well, that got me headed in the right direction. I ended up combining all > > the commands on one line and removing the references to openssl (I'll mess > > with that later) and it worked. I have no_idea why... > >If you installed openssl from something like an rpm or deb package, you >may need to get the -dev version which contains all the libraries >configure is looking for. You may only have the shared libraries and >configure is looking for the header files, etc. If you install those, >configure might properly pick up openssl. Yeah, I know. It's not an urgent matter, but I'll probably do with that what I'm doing with php and mysql, etc.: rip out the rpms (rpm -e) and install from source with my own config files, then symlink openssl-whatever openssl. Just so much more control that way :)) Thanks! BenO >-- >Brian Clark | Avoiding the general public since 1805! >Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 >$ mount -t neuro /dev/brain /mnt/head > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Config Problems
Well, that got me headed in the right direction. I ended up combining all the commands on one line and removing the references to openssl (I'll mess with that later) and it worked. I have no_idea why... Thanks, BenO At 09:03 AM 12/22/01 -0500, you wrote: >* Ben Ocean ([EMAIL PROTECTED]) [Dec 22. 2001 03:22]: > > > None of these suggestions worked. So...what's wrong with this config > script > > that it throws these errors? > >This may make no difference what so ever, but try removing config.cache, >then use my suggestions and see if you get a different result. > >(No need to CC me this time) > >-- >Brian Clark | Avoiding the general public since 1805! >Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 >English is my second language, gibberish is my first. > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Config Problems
None of these suggestions worked. So...what's wrong with this config script that it throws these errors? configure: error: Cannot find OpenSSL's /usr/local/bin/config_php: --with-kerberos=/usr/krb5-1.2.2: No such file or directory /usr/local/bin/config_php: --with-ldap=/usr/local/openldap-2.0.18: No such file or directory Here's my config script: #!/bin/sh cd /usr/local/php ./configure --with-apache=/usr/src/redhat/SOURCES/apache \ --with-openssl=/usr/include/openssl \ --with-kerberos=/usr/krb/ \ --with-imap-ssl=/usr/include/openssl \ --with-ldap=/usr/local/openldap/ \ --with-mysql=/usr/local/mysql exit 0 At 12:07 AM 12/22/01 -0500, you wrote: >* Ben Ocean ([EMAIL PROTECTED]) [Dec 22. 2001 00:01]: > > > Hi; > >Howdy. > > > I'm installing php from source and I've run into these config errors: > >[...] > > > Here's my config script: > > > #!/bin/sh > > cd /usr/local/php > > ./configure --with-apache=/usr/src/redhat/SOURCES/apache \ > > --with-openssl=/usr/share/doc/openssl \ > >Try --with-openssl=/usr or --with-openssl=/usr/local > > > --with-kerberos=/usr/krb/ \ > >Try --with-kerberos=/usr > > > --with-imap-ssl=/usr/share/doc/openssl \ > >--with-imap-ssl=/usr or --with-openssl=/usr/local > > > --with-ldap=/usr/local/openldap/ \ > >Probably --with-ldap=/usr here > > > --with-mysql=/usr/local/mysql > >--with-mysql=/usr/local > > > exit 0 > > > I've also tried the *openssl* part pointing to /usr/include/openssl which > > is where evp.h lives. Why these bizarre errors when the pointers point to > >For that, =/usr is probably what you want. It just wants to base path >usually; it should know to look in include. > >-- >Brian Clark | Avoiding the general public since 1805! >Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 >All civilizations become either spacefaring or extinct. > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Config Problems
Hi; I'm installing php from source and I've run into these config errors: configure: error: Cannot find OpenSSL's /usr/local/bin/config_php: --with-kerberos=/usr/krb5-1.2.2: No such file or directory /usr/local/bin/config_php: --with-ldap=/usr/local/openldap-2.0.18: No such file or directory Here's my config script: #!/bin/sh cd /usr/local/php ./configure --with-apache=/usr/src/redhat/SOURCES/apache \ --with-openssl=/usr/share/doc/openssl \ --with-kerberos=/usr/krb/ \ --with-imap-ssl=/usr/share/doc/openssl \ --with-ldap=/usr/local/openldap/ \ --with-mysql=/usr/local/mysql exit 0 I've also tried the *openssl* part pointing to /usr/include/openssl which is where evp.h lives. Why these bizarre errors when the pointers point to files that exist? TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Troubleshooting Strange Problem
Hi, I moved my server, changed the IP addresses, etc., and now I'm having strange problems with PHP. Not on all scripts, just some. Scripts that worked just fine before I moved it. Most notably, I'm working with Phorm < http://holotech.net > and I can no longer pass certain variables. Again: this worked *just fine* before I moved the server. Makes me think it's got nothing to do with the script, so what could have gone wrong with the server? Again, certain scripts, such as FishCart < http://fishcart.org > continue to work fine after the move. Has anybody run into anything like this before? Your help would be appreciated. TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Link Exchange Robot
Hi; There's a great little proggie I use to scout out potential link exchange partners for my clients called Zeus. I have no financial interest in Zeus. *However*, there are some facilities in this proggie I don't care for: facilities designed to slow one down (and presumably keep the company from being known as a developer of devices for spammers, not that I advocate spamming). I also have a Linux box with a T-1 line that could kick serious butt, and this (of course) is built for Windoze. That, plus the fact that I now find I need a whole bunch of these robots and I'd like to legally skate on the licencing fee :) Which (finally) brings me to my question: Does anyone know of an open source program that does the same thing? TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] What Does This Mean?
Hi; I'm getting this error: >>> Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 >= 3.0.8 <<< What does it mean and what should I do about it (if anything)? TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] What Does This Mean?
Hi; I just ran into the following error while doing maintenance on my RedHat box: >>> Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 >= 3.0.8 <<< What does this mean and how do I fix it? TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] What In the WORLD???
I figured out a work-around...
>>>
// had to remove this line: if ( $k == "id" && $v != "0" ) {
if ( $seatingz == "9" || $aa == $seatingz ) {
if ( $colorz == "9" || ( $cc == $colorz || $dd == $colorz || $ee == $colorz
)) {
if ( $typez == "9" || $gg == $typez ) {
if ( $ != $ ) { // to keep from repeating each table twice
$ = $;
<<<
where $ is the last value to be harvested in the array. Why this works
I have no idea...
BenO
At 07:43 AM 2/2/2001 -0800, you wrote:
>Hi;
>Can someone please explain the logic of why this is happening? I moved my
>server to a different co-location. As a consequence a certain PHP3 script
>quit working (?). Same server, same config, just quit. Now I'm
>trouble-shooting it and I've traced the problem thus:
>
> >>>
>$ = "";
>// had to remove this line: if ( $k == "id" && $v != "0" ) {
>if ( $seatingz == "9" || $aa == $seatingz ) {
>if ( $colorz == "9" || ( $cc == $colorz || $dd == $colorz || $ee ==
>$colorz )) {
>if ( $typez == "9" || $gg == $typez ) {
>if ( $ != $yy ) { // to keep from repeating each table twice
> $ = $yy;
><<<
>
>Prior to all of this is a loop defining an array of values from a MySQL
>table; after it is a loop printing those values in a table. Variables
>ending in *z* are obtained from the client through a *POST* statement. The
>value of *9* is a default, meaning the client has not entered a value. As
>an example, *$aa* is the specific value for *seating* in the table which
>is called by the MySQL statements for a specific row of data. The line I
>had to remove was necessary before moving the server for reasons that were
>and are beyond me. But when I moved the server, that line prevented
>anything from printing. I removed it, then I discovered that all values
>established *prior to* the first variable the client inputs (which changes
>the *z* variables) printed, while those after it didn't. In other words,
>if the client input a value for *type*, which would correspond to *$gg*,
>then *$aa* through *gg* printed, but all the values after that didn't!
>Now, for *some reason* before I moved the server this loop wanted to print
>two copies of everything, so I put in this $ value stuff in the last
>*if* statement. That stopped it and it worked fine (i.e., printed just one
>copy of everything like it was supposed to). While I was trouble-shooting
>this sucker, I slapped in the declaration of *$ = "";* and I'll be a
>son-of-a-gun, suddenly the darn thing prints out an ungodly number of the
>same loop (I currently only have one row in the table as I test it), and
>after about 20 iterations it starts tossing in the extra values that it
>had been skipping (e.g., those beyond $gg in the above example), so that
>after about 100 iterations I have the complete package! What the he*$^%)
>is going on???
>BenO
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] What In the WORLD???
Hi;
Can someone please explain the logic of why this is happening? I moved my
server to a different co-location. As a consequence a certain PHP3 script
quit working (?). Same server, same config, just quit. Now I'm
trouble-shooting it and I've traced the problem thus:
>>>
$ = "";
// had to remove this line: if ( $k == "id" && $v != "0" ) {
if ( $seatingz == "9" || $aa == $seatingz ) {
if ( $colorz == "9" || ( $cc == $colorz || $dd == $colorz || $ee == $colorz
)) {
if ( $typez == "9" || $gg == $typez ) {
if ( $ != $yy ) { // to keep from repeating each table twice
$ = $yy;
<<<
Prior to all of this is a loop defining an array of values from a MySQL
table; after it is a loop printing those values in a table. Variables
ending in *z* are obtained from the client through a *POST* statement. The
value of *9* is a default, meaning the client has not entered a value. As
an example, *$aa* is the specific value for *seating* in the table which is
called by the MySQL statements for a specific row of data. The line I had
to remove was necessary before moving the server for reasons that were and
are beyond me. But when I moved the server, that line prevented anything
from printing. I removed it, then I discovered that all values established
*prior to* the first variable the client inputs (which changes the *z*
variables) printed, while those after it didn't. In other words, if the
client input a value for *type*, which would correspond to *$gg*, then
*$aa* through *gg* printed, but all the values after that didn't! Now, for
*some reason* before I moved the server this loop wanted to print two
copies of everything, so I put in this $ value stuff in the last *if*
statement. That stopped it and it worked fine (i.e., printed just one copy
of everything like it was supposed to). While I was trouble-shooting this
sucker, I slapped in the declaration of *$ = "";* and I'll be a
son-of-a-gun, suddenly the darn thing prints out an ungodly number of the
same loop (I currently only have one row in the table as I test it), and
after about 20 iterations it starts tossing in the extra values that it had
been skipping (e.g., those beyond $gg in the above example), so that after
about 100 iterations I have the complete package! What the he*$^%) is going
on???
BenO
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
