Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error database.php line 19... Help me please!


wsu_nick

Recommended Posts

I recently tried to integrate some oscommerce files into my completley stock version of osc and I keep getting this message.

 

Warning: mysql_connect(): Access denied for user: 'status_osc1@localhost' (Using password: YES) in /home/wheeltr/public_html/shop/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

What is going on. I have tried many things and have yet to be able to figure it out. Please help

Link to comment
Share on other sites

I recently tried to integrate some oscommerce files into my completley stock version of osc and I keep getting this message.

 

Warning: mysql_connect(): Access denied for user: 'status_osc1@localhost' (Using password: YES) in /home/wheeltr/public_html/shop/includes/functions/database.php on line 19

Unable to connect to database server!

What is going on. I have tried many things and have yet to be able to figure it out. Please help

 

Just looks like an authentication problem. Check your username and/or password in your configure files that are used to connect to the db

Link to comment
Share on other sites

Just looks like an authentication problem. Check your username and/or password in your configure files that are used to connect to the db

 

I have the same problem when my webhost had a hardware failure and corrupted all my files. They were able to retrieve my database so I just uploaded by backup for all public_html folder. BUTt I cannot open my main page anymore nor access my admin. I checked the configure file and the password there is self generated by OSC, I didn't assign that password.

 

How am I suppose to change the password that the OSC database is using?

 

Pls help... My site has been down for several days now :(

Link to comment
Share on other sites

I have the same problem when my webhost had a hardware failure and corrupted all my files. They were able to retrieve my database so I just uploaded by backup for all public_html folder. BUTt I cannot open my main page anymore nor access my admin. I checked the configure file and the password there is self generated by OSC, I didn't assign that password.

 

How am I suppose to change the password that the OSC database is using?

 

Pls help... My site has been down for several days now :(

 

I also have the same problem. My site was working fine last time I looked at it about 3 weeks ago. I have not changed a thing since I last looked, and not I am getting the message

 

Warning: mysql_connect(): Access denied for user: 'ukgiftma_ukgiftm@localhost' (Using password: YES) in /home/ukgiftma/public_html/store/includes/functions/database.php on line 19

Unable to connect to database server!

 

Below is the Database.php file. Please can somebody help, as there seem to be a few of us with this problem, someone else must have had and resolved this problem.

 

 

' . $errno . ' - ' . $error . '' . $query . '[TEP STOP]');

}

 

function tep_db_query($query, $link = 'db_link') {

global $$link;

 

if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);

}

 

$result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());

 

if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

$result_error = mysql_error();

error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);

}

 

return $result;

}

 

function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {

reset($data);

if ($action == 'insert') {

$query = 'insert into ' . $table . ' (';

while (list($columns, ) = each($data)) {

$query .= $columns . ', ';

}

$query = substr($query, 0, -2) . ') values (';

reset($data);

while (list(, $value) = each($data)) {

switch ((string)$value) {

case 'now()':

$query .= 'now(), ';

break;

case 'null':

$query .= 'null, ';

break;

default:

$query .= '\'' . tep_db_input($value) . '\', ';

break;

}

}

$query = substr($query, 0, -2) . ')';

} elseif ($action == 'update') {

$query = 'update ' . $table . ' set ';

while (list($columns, $value) = each($data)) {

switch ((string)$value) {

case 'now()':

$query .= $columns . ' = now(), ';

break;

case 'null':

$query .= $columns .= ' = null, ';

break;

default:

$query .= $columns . ' = \'' . tep_db_input($value) . '\', ';

break;

}

}

$query = substr($query, 0, -2) . ' where ' . $parameters;

}

 

return tep_db_query($query, $link);

}

 

function tep_db_fetch_array($db_query) {

return mysql_fetch_array($db_query, MYSQL_ASSOC);

}

 

function tep_db_num_rows($db_query) {

return mysql_num_rows($db_query);

}

 

function tep_db_data_seek($db_query, $row_number) {

return mysql_data_seek($db_query, $row_number);

}

 

function tep_db_insert_id() {

return mysql_insert_id();

}

 

function tep_db_free_result($db_query) {

return mysql_free_result($db_query);

}

 

function tep_db_fetch_fields($db_query) {

return mysql_fetch_field($db_query);

}

 

function tep_db_output($string) {

return htmlspecialchars($string);

}

 

function tep_db_input($string) {

return addslashes($string);

}

 

function tep_db_prepare_input($string) {

if (is_string($string)) {

return trim(tep_sanitize_string(stripslashes($string)));

} elseif (is_array($string)) {

reset($string);

while (list($key, $value) = each($string)) {

$string[$key] = tep_db_prepare_input($value);

}

return $string;

} else {

return $string;

}

}

?>

Link to comment
Share on other sites

I am also now having the same problem as the others. Any help would be appreciated.

 

Thanks,

Chris

 

Warning: mysql_connect(): Access denied for user: 'rename_osc1@localhost' (Using password: YES) in /home/rename/public_html/includes/functions/database.php on line 19

Unable to connect to database server!

Link to comment
Share on other sites

  • 1 month later...
I am also now having the same problem as the others. Any help would be appreciated.

 

Thanks,

Chris

 

Warning: mysql_connect(): Access denied for user: 'rename_osc1@localhost' (Using password: YES) in /home/rename/public_html/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

I would recommend that you take a look at your DB, When I had this error a while back I found I was missing a few tables in my DB. I would suggest reloading your DB. I hope this helps.

Link to comment
Share on other sites

When you get this error it means that the database info that is in your configure.php file is not matching the info that you setup in your hosting control panel for your database.

 

The other thing that can cause this is if your database user is not assigned to the database.

 

Double check and make sure your user is assigned to the database and that all your info in your configure.php is correct.

 

 

If is was working and is not any longer than either your configure.php has been changed or the database or user info itself has changed.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...