Can't get passed "Testing database connection"

dankost · October 7, 2008

Hi,

I'm new to osCommerce. I am trying to install on Windows. I created a database in MySQL, which I can log into using the command line. When I start the installation, the first thing it asks me for is the Database Server, Username, Password and Database Name. I put those in and hit the "Continue" button. A message comes up on the left saying "Testing database connection" with a little gear icon spinning and nothing else happens. Any ideas?

Gauravs · October 7, 2008

Most probably Database Server setting is the issue - why don't you create a stand alone PHP page to test db connection and get error message if any to help you identify the issue?

Here is a simple script, save as dbtest.php in your server root, access it via browser and see what is the outcome

<?
###################################### C O P Y R I G H T S ####################################
# THIS SCRIPT IS DISTRIBUTED BY WEBUNE.COM UNDER LICENSE UNDER THE GPL RULES
# PLEASE DO NOT REMOVE THIS MESSAGE IN SUPPORT OF OUR HARD WORK TO CONTINUE TO PROVIDE FREE SUPPORT
################################################################################
###############
# OK, HERE WE GO
# Use this varialble if you are using an installation script
$step = $_GET['step'];
if (!$step) {
$page_title = 'Form';
}
else{
$page_title = 'install step '.$step;
}
############## BEGIN FUNCTIONS ##############################
# FUNCTION TO TEST USERNAME AND PASSWORD IN MYSQL HOST
function db_connect($server, $username, $password, $link = 'db_link') {
global $$link, $db_error;
$db_error = false;
if (!$server) {
	$db_error = 'No Server selected.';
	return false;
}
$$link = @mysql_connect($server, $username, $password) or $db_error = mysql_error();
return $$link;
}
# FUNCTION TO SELECT DATABASE ACCESS
function db_select_db($database) {
echo mysql_error();
return mysql_select_db($database);
}
# FUNCTION TO TEST DATABASE ACCESS
function db_test_create_db_permission($database) {
global $db_error;
$db_created = false;
$db_error = false;
if (!$database) {
	$db_error = 'No Database selected.';
	return false;
}
if ($db_error) {
	return false;
} else {
	if (!@db_select_db($database)) {
		$db_error = mysql_error();
		return false;
	}else {
		return true;
	}
return true;
}
}

function step1 ($error) {
echo '<h1 style="color:#FF0000">'.$error.'</h1><hr>';
?>
<form name="form1" method="post" action="<? $_SERVER['PHP_SELF']; ?>?step=2">
<table border="0" cellspacing="5" cellpadding="5">
<tr>
<td><div align="right">mysql hostname:</div></td>
<td><input name="server" type="text" value="<? echo $_REQUEST['server']; ?>"> (usually "localhost")</td>
</tr>
<tr>
<td><div align="right">mysql username:</div></td>
<td><input type="text" name="username" value="<? echo $_REQUEST['username']; ?>"></td>
</tr>
<tr>
<td><div align="right">mysql username password:</div></td>
<td><input type="text" name="password" value="<? echo $_REQUEST['password']; ?>"></td>
</tr>
<tr>
<td><div align="right">mysql database name:</div></td>
<td><input type="text" name="database" value="<? echo $_REQUEST['database']; ?>"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
<?php
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Webune MYSQL TEST - <? echo $page_title; ?></title>
</head>
<body>
<h1><? echo $page_title; ?></h1>
<?
############## END FUNCTIONS ##############################
switch ($step) {
case '2':
	if ($_REQUEST['server']) {
			$db = array();
			$db['DB_SERVER'] = trim(stripslashes($_REQUEST['server']));
			$db['DB_SERVER_USERNAME'] = trim(stripslashes($_REQUEST['username']));
			$db['DB_SERVER_PASSWORD'] = trim(stripslashes($_REQUEST['password']));
			$db['DB_DATABASE'] = trim(stripslashes($_REQUEST['database']));
			$db_error = false;
			db_connect($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD']);
			if ($db_error == false) {
				if (!db_test_create_db_permission($db['DB_DATABASE'])) {
					$error = $db_error;
				}
			} else {
				$error = $db_error;
			}
			if ($db_error != false) {
				$error = "failed";
				echo step1($db_error);
			} else {
				echo '<h1 style="color:green">Congratulations!</h1>Connected Successfuly to datbase <strong><a href="http://www.webune.com">Continue >> </a></strong>';
			}
	} else {
		$error = "ERROR: please provide a hostanme";
		echo step1($error);
	}
break;

default:
echo step1('Step 1');
break;
}
?>
<div align="center"><img src="http://www.webune.com/images/headers/default_logo.jpg" alt="Webune Hosting"></div>
<div align="center">Script Courtesy of <a href="http://www.webune.com">Webune PHP/Mysql Hosting</a></div>
</body>
</html>

shanta · October 11, 2008

Most probably Database Server setting is the issue - why don't you create a stand alone PHP page to test db connection and get error message if any to help you identify the issue?

Here is a simple script, save as dbtest.php in your server root, access it via browser and see what is the outcome

Thanks for the script.

I used it to test my system. Your scripts moves to step two. osCommerce still hangs on testing database.

Where should I look for debugging

Thanks

shanta.

Can't get passed "Testing database connection"

Recommended Posts

dankost

Gauravs

shanta

Archived

Browse

Activity