[PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread Olaf van der Spek
In the phpinfo() output, the MySQL client API version is shown as 3.23.49.
Shouldn't this be upgraded to 4.1 (generally available/stable)?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread Steve Buehler
At 07:38 AM 11/24/2004, you wrote:
In the phpinfo() output, the MySQL client API version is shown as 3.23.49.
Shouldn't this be upgraded to 4.1 (generally available/stable)?

To do so, you would need to upgrade it.  I know I am being a smartaleck 
when I say this, but it won't upgrade on its own and it won't upgrade just 
because you upgraded just PHP itself.  PHP only reads what the version is 
from what you have installed, not something that is internal to PHP 
itself.  So if you upgrade your mysql, it will show you a different version 
when you run your phpinfo.  Here is an rpm -qa result from one of my machines:
[root]# rpm -qa|grep mysql
php-mysql-4.3.2-14.ent
mysql-server-3.23.58-1
libdbi-dbd-mysql-0.6.5-5
mysql-devel-3.23.58-2.3
mysql-3.23.58-2.3

My phpinfo client API shows: 3.23.58
Which would be because that is the version of mysql that I am running.  My 
mysql, mysql-server and mysql-devel are all 3.23.58.  Only my php-mysql 
module is 4.3.2-14

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


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread John Nichel
Steve Buehler wrote:
To do so, you would need to upgrade it.  I know I am being a smartaleck 
when I say this, but it won't upgrade on its own and it won't upgrade 
just because you upgraded just PHP itself.  PHP only reads what the 
version is from what you have installed, not something that is internal 
to PHP itself.  So if you upgrade your mysql, it will show you a 
different version when you run your phpinfo.  Here is an rpm -qa result 
from one of my machines:
[root]# rpm -qa|grep mysql
php-mysql-4.3.2-14.ent
mysql-server-3.23.58-1
libdbi-dbd-mysql-0.6.5-5
mysql-devel-3.23.58-2.3
mysql-3.23.58-2.3

My phpinfo client API shows: 3.23.58
Which would be because that is the version of mysql that I am running.  
My mysql, mysql-server and mysql-devel are all 3.23.58.  Only my 
php-mysql module is 4.3.2-14
No, this is not the case.  If you install with RPM, or you compile from 
source and only use --with-mysql, the client API is going to be whatever 
was bundled with PHP at the time.  Update your MySQL version, and you're 
phpinfo will still show the 3.23.58 client library.  The only way to 
change this in PHP4 is to configure and compile php with the version of 
MySQL _you_ have installedotherwise, it will use the bundled MySQL 
client.

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread Olaf van der Spek
On Wed, 24 Nov 2004 10:37:19 -0600, Steve Buehler [EMAIL PROTECTED] wrote:
 At 07:38 AM 11/24/2004, you wrote:
 
 In the phpinfo() output, the MySQL client API version is shown as 3.23.49.
 Shouldn't this be upgraded to 4.1 (generally available/stable)?
 
 To do so, you would need to upgrade it.  I know I am being a smartaleck

;-

 when I say this, but it won't upgrade on its own and it won't upgrade just
 because you upgraded just PHP itself.  PHP only reads what the version is
 from what you have installed, not something that is internal to PHP
 itself.  So if you upgrade your mysql, it will show you a different version
 when you run your phpinfo.  Here is an rpm -qa result from one of my machines:
 [root]# rpm -qa|grep mysql
 php-mysql-4.3.2-14.ent
 mysql-server-3.23.58-1
 libdbi-dbd-mysql-0.6.5-5
 mysql-devel-3.23.58-2.3
 mysql-3.23.58-2.3
 
 My phpinfo client API shows: 3.23.58
 Which would be because that is the version of mysql that I am running.  My
 mysql, mysql-server and mysql-devel are all 3.23.58.  Only my php-mysql
 module is 4.3.2-14

But on a up2date Debian Linux Sarge server with MySQL 4.0 and PHP
4.3.9, it still shows 3.23.56
On a Windows XP server with MySQL 4.1 and PHP 4.3.10 (RC1) it shows 3.23.49.

So what exactly do I need to upgrade?

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



Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread Olaf van der Spek
John Nichel wrote:
Steve Buehler wrote:
My phpinfo client API shows: 3.23.58
Which would be because that is the version of mysql that I am 
running.  My mysql, mysql-server and mysql-devel are all 3.23.58.  
Only my php-mysql module is 4.3.2-14

No, this is not the case.  If you install with RPM, or you compile from 
source and only use --with-mysql, the client API is going to be whatever 
was bundled with PHP at the time.  Update your MySQL version, and you're 
phpinfo will still show the 3.23.58 client library.  The only way to 
change this in PHP4 is to configure and compile php with the version of 
MySQL _you_ have installedotherwise, it will use the bundled MySQL 
client.
But why is the bundled client not upgraded?
Aren't 4.0 and 4.1 clients backwards compatible with 3.23 server?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread John Nichel
Olaf van der Spek wrote:
But why is the bundled client not upgraded?
Aren't 4.0 and 4.1 clients backwards compatible with 3.23 server?
Why they didn't upgrade the bundle to include the 4.0 release, I don't 
know.  However with the password 'issues' between 4.1 and earlier 
versions, I'm sure that's a good reason not to bundle the 4.1 client. 
Bundled support has been dropped in php5.

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread Steve Buehler
At 10:59 AM 11/24/2004, you wrote:
On Wed, 24 Nov 2004 10:37:19 -0600, Steve Buehler [EMAIL PROTECTED] wrote:
 At 07:38 AM 11/24/2004, you wrote:

 In the phpinfo() output, the MySQL client API version is shown as 3.23.49.
 Shouldn't this be upgraded to 4.1 (generally available/stable)?

 To do so, you would need to upgrade it.  I know I am being a smartaleck
;-
 when I say this, but it won't upgrade on its own and it won't upgrade just
 because you upgraded just PHP itself.  PHP only reads what the version is
 from what you have installed, not something that is internal to PHP
 itself.  So if you upgrade your mysql, it will show you a different version
 when you run your phpinfo.  Here is an rpm -qa result from one of my 
machines:
 [root]# rpm -qa|grep mysql
 php-mysql-4.3.2-14.ent
 mysql-server-3.23.58-1
 libdbi-dbd-mysql-0.6.5-5
 mysql-devel-3.23.58-2.3
 mysql-3.23.58-2.3

 My phpinfo client API shows: 3.23.58
 Which would be because that is the version of mysql that I am running.  My
 mysql, mysql-server and mysql-devel are all 3.23.58.  Only my php-mysql
 module is 4.3.2-14

But on a up2date Debian Linux Sarge server with MySQL 4.0 and PHP
4.3.9, it still shows 3.23.56
On a Windows XP server with MySQL 4.1 and PHP 4.3.10 (RC1) it shows 3.23.49.
So what exactly do I need to upgrade?
I have already been corrected on what I said.  I guess you learn something 
new and different every day.  Anyway, John Nichel did the correction.  You 
might want to read his email.  I didn't think it worked that way, but maybe 
I am wrongI usually am. :)

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


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread Olaf van der Spek
John Nichel wrote:
Olaf van der Spek wrote:
But why is the bundled client not upgraded?
Aren't 4.0 and 4.1 clients backwards compatible with 3.23 server?
Why they didn't upgrade the bundle to include the 4.0 release, I don't 
know.  However with the password 'issues' between 4.1 and earlier 
versions, I'm sure that's a good reason not to bundle the 4.1 client. 
Isn't that only an issue for  4.1 clients and = 4.1 servers and not 
for the 'other way around'?
I was actually asking because I have a 4.1 server and I couldn't use PHP 
to connect, because it doesn't support new passwords.

