Ipowerweb VDECK Installation Update

[JynMeyer]

This is for installation only, configuration is on your own unless you want to hire or pay someone to do it for you.

 

 

INSTRUCTIONS:

 

Start off by setting up a new database:

Go into your vdeck, into your database section, and install a new database.

Do this by naming it something like "yourdomainname_shoppingcart" and then adding a new user with a similar name such as "yourdomainname_db" and a password.

 

Hit back once and refresh the database page and hit "EDIT" next to your new database name.

Select the "Select all" option next to your user name "yourdomainname_db" to select all the options and then update. This makes it so that you have full permissions.

From here, open a new page so that you have the database names handy in case you forgot their specific names.

 

Installation:

Step 1.) download the new verision 2.2.m2 from here ( http://www.oscommerce.com/solutions/downloads ) and decompress the folder.

 

Step 2.) upload the file "catalog" to your root folder (http://www.your-domain-name.com/catalog)

 

Step 3.) go to the url http://www.your-domain-name.com/catalog/install and select "New install" when the prompt comes up. (do not select upgrade, even if you have a previous version you installed off of Vdeck. The upgrade is not compatable with the location of the old cart.)

 

Step 4.) Fill in the fields:

Database Server: localhost or (yourdomain.com)

Username: Your Database username

(The username used to connect to the database server. An example username is 'yourdomainname_db'. )

Password: Database password

Database Name: Database Name

(The database used to hold the data. An example database name is 'domainname_shoppingcart'. )

Persistent Connections: (do not check this)

Session Storage: ?select??'Database'??

 

Press continue.

 

You should get a message:

 

New Installation Database Import

A test connection made to the database was successful.

Please continue the installation process to execute the database import procedure.

It is important this procedure is not interrupted, otherwise the database may end up corrupt.

The file to import must be located and named at:

/home/yourdomainhere/public_html/catalog/install/oscommerce.sql

Press CONTINUE.

The OS commerce configuration should already be filled in, no need to change anything unless you would like to Enable SSL, then you would check that.

 

CHMOD PERMISSIONS:

The original OSCommerce Configuration page will come up again, just press continue again and you will recieve a notice:

The configuration files do not exist, or permission levels are not set.

Please perform the following actions:

cd /home/homefre/public_html/catalog/includes/ touch configure.php  chmod 706 configure.php

cd /home/homefre/public_html/catalog/admin/includes/ touch configure.php chmod 706 configure.php

 

You need to go into your file manager and find the catalog/includes/configure.php & the catalog/admin/includes/configure.php file and set permissions to 706 or 777.

Press continue, and then go back and reset these files to ?644? so they are not writeable. They only needed to be writeable for the installation.

You should see a successful installation page and then a page.

You will then have two options- To go to the Catalog or to the Administration panel. Your choice.

 

Note: Be sure to delete your /install folder out of your site and set the permissions in your images folder to ?777? so that you may upload images directly from your admin section.

 

Your cart will be at http://www.yourdomain.com/catalog and your admin will be at http://www.yourdomain.com/catalog/admin .

You must password protect your admin directory so that it is not accessable to others.

 

The installation instructions (general) and cart configuration instructions are here: http://wiki.oscommerce.com

The help forums and support are here: http://www.oscommerce.com/forums/

[JynMeyer]

For Windows or Linux Users, here is more information on the install.

http://www.oscommerce.com/forums/index.php?showtopic=90693

 

-Jyn

[Guest]

This was so helpful. Thanks a million for taking time to spell things out in normal English!

Kate

[Dr. Ephemeron]

If you want a better phpMyAdmin, it is easy to ftp the files to a directory and password protect it via vdeck too.

[hvacr]

Is it neccessary to install from scratch? I have a site all set up on my home computer running win2000 and mysql with php. Can I not just upload the files I have, install the database and then set the permissions?

[Dr. Ephemeron]

Is it neccessary to install from scratch?

 

NO

 

I have a site all set up on my home computer running win2000 and mysql with php. Can I not just upload the files I have, install the database and then set the permissions?

 

YES

[jdlev]

Wow.. that info would have been useful acouple of weeks ago.. Anyway, you didn't explain how to use ssl on ipowerweb. I am having a hard time. Have you been able to make it work properly. What are the steps?

[jpool]

Ok this info is very useful now, install no copy and reset permissions yes

 

sure, how do you use the ssl in ipowerweb? and the steps would come handy too here

Thanks

 

j.

[jdlev77]

Since my post, I have been able to get it to work perfectly through ipowerweb. SSl through ipowerwebs ssl shared server is simple but somewhat tedious. Ipowerweb sent you an email when you first set up an account with the ssl information )something like host#(#=host number in email).ipowerweb.com/~host. That is where you have to point socommerce to use ssl. If you have any problems, post your configure file without the username, password, and db name.

[shaitaan]

Hi there,

 

Thanks for taking the time to write up these instructions :)

 

I'm also using Ipowerweb, and they are notoriously unhelpful when it comes to osC. <_<

 

However, i'm running into a troubling problem. On the last page of installation, I receive these errors:

 

osCommerce Configuration

Warning: fopen(C:/Accounts/webgraph/catalog/includes/configure.php): failed to open stream: Permission denied in C:\Accounts\webgraph\catalog\install\templates\pages\install_7.php on line 209

Warning: fputs(): supplied argument is not a valid stream resource in C:\Accounts\webgraph\catalog\install\templates\pages\install_7.php on line 210

