Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"Unable to connect to database server!"


bhaktalex

Recommended Posts

I went throught the whole installation just fine, but then I noticed that I could not access my admin directory. I get this error:

 

 

Warning: mysql_connect(): Unknown MySQL Server Host ' mysql9.secureserver.net' (0) in /home/content/b/h/a/bhaktalex/html/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

At first that was the only problem, but now I get the same warning when I try to go to the catalog directory.

 

Anyone know why? Thanks.

Link to comment
Share on other sites

I went throught the whole installation just fine, but then I noticed that I could not access my admin directory. I get this error:

Warning: mysql_connect(): Unknown MySQL Server Host ' mysql9.secureserver.net' (0) in /home/content/b/h/a/bhaktalex/html/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

At first that was the only problem, but now I get the same warning when I try to go to the catalog directory.

 

Anyone know why? Thanks.

 

 

You have one of two problems.

 

1. The database info in your configure.php files is in some way incorrect. Could be the database server, username, password, database name.

 

2. When you created your database and user you did not assign the user to the database, this will sometimes give the same error

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

You have one of two problems.

 

1. The database info in your configure.php files is in some way incorrect. Could be the database server, username, password, database name.

 

2. When you created your database and user you did not assign the user to the database, this will sometimes give the same error

 

Thanks. I did look into that file and found a mistake in the host name. It fixed one proble: Being able to acess my CATALOG pages. Then I tried accessing my admin pages and I got the same "warning" as before.

 

I have not yet protected my admin pages. Do I have to before it will let me access?

Also, I have not changed the name of the admin directory. Do I have to?

 

Thanks for your help.

Link to comment
Share on other sites

Like Richard said you have to change your configure.php FILES. There is one for the catalog normally in catalog/configure.php and one for the admin section in catalog/admin/configure.php.

 

HTH

Tom

 

Well, I looked in the admin folder and all there is is a "configuration.php" and I can't find anything within it to configure. The message I get seem to make reference to line 19 in the database.php file which seem to be authenticating user, pass, and host name. See at: venicetemple.com/catalog/krishnayoga

 

Thanks for your patience.

Link to comment
Share on other sites

Thanks. I did look into that file and found a mistake in the host name. It fixed one proble: Being able to acess my CATALOG pages. Then I tried accessing my admin pages and I got the same "warning" as before.

 

I have not yet protected my admin pages. Do I have to before it will let me access?

Also, I have not changed the name of the admin directory. Do I have to?

 

Thanks for your help.

 

 

You do not have to do either though it is a very good idea to do both.

 

When you change the name of your admin folder you will need to edit your admin/includes/configure.php file to reflect the name change

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...