MySQL Client...still freaking me out! Pls Help

[Forri]

Hi again

I'm still getting that PHP has the Mysql-client 3.25.xx whereas i'm pretty sure that i've installed the client version 5. This time i tried it on my WINDOWS PC and the same happens!

I've noticed the PHP has an extension to a library called php_mysql.dll and it references another library within the System32 called libmysql.dll.

If the extension in the PHP.ini file is left uncommented than the Mysql-php link works whereas if its commented with a ; then it doesn;t!

But still if i uncomment it it looks for the mysql3.25.xx library! Mysql has a library called libmysql.dll too but when i tried replacing and started apache it gave errors!

My questions are:

1) Is there another php_mysql.dll available somewhere which references the new libmysql.dll?

2) is there another extension i should provide instead of the c:\php\sapi\php_mysql.dll

3) is there a work around to this!


Thanks and i apologize for my ignorance!

Nicky

 

[ingresman]

is it causing you problems ?

 

[Forri]

yes because i cannot use the 41 character long password! that's the problem..maybe i'm thnking on the wrong line...if you can help i'll be much obliged!

Thanks
Nick

 

[ingresman]

That's a long password !,
I've just looked at the user table in the mysql database at it holds an encded password of 16 character. I've tried to set up a user name with 50 bytes for the password and it seemed ok. Can you show us what error you are getting please ?

 

[Forri]

The problem is not the Mysql Server or database but rather the PHP! since php has its own libraries for mysql, it only has the version 3.25.57 which is an old version and does not support the Long password...for that i have to set users using the OLD_PASSWORD function!

Now i want to know if i can somehow change the mysql client for the PHP! ?

Tahnks
Nick

 

[ingresman]

Sorry man, i'm confused here. What does PHP say if you try to use a long password ?. What's the OLD_PASSWORD function ?
post some code !!

 

[Forri]

sorry ingresman...just read it!

If i do this

mysql> use mysql
mysql> update user set password = PASSWORD('mypass') where user = 'username';

The above will set the password in a 41-character long encrypted password!

using the same code above but insted of using the PASSWORD function you use the OLD_PASSWORD function this wil create a 16-character long fnction!

Now the old Mysql Client versions support only the old passwords but the new ones can support both!

I have installed the Mysql v5 both server and CLIENT! but since php has php_mysql.dll or mysql.so libraries they have the old client installed with v3.23.58 which does not support the long passwords!

Therefore i would like to upgrade that but i have no idea how!

Thanlks

 

[ingresman]

Yes, I see your problem. I've never built PHP from source so I cant help you on this.
One interesting thing though is my config is as follows (on XP)
mysql client 3.23.49
mysql 4.0.18
php 4.3.5

So I think you have established your own solution, use old_password.

I'd be interested if any has a linux version og php that uses a 4.1 client library

 

[Forri]

well if i get somewhere i'll definitly post it!


Tahnks all

 

[Forri]

Hey ingresman...phew i did it!

I had to download the source for PHP and i compiled it using other parameters for mysql and worked flawlessly!

Had no idea how to compile and during compiling had lots of errors but fixed them all...got the hang of it now hehe!

If it intrests you; the following is the configuration line i wrote:

./configure --with-apxs2=/usr/sbin/apxs --with-xml --enable-bcmath --enable-calendar --with-curl --enable-ftp --with-gd --with-jpeg-dir=/usr/local --with-mcrypt=/usr/bin --with-png-dir=/usr --enable-magic-quotes --with-mysql=/usr --enable-discard-path --with-pear --enable-sockets --enable-track-vars --with-ttf --with-freetype-dir=/usr --enable-gd-native-ttf --enable-versioning --with-zlib

Tahnks
Nick

 

[ingresman]

xlent I'm glad you found a fix. I think it will be asked time and time again here as people upgrade to 4.1