Linux: Permanent CIFS/SMB mount

I needed to permanently mount a directory on a Windows server that had spaces in the path. I also wanted to use a credentials file so that the remote server username and password would not be in the world readable fstab file. The following was cobbled together from:

Mount samba shares with utf8 encoding using cifs

 and:

 Mount password protected network folders

  1. Create a credentials file (as root) containing the username and password and restrict it's ability to be read by other users (/etc/fstab is world readable).
    1. vi /root/.smbcredentials
      username=someusername
      password=somepassword
    2. Save and exit the file. Change the file permissions to only be readable by root.
      chmod 600 /root/.smbcredentials

  2. Update the fstab file
    1. Add the following line to /etc/fstab (spaces are replaced with \040 or the mount will fail)
      //ip address/c$/Program\040Files/Microsoft\040SQL\040Server/ /var/backups/Server cifs credentials=/root/.smbcredentials,iocharset=utf8,sec=ntlm 0 0
    2. Exit and save the file
  3. Test the fstab entry with:
    sudo mount -a

Comments

Post a Comment

Popular posts from this blog

YumRepo Error: All mirror URLs are not using ftp, http[s] or file

A very old server that had a service dependant on CentOS 5 Running any yum command resulted in yum check-update Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile YumRepo Error: All mirror URLs are not using ftp, http[s] or file.  Eg. Invalid release/repo/arch combination/ YumRepo Error: All mirror URLs are not using ftp, http[s] or file.  Eg. Invalid release/repo/arch combination/ YumRepo Error: All mirror URLs are not using ftp, http[s] or file.  Eg. Invalid release/repo/arch combination/ The answer was that the mirrorlists needed to be updated to point at the last version of CentOS 5. Stolen from here:  https://www.linuxquestions.org/questions/centos-111/yumrepo-error-centos-5-9-a-4175604669/#post5704920 echo "http://vault.centos.org/5.11/os/x86_64/" > /var/cache/yum/base/mirrorlist.txt echo "http://vault.centos.org/5.11/extras/x86_64/" > /var/cache/yum/extras/mirrorlist.txt echo "http://vault.centos.org/5.11/updat...
Read more

Find Which Processes are Using Swap

I was doing s ome testing on my Virtuozzo linux VPS and wanted to find what was using the swap. The short version is that processes that have not been used in a long time will be moved into swap to free up RAM. I found the following page with a one-liner to show the running processes and the amount of swap they are using (including processes with 0 kB of swap).  https://www.cyberciti.biz/faq/linux-which-process-is-using-swap/  I modified the one-liner to only show processes using swap. for file in $(grep -El "VmSwap:\s+[1-9][[:digit:]]* kB" /proc/*/status) ; do awk '/Name:|VmSwap:/{printf $2 " " $3}END{ print "" }' $file; done | sort -k2nr php-fpm 488792 kB php-fpm 485172 kB php-fpm 475640 kB php-fpm 469504 kB php-fpm 469100 kB php-fpm 462044 kB php-fpm 439604 kB php-fpm 430868 kB php-fpm 410124 kB php-fpm 389892 kB php-fpm 381132 kB php-fpm 380136 kB php-fpm 379988 kB php-fpm 379216 kB php-fpm 316296 kB mysqld 225884 kB php-fpm 92096 kB php-fpm 91...
Read more

Excel - Combine Multiple CSV Files

Open a blank workbook Select the Data menu Select Get Data -> From File -> From Folder Select "Browse..." and navigate to the folder containing the CSV files Select "OK" Select "Transform Data" Use the filter in the 3rd column (Name) to deselect any files you do not want included in the dataset Click the double arrow icon (Combine Files) on the right of the 2nd column (Content) Select "OK" Select the "Source.Name" column Select "Remove Columns" from the Ribbon Ensure the first column of data is highlighted Select Remove Rows -> Remove Blank Rows from the Ribbon Select "Close & Load" from the Ribbon You can now save the combined files as a CSV file.
Read more