Magento Disable CDN
To see URLs configured on a Magento 2 installation, run the following SQL command
|
1 |
select * from core_config_data where path like '%_url'; |
Example
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
mysql> select * from core_config_data where path like '%_url'; +-----------+---------+----------+------------------------------------+------------------------------------------------------------------------+---------------------+ | config_id | scope | scope_id | path | value | updated_at | +-----------+---------+----------+------------------------------------+------------------------------------------------------------------------+---------------------+ | 10 | default | 0 | web/unsecure/base_url | https://buildingplans.com/ | 2021-11-09 19:39:03 | | 200 | default | 0 | payment/braintree/descriptor_url | NULL | 2020-10-14 06:23:31 | | 587 | default | 0 | web/unsecure/base_static_url | https://621984-2039577-raikfcquaxqncofqfm.stackpathdns.com/pub/static/ | 2021-08-05 10:18:30 | | 588 | default | 0 | web/unsecure/base_media_url | https://621984-2039577-raikfcquaxqncofqfm.stackpathdns.com/pub/media/ | 2021-08-05 10:18:30 | | 589 | default | 0 | web/secure/base_url | https://buildingplans.com/ | 2021-11-09 19:39:03 | | 591 | default | 0 | web/secure/base_static_url | https://621984-2039577-raikfcquaxqncofqfm.stackpathdns.com/pub/static/ | 2021-08-05 10:18:30 | | 592 | default | 0 | web/secure/base_media_url | https://621984-2039577-raikfcquaxqncofqfm.stackpathdns.com/pub/media/ | 2021-08-05 10:18:30 | +-----------+---------+----------+------------------------------------+------------------------------------------------------------------------+---------------------+ 8 rows in set (0.00 sec) mysql> |
In this case, the site use stackpath CDN.
To remove CDN, you can delete the entries related stackpathdns with SQL command
|
1 2 3 4 |
delete from core_config_data where path = 'web/unsecure/base_static_url'; delete from core_config_data where path = 'web/unsecure/base_media_url'; delete from core_config_data where path = 'web/secure/base_static_url'; delete from core_config_data where path = 'web/secure/base_media_url'; |
Now you need to re-deploy the static assets with
|
1 |
php bin/magento setup:static-content:deploy |
clear cache
|
1 |
php bin/magento cache:flush |