Part 22- Function PostgreSQL techsolution August 10, 2021Function is a set of SQL procedural commands like declarations, assignments, loops, flow-of-control etc. Function have return type and we... Read More
GET DENSE RANK WITHOUT RANK FUNCATION techsolution August 05, 2021set @rownum1:=0; select AREA_ID , @rownum1:=(CASE WHEN (AREA_ID=@Tmax_18) THEN @rownum1+1 ELSE 1 END ) AS num1,(@Tmax_18:=AREA_ID) RANGE_SET... Read More
Load data from mysql techsolution August 02, 2021 mysql --local-infile=1 -h localhost -u root -p -e "LOAD DATA INFILE '/var/lib/mysql-files/30daysFcst.csv' INTO TABLE MYDB.30... Read More
2.Python Assignment : FOR LOOP techsolution July 30, 2021 Assignment : Program to print the table of the given number . list = [ 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 ] n = 5 for i in list: c... Read More
PYTHON EXERCISES FOR IF ELSE techsolution July 25, 2021 Q1: a = 10 b = "This is python" c = 10.5 print ( type (a)) print ( type (b)) print ( type (c)) Output <class 'int'>... Read More
SELinux | Enforcing | ls -Z | ps -efZ | restorecon |chcon |Permissive | Booleans | policy | getenforce | SELinux mode temporarily | SELinux policy details techsolution July 24, 2021What is SELinux? It is a one type of security that enhances the security that allows users and administrators more control over which users ... Read More
Configure step by step Nic card | nmap | tracepath | miitool | ifconfig in linux techsolution July 24, 2021# setup (to setup the static network in RHEL - 2, 3, 4, 5 and 6) # nmtui (to setup the static network in GUI mode for RHEL - 7) # nmcli... Read More
Network troubleshoot nmtui | setup | nmcli | dig | host | nslookup | ip route | netstat | hostname | ifconfig | ping techsolution July 24, 2021 Q:- How to troubleshoot if the network is not reaching? (i) First check the network cable is connected or not by # ethtool <NIC device... Read More
How to configure bridging or teaming or bonding | TCP and UDP protocol | resolve.conf | /etc/hosts |nmap |run levels of linux techsolution July 24, 2021From RHEL - 6 - What is bonding and how to configure bonding? From RHEL - 7 :- What is link aggregation or bridging or teaming and how to c... Read More
Troubleshoot: Assign the static IP | Set the hostname temporarily and permanently | NIC is notworking techsolution July 24, 2021Q1:-How to assign the static IP address to the NIC card? In RHEL - 6 : # setup (Move the cursor to Network configuration and press Enter key... Read More
Network | NIC card | Topology | Protocol | IP address | Network configuration | resolve.conf | /etc/hosts techsolution July 18, 20211.What is Network? Combination of two more computers connected together to share their resources each other by means of communication like c... Read More
Sudo User | Sudo Permissions | Assign the password | who | lastb | lastreboot | df |du | history | find | last -x | w techsolution July 18, 2021Sudo stands for either "substitute user do" or "super user do" (depending upon how you want to look at it). What sudo do... Read More
APACHE VIRTUAL WEB HOSTING | REDIRECT WEBSITE | PORT BASED WEB HOSTING techsolution July 18, 2021 HOW TO CONFIGURE VIRTUAL WEB HOSTING [root@dev ~]# vi /etc/httpd/conf.d/ip.conf <VirtualHost 192.168.0.10:80> ServerAdmin root@d... Read More