Jump to content

Archived

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

Vger

Quick Install Guide

Recommended Posts

Hi Vger,

 

I've read every single post for the first 20 pages.. now up to 'May 2, 2006'(!) trying to find a quick answer to a simple (for you) question.. sorry if this has already been asked:

 

It's only After I installed OSC that I found threads explaining the difference between installing the catalog Folder on the root and just the Contents of the folder on the root (I installed the folder, too..). I really wanted the url to be accessible via plain ol' http://mydomain.com/ Is it possible to achieve this by moving the contents of the catalog folder to the root, or am I stuck with another (3rd) complete OSC re-install? Also, isn't there any 'risk' in putting all those files onto the root?

 

I've only made a few changes to the site 'so far', so I guess it won't be the end of the world if it means another install.. was just hoping to avoid it :rolleyes:

 

Thanks for all the time & patience you've shown in this thread.. amazing..

 

Steve

*almost forgot.. it's v2.2 RC2a (just in case it makes a difference).

 

 

Hi, If you wish to have your osCommerce website in the root of your domain e.g. http://www.yourdomain.com then just upload the contents of the catalog folder but not the folder itself to the root of your web (usually a folder called something like httpdocs, public_html, html, or htdocs). No need to upload anything outside of the catalog folder.....

Share this post


Link to post
Share on other sites

Just upload the "contents" of the folder to the root of your website, and then edit both configure.php files to remove catalog/ from the pathways.

 

You will also need to re-apply password protection to the 'admin' folder. I know the RC versions have database driven password protection, but this is nowhere near as secure as .htaccess folder protection.

 

Vger

Share this post


Link to post
Share on other sites

You are a gem..

 

Big thanks Vger..

 

Steve

 

 

Just upload the "contents" of the folder to the root of your website, and then edit both configure.php files to remove catalog/ from the pathways.

 

You will also need to re-apply password protection to the 'admin' folder. I know the RC versions have database driven password protection, but this is nowhere near as secure as .htaccess folder protection.

 

Vger

Share this post


Link to post
Share on other sites

hey i need some help.

 

ive uploaded the contents of catalog to my host site but when i go to myadress.com/install.php it says no input file specified

 

any help on what i should do

Share this post


Link to post
Share on other sites

The address is just www.yourdomain.com and the install screen should then appear.

 

If it doesn't then it's likely that you uploaded the files to the wrong place on your web hosting.

 

Vger

Share this post


Link to post
Share on other sites

hey ive got it installed but when i click the catalog button or the admin button it just pops a grey screen up and then downloads an empty index.php

 

anyidea what ive done? or how to fix it?

 

sorry to be a pain :P

Share this post


Link to post
Share on other sites

ok ive sorted that.

 

 

but i am geting this error again

 

Warning Warning: I am able to write to the configuration file: /customers/bodyartparts.co.uk/bodyartparts.co.uk/httpd.www/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

 

but when i change the permissions on the file it seems to change back again and not remove the error ?

Share this post


Link to post
Share on other sites

Your server does not allow you to change the permissions via FTP. Use the File Manager link in your Web Hosting control panel instead.

 

Vger

Share this post


Link to post
Share on other sites

the file manager on my host site doesent seem to have the option to change the permisions when i click propertys it just displays the path and name

 

any ideas?

Share this post


Link to post
Share on other sites

also when i click any of the links the browser cannot display the page and says a file is missing but the files are there? =[

Share this post


Link to post
Share on other sites

You'll have to say what the actual error is.

 

If you cannot edit permisisons using FTP then you must be able to change them using the File Manager. If not - change hosting companies.

 

You can use this fix, but it's not ideal:

 

1. Create a new text document on your PC and rename it to chmod.php (ignore the warning about changing the file type).

 

2. Put this code in it and upload it to where your website is via FTP:

<?php
chmod ("includes/configure.php", 0444);
?>

 

3. Now go to www.yourdomain.com/chmod.php - you won't see anything on the screen but the permissions will have chnaged.

 

4. Delete the file after use.

 

Vger

Share this post


Link to post
Share on other sites

ok ive done that but the blank screen has now taken the place of the index.php page and mysite.com/index.php is now a blank page

 

how do i fix it?

 

thanks alot for the help by the way =]

Share this post


Link to post
Share on other sites

Hi

 

OK, I have downloaded everything but I appear to be having problems with PHP and mySQL as I can’t get past the http://localhost/www.myrc.com/catalog/install/install.php first page. Apologies for posting – I searched the forums for hours but could not find my answers. I am sure they are out there. Apologies also for such a long post.

 

