Failed to connect to database with data you provided
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 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?
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.
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!
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 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 :)