change mysql table column from ENUM to VARCHAR
mysql> ALTER TABLE database.table MODIFY column-name varchar(255) default ’10M’; Query OK, 12137 rows affected (1.40 sec) Records: 12137 Duplicates: 0 Warnings: 0
Network interface settings – CentOS
Configuration of the “/etc/sysconfig/network-scripts/ifcfg-eth0” file In this file, you would find your basic network device configuration. Here, ifcfg-eth0 is the first Ethernet device; ifcfg-eth1 would be the second Ethernet NIC (network interface card), and so forth. In this file, you can have quite a few settings. Directives Required / Optional Expected Settings Comment DEVICE= Required ethX You must have […]
Mount NTFS partition in Linux
Mount NTFS partition in Linux Mount NTFS partition in Redhat Enterpris Linux / Ubuntu Linux Enterprise Linux distributions like Redhat Enterprise Linux ( RHEL ) does not provide native support to Windows NTFS partitions. However you may wand to mount a NTFS formated partiiton in your RHEL box. Here is a simple howto to mount […]
cheat sheet – find command
1. Basic find command # find -name “TestFile” 2. Find Files Using Name and Ignoring Case # find -iname “TestFile” 3. Limit Search To Specific Directory Level Using mindepth and maxdepth # find / -maxdepth 3 -name passwd -maxdepth –> will go 3 directories below — / 1st; /etc 2nd; /usr/bin 3rd # find / […]
Setgid and Sticky bit in Linux
Special permissions on files and directories in linux are : SetUID, SetGID and Sticky bit. With the help of “chmod” command we can implement the special permissions on file and directories. SUID / Set User ID : A program is executed with the file owner’s permissions (rather than with the permissions of the user who executes it). SGID / Set Group ID […]
reset root password- ubuntu boot in single user mode
For that press down the “shift” key while booting and you will get the GRUB boot menu. Normally the top GRUB entry will be pointing to your normal boot entries. It will look similar to: Press the ‘e’ key to edit the kernel parameters. Now what you see are the boot entries. Now find the kernel line and append “init=/bin/bash” to […]
install and configure squid guard – pfsense
To install packages you would go to Systems > Packages menu and click on the Available Packages tab and click on the (+) sign next to each package Configure Squid: So now you have your packages installed it’s now time to enable squid, but before we do that we need to configure some squid options: 1.) Go to Services > Proxy Server […]
Squid https transparent proxy setup with SSL certificate
Squid https transparent proxy setup with SSL certificate Let’s understand first how squid proxy works in transparent mode. While setting up squid as a transparent proxy we can forward the entire request coming from port 80 to squid server’s port i.e. 3128 by default. When we talk about port 80 it means http protocol. What […]
how to check if iPhone Display is original or third party / fake
Third-Party Display Modification Illuminate display with an LED flashlight. If reflection on display has color bands or refractive color banding as shown on the left, then it is an original Apple display. The banding will not be present on a device that has this type of third-party display. Note: If display powers on, then this test is […]
determining if iPhone has come into contact with liquid contamination – check water damage
Liquid Contact Indicators (LCIs) Phone 5 is equipped with one external LCI to assist with determining if iPhone has come into contact with liquid. A triggered LCI indicates that the iPhone may have come into contact with liquid. When a phone comes into contact with liquid, a red color fills a circle within the LCI. […]