Quick Install Guide

[Guest]

craig... i am really sorry i'm only confusing you rather then helping... that said i'm fairly new it it all myself so probably shouldnt be offering advice...

 

again thanx vger...

 

:blush:

 

i hope you get up and running soon craig :(

 

Hey TNX anyway, it's nice to get a reply, wish my host company was so quick to provide a reply :angry:

Anyone around Surry Hills Australia? If you pop in and get me sorted I'll give you a fat discount at my shop, clothing and giftwares from Japan.

[♥Vger]

Well, it's 3 am in the UK - so off to bed!

 

Vger

[Guest]

no probs mate... :)

[oscarmaya]

When you say reset permissions on the configuration file, how do you do this? Can you please walk me through it...

 

Oscar

[♥Vger]

Go to your web hosting control panel

 

Locate the File Manager link and navigate to the file.

 

Use this to reset the file permissions.

 

You can also use FTP but this only works if the server is Apache, if the host allows you to reset permissions via FTP, and if your FTP programme can do that.

 

The only surefire way for everyone is to use the File Manager.

 

Vger

When you say reset permissions on the configuration file, how do you do this? Can you please walk me through it...

 

Oscar

[oscarmaya]

I'm using the localhost on my machine (MAMP, phpMyadmin) can you tell me how to locate File Manager here?

 

Oscar

[♥Vger]

On a local web server you just go to the file, right-click, select Properties, and then tick the 'Read Only' box.

 

Vger

[oscarmaya]

Ok! that did it...

 

Thanks Man!

[kylewa]

I'm posting this here so that people who need to can find a quick Installation Guide for osCommerce. It goes a bit further than the Installation Guide in the Knowledge Base.

 

---------------------------------------------------------------------

 

Here's the quick install guide.

 

1. Create a blank database via your web hosting control panel.

 

2. Download the osCommerce 2.2 MS2 zip file from the downloads section of www.oscommerce.com, unzip it and extract the 'catalog' folder.

 

3. If you want your shop to be available at http://www.yourdomain.com/catalog then upload the whole of the catalog folder to the root directory of your website via FTP. If you want the site to be available at http://www.yourdomain.com then just upload all of the contents of the catalog folder, but not the folder itself.

 

4. Make sure that the permissions on all of the folders are set to 755, and if that does not work then set them to 777. Make sure that the includes/configure.php file and the admin/includes/configure.php file are set to 777 for the duration of the install. Once the install is complete reset to 644, 444, or 400 depending on your server setup.

 

5. Then go to http://www.yourdomain.com/install and begin the install procedure. Your DB Server will probably be 'localhost', your db user name and password (for mysql access) will have been provided to you by your web hosting company. The name of the database you already know - because you just set it up. Do not enable SSL, elect to store sessions in the database and not files (untick the box), and do not enable persistent connections.

 

6. After the install create a folder called 'backups' inside the 'admin' folder (via FTP), and delete the install folder. Reset permissions on the two configure.php files.

 

7. Password Protect your 'admin' folder using the Password Protect feature in your web hosting control panel.

 

Away you go!

 

Vger

Mine seemed to install the data base fine and everything is in there but if I try to go to the store I get this.

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'rocker'@'localhost' (using password: NO) in /home/rocker/public_html/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

I looked at line 19 and there is nothing wrong there????

 

Can you help please.

[♥Vger]

using password: NO

 

You always need to have a password set for mysql, and there is none.

 

If using cPanel then when you create a database you must also create a db User and Password and then assign them to the database.

 

Vger

[kylewa]

You always need to have a password set for mysql, and there is none.

 

If using cPanel then when you create a database you must also create a db User and Password and then assign them to the database.

 

Vger

 

Actually I did do that...This is like the 5th store I have installed but this is the only one giving me problems..

 

Im going to just try and reinstall...

 

 

Thanks anyways.

 

kyle

[Andriy_k]

Hi guys,

 

I'am a new one here and now trying to install OSc on my computer

Please give me an advise (or link where i can find it):

Following documentation now I'm on the step

 

"Using phpMyAdmin or another tool, create your database and user, and assign that user

to the database. Write down the name of the database, username, and password for this

database for the database installation procedure."

 

I created database but next steps:

- create user

- assign that user to the database

i have no idea how to do

 

Please help

 

Cheers,

 

Andriy

[♥Vger]

When you installed your local web server the MySQL user was probably set up automatically as 'root'. The MySQL password you would have had to set up during the install of the web server, or afterwards. If using XAMPP web server then you set up the MySQL user in the xampp control panel at http://localhost

 

Vger

[kylewa]

When you installed your local web server the MySQL user was probably set up automatically as 'root'. The MySQL password you would have had to set up during the install of the web server, or afterwards. If using XAMPP web server then you set up the MySQL user in the xampp control panel at http://localhost

 

Vger

 

Well if the user was automatically set up as root thats great but I never had to set up a password.

 

I set it and it accepted my user name and password I created for the data base but I did not get to set one up for admin for the store.

 

Kyle

[♥Vger]

On a local install you don't have password protection for the 'admin' folder. If you are using one of the RC versions of osCommerce then you can set up a User Name and Password for accessing the 'admin' folder during the install - which is managed by the database.

 

The MySQL User Name and Password are the same for both configure.php files.

 

Vger

[kylewa]

On a local install you don't have password protection for the 'admin' folder. If you are using one of the RC versions of osCommerce then you can set up a User Name and Password for accessing the 'admin' folder during the install - which is managed by the database.

 

The MySQL User Name and Password are the same for both configure.php files.

 

Vger

 

Ok I dont think im explaining thigs right here so I will go into more detail.

 

I have installed several stores before and had no problems

 

First you have a password to get into your website ...I used that to connect the install.

I also have a password set for the store to connect to the data base for the store. Both these work fine. My store is installed and everyting. The problem is the install for the store skiped the setup part.

I put in the info for the first step of the install to connect the install to my server and the install did not work.... or seem to.

I went into my cpanel and into my data base and my data base was still set up. I went into the data base php and there where no files in there so I inported the mysql file from the store and then tried the store again and it worked. The store is as www.mydomain.com/catalog/index.php just like it is in every store that worked before I have installed.

 

The problem is when I go to my admin link: http://www.mydomain.com/catalog/admin/login.php

 

I have no login user name or password because the install part wher you put in a username and password to use to log into the store admin never happened.

 

I need to set up a username and passord for the store admin panel.

 

Can someone please help me.

 

Kyle

[♥Vger]

The reason the osCommerce install did not work in the first instance is that you (probably) have register_long_arrays set to 'off' in php.ini.

 

Now you have a store set up without an osCommerce admin User Name and Password. You can try this fix below, though it was meant for a different purpose originally:

 

Entering a new customer password directly into the database

-----------------------------------------------------------

Using phpMyAdmin select your customers table then click "Browse"

 

Find your customer's name in the table then click the pencil icon to edit the entry.

 

Find the entry for customers_password.

 

Delete the long string of characters and numbers.

 

Add a new password (plain text)

 

from the dropdown menu to the left select "MD5"

 

You should have something that looks like this:

 

customers_password varchar(40) MD5 newpassword

 

If everything looks correct, click the "GO" button.

 

If you go back to check that customer in the table you should see that the new password you entered is now encrypted.

 

In your case it is the administrators table you need to alter. The user name is easy to add, as that is not encrypted. Once you have encrypted the user_password field then change it back to VARCHAR (40)

 

Vger

[Andriy_k]

When you installed your local web server the MySQL user was probably set up automatically as 'root'. The MySQL password you would have had to set up during the install of the web server, or afterwards. If using XAMPP web server then you set up the MySQL user in the xampp control panel at http://localhost

 

Vger

 

 

Thanks a lot

[sikker]

Hi all

 

I just installed my webshop, and I get some problems.

 

You can see it at this adress:

 

hxxp://www.sikker.hu/catalog/

 

Can somebody tell me what shall I do to resolve this?

 

I have just a little php knowledge.

[♥Vger]

Session Save Path and Safe Mode

-------------------------------

The error is a by-product of using PHP in Safe Mode while using a particular version of PHP 4.

To get around the problem go to your osCommerce Admin Panel -->

