Gregory Varghese
  • About Me
  • Labs
  • GitHub
  • My Work Setup
  • My Photography Blog
  • Contact Me
  • About Me
  • Labs
  • GitHub
  • My Work Setup
  • My Photography Blog
  • Contact Me
  • Categories
  • All
  • Administration
  • Solutions
  • Troubleshooting
  • Tips and Tricks
  • Development
8th May 2025
AdministrationCloudDigital OceanLinuxMacSolutionsTerminal

How to Extract SSL Certificates from a PFX File on macOS

If you’ve ever been handed a .pfx file and told to “just upload the certificate,” you know the pain that’s coming.

PFX (PKCS#12) files bundle your private key, SSL certificate, and any intermediate certificates into one encrypted file. That’s great until you actually need to extract those pieces for something like an NGINX server, AWS load balancer, or third-party CDN that wants them all separately.

MacOS has OpenSSL built in, which is all you need. Here’s a simple shell script I use to generate the cert, private key, and chain in one shot and make them clipboard-ready for easy pasting.

Continue Reading
0
2
19th August 2024
AIDevelopmentLaravelLaravelMacMacPHPPHPTerminalTips and Tricks

Supercharge Your Laravel Development and Get AI to Understand Your Models

Hey there, Laravel enthusiasts! Today, I'm diving into a nifty trick that'll make getting AI to understand your Laravel model structures a breeze. We'll harness the power of bash scripting and AI to analyze our migrations quickly and efficiently. Let's get started!

Continue Reading
0
184
30th July 2024
AdministrationPowerShellTips and TricksToolsWindows

How to Take Ownership of Files and Folders Using PowerShell

Ever had to take ownership of a bunch of files and folders? It's a pain, right? Well, not anymore!

Continue Reading
1
114
16th July 2024
Uncategorized

How to add case insensitive where in Laravel

Continue Reading
0
125
8th July 2024
AdministrationMacTerminal

How to Move Files by Partial File Name to New Directory on Mac using a shell script

Continue Reading
0
138
29th March 2024
DevelopmentLaravelPHPPHPStorm

How to Automatically Login into Laravel App in Your Local Dev Environment

I often find myself spinning up Laravel projects for prototypes and idea testing and then letting them sit until I can pick them back up. Logging in whenever I start work gets annoying, and there's no point in manually logging in to my local instance since my account is the admin. Fortunately, there are a few solutions to automate this process in Laravel. I'll delve into the various methods to automatically log in to your Laravel app in your local development environment, enhancing your workflow and boosting productivity.

Continue Reading
0
322
11th January 2024
AdministrationMacMacMacFusionpCloudSoftwareTerminalTips and TricksTools

How to enable MacFuse/PCloud Drive on Mac Sonoma 14.2.1

I recently upgraded to Mac Sonoma 14.2.1 and MacFuse stopped loading which affected my ability to load PCloud and NTFS drives. I spent a few days trying to troubleshoot everything and in the end it turned out I had to disable Mac System Integrity Protection to get everything to load. I'm sharing in case it helps anyone else.

To disable SIP on your Mac Sonoma for extensions like MacFuse and pCloud Drive:

Continue Reading
0
392
25th September 2023
ApplicationsExcelMacSoftwareTips and TricksToolsUtilities

How to Delete a Row in Excel Using the Elgato Stream Deck

Recently I was working on a massive Excel Spreadsheet and needed to manually review each entry and clean up rows that were no longer needed. The Elgato Stream Deck came in handy for a quick shortcut so I thought I'd share it in case anyone else can use it.

I took this opportunity to practice creating the first of what I hope are many training videos. This took me around 30 minutes to do from start to finish as I had to learn the video editing software including how to record, how to split and edit, and how to add text overlays. Hopefully the next videos will be faster but it was a fun exercise and I hope someone else finds it useful.

Continue Reading
0
405
19th September 2023
bun.shDevelopmentMacSolutionsTerminalTroubleshooting

Installing font awesome pro with bun

After recently switching to bun.sh, I was trying to install Font Awesome Pro. It uses a private registry but their docs have not been updated to support non-npm package managers and bun does not yet support .npmrc files.

You can configure a private registry using an organization scope. First, you must get your auth token from your paid Font Awesome account by going to your account page, scrolling down to the Tokens section, and copying the token.

Continue Reading
2
372
24th March 2023
AI

A sonnet about Batman in the style of William Shakespeare

Continue Reading
0
352
Page 1 of 10
  • 1
  • 2
  • 3
  • …
  • 10
Older Posts

Tags

.NET (4) Administration (24) AI (3) Applications (13) ASP.NET (8) ASP.NET MVC (2) C# (6) Caution (4) Debug (6) Development (23) digital ocean (2) Errors (9) ESET (3) Excel (2) Fix (22) High CPU Usage (2) IIS (3) Javascript (5) jQuery (4) laravel (7) linux (6) Mac (17) MAMP (3) Microsoft (5) NTFS (2) Open Source (3) Outlook (2) Outlook 2011 (4) Photography (2) php (4) Programming (9) review (2) Sitecore (2) Software (7) Solutions (43) SQL (4) SSL (3) Tips (35) Tools (5) Troubleshooting (27) Useful (22) Utilties (8) Windows (14) Windows 7 (4) Windows Server (2)

Categories

  • Administration 66
    • Caution 3
    • Cloud 8
      • Cloudflare 1
      • Digital Ocean 6
        • Droplet 5
      • Namecheap 1
    • Hardware 4
      • Drobo 3
    • IIS 2
    • Linux 9
      • Apache 1
      • SSH 7
        • Terminal 4
      • Ubuntu 16.04 1
    • Mac 14
      • Software 5
        • Alfred 1
        • MacFusion 1
        • MAMP 3
        • pCloud 1
        • PHPStorm 1
      • Terminal 9
        • bun.sh 1
    • Review 1
    • Security 6
      • ESET 4
      • Firewall 1
    • SQL 3
      • 2008 1
      • DTSX 1
      • mySQL 1
    • Stupid Tales 2
    • Windows 46
      • Applications 16
      • Malware 2
      • NTFS 2
      • PowerShell 2
      • Software 21
        • Excel 3
        • Outlook 1
        • Peerblock 1
        • Remote Desktop 1
          • RDC 1
        • SourceTree 1
        • Steam 1
        • Synergy 1
        • Visio 1
        • Visual Studio 2013 1
        • Word 1
        • Wordpress 2
          • Hack 2
      • Tips and Tricks 35
      • Tools 23
      • Utilities 19
      • Windows 10 2
      • Windows 7 9
      • Windows 8 4
      • Windows Server 3
        • Windows Server 2008 2
        • Windows Server 2012 2
  • Body Hacking 1
    • Diet 1
    • Soylent 1
  • Development 35
    • AI 3
    • Bitbucket 3
      • Pipelines 3
    • c# 2
    • CouchDB 1
    • Github 3
    • Gitlab 2
    • Open Source 4
    • ORM 1
      • Dapper 1
    • PHP 8
      • Laravel 8
        • Jigsaw 1
    • PHPStorm 2
    • Sitecore 2
    • SourceTree 1
    • Syncfusion 1
  • Mac 13
    • iCloud 1
    • Outlook 2011 2
    • Safari 1
  • Photography 3
    • Food 1
    • Rockstars 1
    • Uproar Festival 2012 1
    • Wolves 1
  • Products 3
    • Backblaze B2 1
    • Reviews 2
  • Programming 32
    • ASP.NET 7
      • MVC 1
    • AWS 1
      • Rekognition 1
    • C# 3
    • Gatsby 1
    • Javascript 2
    • jQuery 3
      • Fancybox 1
    • MonoTouch 1
    • PHP 7
      • Laravel 7
        • Tinker 1
    • Regex 1
    • Sitecore 2
    • SQL 1
    • SSL 2
    • VBA 2
      • Microsoft Word 1
    • Web Development 10
      • JavaScript 2
    • WinForms 2
  • Raspberry Pi 1
  • Recipe 1
  • Self Experimentation 1
  • Troubleshooting 46
    • Solutions 45
  • Uncategorized 11

Archives

  • May 2025 (1)
  • August 2024 (1)
  • July 2024 (3)
  • March 2024 (1)
  • January 2024 (1)
  • September 2023 (2)
  • March 2023 (2)
  • January 2023 (1)
  • November 2022 (1)
  • August 2022 (1)
  • January 2022 (1)
  • October 2021 (1)
  • January 2021 (1)
  • July 2020 (1)
  • May 2020 (1)
  • April 2020 (1)
  • February 2020 (1)
  • September 2019 (1)
  • August 2019 (3)
  • July 2019 (1)
  • June 2019 (1)
  • May 2019 (4)
  • October 2018 (1)
  • July 2018 (1)
  • May 2018 (1)
  • April 2018 (2)
  • November 2017 (1)
  • October 2017 (1)
  • June 2017 (1)
  • May 2017 (1)
  • November 2016 (1)
  • October 2016 (2)
  • September 2016 (1)
  • June 2016 (2)
  • May 2016 (4)
  • February 2016 (1)
  • January 2016 (1)
  • October 2015 (1)
  • September 2015 (1)
  • July 2015 (1)
  • June 2015 (1)
  • May 2015 (3)
  • April 2015 (1)
  • March 2015 (1)
  • February 2015 (1)
  • July 2014 (1)
  • June 2014 (1)
  • May 2014 (1)
  • December 2013 (2)
  • September 2013 (1)
  • July 2013 (1)
  • May 2013 (2)
  • March 2013 (2)
  • February 2013 (1)
  • September 2012 (1)
  • August 2012 (4)
  • July 2012 (1)
  • March 2012 (1)
  • November 2011 (1)
  • September 2011 (4)
  • July 2011 (3)
  • June 2011 (2)
  • February 2011 (1)
  • August 2010 (1)
  • May 2010 (1)
  • October 2007 (1)

Continue Reading
Gregory Varghese

Recent Posts

  • How to Extract SSL Certificates from a PFX File on macOS
  • Supercharge Your Laravel Development and Get AI to Understand Your Models
  • How to Take Ownership of Files and Folders Using PowerShell
  • How to add case insensitive where in Laravel
  • How to Move Files by Partial File Name to New Directory on Mac using a shell script

Copyright © Gregory Varghese. 2025 • All rights reserved.

Published with WordPress.