• Duplicate entry '2147483647' for key 'PRIMARY' MySQL Error Solution

    This usually happens when you are using something like an INT and try to insert a larger valuethan the maximum which is larger than "2147483647" On a practical term I have seen this and been guilty of this error when using scripts like PHPand generating large random numbers: $hash = mt_rand(5,9999999999999); Obviously that many 9's are more digits than the maximum of an INT resulting in that error. Change your code accord........
  • h264 DVR security camera footage cannot be played

    This is not just a Linux issue but a general issue most software or hardware players cannot play the resulting exported/backed up format of .h264 from DVR security camera footage for some silly reason. There is a simple solution in Linux using ffmpeg fortunately. Convert the .h264 file into mp4 ffmpeg -i yourfile.h264 -codec copy video.mp4 play dvr .h264 file........
  • mdadm frozen and doesn't realize array is dead/missing failed due to unplugged drives

    This was a surprising bug but I unplugged all drives for an array md127. At first it was just 1 drive and mdadm seemed to notice this. I unplugged the second drive taking the array offline but mdadm did not realize it was offline and still showed a non-existent disk as being part of it. This created problems trying to unmount it or even to stop this array with mdadm freezing. As for how to fix it I can only think of making sure you are not in a mounted path of........
  • How to Normalize and Increase the Volume on M4A files in Linux

    M4A is a weird format, so you have to be creative here is a quick copy of what I did. Basically you need to convert to .wav to make use of them and thenI converted the resulting .wav into an mp3 (nice small file size and basically universally playable): ======= sudo apt-get install mpg321 mp3gain faad normalize lame faad "Voice 002 (copy).m4a" faad "Voice 002 (copy).m4a"........
  • Howto edit/rotate Samsung/Android Videos in mencoder solution

    Movie-Aspect is undefined - no prescaling applied. videocodec: libavcodec (720x1280 fourcc=34504d46 [FMP4]) [mpeg4 @ 0x2c91c00] timebase not supported by mpeg 4 standard Could not open codec. FATAL: Cannot initialize video driver. That is the error I would get, I thought it was a codec error something else. By fluke Isaw something about ffmpeg where someone recommended manually telling it to the "fps" and it worked.........
  • How to Encode all VOBs from a DVD/Bluray VIDEO_TS folder into an XVID

    In my case I already copied the VIDEO_TS folder to my hard drive. Here is the command for mencoder: mencoder -dvd-device "myvideobackup/VIDEO_TS" dvd:// -ovc xvid -oac mp3lame -lameopts cbr:br=128 -xvidencopts pass=2:bitrate=-700000 -o myvideobackup.avi Replace "-dvd-device myvideobackup/VIDEO_TS" with the location of your backup files or the /dev device of your DVD drive. The -o myvideobackup.avi is of course the name o........
  • KVM/QEMU Base/Template Images and the power they provide

    qemu-img create -b centos.5-8.x86.20120308.qcow2 -f qcow2 ../kvmguests/25000-centos5.8x86.qcow2 Formatting '../kvmguests/25000-centos5.8x86.qcow2', fmt=qcow2, backing_file=centos.5-8.x86.20120308.qcow2, size=10485760 kB -b the source/base image -f format is qcow2 and the location of the destination image What is so special about this? It's even quicker than creating a template with OpenVZ but this is an actual OS. It saves time a........
  • Linux Quick and Simple Animated Banner Creation using gifsicle

    This is just how I like things, quick and simple through CLI (command line) using gifsicle for free. gifsicle --colors 256 --delay=200 --loop banner.gif banner-page2.gif > banner.gif banner.gif = the first page of the banner banner-page2.gif = the second page --delay=200 ms to switch between the two --loop=it goes back and forth between the two pages forever banner.gif=the resulting animated gif. There are many other opti........
  • Convert PDF to JPG/JPEG without low resolution/small picture size

    convert -density 400 somepdf.pdf -scale 2000x1000 output.jpg The key is the "-density 400" switch and also -scale 2000x1000 To give credit I found the solution here: http://www.imagemagick.org/discourse-server/viewtopic.php?f=1&t=10928 That was the perfect solution when I was frustrated with how small the resulting JPG's resulted. I'm sure this will help a lot of people when it comes time to converting a PDF to JPG which I'm amazed Imag........
  • OpenVZ backup container to a single file while it's running using "vzdump"

    Proxmox has made this free utility to backup running OpenVZ containers. It's a great program which is actually just a PERL script but gets the job done. This program is not 100% required because all it really does is cp -a from your container's path as far as I know but it is still good to have uniformity to how you backup your containers. For RPM distros such as Centos/RHEL/Fedora etc.. download and install this: wget http://www.proxmox.com/cms_proxm........
  • Latest Articles

  • ImageMagick Convert PDF Not Authorized
  • ImageMagick Converted PDF to JPEG some files have a black background solution
  • Linux Mint Mate Customize the Lock screen messages and hide username and real name
  • Ubuntu/Gnome/Mint/Centos How To Take a partial screenshot
  • ssh how to verify your host key / avoid MIM attacks
  • Cisco IP Phone CP-8845 8800/8900 Series How To Reset To Factory Settings Instructions
  • ls how to list ONLY directories
  • How to encrypt your SSH private key file id_rsa
  • Linux Mint 18 Disable User Name List from showing on Login Screen
  • Firefox Cannot Hit Enter Key In Address Bar and Location History Not Working
  • Cisco Unified Communications Manager / CUCM IP 8.6,10,12 Install Error Solution
  • Ubuntu Debian Mint Linux SSHD OpenSSH Server Not Starting After Reboot Solution
  • nmap how to scan for all ports and not just the 1000 most common ports
  • Windows 7,8,10 and Server 2008, 2012, 2016, 2019 Read Only Attribute Won't Go Away
  • bind / named how to make a wildcard record and retain defined A records
  • Cisco Unified Communications Manager 12 Install Errors on Proxmox/KVM
  • Local Vs Universally Administered MAC Address NIC Refuses to come up
  • Cisco Unified Communications Manager 12 CUCM 12 - How To Enable Video Calling
  • Windows 7, 8, 10, Windows Server 2008, 2012, 2016, 2019 How To AC97 Audio Drivers and Other Unsigned Drivers
  • Cisco Unified Communications Manager / CUCM IP Telephony Definitions