Google Webmaster Tools Twitter

Last Time i tried  to integrate a Twitter Timeline into my blog but i found out that this ranked down my blog on Google Webmaster Tools cause Twitter sub connected Servers blocking Google Webmaster Bot from reading the timeline by own robots.txt so i stopped using Twitter Integration to fix. 

No Webmaster want show non indexed Informations  and went back to the time of  stones.. Twitter fails..

WordPress: Change User Password manual on mysql prompt

If you don’t want to use Passwords generated by wordpress itself, you can do it manual on a MYSQL Console

howto:

  • Login to your Webserver with the Database via encrypted SSH!!
  • Login to the MYSQL Server Conssole with

$ mysql -u username -p

  • Enter Password, and change database with

mysql>use database-name-of-blog

  • Now Set Password for the User

mysql>UPDATE wp_users SET user_pass = MD5('NEWPASSWORD-16-DIGITS') WHERE user_login = "THEUSERNAME";

  • System shows Echo:

mysql> ok.. Changed 1 Row..

  • Quit

mysql> exit

  • Logout of SSH

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!!!

getsimple cms: blog plugin bug with mod_rewrite

Problem: If you use the „blog“ plugin and move the blog roll to a other site or subfolder you have to recreate the „.htaccess“ file.

You find the „.htaccess“ generator tool link inside blog plugin settings! recreate the „.htaccess“ and put it into the root dir of your webspace

.htaccess dump of a correct file if getsimple is installed to ./

AddDefaultCharset UTF-8
Options -Indexes

# blocks direct access to the XML files - they hold all the data!

    Order allow,deny
    Deny from all
    Satisfy All

    Order allow,deny
    Allow from all
    Satisfy All

RewriteEngine on

# Usually RewriteBase is just '/', but
# replace it with your subdirectory path-> if your site is located 
#in subfolder you need to change this to reflect (eg: /subfolder/)
RewriteBase /

RewriteRule ^post/([^/.]+)/?$ index.php?id=index&post=$1 [L]
RewriteRule ^tag/([^/.]+)/?$ index.php?id=index&tag=$1 [L]
RewriteRule ^page/([^/.]+)/?$ index.php?id=index&page=$1 [L]
RewriteRule ^archive/([^/.]+)/?$ index.php?id=index&archive=$1 [L]
RewriteRule ^category/([^/.]+)/?$ index.php?id=index&category=$1 [L]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule /?([A-Za-z0-9_-]+)/?$ index.php?id=$1 [QSA,L]

getsimple CMS the free slim lightweight CMS

getsimple is a very easy to handle Content Management System for free, it can be used for Homepages, Businesscards, Blogs..

Advantages:

  • light
  • no database framework
  • opensource
  • free
  • fast
  • easy to setup
  • easy to move to a new domain
  • offers backups tool
  • offers recovery for posts
  • extendable with plugins
  • free themes
  • clean design
  • low system requirements for embedded Systems
  • needs PHP5 and rewrite_module enabled on Apache
  • offers debug Log to find errors

Download Source: http://get-simple.info/

Community on google+

Screenshot:

getsimple-cms