Thread

Hi guys

Hoster has upgraded in preparation for a move from EE1.7 to EE2.2 and this message keeps showing when pointed to the new database (the old one is still available too):

Database Error: Unable to connect to your database. Your database appears to be turned off or the database connection settings in your config file are not correct. Please contact your hosting provider if the problem persists.

The IP provider agrees that the config.php appears to be correct and the database shows if they attempt a direct connection using the IP address instead of the hostname.

Is there something other than the config.php that needs adjustment? path.php maybe?

Many thanks. Pete

**************

1) config.php

<?php

if ( ! defined('EXT')){
exit('Invalid file request');
}

$conf['app_version'] = "169";
$conf['license_number'] = "1529-4292-6797-4536";
$conf['debug'] = "1";
$conf['install_lock'] = "1";
// $conf['db_hostname'] = "MySQLC8.webcontrolcenter.com";
$conf['db_hostname'] = "75.103.64.201";
$conf['db_username'] = "xxxx";
$conf['db_password'] = "xxxx";
$conf['db_name'] = "grdb";
$conf['db_type'] = "mysql";
$conf['db_prefix'] = "exp";
$conf['db_conntype'] = "0";
$conf['system_folder'] = "system";
$conf['cp_url'] = "http://galaxyrising.com/ee/system/index.php";
$conf['doc_url'] = "http://www.pmachine.com/expressionengine/docs/";
$conf['db_cache_refresh'] = "30";
$conf['is_system_on'] = "y";
$conf['cp_image_path'] = "http://galaxyrising.com/ee/images/cp_images/";
$conf['member_images'] = "http://galaxyrising.com/ee/images/member_images/";
$conf['enable_js_calendar'] = "y";
$conf['calendar_thumb_path'] = "http://galaxyrising.com/ee/images/cp_images/calendar.gif";
$conf['allow_extensions'] = "n";
$conf['multiple_sites_enabled'] = "n";
$conf['cookie_prefix'] = "";
?>

2) path.php

<?php

// ------------------------------------------------------
// DO NOT ALTER THIS FILE UNLESS YOU HAVE A REASON TO

// ------------------------------------------------------
// Path to the directory containing your backend files

$system_path = "./system/";

// ------------------------------------------------------
// MANUALLY CONFIGURABLE VARIABLES
// See user guide for more information
// ------------------------------------------------------

$template_group = "";
$template = "";
$site_url = "";
$site_index = "";
$site_404 = "";
$global_vars = array(); // This array must be associative

?>

Hi fastpete,

Everything looks good in your setup so far. You said that everything was working fine before your host upgraded to MySQL 5, right? If that’s the case, I’m sure some configuration was changed and is causing problems allowing any PHP to connect to the DB. Work with your host to create a database connection with a stand-alone PHP script first since this will take ExpressionEngine entirely out of the picture. Once you’re able to successfully do that, test EE’s connection again. If it still isn’t playing nice, let us know and we’ll take it from there!

Very many thanks Kevin. I have passed this on.

The old database was working fine for more than seven years. They are an excellent hoster and very responsive so I hope the next message says end of problem.

In my message at top I said this:

The IP provider agrees that the config.php appears to be correct and the database shows if they attempt a direct connection using the IP address instead of the hostname.

That is different from what you just suggested, right?

Peter

Well the hoster is always helpful and efficient and they came up with this:

After some digging and talking with the server team, we finally identified the issue being PHP4 not supporting the new PASSWORD hash requirements of MySQL5.

Although the MySQL upgrade to MySQL5 is done, the upgrade to PHP5 is still pending. You will have to request an upgrade to a newer plan before PHP5 is available.

Make that almost always efficient. Various support guys have been involved depending on whose shift it is

On 11 August I said okay to a plan change with PHP5 when they said moving to that plan would be required for PHP5.

I thought they had done this but they hadnt and I think my next post will say the plan change is done and all works.

The plan and site and software go way back to the beta version of EE by the way. Always very pleased with EE.

Peter,

Great stuff!. Ok lets leave this open for now until your upgrade is successfully completed so you can post a reply either way