Baptism of fire... newbie installation probs

[Brocksburn]

I'm new to osCommerce - VERY new - so consider yourselves warned!

 

I managed to install everything, with much reference to the wiki docs which I found really helpful. The installation process reported the test database connection was successful, but when I browse to mydomain.co.uk/catalog/ as per the instructions, I get the following message:

 

Warning: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/vhosts/mydomain.co.uk/httpdocs/catalog/includes/functions/database.php on line 19

 

Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/vhosts/mydomain.co.uk/httpdocs/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

I named my database server as "localhost" and created a username and password, but "apache" wasn't the name I chose. I've tried creating a user called "apache" but that doesn't help.

 

I've obviously cocked something up during the installation, but I've no idea what, so I'm throwing myself on the mercy of the osCommerce community for help. (Can you tell I haven't got a clue what I'm doing?)

 

Cheers!

[decok]

Can you copy your config.php here so I can check something

[Brocksburn]

OK, do you want the configure.php from /admin or configuration.php from /includes?

 

I'm a complete noob here!

 

Cheers,

Ellie

[decok]

catalog/includes/configure.php

[Brocksburn]

Here it is, (osCommerce header snipped)

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

  define('HTTP_SERVER', ''); // eg, http://localhost - should not be empty for productive servers

  define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers

  define('ENABLE_SSL', false); // secure webserver for checkout procedure?

  define('HTTP_COOKIE_DOMAIN', '');

  define('HTTPS_COOKIE_DOMAIN', '');

  define('HTTP_COOKIE_PATH', '');

  define('HTTPS_COOKIE_PATH', '');

  define('DIR_WS_HTTP_CATALOG', '');

  define('DIR_WS_HTTPS_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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));

  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

  define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

// define our database connection

  define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers

  define('DB_SERVER_USERNAME', '');

  define('DB_SERVER_PASSWORD', '');

  define('DB_DATABASE', 'osCommerce');

  define('USE_PCONNECT', 'false'); // use persistent connections?

  define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

?>

 

Cheers,

Ellie

[Brocksburn]

Panic over, chaps - after decok asked to see the configure.php file I compared mine with another that had been posted to the board and realised that it seemed to be defining an awful lot of nulls... put in the appropriate values for my setup and bingo!

 

Now I'm off to see what else I can screw up before dinner time...

 

:D

 

Thanks all,

Ellie