Unable to connect to database server

[tinigpinoy]

I installed the osCommerce as I was told on the direction, I configured everything and it was successfully configured. however when i try to click on the either administration tool or catalog I get the following:

 

Warning: mysql_pconnect(): Unknown MySQL Server Host 'mysql04.powweb.com ' (1) in /www/p/pinoyhollywood/htdocs/catalog/admin/includes/functions/database.php on line 17

Unable to connect to database server!

 

I'm very new at this, I don't know very technical of it. But when I checked my database thru phpadmin, it seems like database was successfully uploaded to it. please help. what am I doing wrong?

[241]

If the database has been created then the problem may be in your configure.php files both the admin/includes/configure.php and the catalog/includes/configure.php

 

the problem will be with the database information part of these files and probably with this line

 

define('USE_PCONNECT', 'true');

try setting to

define('USE_PCONNECT', 'false');

your host may not allow persistant connections

[tinigpinoy]

When I tried to view the catalog/includes/configure.php or admin/includes/configure.php from my browser it's just blank....totally nothing on it. Anything else I need to install or configure?

[241]

you cant view these files with your browser

use an ftp program to download the files and view them offline

[tinigpinoy]

Idon't have any php editor to take a look at it, so what i did is I copied the configure.php file and rename it to txt to be able to see the code and I got the following:

 

<?php
/*
 $Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
*/

// define our webserver variables
// FS = Filesystem (physical)
// WS = Webserver (virtual)
 define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers
 define('HTTP_CATALOG_SERVER', '');
 define('HTTPS_CATALOG_SERVER', '');
 define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
 define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)
 define('DIR_WS_ADMIN', '/admin/');
 define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);
 define('DIR_WS_CATALOG', '/catalog/');
 define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
 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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
 define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
 define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

// define our database connection
 define('DB_SERVER', '');
 define('DB_SERVER_USERNAME', 'mysql');
 define('DB_SERVER_PASSWORD', '');
 define('DB_DATABASE', 'osCommerce');
 define('USE_PCONNECT', 'false');
 define('STORE_SESSIONS', '');
?>

 

the USE_PC CONNECT is already set on false...and yet still doesn't work but one thing I notice is the username and the Password, does it need to be set up in my username and password when I already set it up when I install the oscommerce?

 

Also, what php editor do you recommend?

[241]

first you are missing the server information

define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers
define('HTTP_CATALOG_SERVER', '');

 

also set this

define('STORE_SESSIONS', '');

as this

define('STORE_SESSIONS', 'mysql');

 

you are probably missing information in the catalog/includes/configure.php as well

 

this may need an absolute path

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)

 

this may need to be changed also

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

and this

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

 

your database information should reflect the information you inputed when installing so you will need the server name

define('DB_SERVER', '');

also this will need to be the correct information

define('DB_SERVER_USERNAME', 'mysql');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'osCommerce');

 

 

this is true for both configure.php files and you cant just copy them as they are different only the database information is the same in both

 

Editors phpedit or vim or dreamweaver to name but three

[gareth123456]

Your problem might be due to your shared hosting using one MySQL database address for non-SSL connections and another using a different name for SSL connections to the database. This is the problem I am having and awaiting help with at post:

 

SSL Database Connection Problem

 

Will let you know if I find the solution......

[tinigpinoy]

It worked now. My host told me to use IP Address instead of the my server name. Because oscommerce taking my servername with a space.

 

Thanks for all the help.

 

Although, my problem now is how to configure the page, like replace the oscommerce logo to mine etc...still working on how will I set everything up the way I'd like it to be.