Oscommerce Config Files

[vikkic]

Brand new to TotalChoice.

I ftp'd all my files over, had Tech Support upload my database dump. Now I'm configuring the Oscommerce config files, but got stuck.

 

3 questions

1. I of course don't know my server# yet, but the https: otherwise would be as noted?

define('HTTPS_CATALOG_SERVER', 'https://server*.totalchoicehosting.com/~keksehxi/');

 

and 2. What is my local path to my document files? This is from my old server and obviously not correct here. I searched everywhere but didn't find an answer - and I know it can't be this hard!!!!

define('DIR_FS_DOCUMENT_ROOT', '/hsphere/local/home/vikkic/hand-dyedfibers.com');

// where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you,

replace with your local path. (eg, /usr/local/apache/htdocs)

 

Lastly - is this my database connection? (of course I xxx'd out the username and password).

// define our database connection

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'keksehxi_XXXXXX');

define('DB_SERVER_PASSWORD', 'XXXXX');

define('DB_DATABASE', 'keksehxi_XXXXXXXX');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

VikkiC

 

 

Edit TCH-Rob: Removed DB name for your protection.

Edited May 23, 2004 by TCH-Rob

[TCH-Rob]

Brand new to TotalChoice.

I ftp'd all my files over, had Tech Support upload my database dump. Now I'm configuring the Oscommerce config files, but got stuck.

Welcome

 

3 questions

1. I of course don't know my server# yet, but the https: otherwise would be as noted?

define('HTTPS_CATALOG_SERVER', 'https://server*.totalchoicehosting.com/~keksehxi/');

 

Yes, and your server number should have been included in your welcome letter.

 

and 2. What is my local path to my document files? This is from my old server and obviously not correct here. I searched everywhere but didn't find an answer - and I know it can't be this hard!!!!

define('DIR_FS_DOCUMENT_ROOT', '/hsphere/local/home/vikkic/hand-dyedfibers.com');

// where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you,

replace with your local path. (eg, /usr/local/apache/htdocs)

I cant check now from behind our firewall at work but if I remember it is home/cPanelname/public_html/file.ext

 

Lastly - is this my database connection? (of course I xxx'd out the username and password).

// define our database connection

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'keksehxi_UserName');

define('DB_SERVER_PASSWORD', 'XXXXX');

define('DB_DATABASE', 'keksehxi_DBName');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

Looks good from here.

[vikkic]

>Yes, and your server number should have been included in your welcome letter.

 

No - and it isn't in my cpanel yet nor does it show up yet when I use the Find Your Server tool. But hopefully later today!!!

 

 

>home/cPanelname/public_html/file.ext

 

home/cpanel_keksehxi/public_html? It doesn't need a file extension, as it just wants the root path.

 

VikkiC

[TCH-Rob]

No - and it isn't in my cpanel yet nor does it show up yet when I use the Find Your Server tool. But hopefully later today!!!

Did your welcome letter include an IP address?

 

home/cpanel_keksehxi/public_html? It doesn't need a file extension, as it just wants the root path

 

home/keksehxi/public_html

[vikkic]

> Did your welcome letter include an IP address?

 

Yes - still not found on the server finder - but tech support was great and whipped it right out to me this morning!!!

 

Still having a problem connecting to the databse - I'm not sure it likes localhost.

 

Thanks TCH Rob!

 

Vikki

[TCH-Rob]

This is from my config file;

 

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

 

This works on my site.

[vikkic]

I'll write this here just in case it helps someone else - but I'm new to CPanel and that's actually where my error was.

When you add a user, and add a database, you then have to ADD the user TO that database!!!

 

I did do it right finally - but mostly by accident.

Once my site is set up though there's almost nothing I ever have to do on the server again!!! (THANKHEAVENS!).

 

And it's up and running and I'm really pealsed with the incredible level of customer service that I got.

 

Vikki

[TCH-Rob]

YAY!

 

I am glad you got it going. I forgot all about checking to see if you added the user.

 

Good job. Thumbs Up