Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

**install help**


joeabouata

Recommended Posts

I'm hung up on step 3

 

In IE I type in http://www.sonomaphoneman.com/catalog/install/ to install this free e-commerce store.

 

I'm importing the blank database I created, so the info I entered and the response I received:

 

 

Database Server: 100megs27.com

 

Username: "my database user name"

 

Passwd: "my database user name's passwd"

 

Database name: "my database's name"

 

 

I hit enter, and the page reads:

 

******

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Access denied for user: '[email protected]' (Using password: YES)

 

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.

 

 

heeellpp

 

****

Link to comment
Share on other sites

Database Server: 100megs27.com

 

whereas the error has megs27.100mwh.com so you need

 

Database Server: megs27.100mwh.com

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Thanks, I tried adding:

 

megs27.100mwh.com

 

 

I still received the same error message:

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

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Access denied for user: '[email protected]' (Using password: YES)

 

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.

Link to comment
Share on other sites

The db user password is usually not the same as your hosting access pw.

 

Check your controls, it wll tell you what the db user name is and will usually give you the option of changing the password.

 

Being on a Mac has nothing to do with it.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

I've been reading the documents in the Wiki site http://wiki.oscommerce.com/docsInstallNew and it seems to be saying that the mysql database doesn't come with this installation. Do we have to go somewhere else and get a database in order for this to work? I haven't seen that said anywhere. But, I am really new to this. Pardon me for bringing this up, but the instructions I got with the program are these:

 

"Once having downloaded the archive from the downloads page, follow these steps

to get the online shop running:

1. Extract the files from within the package

unzip oscommerce-2.2ms2.zip

-- or --

tar -xzf oscommerce-2.2ms2.tar.gz

-- or --

use your favourite graphical application to extract the files, such as

WinZip (http://www.winzip.com)

2. This creates a directory called 'oscommerce-2.2ms2'. Enter this directory

and copy the 'catalog' directory to the webroot path of your webserver:

cd oscommerce-2.2ms2

cp -R catalog /usr/local/apache/htdocs/

For this example, '/usr/local/apache/htdocs/' is used as the webroot path

of the Apache webserver.

Do the same for the 'admin' directory but rename the directory to a

unique and secret name. This directory does not have to reside inside the

catalog directory, though may need to be manually configured.

3. Using your favourite browser, go to the following address:

http://[your site]/catalog/install

and follow the instructions on the screen."

 

I understood this to mean I take the downloaded files and upload them into the public.html folder on my server. Then using my browser, find domainname.com/catalog/install...

 

Is there something implied in there that I missed?

Warmest regards and my sincere thanks to anyone who understands this stuff!

Link to comment
Share on other sites

There is a sample database included in the osc snapshot that when you run the install script will access mysql on your server and create the database tables required to work with oscommerce.

 

When you run the install script you will be required to provide information about your database server as well as your local or web server

"One Of Life's Greatest Pleasures Is Doing What Others Say You Can't"

Link to comment
Share on other sites

Is there something implied in there that I missed?

 

Warmest regards and my sincere thanks to anyone who understands this stuff!

Yep. :lol:

 

Your hosting account should include a mySQL account which is an account which will use the database server associated with your hosting account.

 

Asking if osC provides this is kinda like asking if osC comes with a web hosting account.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Hey Joe,

The first thing I learned is that you have to set up your database. I contacted my host and found how to set up the mysql database. You name it and choose your username and password. Unfortunately it didn't help at all, I still get the same error message as before:

 

"Can't connect to MySQL server on 'db1.godaddy.com' (111)"

Link to comment
Share on other sites

You're going to have to go into whatever control panel godaddy provides and find the correct information.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

I did! I managed to get it working - sort of...

 

These are the error messages I am now getting:

 

Warning: fopen(): open_basedir restriction in effect. File(/home/andallwest/public_html\includes/configure.php) is not within the allowed path(s): (/home/content/a/n/d/andallwest) in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 209

 

Warning: fopen(/home/andallwest/public_html\includes/configure.php): failed to open stream: Operation not permitted in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 209

 

Warning: fputs(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 210

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 211

 

Warning: fopen(): open_basedir restriction in effect. File(/home/andallwest/public_html\admin/includes/configure.php) is not within the allowed path(s): (/home/content/a/n/d/andallwest) in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 259

 

Warning: fopen(/home/andallwest/public_html\admin/includes/configure.php): failed to open stream: Operation not permitted in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 259

 

Warning: fputs(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 260

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 261

 

 

The configuration was successful!

Link to comment
Share on other sites

perhaps you should find your proper document root path.

 

place this into a file, name it test.php and put it into your root, ie would be called like this:

http://www.domain.com/test.php

 

<?php

phpinfo();

?>

 

Then search for the word 'document' you will find your document root how your host has it defined.

Link to comment
Share on other sites

I m new to this stuff and faced same problems when I was trying to install osC ... well here r some tips that may help u as i get installed my osC through this way...

 

try to used "localhost" instead of any server name

make databse base as little as u can like "dname_db"

dname="ur domain user name" db="database name"

 

before installation create a database, a user and asign database for that user.

use "MySQL Databases" option in ur cpanel to make a database...

Link to comment
Share on other sites

This is what you want from that page

 

DOCUMENT_ROOT /home/content/a/n/d/andallwest/html

 

so the corresponding line in /catalog/includes/configure.php

 

should be:

 

define('DIR_FS_CATALOG', '/home/content/a/n/d/andallwest/html/catalog/');

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

santefe, just so you know, i searched your php file, it does not have 'curl' installed, so you may have some problems with some payment modules. so before going to much more, you should check that portion, if you will need to use curl, then i suggest going to another host

Link to comment
Share on other sites

Hey Mibble, Thanks for the headsup. Where would you suggest? and What else do I need? And, dare I ask, is there a place that lists what we need to run this program?

 

Not to put too fine a point on it, but first I needed Mysql, now curl, what else....?

 

I have a suggestion for the docs folks.

 

Anyway, thanks again. I doubt I will ever be able to write any php, but I am deeply grateful for those of you who can help.

Link to comment
Share on other sites

it sounds like you should go back to the basics, and read the documentation on the software, as what you are asking is explained there.

also, go search the net for php tutorials, mysql tutorials.

 

what kind of server are you using? if apache, go to apache.org and read through how paths work, how to manage servers, etc.

Link to comment
Share on other sites

Change the permissions (chmod to 777 or rrr, www, eee) on the

 

catalog/includes/configure.php

catalog/admin/includes/configure.php

 

files with your ftp program and run the installer again.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Changed the permissions in both places. Got this message.

 

"Warning: fopen(/home/content/a/n/d/andallwest/html/catalog/admin/includes/configure.php): failed to open stream: No such file or directory in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 259

 

Warning: fputs(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 260

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 261

 

 

The configuration was successful!"

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...