Hi,
I've just downloaded PT and I'm keen to have a play with it...but have fallen at the first hurdle :-(
I'm getting database connection FAIL when browsing to setup.php:
Checking database connection...FAIL check $config_databaseUsername and $config_databasePassword values
Checking database selection...FAIL
Checking database tables...FAIL
Steps I've carried out so far are:
- Created a new database for PT (mysql version 5)
- created a subfolder www.mysite.com/shop/ for PT files
- Created config.php as instructed
<?php
$config_title = "Title";
$config_charset = "utf-8";
$config_baseHREF = "/shop/";
$config_useRewrite = false;
$config_useRelated = false;
$config_useTracking = false;
$config_useJavaScript = false;
$config_useInteraction = false;
$config_currencyHTML = "£";
$config_resultsPerPage = 10;
$config_databaseServer = "localhost";
$config_databaseUsername = "dbo242286389";
$config_databasePassword = "*********";
$config_databaseName = "db242286389";
$config_databaseTablePrefix = "";
?>
Any idea what's up?
Thanks,
Neil
Hi David,
Thanks for getting back to me.
Just spoken with hosting tech support and MySQL database server is:
$config_databaseServer = "db1443.oneandone.co.uk";
added this to config.php, uploaded and tried browsing to setup.php BUT still getting the same FAIL.
Hosting on 1&1 (Business Package) - added this in case you've seen similar problem with other users on 1&1.
What can I try next?
Thanks
Neil
Hello Neil,
Could you perhaps email me your config.php and a link to your site and I'll take a look and see if I can see anything...
Cheers,
David.
Hello Neil,
The first test "Checking database connection..." is only testing this setting:
$config_databaseServer = "localhost";
...so what it implies is that there is no MySQL server currently running on the same machine (localhost) as your web server, or at least if there is then it is not running on the default port.
Do you have any documentation from your hosting company regarding the setting required for applications that require MySQL? For example, some hosts might require you to use something like:
mysql1234.examplehostingcompany.com
Feel free to forward to me (reply to your reg code or forum registration email) any emails that have got from your host that might have this information but you're not sure about - alternatively, contacting your host regarding the MySQL server hostname should help...
Cheers,
David.