Author: troy

Responsive iframe WordPress

div class=”iframe-container” iframe src=”” allowfullscreen /iframe /div .iframe-container { overflow: hidden; padding-top: 56.25%; position: relative; } .iframe-container iframe { border: 0; height: 100%; left: 0; position: absolute; top: 0; width: 100%; } /* 4×3 Aspect Ratio */ .iframe-container-4×3 { padding-top: 75%; }

Mysql Isolate One Table to Restore from Backup

In order to restore only one table from a mysql database backup file, you want to isolate the single table to another sql file. Use SED on the shell command line: sed -n -e '/– Table structure for table `onetable`/,/– Table structure/p' backup.sql > onetable.sql You will want to DROP the table from the database. From the mysql command line:...

Systemd ssh Reverse Tunnel on Debian 9 Stretch

I have used rc.local for years to setup an ssh reverse tunnel on boot under Debian up until Stretch. Now like many others I imagine, I’ve had to convert to systemd. I read everything I could about the choice for deprecating rc.local for systemd. I can say that systemd may be powerful, but systemd’s complexity entails a huge learning-curve for...

Apache2 Custom 404 Page

Create a html page sudo vi /var/www/missing.html whateveryouwanttosay sudo chown www-data:www-data /var/www/missing.html sudo vi /etc/apache2/conf.d/localized-error-pages Uncomment #ErrorDocument 404 /missing.html sudo service apache2 restart

Harden Apache 2.2

sudo vi /etc/apache2/conf.d/security ServerTokens Prod ServerSignature Off sudo vi /etc/apache2/sites-available/default Directory /var/www/html> Options -Indexes /Directory>

Fail2ban Mysql Database to Manage Persistent Bans

Step 1 Create Database and Tables in MySQL Add a “source” field for the server name if you want to use a remote database setup (and add it to the UNIQUE KEY). The UNIQUE KEY prevents duplicates of course. But this means you can refresh the perl script without handling duplicates there which would complicate things considerably. CREATE TABLE iptable...

LAMP upgrade to mysql 5.6 PHP installation appears to be missing the MySQL extension which is required by WordPress

WordPress Running on Debian 7 LAMP After upgrading to MYSQL 5.6 from 5.5 I encountered several problems, first of which was a completely broken MySQL then Apache2.3 and PHP complained. This ultimately cleaned up the mess: sudo dpkg –purge mysql-client-core-5.6 sudo dpkg –purge mysql-client sudo dpkg –purge mysql-server-core-5.6 sudo dpkg –purge mysql-common sudo dpkg –purge mysql sudo apt-get –purge remove...

Disable IPV6 Debian

sudo vi /etc/sysctl.conf # to disable IPv6 on all interfaces system wide net.ipv6.conf.all.disable_ipv6 = 1 # Uncomment the next two lines to enable Spoof protection (reverse-path filter) # Turn on Source Address Verification in all interfaces to # prevent some spoofing attacks net.ipv4.conf.default.rp_filter=1 net.ipv4.conf.all.rp_filter=1 # Do not accept ICMP redirects (prevent MITM attacks) net.ipv4.conf.all.accept_redirects = 0 #net.ipv6.conf.all.accept_redirects = 0 #...

Stop the Kernel Logging ipv6

To disable IPv6 on all interfaces system wide sudo vi /etc/sysctl.conf add this line net.ipv6.conf.all.disable_ipv6 = 1 Or To disable IPv6 on an interface only net.ipv6.conf.lo.disable_ipv6 = 1 net.ipv6.conf.eth0.disable_ipv6 = 1 sudo sysctl -p /etc/sysctl.conf or reboot

DD Used Space Only Image File Using Gzip Solved

The problem is how to create an img of a disk (or storage of any kind) while not saving the entire unused space – shrink empty disk space with dd. Like many similar problems, I found many posts about how to save the img of a disk and remove empty partitions. Most are obsolete or did not work as specified, which...

Perl 24 Hour Sleep Clock

I searched a lot for all kinds of sleep and wake solutions to find everything but what I wanted. Hopefully this helps someone else. Problem: based on a 24hour clock, sleep after 5pm and wake (go back to work) at 8am. Or pause during non-work hours. #!/usr/bin/perl use strict; use warnings; my $waketime = 8; # sleep when hour <...

Disable RC4 and SSL3

sudo vi /etc/apache2/mods-available/ssl.conf SSLHonorCipherOrder on SSLCipherSuite “EECDH+ECDSA+AESGCM EECDH+aRSA+AESGCM EECDH+ECDSA+SHA384 EECDH+ECDSA+SHA256 EECDH+aRSA+SHA384 EECDH+aRSA+SHA256 EECDH+aRSA+RC4 EECDH EDH+aRSA !RC4 !aNULL !eNULL !LOW !3DES !MD5 !EXP !PSK !SRP !DSS” SSLProtocol All -SSLv2 -SSLv3 SSLCompression Off

How To Configure exim4 on Debian

sudo vi hosts localhost {server ip address} www sudo vi hostname hostname -f sudo vi /etc/mailname apt-get install exim4 dpkg-reconfigure exim4-config (the following setup for Google mail server) Hide local mail name in outgoing mail? No Split configuration into small files? Yes sudo vi /etc/exim4/update-exim4.conf.conf dc_eximconfig_configtype=’smarthost’ dc_other_hostnames=’localhost;’ dc_local_interfaces=’′ dc_readhost=” dc_relay_domains=” dc_minimaldns=’false’ dc_relay_nets=” dc_smarthost=’′ CFILEMODE=’644′ dc_use_split_config=’true’ dc_hide_mailname=’false’...