Monthly Archives: January 2019

General

Virtualization

Leave a comment

In computing, virtualization refers to the act of creating a virtual (rather than actual) version of something, including virtual computer hardware platforms, storage devices, and computer network resources.

Virtualization began in the 1960s, as a method of logically dividing the system resources provided by mainframe computers between different applications. Since then, the meaning of the term has broadened

Virtualization lets you run several operating systems on the same hardware in parallel.

Virtualization allows separation of services, tasks and users in distinct virtual machines.

General

Linux distribution

Leave a comment

A Linux distribution (often abbreviated as distro) is an operating system made from a software collection, which is based upon the Linux kernel and, often, a package management system.

These distributions contain software versions that have proven to be stable even if it is not the recent version in order to minimize problems.

General

LAMP

Leave a comment

The combination of Linux, Apache, MySQL and PHP or other programming languages.

LAMP is an archetypal model of web service stacks, named as an acronym of the names of its original four open-source components: the Linux operating system, the Apache HTTP Server, the MySQL relational database management system (RDBMS), and the PHP programming language. The LAMP components are largely interchangeable and not limited to the original selection. As a solution stack, LAMP is suitable for building dynamic web sites and web applications.

Since its creation, the LAMP model has been adapted to other componentry, though typically consisting of free and open-source software. For example, an equivalent installation on the Microsoft Windows family of operating systems is known as WAMP and an equivalent installation on macOS is known as MAMP.

General

Cloud computing

Leave a comment

Cloud computing is shared pools of configurable computer system resources and higher-level services that can be rapidly provisioned with minimal management effort, often over the Internet. Cloud computing relies on sharing of resources to achieve coherence and economies of scale, similar to a public utility.

Cloud Computing provides new tools to manage IT resources.

From the business perspective, Cloud Computing means outsourcing or centralization of IT operations.

My SQL

check last executed query mysql

Leave a comment

You can controll this option at run time.

If you prefer to output to a table:

Execute SET GLOBAL log_output = 'TABLE';
Execute SET GLOBAL general_log = 'ON';
Take a look at the table mysql.general_log

If you prefer to output to a file instead of a table:

SET GLOBAL log_output = "FILE"; the default.
SET GLOBAL general_log_file = "/path/to/your/logfile.log";
SET GLOBAL general_log = 'ON';
Magento

magento setup upgrade Unexpected error. Unable to create oAuth consumer account.

Leave a comment

I have encountered this issue while community to enterprise migration and it was happening since the base table ‘oauth_consumer‘ was not available.

CREATE TABLE oauth_consumer (   entity_id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
   created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
   updated_at timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
   name varchar(255) NOT NULL COMMENT 'Name of consumer',
   key varchar(32) NOT NULL COMMENT 'Key code',
   secret varchar(32) NOT NULL COMMENT 'Secret code',
   callback_url text COMMENT 'Callback URL',
   rejected_callback_url text NOT NULL COMMENT 'Rejected callback URL',
   PRIMARY KEY (entity_id),
   UNIQUE KEY OAUTH_CONSUMER_KEY (key),
   UNIQUE KEY OAUTH_CONSUMER_SECRET (secret),
   KEY OAUTH_CONSUMER_CREATED_AT (created_at),
   KEY OAUTH_CONSUMER_UPDATED_AT (updated_at)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Consumers';
Magento

Magento 2 Requested store is not found

Leave a comment

This issue can be fixed by issuing the following queries

UPDATE store SET store_id = 0 WHERE code='admin';
UPDATE store_group SET group_id = 0 WHERE name='Default';
UPDATE store_website SET website_id = 0 WHERE code='admin';

It can also be solved by modify StoreManager.php (/vendor/magento/module-store/Model/StoreManager.php)

If $storeId is not defined: It retrive data from COOKIE first, otherwise return the default store code. 

if (!isset($storeId) || '' === $storeId || $storeId === true) {
     if (null === $this->currentStoreId) {
\Magento\Framework\Profiler::start('store.resolve');
         $this->currentStoreId = $this->storeResolver->getCurrentStoreId();    \Magento\Framework\Profiler::stop('store.resolve');
     }
     $storeId = $this->currentStoreId;
 }

To

if(!$storeId) {
 if(isset($_COOKIE['store']) && $_COOKIE['store'] !== ''){
         $storeId = $_COOKIE['store'];
     } else {
         $storeId = $this->getDefaultStoreView()->getCode();
     }           
 }
Magento

Magento 2 css not working

Leave a comment

I have fixed the issue by modifying option in config Stores>Configuration -> Advanced -> Developer ->Sign Static Files (dev_static_sign) -> No.

As the admin panel was not accessible I made this change at DB level.

insert into core_config_data (config_id, scope, scope_id, path, value) values (null, 'default', 0, 'dev/static/sign', 0);