Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Unable to connect to database server!


marcy.su

Recommended Posts

hi all;

 

Hope you can get the help!

 

I am a novice, the first site to do.

I got a website on Go Daddy on a Linux server. As per the instructions for OS Commerce, it says to set up a php database before installing and it asks for the database name at the start of the install. Go Daddy says I can create a database with my SQL. Will this work? How do I set it up for OS Commerce?

 

Also, when installing it asks for the name and password. Do I give the ID and password I used to log into my website or will there be a different one when I create the database that I will need to use?

 

I do a good file in the file upload space, successfully installed OSC system.

 

I now trouble is that

When i try to visit NO1-BATTERY.COM,browser website in the following tips:

 

Warning: mysql_connect(): Can't connect to MySQL server on 'mysql31.ixwebhosting.com ' (4) in /home/content/m/a/r/marcy2007/html/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

 

New database information is as follows:

 

MySQL Database Information

 

Status:

Pending Setup

Host Name:

p50mysql79.secureserver.net

Database Name:

MyUse

Database Version:

5.0

Description:

ABCD

User Name:

MyUse

 

 

Another is my OSC system automatically installed automatically when the database for information as follows:

 

MySQL Database Information

 

Status:

Setup

Host Name:

p50mysql77.secureserver.net

Database Name:

no10800207140287

Database Version:

5.0

Description:

marcy2007

User Name:

no10800207140287

 

 

 

I do configure.php files information is as follows:

 

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

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

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

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

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

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

define('HTTP_COOKIE_DOMAIN', 'no1-battery.com');

define('HTTPS_COOKIE_DOMAIN', ' no1-battery.com');

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', '/hsphere/local/home/marcy2007/no1-battery.com/');

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

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

 

// define our database connection

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

define('DB_SERVER_USERNAME', 'marcy2007');

define('DB_SERVER_PASSWORD', 'XXXXXX');

define('DB_DATABASE', 'marcy2007');

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

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

?>

 

How configure'DB_SERVER'?

p50mysql77.secureserver.net

p50mysql79.secureserver.net

mysql31.ixwebhosting.com

Which correct configure 'DB_SERVER' ?

 

Please help me check whether the correct configure.php files

Whether it should edit config.inc.php of phpMyAdmin file?

What methods can be connected to the database?

 

Please advise?

Thank you!

Regards,

Link to comment
Share on other sites

Did you follow the pinned post at the top of the installation and configuration forum?

 

All you need to do is create the database, and during the install process, give osc the details.

Link to comment
Share on other sites

Thank you for the warm answer!

 

I am a novice, the first site to do.

OSC installed in the system before I have create a database,

Status:

Pending Setup

Host Name:

p50mysql79.secureserver.net

Database Name:

MyUse

Database Version:

5.0

Description:

ABCD

User Name:

MyUse

 

Another is my OSC system automatically installed automatically when the database for information as follows:

Status:

Setup

Host Name:

p50mysql77.secureserver.net

Database Name:

no10800207140287

Database Version:

5.0

Description:

marcy2007

User Name:

no10800207140287

 

 

p50mysql77.secureserver.net

p50mysql79.secureserver.net

 

 

Above two 'DB_SERVER' I do not know Which correct configure localhost?

 

Someone can help?

Please advise?

THS!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...