Hi,
I’m having difficulty opening the UB data Migration Pro plugin after moving the site production server. I’m getting a string of errors, the first of which is “CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2002] Connection timed out”. the line throwing the exception is the line below:
throw new CDbException(‘CDbConnection failed to open the DB connection: ‘.
Please could you kindly advise.
Thanks.
Kind regards,
Dacod
7 answers
Hi there,
connection: SQLSTATE[HY000] [2002] Connection timed out”. the line throwing the exception is the line below:
throw new CDbException(‘CDbConnection failed to open the DB connection: ‘.
Seem you have missed enable remote connection to M1’s MySQL server from your new M2’s server.
Regards,
Mall.
Hi Mall,
Thanks for your reply.
How exactly do I do this?
Hi there,
How exactly do I do this?
Is your M1’s database on the same server with your Magento2 instance now? If not, it’s required to enable remote connection to M1’s MySQL server from M2’s server. You could learn about how to enable remote connection in MySQL following this guide:
http://devdocs.magento.com/guides/v2.0/install-gde/prereq/mysql_remote.html or https://easyengine.io/tutorials/mysql/remote-access/
Regards,
Mall.
Hi Mall,
We’ve followed the steps detailed on the link you forwarded us but the issue seem to be persisting.
Kindly note that both the Magento 2 and Migento 1 sites were migrated from the server in which the plugin was initially installed and the initial migration was done, hence both the Magento 1 and Magento 2 sites have different database login details now. I seem to think this is the problem. Is there a way we can update the database details for the sites in the database?
Hi there,
Is there a way we can update the database details for the sites in the database?
Our migration tool has a database config file at path: pub/ub-tool/protected/config/db.php
You could re-correct your new databases credentials in that config file.
Once done, you could continue with our tool.
Regards,
Mall.
Hi Mall,
Thank you! I’ve added both database details to the php file.
Howerver now we are getting the error below.
The table “{{ub_migrate_step}}” for active record class “UBMigrate” cannot be found in the database.
I am not sure as to why the table would not be there as we did not do any customization to the plugin or its tables.
Hi there,
The table “{{ub_migrate_step}}” for active record class “UBMigrate” cannot be found in the database.
Kindly re-check, seem your new M2’s database has a table prefix and you have missed declare this in the database config file of our tool.
In case you still solve that issue, let’s provide me the information as followings:
+ Admin credentials and site URL
+ SSH credentials and web root path of your M2’s instance
I will check further and help you out.
Regards,
Mall.