Warning: fclose(): supplied argument is not a valid stream resource in C:\Accounts\webgraph\catalog\install\templates\pages\install_7.php on line 211

Warning: fopen(C:/Accounts/webgraph/catalog/admin/includes/configure.php): failed to open stream: Permission denied in C:\Accounts\webgraph\catalog\install\templates\pages\install_7.php on line 259

Warning: fputs(): supplied argument is not a valid stream resource in C:\Accounts\webgraph\catalog\install\templates\pages\install_7.php on line 260

Warning: fclose(): supplied argument is not a valid stream resource in C:\Accounts\webgraph\catalog\install\templates\pages\install_7.php on line 261
The configuration was successful!

 

When i click on either "administration tool" or "catalog," I then get THIS error:

 

No input file specified.

 

 

could anyone please shed some light on this?

 

Thanks :)

[jpool]

I got the same error on a local install and it was a permissions problem, it looks like you are using windows (c:\.... )if so set the user I_USER_"name of computer here" or a very similar name to be able to modify too.

Cheers

j.

[shaitaan]

I got the same error on a local install and it was a permissions problem, it looks like you are using windows (c:\.... )if so set the user I_USER_"name of computer here" or a very similar name to be able to modify too.

Cheers

j.

Thank you Jodie;

 

yes, we're using a windows setup. (I have no idea why, but thats what our president requested.)

 

Where would I make those settings? would it be in configure.php?

 

thanks!

 

-Ash

[jpool]

Thanks for that jdlev77

[Acheron]

Thought these might be useful for some people starting out with osC on iPower. Here is what the content of your configure files should basically look like.

 

/catalog/includes/configure.php

 

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
 define('HTTP_SERVER', 'http://mysite.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://hostxxx.ipowerweb.com/~accountname'); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', true); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'mysite.com');
 define('HTTPS_COOKIE_DOMAIN', 'hostxxx.ipowerweb.com/~accountname');
 define('HTTP_COOKIE_PATH', '/catalog/');
 define('HTTPS_COOKIE_PATH', '/catalog/');
 define('DIR_WS_HTTP_CATALOG', '/catalog/');
 define('DIR_WS_HTTPS_CATALOG', '/catalog/');
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
 define('DIR_FS_CATALOG', '/home/accountname/public_html/catalog/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'accountname_dbuser');
 define('DB_SERVER_PASSWORD', 'dbpassword');
 define('DB_DATABASE', 'accountname_db');
 define('USE_PCONNECT', 'false'); // use persistent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

 

/catalog/admin/includes/configure.php

 

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
 define('HTTP_SERVER', 'http://mysite.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTP_CATALOG_SERVER', 'http://mysite.com');
 define('HTTPS_CATALOG_SERVER', '');
 define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
 define('DIR_FS_DOCUMENT_ROOT', '/home/accountname/public_html/catalog/'); // where the pages are located on the server
 define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required
 define('DIR_FS_ADMIN', '/home/accountname/public_html/catalog/admin/'); // absolute pate required
 define('DIR_WS_CATALOG', '/catalog/'); // absolute path required
 define('DIR_FS_CATALOG', '/home/accountname/public_html/catalog/'); // absolute path required
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_FLAGS', DIR_WS_IMAGES . 'flags/');
 define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
 define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
 define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
 define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

// define our database connection
 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'accountname_dbuser');
 define('DB_SERVER_PASSWORD', 'dbpassword');
 define('DB_DATABASE', 'accountname_db');
 define('USE_PCONNECT', 'false'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

[shaitaan]

Progress!

 

I had an ipowerweb tech support member manually change the permissions for me, since i was not able to do it myself.

 

 

The errors i received before are gone!

 

However, I still get a "no input file selected" error. What might this mean?

 

Thanks!

 

-Ash

[jdlev77]

Acheron - Thanks so much for the help on the admin configuration. That was driving me crazy.

[jpool]

ash good for the permissions,

can you be a littlle more specific about yr error?

 

j.

[Naughtica]

My issue is that I am not able to get the HTTPS links to work. I.E. Checkout, Create account, login, etc. When I try to go to them I receive a Page cannot be found error. Would someone please tell me what I am doing wrong!? Thank you in advance!

 

This is how I have my /catalog/includes/configure.php set up.

 

 

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
 define('HTTP_SERVER', 'http://mysite.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://hostXXX.ipowerweb.com'); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', true); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'mysite.com');
 define('HTTPS_COOKIE_DOMAIN', 'hostXXX.ipowerweb.com/~user');
 define('HTTP_COOKIE_PATH', '/catalog/');
 define('HTTPS_COOKIE_PATH', '/catalog/');
 define('DIR_WS_HTTP_CATALOG', '/catalog/');
 define('DIR_WS_HTTPS_CATALOG', '/catalog/');
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
 define('DIR_FS_CATALOG', '/home/user/public_html/catalog/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'X_db');
 define('DB_SERVER_PASSWORD', '***');
 define('DB_DATABASE', 'X_db');
 define('USE_PCONNECT', 'false'); // use persistent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

[icelos69]

i just install OSC through the vdeck controller system through applications->ecommerce->oscommerce

 

it gives a basic configuration which i then modify to make standard browsing non-ssl.

 

i just paid for the SSL server upgrade so I don't have to use that shoddy shared-ssl, but now everything is no longer functional. time to re-build it all from the ground up.

 

:blink: