WordPress: Move Blog to new URL Domain HTTP HTTPS on the MYSQL Console

Info: Today most Search Engines prefer Blogs who are offering “HTTPS” at the URL for secure direct connects to the Websites but this results a lot of headaches to the Website Developers.

To be effective you should know:

  • You have to offer HTTPS beside HTTP
  • You should use a validated Domain Certificate, most Domain Resellers offer them for FREE
  • You should know that NOT every FREE Certificate is TRUSTED by every Browser (green closed lock symbol at the adressbar)
  • You have to Develop Websites WITH variable Format output ( PC, Tablet, Smartphone, Smart-TV, Infoboxes,)
  • Design Websites and test 3:2, 4:3, 16:9, 21:9, Formats
  • Easy readable for handicapted People
  • Easy to print to PDF (Test Print Preview Page)
  • Test with different Browsers ( IE, Firefox, Midori, Chrome, Safari, Mobile Browsers like Webview, Silk) if you have no possibilities ask Friends to test

To move the Blog you must access the MySQL Server and the Blog Database! phpMyAdmin Admin Interface should NOT be used if you can use the Terminal for higher Security! If not access the phpMyAdmin Admin Weblogin only be Local IP!!!

MySQL Server:

  • Always remove Anonymous User!
  • Always replace the root User Account with a new one
  • Always use very long Database Passwords! minimum 12 digits !
  • Set if you can the Listen IP to localhost or Socket for the MYSQL Server, no one should be able to access the server via public IP. If you have a virtual Server without second IP install a Firewall like “ufw” and block all Ports without 25, 80, 443!!

Database Changes:

  • Login to the Server via SSH and connect to the MySQL Server with $mysql -u databaseadmin -p
  • Enter following MySQL Commands:

 

mysql > use blogdatabasename;  #change to the blog database
mysql > UPDATE wp_posts SET guid = replace(guid, 'http://www.domain','https://www.domain');
mysql > UPDATE wp_posts SET post_content = replace(post_content, 'http://www.domain', 'https://www.domain');
mysql > UPDATE wp_options SET option_value = replace(option_value, 'http://www.domain', 'https://domain');
mysql > UPDATE wp_posts SET guid = replace(guid, 'http://www.domain','https://www.domain');
mysql > UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.domain','https://www.domain');
mysql > flush query cache; #force updates on the mysql server caches!
mysql > quit;

Testing:

  • Login into your Blog on WordPress and check results and view, save and change all basics settings again on area settings an reading, cause much files are often “cached” by Browsers, Proxy’s or by Cache Plugins!
  • Change wp-config.php add this “define(‘FORCE_SSL_ADMIN’, true);” to force https for Admin Login.
  • Check the Widgets! Cause you can’t change all URL’s at the MySQL Database, cause the Widgets creates “dynamic” URL-Path Entry’s!!!

WordPress: RSS Widget Bug builtin Widget (class-wp-widget-rss.php)

Details: If you enable the basic builtin RSS Widget Module and set the RSS Feed URL like

http://www.domainname.com/feed/ the widget set the URL only on the little “RSS Icon” but NOT on the RSS Hyperlink ! The Hyperlink is pulling the Value of $url (www.domainname.com) but not adding “/feed/” subdir value.

Solution:

  1. go ../wp-includes/widgets/
  2. edit with $nano class-wp-widget-rss.php
  3. go line 81 show title “rsswidget”  href ” ‘  .  esc_url ( $link ) .  #change here $link to $url
  4. exit and save..
  5. check results..

Openwrt : Openwrt 15.XX loses settings if the ROM Root Filesystem is full

On openwrt 15.XX i have seen if you installed additional Sofware via opkg and the /overlay path is nearby full you can’t save any settings via Luci Webinterface (blue Info box right upper corner) or the Router reboots hard automatic into failsave mode (lost all settings / factory reset)

Workaround:

  • You can install a external usb stick on most routers and move the “/overlay” folder to it
  • You should always Download the “backup-settings.tgz” from Software Menu to get the Router easy  and fast online again on last working state.
  • If the rootfs (root filesystem and overlay path) is nearby full, YOU CANT remove installed packages by “opkg” packet manager, cause the ROM is readonly! For this reset the router and restore easy from “backup-settings.tgz”.
  • If the external USB Drive loses connect to the Router (Power failure) and you use Samba as NAS Server the /overlay path can run full too!! and the Router can crash and reset too!! This shows openwrt should NEVER be used for secure routing jobs AND NAS Operations ! Cause it can you lock out!

Result: openwrt is a nice opensource router os which allows you to control and active monitor your internet connections with realtime graphs (WebUI+Console) and blocking rules. It should always be used behind a black boxed ISP router of your provider to get a private area!

Openwrt: Turn older Router into Wifi Accesspoint Repeater Extender Solar Powered

At the Summer Time you need perhaps a Wifi Extender for your Garden??

Solution:

  • TP Link 841/N (low power/Battery 9V/Solar /Type-N-allows external planar Antennas!!), 3600+4300 (USB-NAS/CIFS/SFTP/Classroom Library with USB Strorage)
  • Openwrt 15.XX Calmer as OS with Firewall, Webinterface and REALTIME Monitor for Traffic and Connections!
  • Easy Setup, replace the OS by the TP-Link-Updater, reboot and Login to Openwrt
  • You got professional Options!
  • works as Firewall, Extender, Repeater, WIFI-to-WIFI Bridge, LAN-to-WIFI Bridge, NTP-Server, DNS/DHCP Server
  • can isolate connected WIFI Clients
  • can handle different WIFI SSIDs / Networks on same Hardware
  • modded Hardware can be used with 5Volts of Power! (841 removed Resistor)
  • runs Freifunk OS for Public Free WIFI Guestnet (without Password Login and VPN to Public Internet Gateways for anonymous Web Access)
  • free security updates, backup and restore of settings!
  • free support by published Wikis, many Manuals on Internet and of course by me
  • free Download od the Sofware at openwrt.org

freifunk