Best Planets News

Redmi Note 9 Shadow Black, 4GB RAM, 64GB Storage

khurana.r292@gmail.com (Webshine Team) — Mon, 29 Mar 2021 05:15:00 +0000

48MP quad rear camera with ultra-wide, depth sensor, macro mode, portrait, night mode, AI scene recognition, HDR, pro mode | 13 front camera

Redmi 9 (Sky Blue, 4GB RAM, 64GB Storage)

khurana.r292@gmail.com (Webshine Team) — Mon, 29 Mar 2021 05:11:00 +0000

Redmi 9 (Sky Blue, 4GB RAM, 64GB Storage) | Extra INR 300 Cashback as Amazon Pay Balance

InnoDB's default Row Format in MySQL 5.6 and 5.7

khurana.r292@gmail.com (Webshine Team) — Thu, 04 Jul 2019 06:51:00 +0000

The default row format for InnoDB tables

in MySQL 5.6 is COMPACT
in MySQL 5.7 is DYNAMIC

Default InnoDB Row Format has been changed in MySQL 5.7. let me explain why, and provide you some more background information and good-to-know things.

What is row format?

The row format of a table determines behaviour of physically stored. This can affect the performane of queries and DML operations. As more rows fit into a single disk page:

queries and index lookups can work faster.
less cache memory is required in the buffer pool.
less I/O is required to write out updated values.

Supported row formats

The InnoDB storage engine supports four row formats: REDUNDANT, COMPACT, DYNAMIC, and COMPRESSED.

Here's a quick overview:

Row Format	REDUNDANT	COMPACT	DYNAMIC	COMPRESSED
Compact Storage Characteristics	No	Yes	Yes	Yes
Enhanced Variable-Length Column Storage	No	No	Yes	Yes
Large Index Key Prefix Support	No	No	Yes	Yes
Compression Support	No	No	No	Yes
Supported Tablespace Types	system, file-per table, general*	system, file-per-table, general*	file-per-table, general*	file-per-table, general*
Required File Format	Antelope or Barracuda	Antelope or Barracuda	Barracuda	Barracuda

*only available in MySQL 5.7

Default value

The default row format for InnoDB table sis defined by innodb_default_row_formatvariable. The default value is different in MySQL 5.6 and 5.7. If you are now aware of this difference, and you use the default value in MySQL 5.6, you can encounter problems like the following:

Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

The different default value between MySQL 5.6 and 5.7

The default row format for InnoDB tables in MySQL 5.6 is COMPACT and in MySQL 5.7 is DYNAMIC.

Determining the Row Format of a Table

You can determine the row format of a table, by using SHOW TABLE STATUS:

mysql> SHOW TABLE STATUS IN test1\G
*************************** 1. row ***************************
           Name: t1
         Engine: InnoDB
        Version: 10
     Row_format: Dynamic
           Rows: 0
 Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 16384
      Data_free: 0
 Auto_increment: 1
    Create_time: 2016-09-14 16:29:38
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: 
        Comment:

Alternatively, you can query the INFORMATION_SCHEME.INNODB_TABLES table

mysql> SELECT NAME, ROW_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME='test1/t1';
+----------+------------+
| NAME     | ROW_FORMAT |
+----------+------------+
| test1/t1 | Dynamic    |
+----------+------------+

Define the row format of a table explicitly

You can explicitly define the row format of a table, by using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. For example:

CREATE TABLE t1 (c1 INT) ROW_FORMAT=DYNAMIC;ALTER TABLE t1 ROW_FORMAT=DYNAMIC;

Diffrence Between Marketing and Digital Marketing

khurana.r292@gmail.com (Webshine Team) — Wed, 03 Jul 2019 15:27:00 +0000

Here, digital marketing related to internet and marketing represent to pamphlet or offline advertisement.

Marketing :

Marketing is a process. we have to make a plan from day one and do more work in respective of marketing for small business and large organisations as well.

Too many people have good business plan but due to lack of marketing, people can't expand those services and got failure in business while through digitalisation, people can easily broadcast and can reach to large number of audience.

Digital Marketing :

Now a days all things are migrating online. Internet is making our life easy. We can grab too many benefits through Internet.

We can do Multiple activities through this Technology like : Online Shopping, Recharge, Bill Payment, Online Ticket, Bill Transaction Etc.

Before accepting any offer or before purchasing any services user too much research and check the revenue on Internet which is possible due to digitalisation only.

To broadcast your service digital marketing is a easy way to get more audience globally.

We can connect user through Internet to Provide them our services.We can more focus on targeted Audience for our business which was difficult offline.

Initially digital marketing started by giving advertisement on cable TV which was too expensive and dependent on cable operator while now days we have open world and large number of resources like social networking, blog writing, website or you can say we have world web wide So that we can expand our business globally.

We have too many information sources in this world from where we can get required details anytime anywhere this is only possible due to digitalisation.

The Top Most Romantic songs in Hindi Film Industry

khurana.r292@gmail.com (Webshine Team) — Sat, 01 Jun 2019 16:07:00 +0000

Are you looking for Best Romantic Songs in Bollywood Industry?

Most Romantic Hindi Songs List

Let us have a look at some of the best romantic songs of all time. These songs are big hits of those eras of Bollywood.

1. Song : Barish

Lyrics of Barish

Chehre mein tere
Khud ko main dhundun
Aankhon ke darmiyan
Tu ab hai iss tarah
Khwabon ko bhi jagah na mile

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

2. Song : Agar Tum Saath Ho

Lyrics of Agar Tum Saath Ho

Pal Bhar Thahar Jaao,
Dil Ye Sambhal Jaaye,
Kaise Tumhe Roka Ka,
runMeri Taraf Aata Har,
Gham Phisal Jaaye,

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

3. Song : Muskurane Ki Wajah Tum Ho

Lyrics of Muskurane Ki Wajah Tum Ho

Gungunane ki wajah tum ho
Jiya jaaye na, jaaye na,
jaaye na..
O re piya re..
Jiya jaaye na, jaaye na, jaaye na..
O re piya re..

Muskurane ki wajah tum ho

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

4. Song : Hua Hai Aj Pehli Bar

Lyrics of Hua Hai Aj Pehli Bar

Hua hai aaj pehli baar
Jo aise muskuraya hoon
Tumhe dekha toh jaana ye
Ke kyun duniya mein aaya hoon

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

5. Song : Pee Loon, Once Upon A Time In Mumbai

Lyrics of Pee Loon

Pee Loon Tere Neelay Neelay Nainon Se Shabnam
Pee Loon Tere Geelay Geelay Hoto Ki SargamPee Loon Hai Peenay Ka MausamTere Sang Ishq Taari HaiTere Sang Ik Khumari Hai

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

6. Song : Jeene Laga Hoon Pehle Se Zyada

Lyrics of Jeene Laga Hoon Pehle Se Zyada

Jeene laga hoon pehle se zyada

Pehle se zyada tum pe marne laga hoon

Main, mera dil aur tum ho yahaan

Phir kyun ho palkein jhukaaye wahaan
Tum sa haseen pehle dekha nahin
Tum is se pehle the jaane kahaan..

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

7. Song : Hum Tere Bin Ab Reh Nahi Sakte

Lyrics of Hum Tere Bin Ab Reh Nahi Sakte

Hum tere bin ab reh nahi sakte
Tere bina kya wajood mera Tujhse juda gar ho jaayenge
Toh khud se hi ho jaayenge judaa

Top 5 mobiles under Rs. 20000 in India

khurana.r292@gmail.com (Webshine Team) — Sat, 01 Jun 2019 15:09:00 +0000

Xiaomi's Poco F1

Expert comment: Xiaomi's Poco F1, also called Pocophone F1, is the best value-for-money smartphone available in the market. The handset comes with flagship-grade Snapdragon 845 processor at an extremely affordable price point. Xiaomi's new sub-brand's first smartphone does not only offer great performance but also packs some capable cameras and a massive 4,000mAh battery. If you like gaming on your handset and have certain budget constraints, this might be the best smartphone available for you.

Honor Play

Expert comment: The newly launched Honor Play is among the very few handsets in the market that can be claimed to offer true value for your money. The handset brings along the flagship-grade HiSilicon Kirin 970 processor that can easily tackle demanding games and apps. There is respectable battery capacity as well as impressive memory on board to ensure there are no hiccups in terms of performance requirements. You also get dual rear cameras at the back that are powered by the company's AI Master feature to help you click better pictures in different conditions.

