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 »

 307 total views,  3 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 »

 2,104 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,882 total views,  3 views today

 1,882 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,814 total… read more »

 2,814 total views,  3 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,215 total views,  3 views today

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 »

 2,095 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,329 total views,  6 views today

 2,329 total views,  6 views today

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,505 total views,  3 views today

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,782 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,945 total views,  3 views today