Saturday, October 14, 2023

Common linux commands

  1. whoami
  2. man 
  3. clear 
  4. pwd
  5. ls
  6. cd 
  7. mkdir 
  8. touch 
  9. rmdir 
  10. rm 
  11. open 
  12. mv 
  13. cp 
  14. head
  15. tail 
  16. date
  17. cat
  18. less 
  19. echo 
  20. wc 
  21. piping 
  22. sort
  23. uniq 
  24. expansions 
  25. diff 
  26. find 
  27. grep
  28. du
  29. df 
  30. history
  31. ps
  32. top 
  33. kill
  34. killall
  35. gzip
  36. gunzip
  37. tar
  38. nano
  39. alias 
  40. xargs
  41. ln
  42. who
  43. su 
  44. sudo 
  45. passwd
  46. chown
  47. chmod

Sunday, October 8, 2023

Thursday, October 5, 2023

Export multiple records one by one from Excel

 

Sub Print1()

    For a = 1 To 10

        Sheet3.Range("L2").Value = a

ActiveWindow.SelectedSheets.PrintOut copies:=1, collate:=True, IgnorePrintAreas:=False

Next

End Sub

Export multiple records to PDF one by one from Excel

 Sub ExportRangeToPDF()

    For a = 3 To 10

        Sheet1.Range("D4").Value = Sheet2.Cells(a, "A")

        Sheet1.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Naeem\OneDrive\Desktop\PrintingPDF\" & Sheet1.Range("D4").Value & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

    Next

End Sub

Sunday, September 17, 2023

Find WHM/cPanel or linux failed email login log



Webmail Login attempt:


/usr/local/cpanel/logs/login_log

cp /usr/local/cpanel/logs/login_log /home/cpanel_unsername

chmod 644  /home/cpanel_unsername/ogin_log


POP3 login attempts:


/var/log/maillog

cp /usr/local/cpanel/logs/maillog /home/cpanel_unsername

chmod 644  /home/cpanel_unsername/maillog

Wednesday, September 6, 2023

MariaDB Socket from Path XAMPP for VSCODE on MAC OS


Run the following command in terminal:

ps -ax|grep mysql

FInd the output like this:

--socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock --port=3306

Then use this path without quote in Socket path

"Applications/XAMPP/xamppfiles/var/mysql/mysql.sock"


Then click Save and connect. It will show the success message.



Extract Domain from email in Excel or Google sheet

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