configuring PHP w/ MySQL on Mandriva - Tilted Forum Project Discussion Community

aa1037 · 11-29-2005, 04:34 PM

Hey all,

I'm a linux noobie trying to get phpBB running on Mandriva. I already installed Apache and MySQL (server, client, libraries, headers). Now, I'm trying to get PHP working, to no avail.

I use the following:

Code:

./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql --with-zlib-dir=/usr

and the process runs smoothly for a while, but then come up with this:

Code:

hecking for mysql_close in -lmysqlclient... no
checking for mysql_error in -lmysqlclient... no
configure: error: mysql configure failed. Please check config.log for more information.

the seemingly relevant part of config.log is:

Code:

configure:58276: checking for mysql_close in -lmysqlclient
configure:58295: gcc -o conftest -g -O2   conftest.c -lmysqlclient  -lz -lresolv -lm -ldl -lnsl  -lxml2 -lz -lm -lxml2 -lz -lm 1>&5
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
configure: failed program was:
#line 58284 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char mysql_close();

int main() {
mysql_close()
; return 0; }
configure:58516: checking for mysql_error in -lmysqlclient
configure:58535: gcc -o conftest -g -O2   -Wl,-rpath,/usr -L/usr conftest.c -lmysqlclient  -lz -lz -lresolv -lm -ldl -lnsl  -lxml2 -lz -lm -lxml2 -lz -lm 1>&5
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
configure: failed program was:
#line 58524 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char mysql_error();

int main() {
mysql_error()
; return 0; }

any ideas?

bendsley · 11-29-2005, 09:01 PM

can you start mysql and get information out of it?

also, you might try to get php working and then recompile with mysql support.

catback · 12-03-2005, 09:13 AM

You may need to tell php where mysql is. I don't remember the exact details but "--with-mysql" becomes something like "--with-mysql=/path/to/mysql"

aa1037 · 12-03-2005, 10:24 AM

Quote:

Originally Posted by catback

You may need to tell php where mysql is. I don't remember the exact details but "--with-mysql" becomes something like "--with-mysql=/path/to/mysql"

I'm pretty sure that it gave me the same error whether or not I defined the path to mysql.

aa1037 · 12-03-2005, 10:26 AM

Quote:

Originally Posted by bendsley

also, you might try to get php working and then recompile with mysql support.

so do the ./configure w/o the mysql command, then make and make install...but then how do I recompile later?

<---noob

bendsley · 12-03-2005, 04:36 PM

do you have to use mandrive? debian and gentoo (for you Latch) would be a more optimal choice for web/sql hosting. Apt and emerge are much better package management tools than rpm's, if that's what you're using.

Here in a little bit, I'll post some instructions on setting this up for you. I need to try and remember installing from source.

Latch · 12-03-2005, 04:49 PM

Mandriva must use a package management system, be it apt-rpm, yum, etc. etc. Their main repository should definitely have php in it already. You may want to find out about that first.

(Thanks for the gentoo mention, bends

)

11-29-2005, 09:01 PM	#2 (permalink)
bendsley Professional Loafer Location: texas	can you start mysql and get information out of it? also, you might try to get php working and then recompile with mysql support. __________________ "You hear the one about the fella who died, went to the pearly gates? St. Peter let him in. Sees a guy in a suit making a closing argument. Says, "Who's that?" St. Peter says, "Oh, that's God. Thinks he's Denny Crane."

12-03-2005, 04:36 PM	#6 (permalink)
bendsley Professional Loafer Location: texas	do you have to use mandrive? debian and gentoo (for you Latch) would be a more optimal choice for web/sql hosting. Apt and emerge are much better package management tools than rpm's, if that's what you're using. Here in a little bit, I'll post some instructions on setting this up for you. I need to try and remember installing from source. __________________ "You hear the one about the fella who died, went to the pearly gates? St. Peter let him in. Sees a guy in a suit making a closing argument. Says, "Who's that?" St. Peter says, "Oh, that's God. Thinks he's Denny Crane."

12-03-2005, 09:13 AM	#3 (permalink)
catback Psycho Location: North America	You may need to tell php where mysql is. I don't remember the exact details but "--with-mysql" becomes something like "--with-mysql=/path/to/mysql"

12-03-2005, 04:49 PM	#7 (permalink)
Latch In Your Dreams Location: City of Lights	Mandriva must use a package management system, be it apt-rpm, yum, etc. etc. Their main repository should definitely have php in it already. You may want to find out about that first. (Thanks for the gentoo mention, bends )