htaccess file and installing first section

[Guest]

Hello all, I hope I can be of great help to anyone once I get going. Anyways my name is Matt and I am very knowledgable when it comes to computers but i am new to this php stuff.

 

This is what I have:

 

I have a webserver through 1 and 1.com

I have registered an additional website under this server

 

my main server is for example: [email protected]

 

my additional website is within the root directory above and is /LWS

 

so when i type my web address it goes directly into the LWS directory and would traditionally look for index.htm this website is the one I want to setup OsCommerce on.

 

This is what I have done:

 

I copied the entire contents (not the directory folder though) of the catalog directory to both [email protected] directory and also to /LWS directory because I wasnt sure where it should go. I went into both directories and found the configure.php and right clicked and made it read/write/execute (777)

 

I then went and type my web address followed by install and it brought me to the

first webpage for configuring the online store.

 

I inputted my database server as [email protected]

 

I inputted my userename and password

 

I then made up a name for my database as lwsdat (should i do this?)

 

I left the box empty for persistent connections.

 

And for session storage I chose database.

 

The error I receive when I choose NEXT is as follows:

 

Lost connection to MySQL server during query

 

Any help would be GREATLY appreciated!

 

Take Care!

 

Matt

[♥Vger]

You have to create a database before you can start the install. You'll do this via your web hosting control panel.

 

Vger

[Guest]

You have to create a database before you can start the install.  You'll do this via your web hosting control panel.

 

Vger

<{POST_SNAPBACK}>

 

I have gone to my control panel from my webhost and found no option to create a database. Is it possible the database is already on my server somewhere?

[AlanR]

You're not looking hard enough.

 

It's in the 1&1 Control Panel

 

My Account->Package Administration->Applications

 

Then ->MySQL Administration

 

They name the db and give you an initial password.

 

(Oh, this too, you'll need the 1&1 ssl fix for application_top.php or you'll never get ssl working right.)

[♥Vger]

Agh! Silly me. Didn't realise that 1and1.com was the same outfit as 1and1.co.uk - should have guessed.

 

Vger

[Guest]

You're not looking hard enough.

 

It's in the 1&1 Control Panel

 

My Account->Package Administration->Applications

 

Then ->MySQL Administration

 

They name the db and give you an initial password.

 

(Oh, this too, you'll need the 1&1 ssl fix for application_top.php or you'll never get ssl working right.)

<{POST_SNAPBACK}>

 

Thank you very much , everything is working fine now. As for the 1&1 fix for the php, where would i find this?

 

Again Thank you!

 

Matt

[♥Vger]

Just do a Search using "1and1" (with the double quotes) and you'll hit on the threads that deal with this.

 

Vger

[Guest]

Just do a Search using "1and1" (with the double quotes) and you'll hit on the threads that deal with this.

 

Vger

<{POST_SNAPBACK}>

 

 

lol, the only two messages that came up were from you in this thread.

[AlanR]

Thank you very much , everything is working fine now. As for the 1&1 fix for the php, where would i find this?

 

Again Thank you!

 

Matt

<{POST_SNAPBACK}>

 

In catalog/includes/application_top.php, line 41

 

find:

 

// set the type of request (secure or not)

$request_type = (getenv('HTTPS') == 'on') ? 'SSL' : 'NONSSL';

 

change to:

 

// set the type of request (secure or not)

// $request_type = (getenv('HTTPS') == 'on') ? 'SSL' : 'NONSSL';

$request_type = (eregi ($HTTP_HOST, HTTPS_SERVER)) ? 'SSL' : 'NONSSL';

[AlanR]

Let me revise that last post. I was double checking the sites and the first solution works fine for shared ssl but with dedicated ssl (free with some 1&1 accounts now) that fix results in all files being pulled from the ssl side. That's because the test always results in true (the $HTTP_HOST string is always found in the defined HTTPS_SERVER string)

 

So revise as follows:

 

In catalog/includes/application_top.php, line 41

 

find:

 

// set the type of request (secure or not)

$request_type = (getenv('HTTPS') == 'on') ? 'SSL' : 'NONSSL';

 

change to:

 

// set the type of request (secure or not)

// $request_type = (getenv('HTTPS') == 'on') ? 'SSL' : 'NONSSL';

$request_type = (getenv('HTTPS') == '1') ? 'SSL' : 'NONSSL';

 

Thats a very simple change (The previous fix should still be used for shared ssl).

 

The thread which covers this best is here:

 

http://www.oscommerce.com/forums/index.php?sho...ndpost&p=508060

<{POST_SNAPBACK}>