Xiaomi Redmi Note 7 Pro

Expert comment: Xiaomi faced some stiff competition in this price range last year but the brand's new Redmi Note 7 Pro is already looking like the best mid-range smartphone launched this year. The handset comes with an extremely capable Snapdragon 675 SoC a whopping 48MP rear camera for capturing details. The phone comes with a glass sandwich design and has Gorilla Glass 5 protection on both sides. If you are looking for an all-rounder phone under Rs 15,000, Redmi Note 7 Pro is probably your best bet.

Samsung Galaxy A 50

Expert comment: Samsung's new mid-range crusader comes with a premium design and sleek body that holds a gorgeous full-HD+ Super AMOLED panel. Apart from an in-display fingerprint sensor, the inclusion of One UI makes this phone attractive buy. There is a triple camera setup at the back of the phone that consists of a primary sensor, depth sensor, and an ultra-wide sensor, which ensures that the handset remains a capable shooter in all kinds of situations. With all these capabilities, Galaxy A50 is one of the best options available at this price.

Samsung Galaxy A 30

Expert comment: Samsung's Galaxy A30 smartphone comes with a glossy polycarbonate back that gives a premium look to the handset. Taking cues from Galaxy A50, the Galaxy A30 also features a 6.4-inch FHD+ Super AMOLED display with a tiny notch to offer a fullscreen immersive experience. The Galaxy A30 also comes with a 4,000mAh battery to provide ample battery backup and supports fast charging too. Overall, the phone offers good value for money in this range.

80% Indians have more than 1 device simultaneously: Study

khurana.r292@gmail.com (Webshine Team) — Sat, 01 Jun 2019 14:35:00 +0000

Three in four adult consumers in India constantly use more than one device simultaneously and spend almost 90 per cent of their workday interacting with devices, said an Adobe study on Friday.

Smartphones have also emerged as the most preferred medium for all shopping activities with 89 per cent of consumers currently being able to do all the retail activities they want on mobile, showed the findings based on a survey of 1,000 adult consumers in India.

The study revealed that more than half of adults surveyed regularly use voice commands.

"The rapid proliferation of advanced technologies and their increased usage on mobile devices, points to potential new areas for marketers to engage with consumers," said Sunder Madakshira, Head, Marketing, Adobe India.

"Considering the fast consumer adoption of voice tech, we expect to start seeing more brands experimenting with immersive ways of customer engagement over the next few years," Sunder added.

Squid Proxy Server

khurana.r292@gmail.com (Webshine Team) — Sat, 07 Jul 2012 06:09:00 +0000

Squid Proxy Server

It's used to provide the internet connectivity to network connected system ny using single internet connection.

· Package Required:- squid

· Daemon name :--squid

· Port Number:-- 3128

· Path of config file:- /etc/squid/squid.conf

Key Point:--

1. Install squid proxy

2. on and start service by:- #service squid start

3. Give two IPs one for internet and another for LAN

How To Block internet Access for a specific IP or Network

Edit in config file:-- #vim /etc/squid/squid.conf

· Create ACL in file:- acl newaclname src IP/Network Id (which you want to block)

· Give permision to this acl late in file:-- http_access deny newaclname

Save file and restart service

How To Block domain or site

1. If we want to block a perticular site then create a acl in file only:-- acl site dstdomain *.example.com

2. then Give permissions:-- http_access deny site

NOTE:--- “site” is acl name

If we want to block numbers of sites then first have to create a file and write the entries like:

· .google.com

· .yahoo.com

· .facebook.com

then save and exit

Create a acl in config file like:- acl aclname dstdomain “file path”

5 steps to secure your Linux server

khurana.r292@gmail.com (Webshine Team) — Fri, 06 Jul 2012 19:17:00 +0000

5 steps to secure your Linux server

How would you ensure security of your production Linux Server? Should you can be happy with default configuration there in place or there’s are things which we must implement for enhancing security aspects? Of course, Yes. Here I’m writing 5 steps which I usually take to tighten security in Server. This doesn’t means these are Best thing you can do or You don’t need to do anything else. There are many ways and remember securing your Server is a never ending process, So keep an eye open and check your Server regularly.