I have installed Apache 2.2 and PHP 5.2. This went well and I can now run PHP script web pages from my own PC (via http://localhost/mytestwebsite/phptest.php). I also installed mySQL 5.1.23. Following the osCommerce installation guide (update 051112), it stated to create my own database and user. I tried to using phpMydmin – but couldn’t get to tool to work properly. I did read the forums and Vger suggested in a post to “Create a blank database via your web hosting control panel”. But I was not sure how to do this – incidentally is this web hosting control panel under windows Control panel or is it part of my ISP’s web tools ???

 

In frustration I downloaded the eBook “Building Online Stores with osCommerce-Professional Edition, 2005.pdf”. It showed me how to create a user but using mySQL 4.0. So I uninstalled mySQL 5.0, and installed mySQL 4.0 and then created a user using the command> mysql> insert into user values (‘localhost’ , ’oscommerce’ , ’mypwd’ ,’Y’ ,’Y’ …. Etc). I had to use mySQL 4.0 because the all the Ys and Ns are for grant or deny certain privileges and mySQL 5.0 gave an error so there must be additional or less settings between the two versions.

 

Now I think I have created a database because using a tool I can connect to a database called mysql and view table data. I see the following tables [columns_priv], [db], [func] etc, however they are grayed out showing me I cannot select them.

 

Anyway following the eBook – I tried to run a simple PHP script which would connect to mysql database but it returned an erorr – see code below

 

<?php

$conn = mysql_connect("localhost", "oscommerce", "mypwd");

$result = mysql_list_dbs($conn);

while($db_data = mysql_fetch_row($result)) {

echo "<b> $db_data[0]</b><br>";

}

?>

 

Question – could I have used $conn = mysql_connect("localhost", "root", "my_root_pwd");

 

I read the PHP 5.x manual and it had the following PHP 5 no longer bundles MySQL client libraries, what does this mean to me? Can I still use MySQL with PHP? I try to use MySQL and get "function undefined" errors, what gives?

 

Good…., problem is it calls for php_mysql.dll, which I don’t see on my system anywhere. Under the PHP directory I don’t even have a \ext or \includes directory.

 

What should I do ?

Share this post


Link to post
Share on other sites

This thread provides support for people installing osCommerce. I do not provide support for people trying to set up their own web server, which is a specialised field.

 

Vger

Share this post


Link to post
Share on other sites

is that a responce to my question? or the one below mine? if it is mine could you please point me in the right direction to fixing the problem? =]

Share this post


Link to post
Share on other sites
ok ive done that but the blank screen has now taken the place of the index.php page and mysite.com/index.php is now a blank page

 

I think you get to a point where you have to accept that either your hosting company is not suitable for hosting osCommerce, or else you're not up to installing it on your own. I think we've reached that point.

 

You need a hosting company which is suitable for hosting osCommerce and who will install it for you.

 

Vger

Share this post


Link to post
Share on other sites

ok fair enough, but would you be able to explain to me what the chmod() did so i can atemp to fix it myself? as it has stoped me being able to see the home page

Share this post


Link to post
Share on other sites

chmod changes the file permissions. It is a Unix/Linux command which won't work on Windows servers (for Windows servers you have to use File Manager in the Web Hosting control panel).

 

Changing the permissions on the includes/configure.php file should not prevent you from viewing the homepage, but you can use the file again if you like - but try changing the 0400 to 0644 in the file.

 

Vger

Share this post


Link to post
Share on other sites

Hi

 

Although this is probably the wrong spot to post, I found my answer to post #2014 above and just in case someone else wanted to know what i did here it is.

 

I restored my PC to the start of the week, whcih is before I started installing all these apps. I then downloaded PHPtriad 2.2 which contains all 3 software components (Apache / PHP / mySQL) required for development and hence deployment. HTH someone :).

 

Sir Lance

Share this post


Link to post
Share on other sites
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

Man help me out here... You sound like you know the step by step. I have followed carefully but still when I click configure.php file, it opens a PDF fine and DOES NOT show where to change the 777

Share this post


Link to post
Share on other sites

Why would it open a pdf file when you click on configure.php?

 

Vger

Share this post


Link to post
Share on other sites

Hi, I just uploaded osCommerce to my hosting account.. and when I get to the Database Server part of the installation, I enter the correct Hostname, username, and password for the SQLServer I created (I also tried the same thing with MySQL Database I created) but I get the following error when I try to connect & continue:

 

when I use the SQLServer login I get this error:

There was a problem connecting to the database server. The following error had occured:

 

Can't connect to MySQL server on 'p3swhsql-v18.shr.phx3.secureserver.net' (10061)

 

Please verify the connection parameters and try again.

 

when I try the MySQL Database I get this error:

There was a problem connecting to the database server. The following error had occured:

 

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

 

Please verify the connection parameters and try again.

 

 

Can you guys please tell me how to solve this? I am really excited to install osCommerce.

 

Thank you very much for your help! I really appreciate it.

Share this post


Link to post
Share on other sites
Can't connect to MySQL server on 'p3swhsql-v18.shr.phx3.secureserver.net' (10061)

 

This is almost certainly wrong. It should read something like "Can't connect to server on root@localhost, using Password YES". See below:

 

http://dev.mysql.com/doc/refman/5.0/en/can...-to-server.html

 

For the other error:

 

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

 

These aren't osCommerce installation problems - they're problems related to setting up your server correctly.

 

Vger

Share this post


Link to post
Share on other sites

Please anyone help. On installation, I have the following errors:

 

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'cebxwird'@'localhost' (using password: NO) in /home/cebxwird/public_html/catalog/install/includes/functions/database.php on line 29

 

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/cebxwird/public_html/catalog/install/includes/functions/database.php on line 29

 

AND

 

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

Unable to connect to database server!

Share this post


Link to post
Share on other sites

×