Problem moving files

[TreasureBin]

Hi

Sorry for the following long-winded explanation but I'm not sure what the problem is so want to give the full background.

I switched web hosts and starting using OSCommerce to redesign my website. I started with a few stores but wasn't happy with the overall look so decided to move everything into one store and set up different categories.
When I went to set up the root store, my admin panel went straight to OSC Max 2.02.
Love the look of it, much easier to set up, all looked well. I uploaded a few products into different categories and everything still looked good.
I went to the hosting admin panel to point the landing page to the catalog directory and that seemed fine as regards products, shopping, etc. but I no longer had access to admin.
So I changed the landing page back again and decided to move all the files from the catalog directory to the root directory, using FTP. I changed the two Configure files and the appadmin file (removing the word Catalog) but now I get the following error message for any page I go to (shopping, admin, etc):
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'u70713165'@'cgihost' (using password: YES) in /mnt/w0809/d20/s40/b02dbbb7/www/treasure-bin.com/includes/functions/database.php on line 19
Unable to connect to database server!

I couldn't get this working, so I restored all the original files back into the Catalog directory. I even took a screenshot before I started, and everything looks identical in the FTP screen now (everything in the original directories, all original version files with correct dates) but I'm still getting the same error message.
I don't know if I need to change something in the database file, or a different file. Or is it some kind of compatability problem between the OSCommerce and OSCMax directories? (I left the OSCommerce directories for my stores where they were.)

Or do I need to delete everything and reinstall? Not even sure I'll be able to do that as it was originally installed through my web host's admin panel - which I can no longer access either.

HELP!

[michael_s]

That error means that the database credentials in your /includes/configure.php file are wrong for the database you are trying to connect to.

[TreasureBin]

Thanks for the reply Michael but I can't see the error. The following is my /includes/configure file (I've replaced part of my password for security):

<?php
define('HTTP_SERVER', 'http://treasure-bin.com');
define('HTTPS_SERVER', 'https://treasure-bin.sslpowered.com/treasure-bin.com/');
define('ENABLE_SSL', 'TRUE');
define('HTTP_COOKIE_DOMAIN', 'treasure-bin.com');
define('HTTPS_COOKIE_DOMAIN', 'treasure-bin.sslpowered.com/treasure-bin.com/');
define('HTTP_COOKIE_PATH', '/treasure-bin.com/');
define('HTTPS_COOKIE_PATH', '/treasure-bin.sslpowered.com/treasure-bin.com/');
define('DIR_WS_HTTP_CATALOG', '/');
define('DIR_WS_HTTPS_CATALOG', '/');
define('DIR_WS_HTTPS_ADMIN', '/admin/');
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', '/mnt/w0809/d20/s40/b02dbbb7/www/treasure-bin.com/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

define('DB_SERVER', 'MYSQLHOST');
define('DB_SERVER_USERNAME', 'u70713165');
define('DB_SERVER_PASSWORD', '659***');
define('DB_DATABASE', 'd60645740');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'mysql');


Error message is: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'u70713165'@'cgihost' (using password: YES) in /mnt/w0809/d20/s40/b02dbbb7/www/treasure-bin.com/includes/functions/database.php on line 19
Unable to connect to database server!

As far as I can see, the user name and catalog reference is correct.

[ridexbuilder]

Looks like horrible Netfirms again.

General observation: your use of a trailing / is all over the place! [Netfirms defaults?]

user 'u70713165'@'cgihost'

appears to be the clue. ?

[TreasureBin]

You're absolutely right about Netfirms - and their support is worse than useless.
At least I can now access their admin panel again so I think I'll just have to delete all my files and reinstall.

[ridexbuilder]

You're absolutely right about Netfirms - and their support is worse than useless.
At least I can now access their admin panel again so I think I'll just have to delete all my files and reinstall.

Are you using the osCommerce Pro option (osCMax)?
How about doing a 'proper' install using the latest pre-release version from this site - see the Project Announcement?

You manually create your mySQL database, upload the files (usually to catalog) using ftp, then run the install.

EJ

[TreasureBin]

I started with OSCommerce but my problem arose after using OSCMax for creating my store in the root directory.
I'm totally new to trying to do my own website (but figured I couldn't do any worse than the previous designer!) so have to confess I never even heard of SQL before this.
I'm hoping that if I re-install, I will be able to transfer a few of my set-up files (shipping, etc.) with FTP so I'll keep copies of those on my computer and maybe eliminate a little extra work that way.