Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Installation Error


beige

Recommended Posts

during the installation, i see the "database import window",

 

Database Server:

Database username:

Database password:

Database Name:

Enable persistent database connections.

Session Storage: Files Database

 

After click continue, it frozen in half way loaded. with words of "Database Import". the URL is http://localhost/catalog/install/install.php?step=2

 

What is wrong? Thanks ahead,

Link to comment
Share on other sites

I know people have had that problem if they are using PHP5 and the suggestions have been to either go back to an earlier version of PHP or manually install which isn't too hard to do.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Link to comment
Share on other sites

Search for all the php.ini files on your system. Delete any not in the PHP directory.

 

Change the line

register_globals = off

to

register_globals = on

 

Change the one that starts at the beginning of the line

 

change the line

register_long_arrays = off

to

register_long_arrays = on

 

same rules, the ones is a ; are cmments.

 

restart apache

 

see what happens

Link to comment
Share on other sites

Search for all the php.ini files on your system.  Delete any not in the PHP directory.

I only found one pho.ini under C:\windows, is this right?

BTW, I use IIS 5

Link to comment
Share on other sites

Ok, There is definitely a problem with php5 and osCommerce MS2.2. I roll back to php 4.3.11. Now I get:

 

Database Import

 

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

 

I just installed mySQL 4.1.12a on my local, use mySQL admin tool can see the sample db and table, I also created a schema called "oscommerce". user "root" has enough privilege.

 

Any ideas?

Link to comment
Share on other sites

Ok, There is definitely a problem with php5 and osCommerce MS2.2. I roll back to php 4.3.11. Now I get:

 

Database Import

 

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

 

I just installed mySQL 4.1.12a on my local, use mySQL admin tool can see the sample db and table, I also created a schema called "oscommerce". user "root" has enough privilege.

 

Any ideas?

yeah well I'm still getting your first problem

 

New Installation

Database Import

 

using:

Apache/2.0.53 (Ubuntu) mod_perl/1.99_14 Perl/v5.8.4 PHP/4.3.10-10ubuntu4 Server at 68.151.37.105 Port 80

mysql Ver 12.22 Distrib 4.0.23, for pc-linux-gnu (i386)

 

If anyone has a solution please let me know I'm following this thread.

Link to comment
Share on other sites

  • 11 months later...
yeah well I'm still getting your first problem

 

New Installation

Database Import

 

using:

Apache/2.0.53 (Ubuntu) mod_perl/1.99_14 Perl/v5.8.4 PHP/4.3.10-10ubuntu4 Server at 68.151.37.105 Port 80

mysql Ver 12.22 Distrib 4.0.23, for pc-linux-gnu (i386)

 

If anyone has a solution please let me know I'm following this thread.

 

This was a Year ago... Does anyone know if it was ever solved? (PHP 4.3 is now too old to consider as I need 5.0 functionality for the other stuff I do...) Can anyone explin the problem with the DB-PHP interface?

 

Thanks!

Link to comment
Share on other sites

Don't be so quick to blame php5.

 

I'm using php 5.1.4 OK after working through a couple issues the last few days.

I was hanging on the New Install screen, step 2. Wasn't getting errors, would just loop back to the same screen.

Made the changes above; Register_Globals & Long_Arrays.

Once I did that I was able to continue successfully all the way through the install.

However, when I got to the end and clicked on the Admin button, I got only a blank page.

The store loaded fine in my browser, but not the Admin. I finally found the solution here on the forum.

This seems obscure to me, and I don't know what I did really, but it worked.

 

go into:

 

/catalog/admin/includes/classes/upload.php

 

and replace every instance of $this with $th_s

 

Once I did that, my Admin showed-up at localhost/catalog/admin and off I went.

 

I've installed it on my Mac server to learn osCommerce in a safe zone before hitting the real world.

Don't know how platform-dependent php versions are??

 

OS X 10.4.6

php 5.1.4

MySQL server 4.1.13, client 5.0.4

osC 2.2 MS2

 

This forum is fantastic; thanks to all the helpers out there!

 

================================

This was a Year ago... Does anyone know if it was ever solved? (PHP 4.3 is now too old to consider as I need 5.0 functionality for the other stuff I do...) Can anyone explin the problem with the DB-PHP interface?

 

Thanks!

Link to comment
Share on other sites

  • 4 months later...
The error message returned is:

 

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

 

The reason for this is that any version of mysql 4.1 and higher uses a different authentication model and older clients eg oscommerce do not support this by default.

 

One way to fix this is to use your mysql command line client

access it by going to command prompt then type in:

mysql -u youruser -p

hit enter then enter password

if successful it will show:

mysql>

then you need to type in:

set password for 'youruser'@'yourhost eg localhost' = old_password('yournewpassword');

 

old_password is not your previous password it is actually a mysql command so don't substitute it for your password leave as is

 

use this command to convert just that one user to the older authentication model and use that user for oscommerce related tasks and it will work

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...