Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mysql 4.1 has problem with client authent..


Guest

Recommended Posts

Hello.

 

I am trying to get oscommerce to work with mysql 4.1..

I get an errormessage:

mysql_connect() returns that it couldnt validate with the mysql client??

 

How can i fix this? Can i upgrade the mysql client and how

do i do that?

 

Thanks for listening.

 

Best regards,

Christian O.

Link to comment
Share on other sites

I am getting this exact same problem

 

windows 2000 server

 

iis 5.0

 

mysql (latest)

 

php 4 and I tried php5 (both failed)

 

I already tried using old passwords crap thingie.

 

I reverted back to an older mysql and it works but I hate using the older version soo not user friendly.

 

I want to use the new mysql with the administrator which makes thing nicely for backing up and restoring.

 

Please someone help us on this fix!!

Link to comment
Share on other sites

I found the answer.

 

The Answer is MySQL & PHP 5.0. In my testing it shows that they are NOT backwards compatible with OSCommerce.

 

I recently upgraded my server to PHP 5.0 and MySQL (Latest). Gave me that exact same error you are getting.

 

I was like CHIT!!!!

 

So I uninstalled MySQL (latest) and installed a older version MySQL 3.23.

 

Ran my OSCOmmerce and DENIED!!! It would not work.

 

DOUBLE CHIT!!!

 

Chit! Chit! Chit!

 

The old lady who hired me to maintain the server calling me @#$%!!!

 

TRIPLE CHIT!!!

 

I rolled back to PHP 4.3 and VOILA everything started working again.

 

Weeeeeeeeeeeeeeee......

 

So my conclusion is this. Either MySQL 4 (latest) or PHP5 or both are not compatible with OSCommerce.

 

I hope there will be a fix for this but in my thinking maybe many other scripts may not work either and that upgrading is not a good idea just yet till they totally make sure its compatible with OSCommerce.

Link to comment
Share on other sites

osCommerce isnt the problem...

 

The MySQL extension doesn't support full functionality of MySQL versions greater than 4.1.0. For that, use MySQLi.

 

:)

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

ok where do I get that? MySQLi??

 

Also I read this post...

 

Similar Problem

 

That link is on this forum regarding another who has the same problem but with apache for windows.

 

I am using it for IIS 5.0.

 

P.S. before you say it no I wont switch to Apache.

 

I was wondering if that link bares any help on our current situation?!

 

he says to install phpMySQL. What the heck is that? or is that php & MySQL?

 

Help us Sparky!

Link to comment
Share on other sites

To use mysqli you need to be running php5.

 

Then just copy the libmysqli.dll file to windows\system32 and then edit the php.ini to uncomment the mysqli.dll extension then restart IIS and you should be up and running.

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

ok i got php5 installed mysql 4.1 installed and the mysql administrator and I looked HIGH and LOW for those damn libmysql.dll and libmysqli.dll files and they are nowhere to be found in the php5 dir or the mysql 4 dir or anywhere on the harddrive i downloaded them again as source and not the windows installer and still no FOUND.

 

I looked in my php.ini file and nothing there either on the mysqli extension!

 

can you tell me what line I need to type in the php.ini extension area??

 

also where can i find that blimey file!?

 

HELP ME

Link to comment
Share on other sites

ok i found them finally.

 

new problem in my php.ini file

 

i only see this

 

extension=php_mysqli.dll

 

i dont see anything else in the php.ini file.

 

i moved the libmysqli.dll to the winnt\system32

 

i tried and it says cannot find php_mysqli.dll

 

 

help???

Link to comment
Share on other sites

Update

 

I tried everything

 

I put the path for the extensions direction in the php.ini

 

failed

 

installed both libmysqli.dll and php_mysqli.dll files in the same direction for the extensions

 

failed

 

<---finally went to walmart and bought a shotgun

 

Now someone better tell me how in the hell to get oscommerce working with the latest php 5.XX version and MySQL 4.1.7 version or my server going to get a blast from my shot gun.

 

<--- pis@$ed off.

 

nothing works!

Link to comment
Share on other sites

I am having the same problem.

 

I run on a Windows XP SP2 machine:

 

-Apache HTTPserver 1.3.33

-MySQL 4.1.7

-PHP 4.3.9

 

an I get this error:

 

Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

I am not amused.

 

What to do?

 

Regards,

 

Martin :blush:

Link to comment
Share on other sites

I had to downgrade to php 4 and mysql 3.23

 

needless to say I am pis#$d off!

 

I been to the mysql forums and php forums and NOBODY offering any kind of help.

 

not even oh well we think your screwed please try another script.

 

nada just a wall of silence.

 

Now i come here seeking help and NUFFIN!!!

 

I am going to shoot the damn server cuz i want to upgrade for security.

 

and if any1 of you say "RTFM!" Ima gunna kill yew!

 

