Installation problem

[freddae]

I'm having trouble installing, I goto http://localhost/catalog/install and follows the instructions. The checkboxes at the first page are marked, I click continue, then I fill in the information Database server: localhost, Username: root, Password: root, Database Name: shop, then I click continue. The next page appear but it's empty. No errormessage or confirmation of success. Please help.

/freddae

[behappy]

I am experiencing the same difficulties. i am running oscommerce 2.2 and mysql 4.1.7 on a windows 2000 server. Been flipping stuff around for a couple hours to no avail on page /catalog/install/install.php?step=2 when i see the "next page" /catalog/install/install.php?step=2 it's exactly the same header "new installation" over "Database import" with the remaining south of the page blank. any help would be greatly appreciated. no error messages... nada.

[liux99]

Got the same problem. I am using Apache2, php5 on windows XP and 2000. When goes to step 2, then there is half blank page, no error message. I am new to this oscommerce and php, but I was able to pin down to install_2.php, the function osc_db_connect somehow does not function, but no error message. I have been spending last few days researching and learning php, but could not get help. Any one with experience in this stuff please shed some light on this. Thanks in advance!

[pjm]

Hi,

I had this issue earlier, but I've fixed it now. I did quite a few different things whilst playing with the problem (for example, I switched on error display & logging in Apache2 and restarted), but I'm pretty certain that the root cause was that mySQL wasn't setup properly.

When I installed MySQL, I fired up the server without creating grant tables or a user or anything. I managed to create the osCommerce database using the manual SQL process described in the "INSTALL" file which comes in the osCommerce tarball.
However, when I tried to run osCommerce install script from my browser, and filled in my best guesses at the DB values, I got the problem with the "New Installation / Database Import" half-blank screen.

As root, from the mysql directory, run bin/mysqlshow.
You'll get a bunch of diagnostic data about your install.
If you don't see this:

+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+

then you've got issues - because the table mysql is where all the permissions for the dataserver live.
Luckily you can create this table by running bin/mysql_install_db --user=mysql
The user argument should be the user you intend to run the dataserver as (for security reasons this is never root).

You need to have a user correctly setup and with the right permissions on the dataserver. I used webmin to create a user called oscuser and gave it a password. I gave it all privileges, but in practice will restrict these once I am happy it all works!

If you don't have webmin or some other db tool, you can find mysql command line instructions for adding accounts here:
http://dev.mysql.com/doc/mysql/en/Adding_users.html

In short I think you want to login using mysql --user=root mysql and then run:
GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

Now use the same username and password in step 2 of the catalog/install process, and hopefully it might actually work!

It should be pointed out that this user you've created will be a superuser and so this might all be horrible insecure. Once this is all setup, you should restrict permissions using REVOKE.
http://dev.mysql.com/doc/mysql/en/GRANT.html

Let me know whether any of this helps!!

[vinces]

Installing on a Linux server is much easier.