Failed to connect to Database HELP!

Permalink
So I'm trying to install concrete5. I'm using Justhost for service provider. I uploaded concrete5, created a database, I changed permissions for appropriate folders but when I go to install I get an error message saying, "failed to connect to database" I contacted my provider and confirmed database location etc...
after attempting to launch this is the page i'm kicked to:
http://www.satyamproperty.com/index.php/install/-/configure/...

can anyone help?

cannonf700
 
Darkwater23 replied on at Permalink Reply
Darkwater23
There can only be a few problems here. The server name you're using is not correct, the database name you're using is not correct or the credentials are not correct.

I'm not familiar with JustHost, but I'd pressure them for some help. Assuming you can connect to some kind of GUI admin panel for the MySQL instance, see if you can confirm the server's name somewhere on one of those screens.

When I set mine up, I created a schema called 'Concrete5' and a user called 'Concrete5'. I granted all privileges except for 'GRANT' to the new user for the new schema.

Have you had an luck since your last post?
cannonf700 replied on at Permalink Reply
cannonf700
Darkwater23 -
Thanks for the response - I've checked, double-checked and rechecked again the server name, database name, username and password. It's all correct - still nothing. database user is running with all privileges. I'm clueless...
could it be a problem that I'm running this site in a sub-directory of my public_html folder?
I am currently using wordpress on a third site also in a sub-folder of public_html
and a drupal installation as well. These set up without a hitch.
Darkwater23 replied on at Permalink Reply
Darkwater23
The sub directory shouldn't matter. PHP needs to connect to MySql as a client and run a bunch of CREATE/ALTER statements to setup the CMS tables.

Were you able to contact JustHost to see if they had any insight?

The only other thing I can think of is a MySql client version issue or some parameter that C5 does or doesn't do that Wordpress does differently.
Darkwater23 replied on at Permalink Reply
Darkwater23
Found this on another thread.

"Unfortunately it just turned out to be a much simpler solution: the host is on MySQL 4.0, and Concrete requires 4.1 as minimum."

This would be a question for your host.
cannonf700 replied on at Permalink Reply
cannonf700
JustHost is running mysql 5.0
If you want check out:
www.www.satyamproperty.com/phpinfo.php...

this could help.
cannonf700 replied on at Permalink Reply
cannonf700
This is what my conversation with JustHost looked like:
First This:
"There some problems with installation package.
I'm able to connect to mysql server using provided login info to DB."

And after confirming the installation requirements and that safety mode is off and that mod_rewrite is enabled we ended here:
"Ask Concrete support team about Pear and Perl modules.
Maybe this CMS requires some special modules.
I suppose the cause of the problem is here:
./concrete/controllers/install.php
And here is this source code:
$db = Loader::db( $_POST['DB_SERVER'], $_POST['DB_USERNAME'], $_POST['DB_PASSWORD'], $_POST['DB_DATABASE'], true);

if ($_POST['DB_SERVER'] && $_POST['DB_DATABASE']) {
if (!$db) {
$e->add(t('Unable to connect to database.'));

I don't know why it unable to connect to your DB."

Darkwater - did you have to chmod any other folders/files besides what is given in the installation instructions?
Thanks again
Darkwater23 replied on at Permalink Reply
Darkwater23
Since I was only setting this up for eval purposes on a local Virtual PC image, I just gave Everyone Full Control. (I cheated, lol)

I looked at your phpinfo and it appears similar to mine. You even have a newer MySql client version than I do.

One issue I had was that the site.php file wasn't being written out. That file stores these posted settings. Do you have a site.php file?

Unless someone on the dev team pipes up, I'm not sure what else to suggest to you.

Sorry, dude! If you find a solution, please post it here. I'm curious to know.
cannonf700 replied on at Permalink Reply
cannonf700
No - I don't have a site.php file. I was assuming that it would be written when the install took. Do I need to create a site.php first? Do I leave it blank or fill it with the config settings.

I almost ready to drop the $125.00 for C5 to do the install for me but I want to know why I can't get it to run...
Darkwater23 replied on at Permalink Reply
Darkwater23
Yeah, you're right. You're not even getting that far yet. It would probably make that file after the tables were made.

This is what bugs me about this particular app so far. The only person trying to help you so far is a C5 newbie. Where are the developers at?
frz replied on at Permalink Reply
frz
see sticky post at top of this forum.
-frz
cannonf700 replied on at Permalink Reply
cannonf700
Hey Darkwater...
Thought you'd want to know. the problem was that the password for the database had "special characters in it" meaning that it had /'s and *'s in it. Once the password was cleaned to include just letters and numbers... WaLa! Install complete.
Darkwater23 replied on at Permalink Reply
Darkwater23
Well played, sir!