Overall, I haven't been successful getting this installed. Currently, i'm getting the following:
"We are sorry, but ProjectPier failed to connect to the database. Error report has been sent to the administrator so problem should be resolved soon."
Here is the connection information I put into the files indicated in the installation section.
<?php
$con = mysql_connect("mysql6.jodoshared.com", "cpcfonl_root", "xxxxx");
mysql_select_db("cpcfonl_project", $con);
?>I'm new to mysql and php, so my code may be wrong.
What does phpinfo say about mysql and the rest?
Make a file called info.php in the root and call it from a browser. Contents of the file:
<?phpphpinfo();
?>
not sure what to look for. here is the link:
http://project.cpcfonline.org/info.php
Okay, now we know:
a) the extension_dir is set correctly
b) the php version
c) the OS (Windows) en web server (IIS) details
Questions:
a) If you run the code in your initial post you get no errors?
b) Can you put the following code in testdb.php and call it from a browser? Set the pass ofcourse :)
<?php$con = mysql_connect("mysql6.jodoshared.com", "cpcfonl_root", "xxxxx") or die("cannot connect");
mysql_select_db("cpcfonl_project", $con) or die("no such database");
?>
c) Is the database on the same machine as IIS?
d) Is the database accessible on port 3306 (default)? If not, add the port number after .com like this .com:<port>.
e) Can you connect with other tools to the database (e.g. phpMyAdmin)?
first of all, thanks for your help.
a) not sure what you mean on the "initial post"?
b) i get a blank page for testdb.php
c) not sure that it is
d) port is set to 3306
e) i can connect with the phpMyAdmin and Toad
A couple of things:
1) Should I switch the web hosting service to Linux?
2) How can I go about re-installing Project Pier? I remember trying to go back to Step 3 in the installation because I thought I might have been made an input error. But was unable to.
here is a detailed error message:
Warning: mysql_connect() [function.mysql-connect]: Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 4.0.27-standard in C:\wamp\www\project.cpcfonline.org\config\config.php on line 2
Warning: mysql_connect() [function.mysql-connect]: Connecting to 3.22, 3.23 & 4.0 servers is not supported in C:\wamp\www\project.cpcfonline.org\config\config.php on line 2
Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in C:\wamp\www\project.cpcfonline.org\config\config.php on line 3
also, the database is on the web hosting service which would be on a separate machine from IIS right?
Good work! You found the problem.
Warning: mysql_connect() [function.mysql-connect]: Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 4.0.27-standard in C:\wamp\www\project.cpcfonline.org\config\config.php on line 2PHP 5 has a mysql client packaged that cannot connect to a MySQL database less than version 4.1. Starting with version 4.1, MySQL uses a new way of password hashing that is not compatible with pre-4.1 databases. The server your configuration is connecting to is version 4.0.27. So, you need to get yourself a higher version of MySQL.
From the requirements:
http://www.projectpier.org/manual/tour/features
•MySQL with InnoDB Support (MySQL 4.1 or newer recommended)
I guess MySQL 4.1 recommended means MySQL 4.1 required :-)
based on the info.php file for the remote server, that setup meets the minimums. i'll upgrade wamp and see if that gets me started on the local test site. if so, then i know it's a problem with the remote host, right?
Thanks.
a) I meant the very first comment on this thread.
b) Blank page means no errors on connecting and selecting.
c) hmm. ok for now.
d) ok
e) good
1) No need
2) If you just want to change the database connect info, you can edit config/config.php and put in the right values.
If the local wamp installation works fine with the newer MySQL the next thing to try is to connect to the remote MySQL database from your local wamp installation.
If that works, the next thing is to double check the values in config/config.php in the internet installation.
Switched to Xammp and did some reinstalls and finally got to a point where the install was successful. Then read the forum about DB persist and changed from "true" to "false". That took me to the login setup.
All good. thanks for your help.