Step 1. Disable direct root access.
Login should be allowed using simple/wheel user and then from there you can switch to root or use sudo to execute commands under root privileges. Let’s disable direct root login:

$ vi /etc/ssh/sshd_config
Look for "PermitRootLogin yes" line in it and change it to "PermitRootLogin no".

Save the file, check for syntex and reload sshd service to make it effective:

$ sshd -D -f /etc/ssh/sshd_config
$ service sshd reload

You can create a new user now which will be used for login, leave it if there’s already a user for this purpose. Don’t forget to have a strong password for root and for this user as well.

$ useradd usertogetin
$ passwd usertogetin

Our step 1 is completed, but why it’s a necessary? A direct access to root user with a weak password is sure-shot invite for compromising security and get inside your server easily. Another powerful way to make it more difficult to hack in server is to change default ssh port 22 to something else, you can find the steps here to do that.

You should also keep looking into security related logs like /var/log/securefor clue about possible attempt of logins from remote places.

Let me show you something:

$ tail /var/log/secure
Feb  6 07:41:56 ip-184-x-xx sshd[20421]: Failed password for root from xx.xx.xx.xx port 48976 ssh2
Feb  6 07:41:57 ip-184-x-xx-x sshd[20422]: Received disconnect from xx.xx.xx.xx: 11: Bye Bye
Feb  6 07:41:57 ip-184-x-x-x sshd[20424]: reverse mapping checking getaddrinfo for 184-xx-xx-xx.abcd.net failed - POSSIBLE BREAK-IN ATTEMPT!

It shows somebody is trying to get in your server by trying random password for root user. You can block such IPs but most important step is to block root access and use strong passwords.

Example of another instance:

$ tail /var/log/secure
Feb  6 07:46:58 ip-184-168-71-156 sshd[20769]: input_userauth_request: invalid user deathrun
Feb  6 07:46:58 ip-184-168-71-156 sshd[20768]: pam_unix(sshd:auth): check pass; user unknown
Feb  6 07:46:58 ip-184-168-71-156 sshd[20768]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=184.xx.xx.xx

Here login attempts are done using random username and password. It implies that do not name your entry/wheel username as obvious one, choose somewhat difficult but what you can remember text for your username. Of course, Password must be strong which should includes chars,numbers and special symbols.

There should be mechanism to block an IP from where hacking/cracking/invalid/failed login attempts come from. If you see that there are 10s of failed login attempt from a particular IP address, then you should block it immediately. To facilitate this thing automatically, there a very good tool available, called as DenyHosts. I’ve already written an article explaining how to download/install/configure DenyHosts in Server. Its a must have package in any prod server.

Step 2. Remove login shell from all other users except wheel user.
You have disabled the remote access to root but do you know through how many users, a person can get inside to your server? many application while installation creates their user but with a major security flaw, they set login shell to ‘bash’ and this loophole can be exploited.

[root@ip-184-168-71-156 log]# grep 'bash' /etc/passwd
root:x:0:0:root:/root:/bin/bash
usertogetin:x:500:500::/home/usertogetin:/bin/bash

Here you can see only two entries, which are fine but if you see more lines here like with users mysql, ftp, postgre etc. then please change shell of these users to nologin so by using these users, login can’t be done.

# usermod -s /sbin/nologin mysql

Here we have modified shell of user MySQL from /bin/bash to /sbin/nologin. You should do this for other users as well except root and wheel user you created earlier.

Step 3. Check open ports and stop unused services.

$ netstat -ant
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address               Foreign Address             State      
tcp        0      0 184.xx.xx.xx:53             0.0.0.0:*                   LISTEN      
tcp        0      0 184.xx.xx.xx:53             0.0.0.0:*                   LISTEN      
tcp        0      0 127.0.0.1:53                0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:21                  0.0.0.0:*                   LISTEN      
tcp        0      0 0.0.0.0:25                  0.0.0.0:*                   LISTEN      
tcp        0      0 :::80                       :::*                        LISTEN      
tcp        0      0 :::22                       :::*                        LISTEN      
tcp        0      0 :::443                      :::*                        LISTEN      
tcp        0      0 ::ffff:xx.xx.xx.xx:80       ::ffff:xx.xx.xx.xx:52502    TIME_WAIT   
tcp        0   3152 ::ffff:xx.xx.xx.xx:22       ::ffff:xx.xx.Xx.xx:5222     ESTABLISHED
..
..

