ImportCumulusFile.php can't connect to DB
Posted: Tue 12 Dec 2017 2:54 am
I have had Toolbox Remote Command run ImportCumulusFile.php to import the realtime.txt and dayfile.txt to my GoDaddy MySQL database and that has worked well. I have recently updated my hosting to cPanel and everything is working again, except the DB import is giving a
In ImportCumulusFile.php I have only changed $dbhost and $dbpassword from:
to:
I have talked to GoDaddy and they say to use "localhost" for the new hosting, and have double checked my Username and Password. Have I missed something or are other changes to be made in either Toolbox or ImportCumulusFile.php?
Thanks,
Paul
The Toolbox Remote Command settings have not been changed.12/12/17 - 01:42:07
Importing to table: realtime ...
Processing realtimefile: realtime.txt
Error: Failed to connect to the database server
In ImportCumulusFile.php I have only changed $dbhost and $dbpassword from:
Code: Select all
// EDIT THIS NEXT SECTION CAREFULLY
// ----------------------------------------------------------------
// Your security key you will pass in the URL, change this to
// something unique to you
$key = 'a unique key';
// The server host name or number running your MySQL database
// usually 127.0.0.1 or localhost will suffice
$dbhost = 'KomokaWeather.db.5379896.hostedresource.com';
// The username used to log-in to your database server
$dbuser = 'KomokaWeather';
// The password used to log-in to your database server
$dbpassword = 'my unique password';
// The name of the MySQL database we will store the tables in
$database = 'KomokaWeather';
Code: Select all
// EDIT THIS NEXT SECTION CAREFULLY
// ----------------------------------------------------------------
// Your security key you will pass in the URL, change this to
// something unique to you
$key = 'same unique key';
// The server host name or number running your MySQL database
// usually 127.0.0.1 or localhost will suffice
$dbhost = 'localhost';
// The username used to log-in to your database server
$dbuser = 'KomokaWeather';
// The password used to log-in to your database server
$dbpassword = 'my unique password for new database';
// The name of the MySQL database we will store the tables in
$database = 'KomokaWeather';
Thanks,
Paul