Failed to connect to database with data you provided

By adamk - Posted on March 7th, 2008

Tagged:

Technical problems

Hi,

I'm trying to install Project Pier on a remote network, the hosting company is called ipowerweb.com.

I uploaded project pier to the site and setup a MySQL database through the hostings company control panel. Database name: projecpier, user name: test, password: xxx. I typed the xxx/public/install/ url into a browser and was able to get to step 3 of the installation; in step 2 all environment checkes passed, then when i enter in the database info i get the following error message
"Failed to connect to database with data you provided"
i know i typed in the database name, user id and password right but what about the Host Name in Project pier? how do i konw that is "localhost"? where do i check this? i can log into phpMyAdmin, can i check that there somewhere?
And what about the Table prefix? should that be pp_ no matter what?
is there anything else i should check?

All help greatly appreciated!

other info may be usefull...
Platform Type
Debian
MySQL Version
5.0.45
Perl Version
5.8.8
PHP Version
5.2.2
Path to SendMail
/usr/sbin/sendmail
Path to Perl
/usr/bin/perl
Path to PHP
/usr/local/bin/php

I may have found the Host

Submitted by adamk on Fri, 03/07/2008 - 14:35.

I may have found the Host name. the hosting tech support told me it should be "domainname.ipowermysql.com" when i use that in step 3, i nolonger get the error massage "Failed to connect to database with data you provided" but all that happens is the screen refreshes and goes back to step 3 with all fields blank.

Any ideas?

Permissions

Submitted by Ryan on Fri, 03/07/2008 - 23:36.

Did you make sure to give that user full permissions on your database? Also, might need to check INNODB support.

If that's not the case, you might also need to make sure your uploaded files are not corrupted - did you upload the archive to the server and then unzip? or did you unzip locally and ftp? there are often problems with unzipping locally.

how do i do a manual install?

Submitted by adamk on Sat, 03/08/2008 - 07:40.

Thanks for the reply.

I think all the permissions are given to the user, here is what it says under the 'v-deck' control panel form the host
Privileges: Select Insert Update Delete Create Drop Index Alter Tmp Lock
all selected as "yes"

as far as INNODB, im not sure how to check if that is on. the project pier installer never complained.. i searched around and found these references to innodb in phpMyAdmin. does that mean that it's on?

innodb additional mem pool size 1,048,576
innodb autoextend increment 8
innodb buffer pool awe mem mb 0
innodb buffer pool size 8,388,608
innodb checksums ON
innodb commit concurrency 0
innodb concurrency tickets 500
innodb data file path
innodb data home dir
innodb doublewrite ON
innodb fast shutdown 1
innodb file io threads 4
innodb file per table OFF
innodb flush log at trx commit 1
innodb flush method
innodb force recovery 0
innodb lock wait timeout 50
innodb locks unsafe for binlog OFF
innodb log arch dir
innodb log archive OFF
innodb log buffer size 1,048,576
innodb log file size 5,242,880
innodb log files in group 2
innodb log group home dir
innodb max dirty pages pct 90
innodb max purge lag 0
innodb mirrored log groups 1
innodb open files 300
innodb rollback on timeout OFF
innodb support xa ON
innodb sync spin loops 20
innodb table locks ON
innodb thread concurrency 8
innodb thread sleep delay 10,000

I unzipped the files on my computer and uploaded them through FTP, i did this twice in two seperate directories, i think the files should be ok.

I'm still new with this but for some reason i think i have something wrong with the host address. is there a way to check this? lets say if i type that into a browser (ie. mydomainnam.ipowermysql.com) should i connect to something? all i get is a server not found message.

How about doing a manual install? i read on the forum that some people have done this. Where can i find instructions for a manual install?

Thank you!

New Info

Submitted by adamk on Thu, 03/27/2008 - 09:41.

Hello,

Following a suggestion by skittles i created a link to the host setup: http://www.apurk.com/projectpier/ppsupport.php

If someone has an idea why I cant connect to the MySQL database in the projectpier setup using this info please let me know.

FYI I'm using a remotely hosted server form ipower.com

thank you

Ok, I looked at your php

Submitted by Alex. on Thu, 03/27/2008 - 13:27.

Ok, I looked at your php info file, and I can't see anything glaringly wrong.
If you want to make a manual install, then run the following queries in the sql tab of phpmyadmin:

http://projectpier.pastebin.com/mb4e7d90
http://projectpier.pastebin.com/m1cae067c

Then open config/config.php and replace the contents with that from config/empty.config.php (making sure you change the values of db name, password etc.)

Make sure you take down that php file :)

hi did this ever get resolved?

Submitted by sparky on Mon, 11/16/2009 - 17:40.

I am having the exact same issues adam was 18 months ago?
the two queries above are no longer available so I cant use them - I am debating whether to run a manual install or (as I only have a couple of months lest on this years hosting) switch. - ipower do seem to have improved their tech service since adam was having his issues last year, but the configuration problems still look to be there

Any suggestions or should I repost this as a new issue ?

Maybe it is your php.ini config problem.

Submitted by biocyberman on Tue, 03/23/2010 - 11:45.

I had the same error. This thread looks old but I want to put here for others' reference:

I found my solution by first identifying mysql connection problem by adding this line to
public/install/installation/steps/SystemConfigStep.class.php:

Before:

 } else {
        $this->addError('Failed to connect to database with data you provided');

AFTER:

 } else {
        $this->addError('Failed to connect to database with data you provided');
	$this->addError(mysql_error());

The error i got afterward was "No such file or directory" which implies in my case, mysql.sock is not found.
I open php.ini and correct path to mysql.sock in three places:
BEFORE:

pdo_mysql.default_socket=/var/mysql/mysql.sock
mysql.default_socket = /var/mysql/mysql.sock
mysqli.default_socket = /var/mysql/mysql.sock

AFTER:

pdo_mysql.default_socket=/tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

save php.ini and restart apache and voala! :)

So in short, check your php.ini configuration for mysql.

Same problem as everyone else on this thread with 2 exceptions

Submitted by KelleyChambers on Wed, 11/17/2010 - 15:48.

HostGator is my host and supports all the requirements. I'm able to connect to the database as tables show as populated in phpMyAdmin. I'm also given a screen that says the following:
Step 4: Finish

Installation process:

* Database connection has been established successfully
* InnoDB storage engine is supported
* Database 'motorrad_projects' setup. (Queries executed: 25)
* Database 'motorrad_projects' initialized. (Queries executed: 102)
* Configuration saved

Success!

You have installed ProjectPier successfully. Press Finish and start managing your projects. ProjectPier will ask you to create an administrator and provide some details about your company first.

Visit www.ProjectPier.org for news and updates.. '

However, when I press finish, it reverts to:
Step 4: Finish

Installation process:

* Failed to connect to database with data you provided

Even after a manual install, I'm still greeted with a blank index.php screen when trying to login.

I have attempted every solve and cannot for the life of me understand why this isn't working. HELP! I don't know where to go from here!!!

Kindest Regards,

Kelley Chambers, CWD
GrapeVine Design

My bad, read this:

Submitted by phpfreak on Thu, 11/18/2010 - 00:17.

http://www.projectpier.org/node/1913

1) After unpacking delete /cache/autoloader.php