remote access is enabled and I am getting the error message:
Host ‘li1922-52.members.linode.com’ is not allowed to connect to this MySQL server
23 answers
Hi there,
Host ‘li1922-52.members.linode.com’ is not allowed to connect to this MySQL server
Please contact the system admin of your M1 server for further help to enable the remote connection from your M2 server to the M1 MySQL server.
Regards,
Mall.
I have and they have already enabled remote connection.
I am still getting this error.
Hi there,
I have and they have already enabled remote connection.
I am still getting this error.
Since this refers to the server-side issue, and only your hosting provider can help with it.
Please provide the error details to your hosting provider once again.
Alternatively, please consider proceeding with the data migration on the same server (if possible) since this is a better option in terms of performance.
Regards,
Mall.
My hosting provider says they have done all they can by enabling remote access.
And I do not have the option of same server migration.
So I am a bit stuck -- any other suggestions?
Hi there,
We are sorry for replying to you this late. As explained in our previous reply, enabling remote access was a server-side issue so only your hosting provider can assist further in this case.
Can you consider proceeding with migration on the same server? A plus point of this option is that you no longer need to enable the remote connection. Besides, this allows for better performance during the migration process.
Thanks for your understanding.
Regards,
Ubertheme team
I have downloaded the database and uploaded to my server so that issue is no longer present.
I now have a new issue:
After I add the database details all further pages show this error:
Error 500
The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database.
Should I open a new ticket about this?
Or can you assist me with this here?
Thank you
Hi there,
I now have a new issue:
After I add the database details all further pages show this error:
Error 500
The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the
It seems that your current M1 DB has a database prefix and you have not filled in this prefix in step #1 setting of our module: http://prntscr.com/wn2vrc. Please check again.
Regards,
Mall.
the database does indeed have a prefix but it is filled in.
Hi there,
the database does indeed have a prefix but it is filled in.
So, please cross-check if you specified the correct prefix. If the prefix is correct, please check if your M1 db has a table named `core_website`?
Regards,
Ubertheme team
It does not have that table. what can i do?
It does have that table- not sure why I didn’t see it at first.
The table has two rows
I have found the issue.
I accidentally omitted the underscore from the table prfix field
thank you so much for your assistance
Hi there,
It does not have that table. what can i do?
That means you have not successfully exported the DB in your live M1 instance and imported it to the DB instance of your M2 server.
You need to re-export and re-import the DB.
Regards,
Ubertheme team
Hi there,
I have found the issue.
So, please discard our previous reply #13 and continue the migration process following the Readme manual (packed with your download package).
In case you have any additional question, please submit a new ticket, we will follow up with you then.
Regards,
Ubertheme team
how about this error when running step 5 of the migration:
The table “{{inventory_source_item}}” for active record class “Mage2InventorySourceItem” cannot be found in the database.
?
Hi there,
The table “{{inventory_source_item}}” for active record class “Mage2InventorySourceItem” cannot be found in the database.
That occurred because you had not installed the MSI module in your M2 instance. Please consider installing this module following the Magento guide here.
Regards,
Ubertheme team
I do not actually want to use that module.
Can I proceed without doing that?
Hi there,
I do not actually want to use that module.
Can I proceed without doing that?
Yes, you can do with the following steps:
1. Open the PHP file at pub/ub-tool/protected/controllers/Step5Controller.php
and find the code line:
$msiEnabled = 1; //1- enabled MSI module, 0 - disabled MSI module
and replace it with:
$msiEnabled = 0; //1- enabled MSI module, 0 - disabled MSI module
2. And then, you can continue with the data migration in step #5 by running the CLI command:
php -f bin/ubdatamigration run --step=5;
Regards,
Mall.
I am getting the exact same results.
Anything else I can try?
Hi there,
I am getting the exact same results.
Anything else I can try?
I have just edited the code line suggested in reply #18 (and replace it with:
$msiEnabled = 0;
Please try to apply those steps once again.
Regards,
Mall.
Hi there,
We wonder if Mall’s workaround in his reply #20 worked fine for you. If the issue still persists, please get back to us here.
Meanwhile, our team is working on a new plan for 2021, if possible, could you please help us answer a few quick questions via this survey?
Your feedback is crucial for us, so we hope you can share with us your thoughts on those questions.
Sincerely,
Ubertheme team
I ended up commenting out the entire section and that worked.
I will gladly answer the survey.
Thank you again for your assistance.
Hi there,
We’re glad to hear that. We look forward to your feedback at your earliest convenience.
PS. For any technical questions you might have related to your migration project, please get back to us here.
Regards,
Ubertheme team