Manuals read like chinese.

 

Someone be kind of enough to address this gawd damn ISSUE!!!!

 

For the love of GOD People! Put some blimey input into this thread!!!

Link to comment
Share on other sites

I had to downgrade to php 4 and mysql 3.23

 

needless to say I am pis#$d off!

 

I been to the mysql forums and php forums and NOBODY offering any kind of help.

 

not even oh well we think your screwed please try another script.

 

nada just a wall of silence.

 

Now i come here seeking help and NUFFIN!!!

 

I am going to shoot the damn server cuz i want to upgrade for security.

 

and if any1 of you say "RTFM!" Ima gunna kill yew!

 

Manuals read like chinese.

 

Someone be kind of enough to address this gawd damn ISSUE!!!!

 

For the love of GOD People! Put some blimey input into this thread!!!

 

Although I share your anger, I do not think anyone is going to help us when we start adressing everybody like our enimies.. :-)

So shall we change tone and await an helping and understanding reply?

 

Regards,

 

Martin

Link to comment
Share on other sites

BTW,

 

The most frustrating for me is that it seems that quite a few people have managed to install it with no harm. Although I don't consider myself as a computer and internet no-know, I feel awfull tiny and dumb..

So if anyone recognizes my feelings and feels like helping an internet user of the first hour, please feel free to reply with some constructive indications...

 

:rolleyes:

Link to comment
Share on other sites

This isnt a problem with osCommerce so I will do my best to help you through it.. however you could be better using php specific forums to ask for help if this doesnt fix your problem.

 

Here is how I installed mysqli

 

1. Download php 5.0.2

2. extract it to c:/php5

3. Configure apache to use php5 (I dont use IIS so cant provide instructions)

4. Copy php.ini from c:/php5 c:/windows

5. Copy libmysqli.dll c:/windows/system32

6. Copy php5ts.dll c:/windows/system32

 

7. Create a new page called info.php

 

<?php
phpinfo();
?>

 

Ran this to make sure php 5 was installed correctly.

 

8. Edit php.ini added extension=php_mysqli.dll

9. Edit php.ini set extension_dir="C:\php5\ext\"

10. Restart apache.

 

Mysqli is now loaded.

 

The only problem with using the mysqli driver is that osCommerce is coded to use mysql and the connect strings etc are all different.

 

The best solution would be to remove MySQL 4.1.x and install 4.0.x (There is no need to use 3.23.x)

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

Does Administrator work for mysql 4.0?

 

MySQL Administrator is available for Microsoft Windows and Linux, and is compatible with MySQL version 4.0 or later.

 

HTH :)

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

system

 

windows 2000 server IIS 5.0

 

php 4.x

 

mysql 3.x

 

situation: i want to upgrade to php 5.0.2 / mysql 4.1.7 / mysql administrator 1.0

 

data: its all f#$ked up. I uninstalled php 4.x and mysql 3.x. I restarted.

 

I proceeded to install php 5 using the php 5 windows installer. I used the php5 windows installer cuz its easy and it automatically makes changes to the IIS 5.0.

 

However!! low and behold the g#d D#MN php 5 windows installer is just basic sh#t!. No worries I think, just go ahead and download the php 5 source which should include everything. So I did and copied everything from the source which iincludes extension and everything else to C:\php directory.

 

OK that is finally done!

 

I test it first

 

It works using a test.php script I found on the google somewhere.

 

so now at this point i confirmed php5 is working.

 

NEXT...

 

MySQL 4.1.7

 

I continued to install this monster. So far installation a breeze till it tries to EXECUTE and install a SERVICE.

 

FAILED!!!

 

I Say "WTF?"

 

I look in my services and the old mysql is still there installed as a service. Well CHIT! I say. Logs show its failing on start up because I uninstalled it. Well CHIT! I used add/remove programs apparently the damn thing dont uninstall correctly.

 

What this means? i cant f#$#king install mysql 4.1.7 correctly.

 

so what must I do ?

 

get rid of that g#d damn service.

 

so i do what any of you would do!

 

I GOOGLE.

 

AHA! delete mysql from the registry and reboot.

 

2 places where it showed in the registry as a service so i delete.

 

REBOOT

 

VOILA its no longer shows up as a service trying to start and caushing massive errors cause it cannot find the bloody program.

 

ok NOW

 

iTS TIME for mysql 4.1.7

 

good thing its free cuz i would feel ripped OFF not being able to properly uninstall its previous version.

 

now i install this MOFO and it installs FINE.

 

time to test this MOFO out. using another TEST php script I found while googling

 

its a php file that tests mysql to see if its working or not.

 

I thought this be a good idea to try out because maybe oscommerce has a bug.

 

I put it in my website hop OVER to another computer and test it out.

 

FAILED!!!

 

I am like F#@K! (I feel at this point to throw the mofo server out the window)

