Thursday, March 30, 2023

How to set up VSFTPD Server and FTP Account in AlmaLinux

sudo dnf install vsftpd

sudo mv /etc/vsftpd/vsftpd.conf /etc/vsftpd/vsftpd.conf_original

sudo vi /etc/vsftpd/vsftpd.conf

Add the following code to vsftpd.conf:

-------------------------------

anonymous_enable=NO

connect_from_port_20=YES

dirmessage_enable=YES

local_enable=YES

local_umask=022

listen=NO

listen_ipv6=YES

pam_service_name=vsftpd

userlist_enable=YES

write_enable=YES

xferlog_enable=YES

xferlog_std_format=YES

-------------------------------

cat /etc/vsftpd/vsftpd.conf 

sudo firewall-cmd --zone=public --add-service=ftp --permanent

sudo firewall-cmd --reload

sudo systemctl restart vsftpd

sudo useradd -m testftpuser

sudo passwd testftpuser

sudo bash -c "echo TO CHECK WORKING OF FTP > /home/baycombd/FTP_CHECK"

chown -R testftpuser /home/testftpuser

Note: Up to this user can access FTP files via ftp client application like FileZilla

Sunday, March 5, 2023

Remove header and footer text when click print button in Codeigniter

Add the following CSS for print area html tag:

@media print { @page { margin-top: 0; margin-bottom: 0; } body { padding-top: 5px; padding-bottom: 5px ; } }

Wednesday, March 1, 2023

Generate specific range of numbers having specific digit in excel

 The following function is for generating 8 digit unique number in excel and masked with 123:

=RANDBETWEEN(12300000,12399999)

Extract Domain from email in Excel or Google sheet

  =TEXTAFTER( A2 , "@") or, =MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))