• Cisco DHCP Snooping Relay Setup Information


    Switch#show ip dhcp snooping Switch DHCP snooping is disabled DHCP snooping is configured on following VLANs: 1 Insertion of option 82 is enabled circuit-id format: vlan-mod-port remote-id format: MAC Option 82 on untrusted port is not allowed Verification of hwaddr field is enabled Interface&nb........
  • Linux How To Eject and Insert a CD-R/DVD-R/BD-R Disc


    Many people are aware of the "eject command" which works as you would expect. To eject the disc: sudo eject /dev/sr0 To insert the disc again you still use the same command but with the "-t" close try toggle: sudo eject -t /dev/sr0 ........
  • 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........
  • MySQL Cannot Update/Write to any database table solution


    This happened on Centos for no apparent reason with no obvious issue in the logs. Data could be read fine but not written (possibly due to some corruption or out of memory issue in the OpenVZ container is the best guess). All mysql update and insert queries failed freezing without any error log on any database and table. Tried to restart: service mysqld restart Timeout error occurred trying to stop MySQL........
  • ffmpeg trouble concatenating similar but different files


    When things go wrong your video is basically unplayable or the first video plays fine and then freezes when moving on to the next. Generally if both videos weren't produced with the exact 100% same settings you will have issues. You can try the basic concat but it often won't work right. Solution for me: My example uses 3 videos in total so "n=3" and a=1 to include audio. ffmpeg -threads 12 -i file1.mp4 -........
  • ecryptfs errors


    ecryptfs-mount-private Enter your login passphrase: Inserted auth tok with sig [ee16d84] "into the user session keyring mount: No such file or directory" [ 156.118113] ecryptfs_mount: kern_path() failed [ 156.118431] Reading sb failed; rc = [-2] [ 164.233055] traps: mate-notificati[3472] trap int3 ip:7f43d7002c13 sp:7fff162c6600 error:0 [ 166.017061] ecryptfs_mount: kern_path() failed........
  • PayPal Subscription Howto Creation Automatic Payments Manual


    An easy way to pay companies and friends/family since PayPal does not have an option when sending money to make it a subscription: "business" = The e-mail or PayPal ID of the person/organization to pay to. a3 The recurring amount "eg. 115" will be 115 USD p3 The time period (eg. 2) t3 Unit of time period m=monthly,w=weekly,y=yearly item_name = "the note/product service reason you are paying ha........
  • Apache Vhost HowTo Serve Same Content using a different domain and IP


    There are a few ways of doing this and all basically involve using the reverse proxy or "ProxyPass" feature of Apache to accomplish it. 1.) Create a normal vhost and simply symlink the root directory of the site you want to mirror. Eg. originalsite.com and newsite.com /vhosts/originalsite.com/httpdocs You would symlink like this: ln -s /vhosts/originalsite.com/httpdocs vhosts/originalsite.com/........
  • Mysql how to backup/copy row from one table to another


    INSERT INTO articles_backup SELECT * FROM articles WHERE articleID="118" It is so simple we always recommend people do this when updating their database so you always have a backup. The above inserts the copy into the table "articles_backup" which has an identical structure. It selects the entry from "articles" where the articleID is "118" but of course you can adapter yours to whatever the situation is.........
  • Virtualbox errors on Ubuntu/Debian/Mint


    The solution was to reinstall the vbox dkms package and do a manual modprobe of the modules it makes. I never sorted out the unable to start due to the USB issue, I did have the guest additions installed but the only way to boot was to change the pointing device from USB to PS2 and then to disable the USB controller (if your pointing device is set as USB, disabling USB will not work because it will re-enable by default when it sees your pointing device is USB, this is w........
  • flypro EEPROM PLCC32 programmer software error "The device ID does not match, whether to continue operating"


    If you get that message it means you have inserted the adapter or device incorrectly. In my case the adapter needed to be at the rear end of the pins and it caused this message. Do not ignore this message as it may appear to work but you will get errors and in reality your chip will not be erased or programmed even if it appears like it is working.........
  • Sipura / Linksys PAP/VOIP/SIP Adapter Issue Can't receiving incoming phone calls and you're behind a NAT router (99% of people)? solution


    Sipura / Linksys PAP/VOIP/SIP Adapter Issue Can't receiving incoming phone calls and you're behind a NAT router (99% of people)? 1. Login to the adapter. 2. Click on "Advanced" (location varies but usually somewhere on top) 2. Click on "SIP" 3. Scroll down to "NAT" (usually at the bottom). You'll find 2 columns with 4 rows of drop-down boxes (they'........
  • Dell FS12-NV7 2U Server Information and Guide


    I've got one of these for testing projects from work at home and got more than I bargained for with the time I've spent on it due to the storage handing/Perc 6/i cards. My particular model came with the following: 2U Rack Mount Server with Rails 2xOpteron 2373 EE (Quad Core, there is a 6-core version that can be found at times) 16GB RAM 2 x 250GB Seagate SATA 2 x Dell Perc 6/i (horrible and a nightmare to work........
  • package kernel-xen-2.6.18-274.7.1.el5.x86_64 is intended for a x86_64 architecture solution


    package kernel-xen-2.6.18-274.7.1.el5.x86_64 is intended for a x86_64 architecture Linux etc 2.6.18-274.7.1.el5xen #1 SMP Thu Oct 20 17:06:34 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux As you can see above architecture and kernel is 64-bit but I had to force it to install using "--ignorearch" Solution #rpm --ignorearch -ivh kernel-xen-2.6.18-274.7.1.el5.x86_64.rpm Preparing...&nb........
  • MySQL HowTo Copy Duplicate a Table for backup purposes


    This is a great way to test and experiment without risking your current table, or to make a backup of your current table to avoid corruption or dataloss due to malicious activity eg. deletion etc.. There are two steps and two commands 1.)Copy Table Structure "cars_backup" is the new table and it will be a copy of the table called "cars"........
  • Samsung Galaxy Note I717M Canadian Version, Root and Unlock


    I chose this because I heard a lot of stories about scams and that many providers I contacted said they can't unlock the Canadian I717s (one said "my Bell server" is down). This method worked perfectly on my Bell I717M and should work for all I717 in Canada, I was able to insert a foreign SIMcard. This will work abroad too but remember entering CWM mode is different for I717's in other countries (at least theUS). Step 1 - Root + CWM........
  • Samsung Galaxy Note ICS Corrupting microSDHC partition table?


    This was partitioned as a single 32GB VFAT but when I inserted it into the phone it said that it can't read it and now here is how the partition table looks. Interestingly enough the data works and reads fine from the computer still. Disk /dev/sdb1: 32.1 GB, 32085360640 bytes 64 heads, 32 sectors/track, 30598 cylinders, total 62666720 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum........
  • gocr - free Linux OCR (Optical Character Recognition) conversion tool


    gocr works great and it's simple, just invoke it like so: gocr filename.png The output will be printed to the screen. My only complaint/concern is that even with standard terminal output (not scanned) from a printscreen, gocr does make mistakes by inserting extra spaces where they don't belong, mistaking letters for numbers etc.. but it's definitely enough to be readable and figure out what you're looking at. I haven't tested yet with scanned input........
  • MySQL Import CSV data tutorial guide


    It's actually fairly straight forward: load data local infile 'billpayments-payments.csv' into table payments fields terminated by ',' enclosed by '"' lines terminated by 'n' The above assumes that your fields are terminated by a comma (some programs like OpenOffice change this to a semi-colon ;) and that they are enclosed with " The above will insert the data from billpayments-payments.csv into the table payments.........
  • Dying Samsung DVDRW Drive


    My Samsung drive failed on me, at first I thought it was the enclosure but a direct SATA connection causes the same problems for discs that are inserted. It will work fine for a few minutes but then starts spewing the errors below. I've never been a fan of Korean made optical drives and have always had trouble with them. The problem is that I don't believe NEC and Lite-ON make drives anymore, and I considered them the leaders. Apr 7 11:58:48 bo........
  • Ubuntu/Debian DRBD 8.0 Setup Guide


    I've only used it on Centos, soI thought I'd make a quick Debian guide: Install the DRBD Package apt-get install drbd8-utils Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libswfdec-0.8-0 Use 'apt-get autoremove' to remove them. The following........
  • MySQL Insert Statement ONLY IF a duplicate entry does not exist


    This is a great way to reduce MySQL code/mistakes/annoyance when doing things, take for example this statement: INSERT IGNORE INTO sometable(CatName) VALUES("someitem"); Notice the "IGNORE", that is what does the magic. Normally if the entry "someitem" existed you'd get an error message back such as "Duplicate entry for whatever". What I have normally done in PHP or whatever language is manually coded or made a........
  • Asus Eee PC 1000HE Crashed/Need To Recover/Restore Windows? Easy Solution is Hitting F9


    I'm not a fan of Asus and won't be buying another because of having to fight Asus over a bogus warranty denial (it's a long story but they only replied about how to RMA my unit weeks later on the EXACT day the warranty expired). Anyway, it's just a matter of hitting F9 to do this, there's no need to worry about booting from USB or CD (unless of course you want a different OS eg. Windows XP Pro, Vista/7, or a flavor of Linux or Unix). Also remember that you need to fully/properl........
  • GRUB Boot FreeBSD


    GRUB Boot FreeBSD[code:1:a7050277b7]title FreeBSD 6.0 root (hd0,2,a) kernel /boot/loader[/code:1:a7050277b7] Just insert the above code into GRUB's [b:a7050277b7]menu.lst[/b:a7050277b7] and make sure you set the root path correctly. [quote:a7050277b7]Let's quickly explain what the root (hd0,2,a) means: *hd0 stands for the primary master drive *2 stands for partition 3 *a stands for the........
  • CREATE Database/Granting Privileges


    CREATE Database/Granting PrivilegesCREATE your first database Code: [code:1:0668cd8e74]CREATE database myfirstdb; [/code:1:0668cd8e74] CREATE a user for your first database This one creates the user 'sqladmin' and gives them 'usage' on your new database 'myfirstdb' Code: [code:1:0668cd8e74]mysql> GRANT usage on myfirstdb.* to sqladmin@localhost; Query OK, 0 rows affected (0.00 sec)[/code:1:0668........
  • Writing/Burning a data CD-R/DVD-R or DVD+RW in Unix/Linux


    There's a lot of outdated information and confusion for system administrator's out there. One annoying task for many an Administrator has been backing up data in Linux. You don't need any GUI tools such as K3B or GnomeBaker. Both are excellent tools but for veteran command line users working remotely, using the keyboard is a great and possibly automated way to save yourself pain and hassle. At a later date we'll cover how scripting can automatically backup certain........
  • Latest Articles

  • python 3 pip cannot install mysql module
  • QEMU-KVM won't boot Windows 2016 or 2019 server on an Intel Core i3
  • Virtualbox vbox not starting "No suitable module for running kernel found"
  • Bind / named not responding to queries solution
  • Linux Mint How To Set Desktop Background Image From Bash Prompt CLI
  • 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