unable to connect database

Hi Team,
 
Please have a look why we are not able to connect mysql database with your tool and at admin panel getting “No such file or directory”  and in error log.
And website ruing at magemojo server.
 
{“0″:”SQLSTATE[HY000] [2002] No such file or directory”,”1″:”#1 Zend_Db_Adapter_Pdo_Mysql->_connect() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:410]\n#2 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_connect() called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Abstract.php:460]\n#3 Zend_Db_Adapter_Abstract->query() called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238]\n#4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:546]\n#5 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_query() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:613]\n#6 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->query() called at [generated\/code\/Magento\/Framework\/DB\/Adapter\/Pdo\/Mysql\/Interceptor.php:128]\n#7
 
I’ll be waiting for your reply.
Thanks

15 answers

Profile photo of Mall Staff 184060.00 $tone August 12, 2020
Public

Hi there,

The issues you mentioned is strange. Did you get that issue after installing our module in your M2 instance?

Please try to update the permission of folder/files in your M2 root folder once again. If the issue still persists, please provide me information of your instance:

  • URL and Admin credentials of your M2 instance
  • SSH credentials of your M2 instance
  • Let me know the path to your M2 folder

I will help to check further and get back to you then.
PS. Please make sure you mark your reply private or simply switch this ticket to the private mode. Then it’s safe to share your site info here. Only you and our technical team can access it. 
Regards,
Mall.

#3
Profile photo of Mall Staff 184060.00 $tone August 12, 2020
Public

Hi there,

But we are facing another issue when we are running delta command everything works fine at SSH window but at the admin panel there no record updated. Even we run the indexing and cache flush/clean

That is strange. How did you run the delta migration in the steps you mentioned?
Do you want to run delta update for both migrated items or you just want to run delta migration for the newly added items in M1 only?

Regards,
Mall.

#5
Profile photo of Mall Staff 184060.00 $tone August 12, 2020
Public

Hi there,

We run the delta for products, customers, and sales but nothing gets updated with the latest record.

So you can run the delta migration at your end with these steps:

1. To run delta migration for Products, you run this CLI command:
php -f bin/ubdatamigration run --step=5;
2. After you finish Step #5, you continue with Step #6 using this command:
php -f bin/ubdatamigration run --step=6;
3. Once you finish Step #6, you continue Step #7:
php -f bin/ubdatamigration run --step=7;

Please note that if you get any error message on each step, please pause at that point and let me know, I will help to check further and get back to you then.
 
Regards,
Mall.
 
 
 

#7
Profile photo of coz6@9yi9756 320.00 $tone August 12, 2020
Public

Hi Mall,
We have an issue with delta migration as we have already done the data migration and now we have taken the latest M1 database backup and want to run the delta migration to add the products, customer, and sales after first migration.
Please understand the issue we want to run delta migration, not data migration and you can also check you have all the details.

Thanks

#8
Profile photo of coz6@9yi9756 320.00 $tone August 12, 2020
Public

Mall you have all the details please have a look and let us know what is the issue after successful delta migration the updated records not showing. even we did reindex as per your guide but no luck.
 
So please look and get back to us ASAP
Thanks
 

#10
Profile photo of ubdev Staff 98150.00 $tone August 13, 2020
Public

Hi there, 
Our team did check and suggest you the workaround accordingly. Please follow all the steps suggested in Mall’s reply #7 above at your end. If you run across any issue, please pause the process and let us know here. 
Actually, the migration process should be handled at your end. Due to our limited resources, we can only provide you help with the bug fixes if they are caused by our module. 
Thanks for your understanding.
Regards,
Ubertheme team

#11
Profile photo of coz6@9yi9756 320.00 $tone August 13, 2020
Public

Hi Ubertheme Team,
Thanks for your reply but I think you are responding without reading our previous comment on Mall’s reply, as he suggested us to run the fresh migration step, not for delta migration.
 
Our main issue is after running the delta migration with an updated M1 database and SSH we don’t have any issue with everything working fine but after reindex at the admin panel no latest record getting update.

So please understand our situation and help us to resolve it.
Thanks
 

#12
Profile photo of ubdev Staff 98150.00 $tone August 13, 2020
Public

Hi there, 

Mall’s reply, as he suggested us to run the fresh migration step, not for delta migration.

Mall’s reply #7 referred to the delta migration, not the fresh migration. 
So, please run all the steps noted in Mall’s reply and let us know how it goes then. For your convenience, we include Mall’s reply #7 below: 

So you can run the delta migration at your end with these steps:
1. To run delta migration for Products, you run this CLI command:
php -f bin/ubdatamigration run --step=5;
2. After you finish Step #5, you continue with Step #6 using this command:
php -f bin/ubdatamigration run --step=6;
3. Once you finish Step #6, you continue Step #7:
php -f bin/ubdatamigration run --step=7;
Please note that if you get any error message on each step, please pause at that point and let me know, I will help to check further and get back to you then.

Regards,
Ubertheme team

#13
Profile photo of coz6@9yi9756 320.00 $tone August 13, 2020
Public

Hi Team,
 
Please have a look at your readme.htm file for delta migration you have clearly mentioned steps

php -f bin/ubdatamigration run --step=5 --mode=update   

And we have used this CLI in so many websites for delta migration 

I don’t know why you are asking me to use the fresh migration CLI.

Please suggest

#14
Profile photo of Mall Staff 184060.00 $tone August 13, 2020
Public

Hi there,

php -f bin/ubdatamigration run --step=5 --mode=update   

That is a CLI command with the ‘update’ mode which helps to delta update both migrated products and newly added products in M1.

The CLI commands suggested in my reply #7 are those without the ‘update’ mode. It helps to continue on each step and delta migrate newly added items in M1 only.
 
Regards,
Mall.

#15

Please login or Register to Submit Answer

Written By

Comments