Database Archives

How to Retrieve Metadata of AWS EC2 Machine

Author - Webner
|
0 Comments
|

Metadata is data about your EC2 instance that is used to manage and configure the instance. Developers use the metadata in the script in order to configure the instances and their resources.

Please login to your EC2 machine and run the following command:

# curl http://169.254.169.254/latest Read more…

Call Apex Function inside an LWC Function

Author - Webner
|
0 Comments
|

While creating the LWC component whenever you want to call an apex function you use the @wire function in it and pass parameter in it which has @track or @api decorator attached with it like @track id; or @api id; and whenever there is any change in the parameter the Read more…

RabbitMQ

Author - Webner
|
0 Comments
|

You can think of RabbitMQ as a mediator between the two parties. One is known as the producer that produces goods and services and stores them into RabbitMQ. Another one is the consumer that consumes goods and services from the RabbitMQ.

So, RabbitMQ accepts, stores, and forwards binary blobs of Read more…

How to switch the Mysql authentication method from auth_socket to mysql_native_password

Author - Webner
|
0 Comments
|

In this article, we will come to know how we can switch the MySQL root user default (Auth_Socket) authentication method to mysql_native_password.

Auth_socket Authentication

Auth_socket authentication is a server-side default authentication plugin that is used to authenticate the client input in order to access databases. Auth_Socket authentication Read more…

Keyring Password Issue

Author - Webner
|
0 Comments
|

Use this if you have forgotten the password of the keyring in Ubuntu, but you want to safeguard a new keyring with a password.

For Ubuntu 18.04, I used the following.
Remove old keyring: For this, we need to change the directory to keyring location Read more…

How to exclude source when Syncing or Converting – DX

Author - Webner
|
0 Comments
|

While Syncing the metadata files between your local system and a target/Scratch org, you often want to exclude some of the source files. Similarly, you often have files to exclude when converting the source to the Salesforce DX project format. In both the above-said cases, you can exclude Read more…

How to export database schema with data in Microsoft SQL Server Management Studio

Author - Webner
|
0 Comments
|

Problem: When we use Microsoft SQL Server Management Studio to export the database, by default it will export the database schema only. When I was trying to export the database to import it into my other local machine, I faced this issue. I selected to export Read more…

Advantages of Azure SQL Database

Author - Webner
|
0 Comments
|

Azure SQL Database is a relational database provided as Database-as-a-Service, which is a part of Microsoft’s Cloud Infrastructure Platform, Microsoft Azure. It is also called SQL Azure. It provides database-backed managed service in the cloud with a petabyte-scale infrastructure. It is based Read more…

Salesforce CRM Features

Author - Webner
|
0 Comments
|

Growing your business isn’t simple. It needs boosting sales however it’s not simply selling the services or products to prospective and prevailing customers. A business is a scientific and economical method of collecting leads so they will be born-again to loyal customers and sales.

What does Read more…

Install Openssl with source code

Author - Webner
|
0 Comments
|

To install Openssl, we have to perform all steps with the root user. Please check the steps below:

sudo su (Do all operation with root user)
Change the directory to your desire location
cd /var/www/html/
Make two directories
mkdir Release
mkdir Sources
Go to the Sources folder and Read more…

Security token in Salesforce

Author - Webner
|
0 Comments
|

How to generate an access token?

Step 1: From Setup, enter Apps in the Quick Find box, then select App Manager.
Step 2: Locate the OAuth connected app in the apps list, click and select View.
Step 3: In the Initial Access Read more…

Azure Event Hubs

Author - Webner
|
0 Comments
|

Introduction:

Event Hubs is a real-time data ingestion service that is fully managed, simple, scalable, and trusted. It can stream, process, and receive millions of events per second from any of the sources, which builds data pipelines that are dynamic in nature. These pipelines are favourable to Read more…

Mysql | #1553 – Cannot drop Index

Author - Webner
|
0 Comments
|

Issue:

#1553 – Cannot drop index ‘index_name’: needed in a foreign key constraint

An issue is generally faced when we are going to drop a unique index from a table. For example, here I have the table articles that have the following structure:

Column
Data type
Specifications

id
int Read more…

How to Run Multiple versions of MySQL on the Same Server?

Author - Webner
|
0 Comments
|

Solution:
If your system is having a current version of MySQL installed i.e 5.6 and you also need 5.5 version then follow the below steps.
You can also play with different versions also.

Installing Docker

To install Docker on your machine Read more…

How do you convert ACLs of any key on S3?

Author - Webner
|
0 Comments
|

Introduction to ACLs of Key on S3

Many times when you need to change the access control list (ACL) of a key on the S3 to make it public to private or private to public. This is easy as we provide this control at the time when we Read more…

Firebase Cloud Messaging With Laravel 6

Author - Webner
|
1 Comment
|

Introduction to Firebase Cloud

Earlier known as Google Cloud Messaging and now called Firebase Cloud Messaging (FCM) is a messaging solution for cross-platform provided by Google itself. This service lets you reliably deliver messages or notifications at no cost. One can use FCM for sending push notification Read more…

Firebase Integration With Laravel 6.x (Ubuntu 18.04)

Author - Webner
|
0 Comments
|

Below are the steps to integrate Firebase with Laravel 6.x

Step 1

To integrate Firebase with Laravel we first need a Laravel project. Create a new Laravel project using the given composer command.

composer create-project –prefer-dist laravel/laravel firebase

Step 2

Read more…

Advanced SQL – Indexes and Triggers

Author - Webner
|
0 Comments
|

Introduction

The SQL database provides a lot of commands and functions. With the help of them, we can manage a huge amount of data easily in the database. Following are some of the examples:

INDEX:

In the SQL database Index is like a schema object. It Read more…

MySQL: only_full_group_by issue on joins

Author - Ishpreet Kaur
|
0 Comments
|

Issue

#1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After upgrading ubuntu 14.04 to 18.04 and MySQL 5.5 to Read more…

PHP: mysqli_multi_query stops the execution of further MySQL queries.

Author - Ishpreet Kaur
|
0 Comments
|

The mysqli_query statement

Generally, we use mysqli_query to execute Mysql queries in PHP. We can use multiple mysqli_query statements to execute multiple operations like insert, update, and select. Sometimes, we store records in more than one table during save operation at the backend, but it is Read more…