marcy.su Posted January 7, 2008 Share Posted January 7, 2008 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 More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 did you try localhost? define('DB_SERVER', 'localhost'); Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 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 More sharing options...
marcy.su Posted January 7, 2008 Author Share Posted January 7, 2008 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.