Here’s how to delete blank rows in Excel.
Archives for October 2019
Bash History With Timestamps
If you need to see Bash history with timestamps, use this command.
HISTTIMEFORMAT="%d/%m/%y %T " |
To make it permanent, add it to your .bashrc.
echo 'HISTTIMEFORMAT="%d/%m/%y %T "' >> ~/.bashrc source ~/.bashrc |
Timestamps accuracy is retroactively, meaning it will not be accurate for commands performed prior to the history time format being set.
Tar Commands
Here are two important tar commands on how to create and extract a tar.gz file.
Create a tar gzip file called “project.tar.gz” of a directory called “foo.”
tar -cvzf project.tar.gz foo |
Untar the “project.tar.gz” file to a directory called bar.
tar -xvzf project.tar.gz bar |
FFMPEG with Start Time
This is a follow up to a previous post about FFMPEG. In addition to sending a RTMP stream, you can also set a start time and duration.
Here’s how to set the start time using -ss option and -to for the duration. Video will start at 1 min 23 secs and play until 2 mins.
ffmpeg -ss 00:01:23 -i video.mp4 -to 00:02:00 -c copy -copyts cut.mp4 |
Here’s how to start time to start the video at 1 min 23 sec for RTMP streaming. Please note, the start time option needs to be before the input file.
ffmpeg -ss 00:01:23 \ -re -i $1 -acodec libmp3lame -ar 44100 -b:a 128k \ -pix_fmt yuv420p -profile:v baseline -s 1280x720 -bufsize 6000k \ -vb 1200k -maxrate 1500k -deinterlace -vcodec libx264 \ -preset veryfast -g 30 -r 30 -f flv \ -flvflags no_duration_filesize \ "rtmp://username:password@yourserver:1935/live/backup" |
RTMP of MP4 via FFMPEG
FFMPEG is the jack of all trades utility for both audio and video files. You can record, convert, and even live stream an audio or video file in just about any file format. In this example, I will be sending a RTMP stream of a MP4 file to a Wowza streaming server. I can easily send the same stream to YouTube, Facebook or any streaming server that accepts a RTMP source. In this example, I created simple Bash script called play.sh, with all the options needed to live stream to Wowza Streaming server.
Here are the options in play.sh.
ffmpeg -re -i $1 -acodec libmp3lame -ar 44100 -b:a 128k \ -pix_fmt yuv420p -profile:v baseline -s 1280x720 -bufsize 6000k \ -vb 1200k -maxrate 1500k -deinterlace -vcodec libx264 \ -preset veryfast -g 30 -r 30 -f flv \ -flvflags no_duration_filesize \ "rtmp://username:password@yourserver:1935/live/backup" |
To launch, run the script.
bash play.sh filename.mp4 |
RFC 1918
Here’s the original document published back in February 1996 detailing the allocation for private internet addresses. The Internet Assigned Numbers Authority (IANA) has reserved the following three blocks of the IP address space for private internets. RFC 1918.
10.0.0.0 - 10.255.255.255 (10/8 prefix) 172.16.0.0 - 172.31.255.255 (172.16/12 prefix) 192.168.0.0 - 192.168.255.255 (192.168/16 prefix) |
XFS Filesystem has duplicate UUID
Here’s how to fix a duplicate UUID on a XFS file system.
mount -o rw,nouuid /dev/sda1 /data |
Mounting with nouuid will work, but not after a reboot.
To avoid a duplicate ID, run this command to generate a new UUID.
xfs_admin -U generate /dev/sda3 Clearing log and setting UUID writing all SBs new UUID = xxxxx-xxxx-xxxx-xxxxxxxxx |
Yum RPMDB failed
If you are getting an error similar to the yum error below, yum may be broken in your system.
error: rpmdb: BDB0113 Thread/process 2196/139984719730496 failed: BDB1507 Thread died in Berkeley DB library error: db5 error(-30973) from dbenv->failchk: BDB0087 DB_RUNRECOVERY: Fatal error, run database recovery error: cannot open Packages index using db5 - (-30973) error: cannot open Packages database in /var/lib/rpm CRITICAL:yum.main: Error: rpmdb open failed |
Here’s the fix.
mv /var/lib/rpm/__db* /tmp yum clean all |
Run your yum commands. The errors should be gone.