Other

Convert Excel Files to CSV – Windows Script

Instructions Copy both files into the directory containing the files you want converted Run excel-to-csv.bat Note: This script requires Excel to be installed. excel-to-csv.bat FOR /f “delims=“ %%i IN (‘DIR *.xls* /b’) DO to-csv.vbs “%%i“ “%%i.csv“ to-csv.vbs if WScript.Arguments.Count < 2 Then WScript.Echo “Please specify the source and the destination files. Usage: ExcelToCsv <xls/xlsx source file>… read more »

 109 total views,  6 views today

How to Search for Files and Folders Recursively via SSH

You need to use the following command to search for a file called FileName.txt under the current folder including all subfolders find ./ -type f -exec grep -l “text to find” {} \; find . -name FileName.txt If you are unclear about the file name or want to match a part of the file name,… read more »

 1,906 total views,  3 views today

XRDP – Install XRDP RDP on Ubuntu – Easiest way

sudo apt-get install xrdp sudo apt-get update sudo apt-get install mate-core mate-desktop-environment mate-notification-daemon sudo sed -i.bak ‘/fi/a #xrdp multiple users configuration \n mate-session \n’ /etc/xrdp/startwm.sh  1,714 total views,  3 views today

 1,714 total views,  3 views today

Add Windows ISO Templates for Virtualizor KVM

Download any of client OS template to the location in Node ( /var/virtualizor/Xen or KVM according to the virtualization). http://mirror.softaculous.com/virtualizor/templates/windows-2003-x86.img.gz http://mirror.softaculous.com/virtualizor/templates/windows_2003R264.img.gz http://mirror.softaculous.com/virtualizor/templates/windows-2008r2.img.gz http://mirror.softaculous.com/virtualizor/templates/windows-2012server.img.gz http://mirror.softaculous.com/virtualizor/templates/windows-2012r2.img.gz http://mirror.softaculous.com/virtualizor/templates/windows-2016.img.gz For example: cd /var/virtualizor/kvm wget http://mirror.softaculous.com/virtualizor/templates/windows-2016.img.gz   Then to extract template run : gunzip TEMPLATE_NAME For example: gunzip windows-2016.img.gz   Then add the template using below link : http://www.virtualizor.com/wiki/Add_OS_Template  2,433 total… read more »

 2,433 total views,  12 views today

Mount a Disk and make partitions mount at startup?

mkfs.ext4 /dev/sda mount /dev/sda /backup sudo cp /etc/fstab /etc/fstab.old – Create a backup of the fstab file just in case something unwanted happens. If something happens, you will need a bootable (live) usb. If you do not have one, use the GUI method instead. sudo blkid – Note the UUID of the partition you want to automount…. read more »

 2,023 total views

4 Drive raid setup – 2 SSD raid 1 for system setup and 2 HDD another raid 1 to /storage

First setup the ssd with raid 1 and comment the 2 hdd. Then Add a software RAID array In our example scenario, the drives /dev/sda and /dev/sdb are already combined in multiple RAID1 arrays, which hold the operating system: But we have two more drives (/dev/sdc and /dev/sdd), which we would like to setup as a data storage with RAID1 array… read more »

 1,930 total views,  3 views today

[CentOS] curl#6 or #14 – “Could not resolve host: mirrorlist.centos.org; #72

For that type error: Downloading packages:Delta RPMs disabled because /usr/bin/applydeltarpm not installed.screen-4.1.0-0.26.20120314git3 FAILEDhttp://mirrors.gigenet.com/centos/7.9.2009/os/x86_64/Packages/screen-4.1.0-0.26.20120314git3c2946.el7.x86_64.rpm: [Errno 14] curl#6 – “Could not resolve host: mirrors.gigenet.com; Unknown error”Trying other mirror….. For fix that:  2,122 total views

 2,122 total views

Migrate/Transfer Multiple cPanel Accounts without WHM Transfer tools

First of all remove any backup file present under /home directory using the command rm -rf /home/cpmove-* Create the list of accounts you wish to migrate using the below commands. cat /etc/trueuserdomains | awk ‘{print $2}’ > /home/accountlist Now you have the list of account in the file  /home/accountlist Suppose that you have 100 accounts and wish to move… read more »

 3,346 total views

How to Restrict SFTP Users to Home Directories Using chroot Jail

Create or Modify Users and Groups Let us restrict the existing user, for example asifnew, to his/her home directory named /home/asifnew. For this, you need to create a new sftpgroup group using groupadd command as shown: # groupadd sftpgroup You can also create a new user using useradd command, for example asifnew and assign the user to sftpusers group. # adduser asifnew -g sftpgroup -s… read more »

 2,614 total views,  3 views today

How to Install and Configure FTP Server in Ubuntu

In this tutorial, we will show how to install, configure and secure a FTP server (VSFTPD in full “Very Secure FTP Daemon“) in Ubuntu to have a powerful security against FTP vulnerabilities. Step 1: Installing VsFTP Server in Ubuntu 1. First, we need to update the system package sources list and then install VSFTPD binary package as follows: $ sudo apt-get update $… read more »

 2,747 total views,  3 views today

Sidebar