Configuration --> Sessions and set Session Save Path to just tmp

with no forward slash before or after tmp. You get this error even if you

have elected to store sessions in the database.

 

If the error prevents you from accessing your admin panel then

access the database via phpMyAdmin, go to the 'configuration' table,

find the Session Save Directory entry (there are several pages of

entries for this table), open it for editing and change /tmp to

just tmp with no slash before (or after) it.

 

Vger

[sikker]

Session Save Path and Safe Mode

-------------------------------

The error is a by-product of using PHP in Safe Mode while using a particular version of PHP 4.

To get around the problem go to your osCommerce Admin Panel -->

Configuration --> Sessions and set Session Save Path to just tmp

with no forward slash before or after tmp. You get this error even if you

have elected to store sessions in the database.

 

If the error prevents you from accessing your admin panel then

access the database via phpMyAdmin, go to the 'configuration' table,

find the Session Save Directory entry (there are several pages of

entries for this table), open it for editing and change /tmp to

just tmp with no slash before (or after) it.

 

Vger

 

 

Thanks a lot.

 

It resolved a part of that php errors, but I still have one: function.file-exists.

Somebody tells me its because linux server.

Do you have some idea how to fix it?

[♥Vger]

I only answer osCommerce Basic install questions here. If you need server advice then a specialist forum for people who self-manage their own servers would be more appropriate.

 

Vger

[Guest]

Oh boy. Thank you so much for all of this incredible information. I'm a complete newbie who's trying to go this on my own. Ugh.

 

:blush: Well, I think I got things installed but not too sure. How do I check the permissions on the folders to make sure that they are set properly? I'm so confused on this.

 

after my installation the following info was given to me:

 

directory where the online store is installed on the server:

/misc/20/369/526/776/8/user/web/sitename/catalog/

 

of course, sitename is changed to hide my website name. Did I do this right and is this what I want? I'm trying to follow the directions but not finding all the stuff it's telling me to do.

 

When I go to my catalog I get a couple error messages:

 

:angry: Warning: Installation directory exists at: /misc/20/369/526/776/8/user/web/sitename/catalog/install. Please remove this directory for security reasons.

:angry: Warning: I am able to write to the configuration file: /misc/20/369/526/776/8/user/web/sitename/catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

 

 

What do these mean?

 

:'( HELP!!!

 

Kristin Wilson

 

 

 

Here's the quick install guide.

 

4. Make sure that the permissions on all of the folders are set to 755, and if that does not work then set them to 777. Make sure that the includes/configure.php file and the admin/includes/configure.php file are set to 777 for the duration of the install. Once the install is complete reset to 644, 444, or 400 depending on your server setup.

 

5. Then go to http://www.yourdomain.com/install and begin the install procedure. Your DB Server will probably be 'localhost', your db user name and password (for mysql access) will have been provided to you by your web hosting company. The name of the database you already know - because you just set it up. Do not enable SSL, elect to store sessions in the database and not files (untick the box), and do not enable persistent connections.

 

6. After the install create a folder called 'backups' inside the 'admin' folder (via FTP), and delete the install folder. Reset permissions on the two configure.php files.

[♥Vger]

You need to delete the 'install' folder after you complete the install.

 

You need to reset the permissions on the two configure.php files - either to 644, 444 or 400 - which will work depends on your hosts server settings.

 

Vger

[bowers2000]

Hi Vger,

 

Like everyone else here I am new to this and was hoping you could help.

 

The issue I was having was if I typed http://www.mydomain.com the page would not display. It would display if I typed http://www.mydomain.com/catalog

 

I would like to have the page display if a user types my main URL (i.e. http://www.mydomain.com). Users wouldn't know to type catalog. I saw a few posts that said that I should just upload the contents of the catalog folder to the root directory.

 

I only noticed this problem after I installed everything. After install I went back and tried moving all the contents of the catalog folder directly to the root. It loads the intitial index.php file, but any links I click after that are broken.

 

I believe this is because during set-up I listed the URL as http://www.mydomain.com/catalog. After the set-up is complete...is there a way to fix this without completely reinstalling? I have made some modifcations and would like to avoid that if possible.

 

Thanks!