Please help me! Unable to connect to database server!

[marcy.su]

I now trouble is that

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

Also edit phpMyAdmin upload files to the directory.

 

 

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!

 

 

I purchased the space for www.godaddy.com

 

 

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

 

 

What methods can be connected to the database?

Please advise?

I hope to have all the help warm!

Thank you!

[♥geoffreywalton]

Try

 

 

// define our database connection

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

[Guest]

Now that you have posted sensitive data for the world to see, you will need to change the username and password.

[marcy.su]

Now that you have posted sensitive data for the world to see, you will need to change the username and password.

 

I am a novice, the first site to do.

 

 

p50mysql77.secureserver.net

p50mysql79.secureserver.net

mysql31.ixwebhosting.com

 

Which correct configure 'DB_SERVER' ?

 

 

Please advise?

Thank you!

Regards,

[Guest]

I am a novice, the first site to do.

p50mysql77.secureserver.net

p50mysql79.secureserver.net

mysql31.ixwebhosting.com

 

Which correct configure 'DB_SERVER' ?

Please advise?

Thank you!

Regards,

You web host can tell you what it is.

[gbmarin]

I now trouble is that

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

Also edit phpMyAdmin upload files to the directory.

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!

I purchased the space for www.godaddy.com

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

What methods can be connected to the database?

Please advise?

I hope to have all the help warm!

Thank you!

 

You sound like you're having the same problem I had when I originally installed OS Commerce to GoDaddy. The problem for me was a simple fix (however it took 24 hours to complete). Are you using Windows or Linux for your server operating system? If you're using Windows, that is the problem. You need to switch to Linux OS for OSCommerce to work. If this is the problem, you'll need to delete your database. Then you can switch the OS through the hosting manager. I don't remember exactly where it is to do it. If you can't find it, just call customer support and they'll walk you through it. It only takes a couple of minutes, but you have to wait up to 24 hours for the change to take affect. Hope this helps!!

[marcy.su]

Thank you for your enthusiastic help problem!

 

I use Linux server operating system.

OSCommercce was installed with the Go Daddy Hosting center.

The MYSQL database created was no10800708553092 that configure the coding using that database name

 

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

unable to connect to the database,

 

I can not vist when i try to visit www.no1-battery.com/phpMyAdmin/ ,

I can via the godaddy database web interface or via the oSCommerence install.

I use phpMyAdmin 2.6.0-beta2 that edit config.inc.php of phpMyAdmin file

 

Is it because I upload phpMyAdmin file version 2.6.0 is not only the problem visit www.no1-battery.com/phpMyAdmin/

If this is the reason, then I phpMyAdmin file changes

 

I am most concerned about now is how can the database connection,

 

I hope someone can talk about the issue in detail how to save

 

Thanks you!

Regards,

[Avec]

Did you change your define database to this?

 

// define our database connection

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

 

When you use phpMyAdmin from your host provided Cpanel, what is the name of the database as listed there? Is it marcy2007 or something like no1bat_marcy2007? Whichever it is is the name you need to have in your configure.php files

[marcy.su]

Hi,all!

 

I define ('DB_SERVER', 'no10800207140287') that I use phpMyAdmin v2.20-beta2 that edit and Update config.inc.php of phpMyAdmin file,

now i try to visit www.myname.com/phpmyadmin/ then connect to the database!

But try to visit www.myname.com,browser website in the following tips:

unable to connect to the database!

 

Please advise?

 

Thank you!

[marcy.su]

Sorry,

 

Now I corrected that define ('DB_SERVER', 'no10800207140287') related to the above I am wrong.

I define ('DB_SERVER', 'p50mysql77.secureserver.net') that edit includes/configure.php and admin/includes/configure.php to have the correct file system (FS) paths for my user account. Please help me check whether the correct configure.php .

 

includes/configure.php

<?php

define('HTTP_SERVER', 'http://myname.com');

define('HTTPS_SERVER', 'https://myname.com');

define('ENABLE_SSL', 'true');

define('HTTP_COOKIE_DOMAIN', 'myname.com');

define('HTTPS_COOKIE_DOMAIN', 'myname.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', '/home/content/m/a/r/marcy2007/html/myname.com/');

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

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

 

define('DB_SERVER', 'p50mysql77.secureserver.net');

define('DB_SERVER_USERNAME', 'no10800207140287');

define('DB_SERVER_PASSWORD', 'XXXXX');

define('DB_DATABASE', 'no10800207140287');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

?>

 

admin/includes/configure.php

<?php

define('HTTP_SERVER', 'http://myname.com');

define('HTTPS_SERVER', 'https://myname.com');

define('ENABLE_SSL', 'true');

define('HTTP_COOKIE_DOMAIN', 'myname.com');

define('HTTPS_COOKIE_DOMAIN', 'myname.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', '/home/content/m/a/r/marcy2007/html/myname.com/');

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

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

 

define('DB_SERVER', 'p50mysql77.secureserver.net');

define('DB_SERVER_USERNAME', 'no10800207140287');

define('DB_SERVER_PASSWORD', 'XXXXX');

define('DB_DATABASE', 'no10800207140287');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

?>

 

 

But try to visit www.myname.com,browser website in the following tips:

unable to connect to the database!

 

Please advise?

THS!

[Avec]

Try

 

 

// define our database connection

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

 

Did you try this yet?

[proxyloh]

Then you can switch the OS through the hosting manager. I don't remember exactly where it is to do it. If you can't find it, just call customer support and they'll walk you through it. It only takes a couple of minutes, but you have to wait up to 24 hours for the change to take affect. Hope this helps!!

Thank you.I was looking for this info a whole day.