Database Server Name

[darlanne]

I'm not new to filling out the information in the configure.php file, so I know what to put, and I know how to add the user, add database, then add user to the database, but I can't seem to get past the second installation screen on this one.

 

// define our database connection

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

define('DB_SERVER_USERNAME', 'aperfume_admin');

define('DB_SERVER_PASSWORD', 'xxxxx');

define('DB_DATABASE', 'aperfume_osc');

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

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

?>

 

That's what I'm also filling out in the fields on the installation screen but I am getting, no matter how I mess with it (tried taking out the prefixes, etc) ... I still get:

 

Access denied for user: 'aperfume_admin@localhost' (Using password: YES)

 

Am I missing something just so obvious that it's right under my nose?

 

I emailed my host and they verified that the correct name should be "localhost" ... and yet I somewhat recall this problem before with another installation on another site, same host ... and now I can't recall if it had to do with the prefixes, or if I used something different than localhost.

 

PULLING my hair out :blink:

[darlanne]

This is my admin config

 

// Define the webserver and path parameters

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

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

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

define('HTTP_CATALOG_SERVER', 'http://aperfume.com/store');

define('HTTPS_CATALOG_SERVER', '');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home/aperfume/public_html/store'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/store/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/home/aperfume/public_html/store/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/store/'); // absolute path required

define('DIR_FS_CATALOG', '/home/aperfume/public_html/store/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

define('DIR_FS_CATALOG_MAINPAGE_MODULES', DIR_FS_CATALOG_MODULES . 'mainpage_modules/');

define('DIR_WS_TEMPLATES', DIR_WS_CATALOG . 'templates/');

define('DIR_FS_TEMPLATES', DIR_FS_CATALOG . 'templates/');

// define our database connection

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

define('DB_SERVER_USERNAME', 'aperfume_admin');

define('DB_SERVER_PASSWORD', 'xxxxxx');

define('DB_DATABASE', 'aperfume_osc');

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

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

?>

 

 

 

 

This is my main config

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://aperfume.com'); // 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', true); // 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/');

 

//Added for BTS1.0

define('DIR_WS_TEMPLATES', 'templates/');

define('DIR_WS_CONTENT', DIR_WS_TEMPLATES . 'content/');

define('DIR_WS_JAVASCRIPT', DIR_WS_INCLUDES . 'javascript/');

//End BTS1.0

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '');

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

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

 

// define our database connection

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

define('DB_SERVER_USERNAME', 'aperfume_admin');

define('DB_SERVER_PASSWORD', 'xxxxxx');

define('DB_DATABASE', 'aperfume_osc');

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

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

?>

 

 

For the life of me I can't see what I'm doing wrong, though obviously something. OH and this is a loaded version of OSC, should mention that.

[Brando]

ok....so you know how to create a database user as told up above....but are you absolutely sure you assigned the user to the database name you are using?

I know I did that one time... :rolleyes:

[darlanne]

Yep, and I even, just to be certain, deleted and re-added the user.

 

Totally scratching my head at this point.

 

Should I just have "localhost" in all references at the top of each config file? Although I think I tried that too :unsure:

[darlanne]

Just wanted to update, that there appears to be a domain pointing conflict, and an error with the registrar.

 

So I wasn't NUTS afterall :D

[Guest]

Try this, I think I got it all but don't count on it;

-> indictates change

 

 

This is my admin config

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://aperfume.com'); // eg, http://localhost - should

not be empty for productive servers

-> define('HTTP_CATALOG_SERVER', '/');

define('HTTPS_CATALOG_SERVER', '');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home/aperfume/public_html/store'); //

where the pages are located on the server

define('DIR_WS_ADMIN', '/store/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/home/aperfume/public_html/store/admin/'); //

absolute pate required

-> define('DIR_WS_CATALOG', 'store/'); // absolute path required

define('DIR_FS_CATALOG', '/home/aperfume/public_html/store/'); // absolute

path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

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_CATALOG_LANGUAGES',

DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES',

DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

define('DIR_FS_CATALOG_MAINPAGE_MODULES',

DIR_FS_CATALOG_MODULES . 'mainpage_modules/');

define('DIR_WS_TEMPLATES', DIR_WS_CATALOG . 'templates/');