Bundled support has been dropped in php5.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread John Nichel
Olaf van der Spek wrote:
snip
Isn't that only an issue for  4.1 clients and = 4.1 servers and not 
for the 'other way around'?
I was actually asking because I have a 4.1 server and I couldn't use PHP 
to connect, because it doesn't support new passwords.
It works both ways.  You can make your 4.1 client treat passwords as 
=4.0, and your 4.1 server accept older passwords.  If you want the 4.1 
client used in PHP, you'll have to compile it from source and use PHP5. 
 I don't think php4 supports 4.1 (mysql vs mysqli).

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] PHP info: MySQL client API version: 3.23?

2004-11-24 Thread Olaf van der Spek
John Nichel wrote:
Olaf van der Spek wrote:
snip
Isn't that only an issue for  4.1 clients and = 4.1 servers and not 
for the 'other way around'?
I was actually asking because I have a 4.1 server and I couldn't use 
PHP to connect, because it doesn't support new passwords.

It works both ways.  You can make your 4.1 client treat passwords as 
=4.0, and your 4.1 server accept older passwords.  If you want the 4.1 
Where in the client lib can you change that?
I thought = 4.1 clients would automatically use  4.1 passwords if 
connecting to a  4.1 server.

client used in PHP, you'll have to compile it from source and use PHP5. 
 I don't think php4 supports 4.1 (mysql vs mysqli).


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