Apart from whatever showing above, your list may have many such lines with different ports with Listen/Established state. Here we used netstat command to list all active/listen/established ports with their IP addresses. You can see here some well known port numbers like 53 (DNS), 21 (FTP), 25 (SMTP), 80 (HTTP), 22 (SSH), 443 (HTTPS). These seems fine but if you doesn’t need any of these services, stop that program. In case you see some unusual listening ports, then you should verify their applications and stop them if they are not necessary.

Here by look at port numbers, you can’t get the information about which application is associated with any particular port number. Just for example, we want to know, which application is listening or using the port number 443. We can get this information by lsof command:

$ lsof -i :443
# lsof -i :443
COMMAND   PID   USER   FD   TYPE DEVICE SIZE NODE NAME
httpd    4335 apache    6u  IPv6 369447       TCP *:https (LISTEN)
httpd    6888   root    6u  IPv6 369447       TCP *:https (LISTEN)
httpd    7343 apache    6u  IPv6 369447       TCP *:https (LISTEN)
...
...

So port 443 is used by httpd (Apache) application/process to provide secure http services.

Step 4. Solid Backup Plan
Ensure that your server have a solid backup plan. All important files/databases/scripts etc. should be included in backup and it should be frequent. I have written a script which can help you to take frequent backup of essential log files/database. You can find it here with its usage.

Step 5. Regular upgrades
Ensure that regular upgrades/security patches/fixes of packages must be applied on time to so that all known vulnerabilities are fixed. You can check sites like http://www.securityfocus.com/ for such vulnerabilities.

Installation of more advanced packages like SELinux and/or AppArmour and/or rootkit detection etc. will provide you higher level of security.

Please note that nothing can ensure a 100% secure server but the steps listed above can ensure that your server have adequate security mechanism in place. One more thing, if unfortunately your security in your Server get compromised then never trust that server as a cracker can have access to 100% of the system. In such cases where we don’t have 100% confidence that Server is ok, its better to rebuild the Server from scratch and restore backup to make it up again.

I’d appreciate your comments sharing your experience or approaches which can help us securing our Servers more effectively.

How to change Date, Time and Time Zone in Linux

khurana.r292@gmail.com (Webshine Team) — Fri, 06 Jul 2012 19:14:00 +0000

In Redhat based distro, here’s a quick solution to change your time zone to PST/PDT:

$ mv /etc/localtime /etc/localtime.Old && ln -s /usr/share/zoneinfo/PST8PDT /etc/localtime

Other commands:

Change Time zone to IST:

$ mv /etc/localtime /etc/localtime.Old && ln -s /usr/share/zoneinfo/Asia/Calcutta /etc/localtime

Set the TZ environment variable for quick display time according to preferred Time Zone:

$ export TZ=America/Los_Angeles
$ date

If you have the utility rdate, update the current system time by executing



$ rdate -s pool.ntp.org



You can execute ‘system-config-date’ for setting up date/time and time zone


$ system-config-date



If you’re using Ubuntu, tzconfig is there for you:


$ tzconfig

How To Break Root Password in Linux(Centos/RHEL 5)

khurana.r292@gmail.com (Webshine Team) — Fri, 06 Jul 2012 19:05:00 +0000

How To Break Root Password

Case I:--

If Bootloader don't have password or we know bootloader password

Key Points:--

1. Select Redhat linux title and press E to edit

2. Press E to edit kernel line

3. then type 1 after giving single space

4. Below Editing

5. kernel /vmlinuz-2.6.32-71.el6.x86_64 ro ....................crashkernel=auto rhgb quiet

6. After Editing

7. kernel /vmlinuz-2.6.32-71.el6.x86_64 ro......................crashkernel=auto rhgb quiet 1

8. Then Enter and boot by B

9. then check Selinux

10. if selinux is enforcing then change to permisive by:--

11. #setenfoce 0

12. then change password

Case II:--

If we don't know bootloader password

Key Points:--

1. Boot by Linux DVD

2. Select Rescue Mode

3. #chroot /mnt/sysimage

4. passwd (cmd to change password)