Installation problem

Submitted by npaitken on Thu, 2008-04-17 17:10 in Price Tapestry

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 = "&pound;";
  $config_resultsPerPage = 10;
  $config_databaseServer = "localhost";
  $config_databaseUsername = "dbo242286389";
  $config_databasePassword = "*********";
  $config_databaseName = "db242286389";
  $config_databaseTablePrefix = "";
?>

- uploaded PT files to /shop/
- browsed to setup.php
- didn't get PASS

Any idea what's up?

Thanks,
Neil

Hello Neil, The first test

Submitted by support on Thu, 2008-04-17 17:31

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.

Hi David, Thanks for getting

Submitted by npaitken on Thu, 2008-04-17 17:57

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

Submitted by support on Thu, 2008-04-17 18:05

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.