SMB

File sharing ..

The Server Message Block (SMB) protocol is a network file sharing protocol that allows applications on a computer to read and write to files and to request services from server programs in a computer network. The SMB protocol can be used on top of its TCP/IP protocol or other network protocols

Objective of this workshop is to:

• install & configure a basic Samba server.

• share user home directories as well as provide read-write anonymous access to selected directory.

SMB Server

Setup

Samba is a suite of applications that implements the Server Message Block (SMB) protocol. Many operating systems, including Microsoft Windows, use the SMB protocol for client-server networking. Samba enables Linux / Unix machines to communicate with Windows machines in a network. Samba is open source software.

The following section is for Reference only.

Samaba has been installed and configured on both Windows & Linux servers.

Windows

x

1. Double-click the Samba executable file that you downloaded in Step 1.

2. In the Samba installation wizard, click Next to proceed.

3. Accept the license agreement and click Next.

4. Choose the destination folder where you want to install Samba and click Next.

5. Choose the components that you want to install (we recommend selecting all components) and click Next.

6. Configure the Samba Server settings (e.g., global workgroup, security mode, etc.) as per your requirements and click Next.

7. Choose a password for the administrative account that you will use to manage the Samba server and click Next.

8. Review the installation summary and click Next to start the installation process.

9. After the installation is complete, click Finish to close the installer.

x

x

1. Open the Samba configuration file (smb.conf) located in the installation directory.

2. Edit the smb.conf file to configure the necessary settings (e.g., share directories, users and groups, etc.). You can refer to the Samba documentation for more information on configuring smb.conf.

3. Save the changes to the smb.conf file.

x

1. Press the Windows key + R to open the Run dialog box.

2. Type services.msc and click OK to open the Services Manager window.

3. Find the Samba service (named "SMB" or "Samba") in the list of services.

4. Right-click the Samba service and choose Start.

5. Wait for a few seconds until the Samba service starts.

x

1. Open the File Explorer on your Windows 10 system.

2. In the address bar, type \localhost or \[your-computer-name] and press Enter.

3. You will be prompted to enter your Samba username and password. Enter the credentials that you specified in Step 2.

4. You should now see a list of shared directories on your Samba server. Double-click the directories to access their contents.

x

Linux

Installed on Ubuntu 22.04.

1. Ensure all installed Packages are up-to-date.

sudo apt update && sudo apt upgrade -y

1. Install Samba server.

sudo apt install tasksel
sudo tasksel install samba-server

1. Make a copy of the existing configuration file and create a new /etc/samba/smb.conf configuration file

sudo cp /etc/samba/smb.conf /etc/samba/smb.conf_backup
sudo bash -c 'grep -v -E "^#|^;" /etc/samba/smb.conf_backup | grep . > /etc/samba/smb.conf'

1. Any user existing on the samba user list must also exist within the /etc/passwd file.

sudo smbpasswd -a pentaho

New SMB password: Welcome123
Retype new SMB password: Welcome
Added user pentaho.

1. Add the home directory share.

sudo nano /etc/samba/smb.conf

1. Copy & paste the following to the bottom of the file - private home & public access.

[homes]
   comment = Home Directories
   browseable = yes
   read only = no
   create mask = 0700
   directory mask = 0700
   valid users = %S
[public]
  comment = public anonymous access
  path = /var/samba/
  browsable =yes
  create mask = 0660
  directory mask = 0771
  writable = yes
  guest ok = yes

1. Save.

CTRL + O
Enter
CTRL + X

1. Create a directory that mounts public share and change its access permission.

sudo mkdir /var/samba
sudo chmod 777 /var/samba/

1. Restart your samba server.

sudo systemctl restart smbd

---

Test server

1. Let’s create some test files.

touch /var/samba/public-share 
touch /home/pentaho/home-share 

Public

1. In File Explorer, select: + Other Locations.

2. Enter the following connection details:

Connect to public share

1. Connect as: Anonymous.

Connect as: Anonymous

1. You should see the public-share file.

public-share

Regsitered User

1. In File Explorer, select: + Other Locations.

2. Enter the following connection details:

Connect to private share

1. Connect as: Registered User & enter the following details:

Connect as: Registered User

Username	pentaho
Domain	WORKGROUP
Password	Welcome123

1. You have access to /home/pentaho.

home-share

Pentaho Data Integration

Pentaho Data Integration utilizes Virtual File System (VFS) as the abstraction layer within the kernel to expose different filesystems.

In PDI, you can add a VFS connection and then reference that connection whenever you want to access files or folders on your Virtual File System.

Download CIFS driver

Pentaho Data Integration ships with jcifs-1.3.3.jar

If you wish to replace the current driver, rename to: jcifs-1.3.3.jar -> jcifs-1.3.3.jar.bak

1. Download the library.

Index of /src

Link to CIFS jar

1. Copy the JCIFS JAR file into Pentaho Data Integration "lib" folder.

Windows

x

Linux

cd
cd ~/Downloads
cp jcifs-1.3.19.jar ~/Pentaho/design-tools/data-integration/lib

1. Start Pentaho Data Integration.

Windows

x

Linux

cd
cd ~/Pentaho/design-tools/data-integration
./spoon.sh

1. Create a new Transformation.

2. Click on the 'View' tab.

3. Highlight 'VFS Connections' and select 'New'.

1. Configure with the following details:

VFS - SMB

1. Click 'Test'.

Test connection

---

Transformation - SMB File Retrieval

1. Open the transformation:

~/Workshop--Data-Integration/Labs/Module 3 - Data Sources/SMB/tr_SMB_File_Retrieval.ktr

tr_SMB_File_Retrieval

1. Double-click on Text file input -> File tab

2. Click on Browse and ensure you select:

VFS Connections -> SMB -> Workshop--Data-Integration/Labs/Module 3 - Data Sources/SMB/data/sales_data.csv

VFS - SMB - sales_data.csv

1. Add the path.

VFS path - sales_data.csv

1. Click on Content tab & configure with the following settings.

Content

1. Click on Fields tab & click on 'Get Fields' - Preview the rows

Retieve fields

1. Click OK.

Take a look at the other steps.

The Text file output step creates an 'output.txt' file in the same directory as the transformation