cannot connect to SQL Server

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

Profile photo of Mall Staff 159450.00 $tone December 18, 2020
Public

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.

#1
Profile photo of Mall Staff 159450.00 $tone December 18, 2020
Public

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.

#3
Profile photo of rgross 240.00 $tone December 18, 2020
Public

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?

#4
Profile photo of ubdev Staff 76860.00 $tone December 21, 2020
Public

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
 

#5
Profile photo of rgross 240.00 $tone January 14, 2021
Public

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

#6
Profile photo of Mall Staff 159450.00 $tone January 14, 2021
Public

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.

#7
Profile photo of ubdev Staff 76860.00 $tone January 14, 2021
Public

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

#9
Profile photo of ubdev Staff 76860.00 $tone January 14, 2021
Public

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

#13
Profile photo of ubdev Staff 76860.00 $tone January 14, 2021
Public

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

#14
Profile photo of rgross 240.00 $tone January 14, 2021
Public

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.
 
?

#15
Profile photo of ubdev Staff 76860.00 $tone January 14, 2021
Public

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

#16
Profile photo of Mall Staff 159450.00 $tone January 14, 2021
Public

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.

#18
Profile photo of Mall Staff 159450.00 $tone January 18, 2021
Public

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.

#20
Profile photo of ubdev Staff 76860.00 $tone 6 days ago
Public

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

#21
Profile photo of rgross 240.00 $tone 6 days ago
Public

I ended up commenting out the entire section and that worked.
I will gladly answer the survey.
Thank you again for your assistance.

#22
Profile photo of ubdev Staff 76860.00 $tone 6 days ago
Public

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

#23

Please login or Register to Submit Answer

Written By

Comments