JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

6 entries / Linux

Clear filters
Minimal Privileges for MySQL Database Backup Cron Job
cPanel 25768

Minimal Privileges for MySQL Database Backup Cron Job

What A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a...

Read note
Unix Date Format Specifiers
Linux 28697

Unix Date Format Specifiers

I could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix)

Read note
List all cron jobs for all users
Linux 31644

List all cron jobs for all users

Amazing little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located.

Read note
How to run a .RUN file
Linux 17481

How to run a .RUN file

I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories > Terminal Type 'CD Desktop' to go to your desktop folder Type 'LS' just to...

Read note
Ubuntu as a media server
Linux 20078

Ubuntu as a media server

1. If someone wants to use Ubuntu as a home media pc connected to a tv, there is the problem of overscan; consumer tv's crop off the border around the image. How does Ubuntu intend to officially solve this? Right now LinuxMCE has it's own method for doing this so the LMCE UI is never cropped off, but when the user swit...

Read note
All published notes loaded.

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

25 Years in IT
1990 CRM clients
798 Site articles
24.4m+ Reads / hits