Guest Posted November 13, 2005 Share Posted November 13, 2005 I am very far from being computer savy, so bear with my ignorance on what exactly is going on. My server is local, earlier a friend helped me get PHP5 up and running. I downloaded and extracted OSC, patched it to allow register_globals off, and then proceeded with install. Once I submit the server and DB info in step 1, step 2 loads the header for the page, containing the OSC logo on the right and the following to the left: New Installation Database Import And that's it. Tried logging into the server with different user names, different DB names, the works. I've been searching around, and can't seem to find a solution to this. I'm lost, any help is very much appreciated :thumbsup: Link to comment Share on other sites More sharing options...
GraphicsGuy Posted November 13, 2005 Share Posted November 13, 2005 You didn't mention the version of mySQL that you installed, but if you are working with a copy of osCommerce downloaded prior to yesterday (11-12-2005), then it is not PHP5 or mySQL5 compatible. Yesterday the team released an updated version that is compatible with PHP5 and mySQL5. It is available here osCommerce 2.2 Milestone 2 Update 051112 , The forum thread discussing it is here. Rule #1: Without exception, backup your database and files before making any changes to your files or database. Rule #2: Make sure there are no exceptions to Rule #1. Link to comment Share on other sites More sharing options...
clive Posted November 13, 2005 Share Posted November 13, 2005 Open the php.ini file present in the folder into which you installed PHP. Change the entry register_long_arrays = Off to register_long_arrays = On It worked for me Link to comment Share on other sites More sharing options...
Guest Posted November 13, 2005 Share Posted November 13, 2005 Open the php.ini file present in the folder into which you installed PHP. Change the entry register_long_arrays = Off to register_long_arrays = On It worked for me Already checked that, it was one solution I found in searching around. It's already on. I downloaded OSC yesterday, so it should be the newest update, I'll check into it. Thanks guys. Link to comment Share on other sites More sharing options...
Guest Posted November 13, 2005 Share Posted November 13, 2005 Oh, forgot to mention, MySQL5. I have the most recent version of OSC. Link to comment Share on other sites More sharing options...
Guest Posted November 14, 2005 Share Posted November 14, 2005 More searching brought me to the '$this = null' issue with PHP5. However in the admin/includes/classes/upload.php there is no '$this = null' to change. Is this because I have the PHP5 compatible version? Am I just being stupid? And if the $this fix does not apply to me, nor register_long_arrays = On, just what is my problem. I have tried doing the install with register_long_arrays turned off (it was turned on by default), a variety of different user names and passowrds, etc, and the same result. No error message, no nothing, just a partially loaded page that doesn't do anything. Link to comment Share on other sites More sharing options...
GraphicsGuy Posted November 14, 2005 Share Posted November 14, 2005 The configuration of a web server (Apache or IIS), PHP and mySQL and their interaction is complex and there are so many possibilities that you could lose a great deal of time troubleshooting it. As an alternative, you may want to remove the current installations of PHP and mySQL. Then use one of the prebudled packages that installs all three together and configures them. (i.e. XAMPP ) Rule #1: Without exception, backup your database and files before making any changes to your files or database. Rule #2: Make sure there are no exceptions to Rule #1. Link to comment Share on other sites More sharing options...
Guest Posted November 14, 2005 Share Posted November 14, 2005 Wow, that is very cool. I was totally unaware that there were such bundles out there. Unless I somehow stumble accross a solution in the next dew hours, I'll install that. Thanks :) Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 Got it working, turns out that despite having the newest OSC release linked above, something in PHP5 is incompatible with step 2 of the install. Uninstalled PHP5, installed PHP 4.4.1 and there it went. For others' reference (in the event it makes any difference), the server is running: Windows 2000 Advanced Server PHP4.4.1 Mysql 5.0.15 Apache 2.0.54 osCommerce 2.2 Milestone 2 Update 051112 Now to get Mysql working right, thanks to all that offered help :) Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 Anyone care to explain what this means? 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 Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company. :blink: Link to comment Share on other sites More sharing options...
DiMiT Posted November 16, 2005 Share Posted November 16, 2005 sounds like you may not have put the correct database name and/or password happened to me when I installed first time I could be wrong tho people please fill out your info ... I like to see the sites and it helps everyone help you greatly Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 Do I need to create a DB manually? I thought the OSC install created the database if one did not already exist with that name? The authentication protocol error is confusing me... wouldn't it say something along the lines of database not found or incorrect login if that were the problem? :huh: Link to comment Share on other sites More sharing options...
Guest Posted November 16, 2005 Share Posted November 16, 2005 Much searching and head scratching solved my problem. mysql> SET PASSWORD FOR -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); The issue was the way passwords work between PHP4 and MySQL5; doing the above apparently fixes it. :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.