Welcome to W3Space Blog

Step-by-Step Tutorials

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 »

Loading

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 »

Loading

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

Loading

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

Loading

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 »

Loading

[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:

Loading

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 »

Loading

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 »

Loading

Sidebar