sysadmin, Win10, Windows

Mount an NFS Share on Windows

Requirements

  •  Windows computer running server or desktop OS that is in support.

Mounting the NFS Share

  •  Make sure that the NFS Client is installed.
    1. Open a Powershell command prompt.
    2. Run the appropriate command for your situation:
      • Server OS: Install-WindowsFeature NFS-Client
      • Desktop OS: Enable-WindowsOptionalFeature -FeatureName ServicesForNFS-ClientOnly, ClientForNFS-Infrastructure -Online -NoRestart
  • Mount the share using the following command, after making the required modifications (Note – mount cmd from CMD shell, not powershell):
    • mount -o anon nfs.share.server.name:/share-name X:
      1. Replace nfs.share.server.name with the name of the server the NFS share is on (eg. files.umn.edu)
      2. Replace share-name with the name of the NFS share (eg. OIT-Test)
      3. Replace X: with the desired drive letter.

Enable Write Permissions for the Anonymous User

With the default options you will only have read permissions when mounting a UNIX share using the anonymous user. We can give the anonymous user write permissions by changing the UID and GID that it uses to mount the share.

The image below shows the a share mounted using the default settings.

Windows 10: NFS Mount Command

To change the UID and GID we need to make a simple change to the Windows registry by performing the following steps:

  1. Open regedit by typing it in the search box end pressing Enter.
  2. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ClientForNFS\CurrentVersion\Default.
  3. Create a new New DWORD (32-bit) Value inside the Default folder named AnonymousUid and assign the UID found on the UNIX directory as shared by the NFS system. (Use Decimal values)
  4. Create a new New DWORD (32-bit”) Value inside the Default folder named AnonymousGid and assign the GID found on the UNIX directory as shared by the NFS system. (Use Decimal values).Windows 10: Regedit NFS AnonymousUid and AnonymousGid
  5. Restart the NFS client or reboot the machine to apply the changes.
  6. To Restart NFS client without having to restart Windows:
    1. net stop nfsclnt
      net stop nfsrdr
      net start nfsrdr
      net start nfsclnt

 

How to Mount an NFS Share

Assuming your NAS device is on the same network as your Windows machine and the IP address of the device is 10.1.1.211, the following command will mount a share on the NFS system at /mnt/vms.

C:\Users\windows> mount -o anon \\10.1.1.211\mnt\vms Z:
Z: is now successfully connected to \\10.1.1.211\mnt\vms

The command completed successfully.

The share is now mounted and we can access the data by navigating to the Z: drive.

Cameras, coding, Security, surveillance

Hikvision RTSP URL address format

Hikvision RTSP URL address format

July 3, 2020
in Hikvision

If you own a Hikvision device such as an IP camera or a NVR/DVR, you can use the RTSP protocol to live stream. RTSP stands for Real Time Streaming Protocol, a network protocol for streaming the videos in real-time. Basically, it’s designed to send audio or video live from one device to another. The same RTSP url format works for Hilook devices as well.

Hikvision RTSP URL format (with Authentication)

Hikvision RTSP: rtsp:// [USER] : [PASS] @ [ADDRESS] : [RTSP PORT] /Streaming/Channels/ [CH] 0 [STREAM TYPE]

Fill in your information as follows:

  • [USER] – This is the username to access your device (IP camera, NVR, DVR)
  • [PASS] – This is the password to the user
  • [ADDRESS] – This can be the IP address or the domain / DDNS name of your device
  • [RTSP PORT] – This is the RTSP port of your device, the default is normally 554
  • [CH] – This refers to the channel number that you want to pull
  • [STREAM TYPE] – 0 for main stream (highest resolution), 1 for substream (low resolution, but faster)

Example 1. Local IP address

The local IP address of the device is: 192.168.1.100 and the RTSP port is 554. These are the RTSP streaming addresses:

Hikvision Main Stream: rtsp://admin:password@192.168.1.100:554/Streaming/Channels/101
Hikvision Sub Stream: rtsp://admin:password@192.168.1.100:554/Streaming/Channels/102

Example 2. External IP address

The local IP address of the device is: 105.152.15.99 and the RTSP port is 554. These are the RTSP streaming addresses:

Hikvision Main Stream: rtsp://admin:password@105.152.15.99:554/Streaming/Channels/101
Hikvision Sub Stream: rtsp://admin:password@105.152.15.99:554/Streaming/Channels/102

RTSP without Authentication

rtsp://<IP addressof device>:<RTSP port>/Streaming/channels/<channel number><stream number>
Note: <stream number> represents main stream(01), or the sub stream(02)

Example:
rtsp://173.200.91.70:10554/Streaming/channels/101 –get the main stream of the first channel
rtsp://173.200.91.70:10554/Streaming/channels/102 –get the sub stream of the first channel

Source: Hikvision RTSP URL address format — SecurityCamCenter.com

microsoft

Shade Alternate Rows in Excel

Shade Alternate Rows

This example shows you how to use conditional formatting to shade alternate rows. Shading every other row in a range makes it easier to read your data.

1. Select a range.

Shade Alternate Rows Example

2. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

3. Click New Rule.

Click New Rule

4. Select ‘Use a formula to determine which cells to format’.

5. Enter the formula =MOD(ROW(),2)

6. Select a formatting style and click OK.

New Formatting Rule

Result.

Shade Alternate Rows in Excel

Explanation: the MOD function gives the remainder of a division. The ROW() function returns the row number. For example, for the seventh row, MOD(7,2) = 1 because 7 divided by 2 equals 3 with a remainder of 1. For the eight row, MOD(8,2) = 0 because 8 divided by 2 equals 4 with a remainder of 0. As a result, all odd rows return 1 (TRUE) and will be shaded.

Source: Shade Alternate Rows in Excel – Easy Excel Tutorial

Some stuff about things