define('DIR_FS_TEMPLATES', DIR_FS_CATALOG . 'templates/');

// define our database connection

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

productive servers

define('DB_SERVER_USERNAME', 'aperfume_admin');

define('DB_SERVER_PASSWORD', 'xxxxxx');

define('DB_DATABASE', 'aperfume_osc');

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

-> define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or

set to 'mysql'

?>

 

 

 

This is my main config

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://aperfume.com'); // 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', 'www.aperfume.com');

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/');

 

//Added for BTS1.0

define('DIR_WS_TEMPLATES', 'templates/');

define('DIR_WS_CONTENT', DIR_WS_TEMPLATES . 'content/');

define('DIR_WS_JAVASCRIPT', DIR_WS_INCLUDES . 'javascript/');

//End BTS1.0

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

->define('DIR_FS_CATALOG', '/home/aperfum/public_html/');

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

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

 

// define our database connection

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

productive servers

define('DB_SERVER_USERNAME', 'aperfume_admin');

define('DB_SERVER_PASSWORD', 'xxxxxx');

define('DB_DATABASE', 'aperfume_osc');

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

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

to 'mysql'

?>

[241]

this is how the configure.php files need to be

 

ADMIN

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://aperfume.com');
define('HTTP_CATALOG_SERVER', 'http://aperfume.com');
define('HTTPS_CATALOG_SERVER', '');
define('ENABLE_SSL_CATALOG', 'false');
define('DIR_FS_DOCUMENT_ROOT', '/home/aperfume/public_html/store/');
define('DIR_WS_ADMIN', '/store/admin/');
define('DIR_FS_ADMIN', '/home/aperfume/public_html/store/admin/');
define('DIR_WS_CATALOG', '/store/');
define('DIR_FS_CATALOG', '/home/aperfume/public_html/store');
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_CATALOG_MAINPAGE_MODULES', DIR_FS_CATALOG_MODULES . 'mainpage_modules/');
define('DIR_WS_TEMPLATES', DIR_WS_CATALOG . 'templates/');
define('DIR_FS_TEMPLATES', DIR_FS_CATALOG . 'templates/');
// define our database connection
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'aperfume_admin');
define('DB_SERVER_PASSWORD', 'xxxxxx');
define('DB_DATABASE', 'aperfume_osc');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'mysql');
?>

 

CATALOG

 

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://aperfume.com');
define('HTTPS_SERVER', '');
define('ENABLE_SSL', true);
define('HTTP_COOKIE_DOMAIN', '/store/');
define('HTTPS_COOKIE_DOMAIN', '');
define('HTTP_COOKIE_PATH', '/store/');
define('HTTPS_COOKIE_PATH', '');
define('DIR_WS_HTTP_CATALOG', '/store/');
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/');

//Added for BTS1.0
define('DIR_WS_TEMPLATES', 'templates/');
define('DIR_WS_CONTENT', DIR_WS_TEMPLATES . 'content/');
define('DIR_WS_JAVASCRIPT', DIR_WS_INCLUDES . 'javascript/');
//End BTS1.0

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
define('DIR_FS_CATALOG', '/home/aperfume/public_html/store/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'aperfume_admin');
define('DB_SERVER_PASSWORD', 'xxxxxx');
define('DB_DATABASE', 'aperfume_osc');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'mysql');
?>

as for the database make sure that the password is spelt correct and the username you should be able to determine the database server name and info from either your cpanel if that is what you have or through phpMyAdmin

[darlanne]

wow I'm grateful this is here, since I was wrong about it being a domain problem (tried to install on another domain, same problem).

 

Thank you! I'll give this a go :D

[darlanne]

It worked! Thank you SOOOO much :D

[Guest]

Hi! I think that this is what I am looking for to fix some of the problems that I am having. I see there are two config files that are being altered: Admiin and Catalog. What directories are these in?

 

I can find the config.php off the root directory.... is this 'admin'? I can also find 'configuration' in the modules/catalog_admin folder... is this 'catalog'?

 

Please let me know. I have also been having trouble setting the default language to english, thus the currency keeps coming up wrong as well.

 

Is there more installation documentation? I really don't mind reading before posting...