Backup all MSSQL databases
Linux General,You can use the below stps to backup all your mssql database at ease. We at actsupport, provide backup solution. 1. Log into your server through Remote Desktop Connection. 2. Open SQL Server Management Studio and select the server name 3. Click the New Query button and enter in the following data: DECLARE @name VARCHAR(50)…
Read moreHow to enable more than 4GB RAM support on Linux 32bit servers?
Linux General,# uname -r 2.6.18-8.1.3.el5 # yum info kernel-PAE Available Packages Name : kernel-PAE Summary: The Linux kernel compiled for PAE capable machines. Description: This package includes a version of the...
Read moreFFMPEG Installation
Linux General,FFMPEG and it’s related modules Installation through Script: Details:All FFmpeg packages are installed from source except codecs. The main dependency for installing ffmpeg is: yum Ffmpeg installation will only work on redhat and suse (requires yum) distributions. FFmpeg installation will work in cpanel and plesk servers.How to run:Wget the above script to /usr/src…
Read moreLinux Tips & Tricks
Linux General,TIP 1: NTP Is NTP Working? STEP 1 (Test the current server): Try issuing the following command: $ ntpq -pn remote refid st t when poll reach delay offset jitter =================================================== tock.usno.navy 0.0.0.0 16 u – 64 0 0.000 0.000 4000.00 The above is an example of a problem. Compare it to a working configuration.…
Read moreAdding modsecurity rule for domain
Linux General,Add the below rule in the .htaccess file. SecRuleEngine Off This will work only if you have old version of mod_security installed on the server. You cannot disable mod_security2 using .htaccess, the only way to bypass mod_security2 in Apache 2 is to manually edit httpd.conf. Create a directory with the username and the domain name,…
Read moreMysql Queries in Linux
Linux General,How to resolve mysql_connect() Error Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘username’@’localhost’ (using password: YES) Possible root cause for this problem is proper privilege not assigned to the particular user. So providing proper privileges will solve this issue. $grant all privileges on “Database_Name” to “username@localhost” identified by “password” If the mysql resides in the…
Read moreDoes DNS use TCP or UDP or both?
Linux General,Does DNS use TCP or UDP or both? TCP is a connection-oriented protocol and it requires data to be consistent at the destination and UDP is connection-less protocol and doesn’t require data to be consistent or don’t need a connection to be established with host for consistency of data. UDP packets are smaller in size.…
Read moreLinux – Advanced Commands
Linux General,Show status of ethernet interface eth0: ethtool eth0 List addresses for interfaces: ip addr show (OR) ip a Set default gateway: ip route add default via 1.2.3.254 List routing table: ip route show Add (or del) ip and mask (255.255.255.0): ip addr add 1.2.3.4/24 brd + dev eth0 Text Manipulation: Replace string1 with string2: sed…
Read moreLinux – Ethernet bonding
Linux General,Linux bond or team multiple network interfaces (NIC) into single interface We have two Dell servers that need setup with Intel Dual Gig NIC. My idea is to improve performance by pumping out more data from both NIC without using any other method. This box act as heavy duty ftp server. Each night I need…
Read moreLinux – Tweaks
Linux General,Fork Bomb on Linux/Unix: Q. Explain following bash code or bash fork() bomb? : () { : | :& };: A. This is a bash function. It gets called recursively (recursive function). This is most horrible code for any Unix / Linux box. It is often used by sys admin to test user processes limitations…
Read more