Yes its running in my HOME! save me money on paying another MOFO for webhosting.

 

I think WTF?!

 

OH I KNOW that guy SPANKY or SParky said i need to enable a extension.

 

LETS DO THAT NOW!!

 

I first edit php.ini

 

i change the extenesions directory to c:\php\ext

 

I uncomment php_mysqli.

 

ERrrr HOLD UP!!!

 

Uncomment MY ASS!!! it aint f##$king there to uncomment in php5

 

I had to add it myself.

 

SO i do that add the gAWD damn line.

 

ok now that is done

 

restart IIS 5.0

 

now TEST

 

cannot load module because its not located in c:\php\ext !!!

 

WTF?! OMFG

 

I check the spelling four times.!! I check to make sure those G#D damn files are there FOUR TIME!!

 

I put on my glasses to MAKE SURE and repeat step ABOVE!!

 

OMFG!! WTF!?

 

ok no i think copy and paste them files php_mysqli.dll and this other one it needs i heard on google libmysqli.dll to windows dir and i copied it to system32 directory too.

 

i edit php.ini to point to the windows directory

 

FAILED

 

i try to edit php.ini and change the extensions dir to point to system32

 

FAILED!!

 

at this point i say "F#@K IT!"

 

reboot with my norton ghost boot floppy and revert my server to a saved ghost image

 

Voila everythign working and back to normal except using older php and older mysql.

 

Now before you say goto php or mysql websites for support.

 

let me first tell you they dont know what support is!

 

i dont know wtF they are doing over there, but support is not one of them. neither is RTFM, because their documentation reads like chinese.

 

However I tried anyhow. they reply its not a bug so we cannot help.

 

F#@K

 

so here I am praying to god someone is using windows 2000 or windows 2000 server with IIS 5 and found a way to get php5 working with mysql 4.1.7 with OSCommerce.

 

I will continue to post updates cuz this will keep this topic @ #1 till someone or anyone responds a fix to this post!!

 

Moderators HELP damn YEW! put in your 2 cents

Link to comment
Share on other sites

so here I am praying to god someone is using windows 2000 or windows 2000 server with IIS 5 and found a way to get php5 working with mysql 4.1.7 with OSCommerce.

 

First off you need to get mysql and php working together before you can consider osCommerce :)

 

Why do you want to use mysql 4.1.7? Is there a special reason?

 

I will continue to post updates cuz this will keep this topic @ #1 till someone or anyone responds a fix to this post!!

 

Good luck :)

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

This thread reads like a comic book.

 

Great stuff. Keep it coming!

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Thanks for contributing even if its just chatting.

 

I want to use all upgrading software, because my server has been compromised recently and a lot of destruction occurred. This is the biggest reason why I am upgrading everything. To be on the safe side if that means anything.

 

Plus another big reason is I like administrator 1.0, it looks like its really easy to work with.

 

Help Me!!!! :-"

Link to comment
Share on other sites

I want to use all upgrading software, because my server has been compromised recently and a lot of destruction occurred. This is the biggest reason why I am upgrading everything. To be on the safe side if that means anything.

 

If you are worried about security then using the latest versions of any software is the worst thing you can do :rolleyes: :-"

 

Plus another big reason is I like administrator 1.0, it looks like its really easy to work with.

 

That doesnt mean you have to use the latest mysql if you read my post earlier you will see that it works with mysql 4.0 also :)

 

Help Me!!!! :-"

 

If you want to use the latest versions of software then you will have to be prepared for a lot of work... after you get php working with mysql 4.1.7 you will need to re-write the db class for oscommerce anyway :)

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

Update!!!!

 

I google like nobody has googled before. I googled soo damn hard my wrists have developed Carpel Tunnel. <--if this is misspelled consider it a TYPO, if its not then just ignore this statement all together.

 

My fingers feel lilke jello, I can't control my fingers they feel numb.

 

I have to now resort to the TYPING with 2 finger method. I know many of you use this method already, so does my boss who makes more money than me and spends all day long playing internet video games cuz he married the boss's daughter.

 

Anyhow

 

It would appear this is a bigger problem than most have suspected. Its on a large scale. Many reported this being a problem with many other scripts after they updated.

 

I feel php or mysql or both better ante up some apologizes.

 

f00k my fingers feel like mush as I type here.

 

I know its 9am here, so I imagine for those who are barely waking up and read this post, some of youse has to know the ANSWER.

 

maybe some deveoper or alienware type geek has the answer to this million dollar ?

 

Help the "save my fingers from feeling like jello foundation" and contribute a possible fix to our massive problem which is all over GOOGLE.

 

You be helping me but more important you be helping the millions out there with fingers also feeling like mush from googling!!!

Link to comment
Share on other sites

I feel php or mysql or both better ante up some apologizes.

 

Good idea... give them a call and tell them :D

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)

 

---------------------------------------

Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...