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 »

 106 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 »

 1,903 total views

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,711 total views

 1,711 total views

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,430 total… read more »

 2,430 total views,  9 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

[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,611 total views

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,744 total views

Sidebar