beige Posted June 7, 2005 Posted June 7, 2005 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,
moonbeam Posted June 9, 2005 Posted June 9, 2005 Look Here for help on install. If you have no errors, it just froze. I think you need to start over. Hope this helps, Moon "Woohoo, Just Havin Funnn!"
Wendy James Posted June 9, 2005 Posted June 9, 2005 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.
ajpeters Posted June 9, 2005 Posted June 9, 2005 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
beige Posted June 9, 2005 Author Posted June 9, 2005 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
beige Posted June 9, 2005 Author Posted June 9, 2005 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?
pkarlos_76 Posted June 12, 2005 Posted June 12, 2005 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? <{POST_SNAPBACK}> 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.
Guest Posted May 26, 2006 Posted May 26, 2006 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!
houseoftea Posted May 26, 2006 Posted May 26, 2006 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!
jbunn555 Posted September 30, 2006 Posted September 30, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.