osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

New Installation - Database import problem

This is a discussion on New Installation - Database import problem within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; I installed Apache2, php4, and MySQL4.1. I downloaded osCommerce and tried to install, but got stuck at install step 2. ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Installation Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 01-04-2005, 08:56 PM
New Member
 
Join Date: Jan 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jennyvu
Default New Installation - Database import problem

I installed Apache2, php4, and MySQL4.1.

I downloaded osCommerce and tried to install, but got stuck at install step 2.
After provided all information: Database server, Username, Password, Database name, etc.
The next page showed:
----
A test connection made to the database was NOT successful.

The error message returned is:

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


Any one has faced this problem and know how to solve it, please help me out.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 01-13-2005, 09:17 PM
developer_x's Avatar
Active Member
 
Join Date: Nov 2004
Location: Digital Infoway
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
developer_x
Default RE: New Installation - Database import problem

Let me know what you have typed in the field for Database server name. If you are installing oscommerce on localhost try this as database server name:

localhost

I think you should not write http:// before the name of database server.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 01-14-2005, 08:11 AM
New Member
 
Join Date: Jan 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jennyvu
Default RE: New Installation - Database import problem

Yes, I installed oscommerce on localhost.

I filled as following:
Database Server: localhost
Username: root
Password: (mypassword)
...

Do you think I should down grade the version of Apache (I installed Apache 2.0).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 01-14-2005, 10:04 AM
Active Member
 
Join Date: May 2003
Posts: 148
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 0
Arpit
Default RE: New Installation - Database import problem

this has nothing to do with apache, its a mysql version error, before 4.1 they used to have hashes 16 bytes in legth but in later versions it was changed to 41 (sha) and so now if the client and the server have different versions, the hashes would not match, and hence the error,

http://dev.mysql.com/doc/mysql/en/Password_hashing.html
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #5  
Old 01-14-2005, 10:09 AM
developer_x's Avatar
Active Member
 
Join Date: Nov 2004
Location: Digital Infoway
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
developer_x
Default

But Arpit he has installed oscommerce on localhost. Hence, IMHO his problem is not due to different versions of mysql at server and localhost.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #6  
Old 01-14-2005, 11:03 AM
Active Member
 
Join Date: May 2003
Posts: 148
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 0
Arpit
Default

yea so its the mismatch between the php library (aka client) for mysql and the mysql database(aka server)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #7  
Old 01-19-2005, 07:12 AM
Lurker
 
Join Date: Jan 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jenny
Default

Had the same problem and spent a day completley re checking my configuration for MySql. In MySqlAdmin you can look to see if the database exists. In the end I discovered that the database set up was causing the problem. So using MySQL I changed to root password for mySQL - logged in - and then checked out the database to ensure that the passwords and user was correct. These steps would also check that your SQL server is working.

Hope this helps
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #8  
Old 01-28-2005, 10:26 PM
New Member
 
Join Date: Jan 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jennyvu
Default

Thanks for your message, Jenny.

I think that nothing wrong with my mysql server setup. After installed, I used root password to log in to see that mysql working fine. So, I guess my problem cause by somethinh else.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #9  
Old 01-29-2005, 12:13 PM
Active Member
 
Join Date: Jun 2004
Location: Glued to Computer Chair
Posts: 108
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
makemethis
Default

.htaccess file ...maybe you need to change the lines that read
#<IfModule mod_php4.c>
# php_value session.use_trans_sid 0
# php_value register_globals 1
#</IfModule>

to
<IfModule mod_php4.c>
php_value session.use_trans_sid 0
php_value register_globals 1
</IfModule>
__________________
True Meaning of Lost: Building a web site without knowledge or skill

True Meaning of Crazy: Building a web site anyhow

The Net Results: Never needing a comb again

www.MakeMeThis.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #10  
Old 01-31-2005, 04:03 PM
New Member
 
Join Date: Jan 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jennyvu
Default

Hi makemethis,

As you suggested, I tried but it didn't help. Problem is still the same.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
OSCMax v2 - Stuck on New Installation Database Import Geno11x11 osCMax v2 Installation issues 2 12-04-2005 09:27 AM
database export/import rick osCMax v1.7 Discussion 10 12-29-2004 07:04 PM
installation problem, hangs after database server,user name splatacat osCMax v1.7 Installation 2 12-23-2004 06:34 AM
New Installation / Database Import redobe osCommerce 2.2 Installation Help 2 11-25-2003 09:43 AM
Database import sverker osCommerce 2.2 Installation Help 4 11-24-2003 12:26 PM


All times are GMT -8. The time now is 08:46 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax