Installation File Configuration

[Guest]

Hello,

 

I have installed osCommerce and, using a Mac computer with Adobe GoLive, am attempting to use it.

 

I receive the following error:

The error message returned is:

 

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

 

I have placed files where I believe they are supposed to be. I believe the username, password and so forth retrieved from the creation of the database using WebsiteOS are valid and entered correctly into the HTML installation. However, I then found the instructions listed here:

 

Changing file permissions

The permission on the catalog/includes/configure.php file needs to be set to 777 by logging into your root server and running "chmod 777 configure.php".

 

If you do not have access to the root of your server you can use an ftp program such as www.smartftp.com. When using an ftp program to change the permissions navigate to that specific file, right-click on it, and there will be a chmod (or change attributes) listing which is where the permissions would be changed to 777 for the catalog/includes/configure.php files ... 777 = read/write/execute.

 

If these permissions are not set correctly you will get an error when installing telling you the permission setting on catalog/includes/configure.php is not set correctly.

 

However, I do not entirely understand them. If anyone could please assist in breaking down these instructions in a much more simple manner specific to GoLive, I would greatly appreciate it.

 

Basically, I am not sure how to change the file permissions in GoLive. Is there anything else I'm missing?

 

 

Thank you,

 

TimothyB

[natewlew]

I don't think that is a permissions problem? Can you login to your database (mysql or phpmyadmin) with the user and password that you input into the install?

[Guest]

I don't think that is a permissions problem? Can you login to your database (mysql or phpmyadmin) with the user and password that you input into the install?

 

 

If I use the Website OS used by Uniserve customers (Uniserve is hosting the website), then yes, the same info lets me access the database and use it. I've been digging through the forum and found this:

The missing configure.php files were NOT ON MY SERVER!!! They were on a different SSL server, accessed via ssl.hostname.com, NOT ftp.hostname.com..

 

That was the entire problem. The configuration files that needed to be updated were not within my primary file system. They were in a different filesystem on a different server entirely.

 

Perhaps this has something to do with the access problem. Unfortunately I do not know how to access the ssl server. I will have to consult with Uniserve.

 

Any other ideas you can give me on the subject would be appreciated.

 

 

Thanks,

 

TimothyB

[Guest]

I also use a Mac with AdobeGolive and osCommerce. It is almost funny because last Friday I messed all my osCommerce files up by setting the wrong permissions up in GoLive.

 

Hope to have it back running. I found your post searching on what the settings are supposed to be.

 

To your problem, I have been through it with a provider switch. I am now with Bluehost, which has an independent install setup with 'fantastico'. When I used it, I had a fine generic oscommerce program running.

 

However I already had a working cart with my old host. So I actually copied most of my old files with GoLive.

 

So first of all, if you have Golive access to your server the folder 'catalog' which is osCommerce. And as Nate pointed out your Host should provide you with access to the os database (mysql or phpmyadmin).

 

On my site the 'catalog' folder is just a fraction of the files in there. Connect to your server and if you see your 'catalog' folder you have a start.

 

Any file in there has permissions, if you highlight the file and look at you inspector panel on the right in the sub tab 'FTP Access' you can change permissions. Chances are the are already correct.

 

Your most important files are the two configure.php

one in catalog/includes/configure.php

the other in catalog/admin/includes/configure.php

 

These files will have to be set up with your site configurations and than you will have access.

 

But best talk to your host and have them put the folder in the right place.

 

Good Luck

Wolfgang

 

 

:thumbsup:

[Guest]

Thanks for the responses so far.

 

I've figured out how to change permissions in GoLive. Both config files have now been changed as far as I can see. All permissions are on.

 

I found a script:

 

<?php

// database_settings.php vers 1.0 by pyramids 09152006

// Will print out your database settings and report mysql errors

// Only reads the database it does not write to it

// Run from the shop root as www.mydomain.com/database_settings.php

 

if (!file_exists('includes/configure.php')) {echo "<font size=4>Can't find the <b>'includes/configure.php'</b> file. <b>NOTE: </b>This script 'database_settings.php' needs to run in the shop root like mydomain.com/database_settings.php or mydomain.com/shop/database_settings.php depending on your setup</font>";die();}

 

require ('includes/configure.php');// login info

 

echo 'My DB includes/configure.php is set to:<br><br>' .

'DB Name: ' . DB_DATABASE . '<br>' .

'DB Server: ' . DB_SERVER . '<br>' .

'DB UserName: ' . DB_SERVER_USERNAME . '<br><br>';

 

$conn = mysql_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD) or die(mysql_error());// connect to the DB

if ($conn){echo 'SUCCESS ->> Connected to DB server ' . DB_SERVER . "<br><br>";}

 

$select_db = mysql_select_db(DB_DATABASE, $conn) or die(mysql_error());// select the DB

if (mysql_select_db){echo 'SUCCESS ->> Selected the DB named ' . DB_DATABASE . "<br><br>";}

 

$sql = "SELECT startdate from counter limit 1";// read database

$result = mysql_query($sql, $conn) or die(mysql_error());

$more_info = mysql_fetch_array($result);

 

if ($more_info[0] && $conn){echo "SUCCESS ->> DB server is UP and we are able to read it<br><br>";}

 

?></p>

 

 

 

someone had posted that scrpt in this forum earlier for finding the config files and I installed it (I can't relocate the original post, but I think it checks for mysql errors). The script runs in php and comes back with:

 

 

My DB includes/configure.php is set to:

 

DB Name: osCommerce

DB Server:

DB UserName:

 

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

 

 

 

I'm still getting the install error on the first time osCommerce install tries to access the database:

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

 

Anyone know if the (Using password: YES) has any significance?

 

I've tried contacting my provider about the database, but the instant I mention osCommerce, they clam up and refuse to help, tell me its not their problem. Even if I just ask about server permissions. The Website OS they use lets me access the database just fine. Any idea whether or not that access would be prevented from outside sources, even with the right name and password?

 

Any other ideas?

 

 

Thanks,

 

Timothy

[natewlew]

That means the script is trying to use a password but it's not working. Maybe you should try to install another program like phpbb and see if it works?