[PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

2004-05-20 Thread Aaron Axelsen
Greetings,

I compiled and installed mysql from source, and now I am trying to recompile
php agaisnt the new version of MySQL (was previous running 3.23.53).  Here
is the configure string I used:

./configure --with-apxs2=/usr/local/apache/bin/apxs --prefix=/usr/local/php
--with-mysql=/usr/local/mysql --with-pgsql=/usr/local/pgsql --with-gettext

Note: I have used this exact string compilng against myql 3.23.53 with no
issues.

When I run the make command, I get the following error:

ext/mysql/php_mysql.lo: In function `zif_mysql_create_db':
/home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1158: undefined reference to
`mysql_create_db'
ext/mysql/php_mysql.lo: In function `zif_mysql_drop_db':
/home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1200: undefined reference to
`mysql_drop_db'
collect2: ld returned 1 exit status
make: *** [sapi/cli/php] Error 1

Any suggestions?  Thanks.

-- 
Aaron Axelsen 
AIM: aaak2 
Email: [EMAIL PROTECTED] 



Re: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

2004-05-20 Thread Curt Zirzow
* Thus wrote Aaron Axelsen ([EMAIL PROTECTED]):
 Greetings,
 
 I compiled and installed mysql from source, and now I am trying to recompile
 php agaisnt the new version of MySQL (was previous running 3.23.53).  Here
 is the configure string I used:
 
 ./configure --with-apxs2=/usr/local/apache/bin/apxs --prefix=/usr/local/php
 --with-mysql=/usr/local/mysql --with-pgsql=/usr/local/pgsql --with-gettext
 
 ...
 
 ext/mysql/php_mysql.lo: In function `zif_mysql_create_db':
 /home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1158: undefined reference to
 `mysql_create_db'

That sound like php used a 3.x mysql_version.h file to include but
is trying to link against the real 4.x mysqlclient.so (since 4.x
does not have mysql_create_db).

At what prefix was mysql 3.x installed? /usr or /usr/local? 

Couple quick commands to find your mysql files
  locate mysql.h
  locate mysql_version.h
  find / find / -type f -name mysql*.h #last resort


Curt
-- 
I used to think I was indecisive, but now I'm not so sure.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

2004-05-20 Thread Aaron Axelsen
The mysql 3.x was installed with prefix /usr/local/mysql 


--
Aaron Axelsen
Email: [EMAIL PROTECTED]

-Original Message-
From: Curt Zirzow [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 20, 2004 7:08 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

* Thus wrote Aaron Axelsen ([EMAIL PROTECTED]):
 Greetings,
 
 I compiled and installed mysql from source, and now I am trying to 
 recompile php agaisnt the new version of MySQL (was previous running 
 3.23.53).  Here is the configure string I used:
 
 ./configure --with-apxs2=/usr/local/apache/bin/apxs 
 --prefix=/usr/local/php --with-mysql=/usr/local/mysql 
 --with-pgsql=/usr/local/pgsql --with-gettext
 
 ...
 
 ext/mysql/php_mysql.lo: In function `zif_mysql_create_db':
 /home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1158: undefined reference 
 to `mysql_create_db'

That sound like php used a 3.x mysql_version.h file to include but is trying
to link against the real 4.x mysqlclient.so (since 4.x does not have
mysql_create_db).

At what prefix was mysql 3.x installed? /usr or /usr/local? 

Couple quick commands to find your mysql files   locate mysql.h   locate
mysql_version.h   find / find / -type f -name mysql*.h #last resort


Curt
--
I used to think I was indecisive, but now I'm not so sure.

--
PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

2004-05-20 Thread raditha dissanayake
Aaron Axelsen wrote:
The mysql 3.x was installed with prefix /usr/local/mysql 
 

So why are you pointing to the 3.x path when compiling with 4.x?
And since you are going through all this trouble might as well use a 
very recent version of mysql

--
Aaron Axelsen
Email: [EMAIL PROTECTED]
 

Greetings,
I compiled and installed mysql from source, and now I am trying to 
recompile php agaisnt the new version of MySQL (was previous running 
3.23.53).  Here is the configure string I used:

./configure --with-apxs2=/usr/local/apache/bin/apxs 
--prefix=/usr/local/php --with-mysql=/usr/local/mysql 
--with-pgsql=/usr/local/pgsql --with-gettext

...
ext/mysql/php_mysql.lo: In function `zif_mysql_create_db':
/home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1158: undefined reference 
to `mysql_create_db'
   

That sound like php used a 3.x mysql_version.h file to include but is trying
to link against the real 4.x mysqlclient.so (since 4.x does not have
mysql_create_db).
At what prefix was mysql 3.x installed? /usr or /usr/local? 

Couple quick commands to find your mysql files   locate mysql.h   locate
mysql_version.h   find / find / -type f -name mysql*.h #last resort
Curt
--
I used to think I was indecisive, but now I'm not so sure.
 


--
Raditha Dissanayake.
-
http://www.raditha.com/megaupload/upload.php
Sneak past the PHP file upload limits.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

2004-05-20 Thread Aaron Axelsen
I was trying to upgrade over the older one, which is why the paths are the
same.  I want to stick with the stable realease 


--
Aaron Axelsen
Email: [EMAIL PROTECTED]

-Original Message-
From: raditha dissanayake [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 20, 2004 7:47 PM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

Aaron Axelsen wrote:

The mysql 3.x was installed with prefix /usr/local/mysql
  

So why are you pointing to the 3.x path when compiling with 4.x?
And since you are going through all this trouble might as well use a very
recent version of mysql


--
Aaron Axelsen
Email: [EMAIL PROTECTED]

  

Greetings,

I compiled and installed mysql from source, and now I am trying to 
recompile php agaisnt the new version of MySQL (was previous running 
3.23.53).  Here is the configure string I used:

./configure --with-apxs2=/usr/local/apache/bin/apxs
--prefix=/usr/local/php --with-mysql=/usr/local/mysql 
--with-pgsql=/usr/local/pgsql --with-gettext

...

ext/mysql/php_mysql.lo: In function `zif_mysql_create_db':
/home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1158: undefined reference 
to `mysql_create_db'



That sound like php used a 3.x mysql_version.h file to include but is 
trying to link against the real 4.x mysqlclient.so (since 4.x does not 
have mysql_create_db).

At what prefix was mysql 3.x installed? /usr or /usr/local? 

Couple quick commands to find your mysql files   locate mysql.h   
locate mysql_version.h   find / find / -type f -name mysql*.h #last 
resort


Curt
--
I used to think I was indecisive, but now I'm not so sure.

  



--
Raditha Dissanayake.
-
http://www.raditha.com/megaupload/upload.php
Sneak past the PHP file upload limits.

--
PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

2004-05-20 Thread raditha dissanayake
Aaron Axelsen wrote:
I was trying to upgrade over the older one, which is why the paths are the
same.  I want to stick with the stable realease 
 

4.0.18 is stable. Generally you should not install a new version of a 
software over the older tree, it leads to many a conflict as you have 
just found ;-)

--
Aaron Axelsen
Email: [EMAIL PROTECTED]
-Original Message-
From: raditha dissanayake [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 20, 2004 7:47 PM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

Aaron Axelsen wrote:
 

The mysql 3.x was installed with prefix /usr/local/mysql
   

So why are you pointing to the 3.x path when compiling with 4.x?
And since you are going through all this trouble might as well use a very
recent version of mysql
 

--
Aaron Axelsen
   


--
Raditha Dissanayake.
-
http://www.raditha.com/megaupload/upload.php
Sneak past the PHP file upload limits.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

2004-05-20 Thread Curt Zirzow
* Thus wrote Aaron Axelsen ([EMAIL PROTECTED]):
 I was trying to upgrade over the older one, which is why the paths are the
 same.  I want to stick with the stable realease 

Overwritting versions like that might not work very well, file
names have changed accross the versions. I usually update my server
with something like:

cd /usr/local
mv mysql mysql.3.x
cd /source/mysql.4.x
make install
cd /usr/local
mv mysql.3.x/var/* mysql/data/var/


Curt
-- 
I used to think I was indecisive, but now I'm not so sure.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php