Invalid MySQL Client...mismatch version from server?

Corporal Joined: Feb 15, 2003 Posts: 53 Location: USA

I upgraded my system to the latest MySQL Windows version and still getting an older Client version reported when I run Analyzer. Anybody have any ideas on what's going on?

http://mithoron.dyndns.org/analyze.php

Thanx!

Posted: Sat Feb 15, 2003 2:03 pm

3.23.49 is not the latest version of MySQL, in case Analyze.php is giving out the wrong version which i would find very odd, place the following in a file call it something like info.php, upload it and point your browser to it.
<?php
phpinfo()
?>

Corporal Joined: Feb 15, 2003 Posts: 53 Location: USA

Yes, I know 3.23.49 is not the latest version of MySQL Laughing

; hence my post. I have 4.0.10-gamma installed and I'm still getting the message that 3.23.49 is installed (which was originally installed before I uninstalled and installed the 4.0.10-gamma version).

Here is the PHP info:

http://mithoron.dyndns.org/phpinfo.php

As you can see, it's stating I have an older client API; however, I have no idea how to get rid of it to get the latest installed!

Thanx again for your help!

Major Joined: Jan 13, 2003 Posts: 892

http://www.mysql.com/downloads/index.html

3.23.55 is the "Stable" release.

Corporal Joined: Feb 15, 2003 Posts: 53 Location: USA

ARGH!!!!

I've uninstalled 4.0.10-gamme and RE-installed 3.23.55 and STILL getting the same problem.

The above links still work, so you can see...even though it SAYS I have 3.23.55 server installed, I'm still getting the 3.23.49 client message.

How much of a security breach IS this hole? And can it be locked down short of reformating Crying or Very sad

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

I believe the latest client API is .54 while the latest server is .55 insofar as the stable MySQL goes. If I'm wrong on the client API I'll reply back shortly.

Corporal Joined: Feb 15, 2003 Posts: 53 Location: USA

Thanx Zhen...any idea where I can download the Wintel API?

I would have thought it came with the full 13 Mb install of the server install, but obviously mistaken. Unless there's somewhere within the actual PHP-Nuke web I need to change as well?

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Not unless its from Mysql.com I don't know. I'm checking the API version in just a moment.

Also, analyzer 1.89.1 will be released as .2 soon to fix the incorrect mysql client version check.

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Yes the latest client API is 3.23.54.

Corporal Joined: Feb 15, 2003 Posts: 53 Location: USA

LOL, so you mean there IS an incorrect client version check within the code? Hehehe, well, then I'll wait for the next rendition to make sure I'm alright.

I've looked through a couple other sites that had their Analyzer links valid and it appears to be a non uncommon problem...

Still don't know why it's reporting an older API but will see if the next version of Analyzer says differently...

Thanx again!

Major Joined: Jan 13, 2003 Posts: 892

Interesting with phpinfo I get 3.23.49
From winmysqladmin I get client info 3.23.55

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Here is the official stuff...

If you are running MySQL stable then you should be at .55. For Client API its .54. You can run Analyzer as it tells you which version of each you have. It if says upgrade your mysql client to .55, disregard... its a bug.

Corporal Joined: Feb 15, 2003 Posts: 53 Location: USA

s'alright, will ignore, hehehe.

Thanx for your time! Much appreciated!

Laughing

Nuke Cadet Joined: Feb 18, 2003 Posts: 2

Hi, I just registered because I like the analyzer very much, and wanted to be able to post here. I'm running several nuke sites and have ben nuking from v3.5.

I've just d/l the analyzer 1.89.4 and I've got exactly the same problem described by poster #1.

I had an old mysql v3.23.39 installed, but after upgrading to the latest version mysql-3.23.55, analyzer and phpinfo() still reports the older client version, in my case 3.23.39.

Since Phpinfo() produces the same result :S, so I guess that's the root of the problem, winmysqladmin is showing the new client version, so I think everything should be okay, but need some confirmation...

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

The MySQL client API versions is obtained thru a mysql_client version function call. Specifically:

http://www.php.net/manual/en/function.mysql-get-client-info.php

There isn't very good documentation about this at all. You see there are many client APIs that hook into the MySQL server version. I may just have to remove this particular check from Analyzer.