Unable to connect to database server, AFTER trying to add "www." to my site

[Redhead_Elf]

Hi!

 

this is quite the emergency seen as I completely lost my site for an hour so far !

 

I had tried to add "www.mysite.com" instead of "http\\mysite.com"

 

I looked on forums and it said to change the configure.php files. the moment I did I recieved this error :

 

"Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nobody'@'localhost' (using password: NO)

 

in /home/mysite/public_html/catalog/includes/functions/database.php on line 19

 

Unable to connect to database server!" :( :(

 

PLEASE PLEASE HELP ! :(

 

I had copied back to my server the same files exactly as they were before I changed them, and it's no turning back situation !

 

I don't know what to do and my hair is changing to white !

 

thanks so much in advance!

 

Red.

[Bloged]

Did you remove the configure.php files? Or did you move or rename them?

 

Grtz,

 

Arjan Gelderblom

[Redhead_Elf]

Did you remove the configure.php files? Or did you move or rename them?

 

Grtz,

 

Arjan Gelderblom

 

No ! I had changed the configure.php files in catalog/includes. and once I recieved the error, I immiadtly "control z" :) all the way back to the way it was.

uploaded the file back.

 

and the error remaind. :(

 

(thank you so much for the reply by the way - sorry, i'm in panic)

[Bloged]

No ! I had changed the configure.php files in catalog/includes. and once I recieved the error, I immiadtly "control z" :) all the way back to the way it was.

uploaded the file back.

 

and the error remaind. :(

 

(thank you so much for the reply by the way - sorry, i'm in panic)

 

Ok no need to panic...

 

If you could post the content of the configure.php file here (be sure to remove login and passwords from it!)

 

Grtz,

 

Arjan Gelderblom

[Redhead_Elf]

Ok no need to panic...

 

If you could post the content of the configure.php file here (be sure to remove login and passwords from it!)

 

Grtz,

 

Arjan Gelderblom

 

thats the thing ! oddly, It was never filled ! and the site was working great !

 

here goes

 

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

?>

 

Thank YOu !!!

 

p.s when I did filled the information it had some basic information of the site on (no images, no inner catagoires url working, and the styles. it mainly looked like some few blue hyperlinks the wont work

[Bloged]

Thank YOu !!!

 

p.s when I did filled the information it had some basic information of the site on (no images, no inner catagoires url working, and the styles. it mainly looked like some few blue hyperlinks the wont work

 

<?php
// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://localhost'); // 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', 'http://localhost'); // 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'
?>

 

Look for the <?php I added on the first line... if that ones gone in your configure.php add it and test it again!

 

Here some more explanation to get you started:

define('HTTP_SERVER', 'http://localhost'); Better to replace the bold with your website address like http://www.yoursite.com

 

define('DIR_WS_HTTP_CATALOG', './'); Here your path to the root directory should be... When you login into your FTP you probably see something like /home/<name/httpdir/www/public_html copy and paste that directory into between the accolades!

 

define('DB_SERVER', 'http://localhost'); Probably this would work (when password and login are set) if you have an external DB-server this should be it's address!

 

Grtz,

 

Arjan Gelderblom

[Redhead_Elf]

<?php
// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://localhost'); // 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', 'http://localhost'); // 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'
?>

 

Look for the <?php I added on the first line... if that ones gone in your configure.php add it and test it again!

 

Here some more explanation to get you started:

define('HTTP_SERVER', 'http://localhost'); Better to replace the bold with your website address like http://www.yoursite.com

 

define('DIR_WS_HTTP_CATALOG', './'); Here your path to the root directory should be... When you login into your FTP you probably see something like /home/<name/httpdir/www/public_html copy and paste that directory into between the accolades!

 

define('DB_SERVER', 'http://localhost'); Probably this would work (when password and login are set) if you have an external DB-server this should be it's address!

 

Grtz,

 

 

I did as you said, and still got an error.

 

I tried adding several different informations in the database requests, just to try it all and see what works.

 

none helps.

 

I can't help but wonder how is it that it worked before, when the configuration was as I copied :S

 

when I initaly installed oscommerce, I had fillied this information... but it was never in this file.

 

is there another possible place or way to fix this?

 

can I change something within my SQL or that has nothing to do with it? :S

 

Thanks again :)

Arjan Gelderblom

[Redhead_Elf]

OMG !!!!!!!!!!

 

O MY GOD O MY GOD !

 

it works it works!

 

heres what i did

 

 

// Define the webserver and path parameters

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

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

define('HTTP_SERVER', 'http://MY SITE.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', '');

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', '');

define('HTTPS_COOKIE_PATH', '');

define('DIR_WS_HTTP_CATALOG', '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', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'MY USER');

define('DB_SERVER_PASSWORD', 'MY PASS');

define('DB_DATABASE', 'MY INFO');

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

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

?>

 

 

THANK YOU AGAIN SO SO SO MUCH !!!

 

hey, lol, how the hell do I change it to www.mysite.com then?!

 

:D

[Bloged]

OMG !!!!!!!!!!

 

O MY GOD O MY GOD !

 

it works it works!

 

THANK YOU AGAIN SO SO SO MUCH !!!

 

hey, lol, how the hell do I change it to www.mysite.com then?!

 

:D

 

Change:

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

To

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

 

Grtz,

 

Arjan Gelderblom