Unable to connect to database server!

[ftcvictor33]

:huh: Hi sir,

This is my first time to use and install oscommerce,so I have a problem of installation.

I have finished install the system,but when I access my website to see the new on-line shop,it said "Unable to connect to database server!"

then I access the admin page (www.mydomain.com/admin),it also said "Unable to connect to database server!"

but when I install the system it said to me the Database Name server and Database Name and Database Login and Password are all right,the test connection is successful.

I do not know what is the problem? what can I do next?

waiting for your reply!thank you very much! :'( :(

[Guest]

:huh: Hi sir,

This is my first time to use and install oscommerce,so I have a problem of installation.

I have finished install the system,but when I access my website to see the new on-line shop,it said "Unable to connect to database server!"

then I access the admin page (www.mydomain.com/admin),it also said "Unable to connect to database server!"

but when I install the system it said to me the Database Name server and Database Name and Database Login and Password are all right,the test connection is successful.

I do not know what is the problem? what can I do next?

waiting for your reply!thank you very much! :'( :(

 

you'll have to view your connection strings in the config files located here :

/includes/configure.php

/admin/includes/configure.php

 

the database connection strings are at the bottom of this file(s)

 

Corrie

[ftcvictor33]

you'll have to view your connection strings in the config files located here :

/includes/configure.php

/admin/includes/configure.php

 

the database connection strings are at the bottom of this file(s)

 

Corrie

 

Hi sir,

Thanks for you reply.

 

This is the bottom code of configure.php.

 

********** configure.php code begin *************

 

// define our database connection

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

define('DB_SERVER_USERNAME', 'asdjksadj');

define('DB_SERVER_PASSWORD', 'sdsd2892893');

define('DB_DATABASE', 'database1212');

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

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

?>

********************* code end *********************************

 

I have checked all the information of my mysql database,they are all right.And I can see the database,there are many new tables are created when I install the system.this is the list of them:

 

database1212 (46)

address_book

address_format

banners

banners_history

categories

categories_description

configuration

configuration_group

counter

counter_history

countries

currencies

customers

customers_basket

customers_basket_attributes

customers_info

geo_zones

languages

manufacturers

manufacturers_info

newsletters

orders

orders_products

orders_products_attributes

orders_products_download

orders_status

orders_status_history

orders_total

products

products_attributes

products_attributes_download

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

reviews

reviews_description

sessions

specials

tax_class

tax_rates

whos_online

zones

zones_to_geo_zones

 

so what is the problem?what can I do next?

Thank you very much!

:'(

[Guest]

Hi sir,

 

That's Madam to you!!

 

change this line to read local host, from this :

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

to this :

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

 

if that doesn't work, then remove the space in this from this :

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

to this :

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

 

I doubt you have permissions to connect to remote db's anyway.

 

Lastly - never ever ever post your database configuration settings.

 

Once you get this going, the first thing you should do it change your username and password to connect to your db.

And remove the asdjksadj user.

unless this is bogus info! Which I assume. :-)

 

Corrie