Month: April 2017

WordPress: Secure Faster Effective Blogging

If you use WordPress or a other CMS for daily blogging, it’s useful to have a own User Acount on a PC. Advantages: Own Browser for Blogging with saved Passwords Own Link Bar for quick switching between the Social Media Platforms You won’t need to open Security Holes like API Software Interfaces for used Plugins Speeds up the WordPress Blog cause reduced Plugin loads You have the full control. cause most free API Plugins save your Passwords on foreign Servers One touch Bookmarks let you jump fast between the Social Media Platforms No Data are automatic transfered without your knowledge […]

Review: Tiny powerful MP3 Player

If you look for a Travel MP3 Player which is useful, powerful and easy to handle you should take closer look on this Odys MP3 Player. Advantages: Battery Powered 1x Standard AAA High Output Anti Shock Resistent Low Price Ease to handle Equalizer (not often needed) Output for 2 Persons Dual Stereo Jack Sun readable Display with Backlight for Nights Different Play Modes, Shuffle, Repeat and Repeat all Much louder than most Smartphones! Hard Case for Jogging / Outdoor usage Can update older Ghetto Blasters with MP3 Option Can offer a local Home “FM” Radio Station with a 3,5mm Stereo to FM […]

WordPress: Change Word on all content sites with mysql

If you run a WordPress Blog or other CMS with MySQL Backend you can easy change one same word or expression on all content sites on the fly Do a mysqldump at first of the current database $ mysqldump -u username -p dbname > dbbackup.sql Login to the MySQL server Console Switch to the Database mysql> use dbname; run command for tests, lists touched posts mysql> SELECT * FROM wp_posts WHERE (post_content LIKE '%expression%'); Run Replace code to pre, cause i use preformat text plugin for the copy & paste boxes mysql> UPDATE wp_posts SET post_content = REPLACE ( post_content, […]

FreeBSD: Monitor svn Updates

If you use the  svn subversion tool to update source tree or ports tree, you want to have a possibility to look back what was pulled, pushed and droped you can use a Log File to monitor the update scripts. This helps if you temporarily log out the Terminal Sessions for a Coffee break. Howto: Login to FreeBSD via SSH Use a tmux program like screen or tmux, if not installed, then install it. This allows ongoing operations on disconnects Run on the Terminal $tmux Run $sudo svn update /usr/src > /home/updates/svn.log #exit STRG+B then press "d" detach The svn […]

FreeBSD: Current Version port upgrade fails with “portsnap extract” bug

If you use the current “head” Version (Release 12) of FreeBSD with a svn updated /usr/src path you could run into errors after updating the OS via buildworld from sources. There’s a bug ahead Revision “r314099” at the “portsnap” lib that will stop on extracting the ports.tgz to /usr/ports! Solution: Pull again sources to /usr/src with $svn update /usr/src $make buildworld $make buildkernel $make installkernel $reboot $mergemaster -p $make installworld $mergemaster -FiU $reboot $portsnap fetch update #again.. to update ports tree $portupgrade -a $reboot This should work now, the failed portsnap extract function was a known bug. If you dont […]

WordPress: Monitor the Size of the MYSQL Database

If you use WordPress or a other Blog Software with a MySQL Database over years it is useful to do some things regularly: Check the Database Size weekly, that no Skript Kid has found a Backdoor and fills up the Database silent Purge Database Caches with default maintenance tools of the Software Dont forget to create a MySQL Dump Backup weekly with cron To Check the Size login on mysql command prompt do: $mysql -u dbuser -p #Enter Password mysql > use dbwordpress mysql > SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024 "Data Base […]

Centos: Release 5 now “end of life”

On 2017, March 31th the official Release End of Version 5 is reached. This also touches SME Server Version 8.1. If you use this you must now upgrade the Webserver to the next Version. Checkout which last version offers latest Options like PHP7, MYSQL 6 ..more Checkout that you current Content PHP Kits Support the new OS Options (PHP7) As Remark you should do at first a FULL BACKUP of your DATA!! see here Save manual the /etc folder to Backup, dump crontabs and firewall settings! (ufw) Setup a fresh OS if you are not a Professional Admin cause to […]

WordPress: Why less plugins is more?

WordPress is a well known Blogging Platform to publish your Content to the world. But after some years of analysing of my Webserver Logs i remarked that a lot of used plugins produces more errors on inside linking than i would like to have. I could not explain why the Search Engines run into Errors or dead ends if they scan via the bots the Content. I didn’t realize that the plugins were the bad factor. If you see same problems you can start up analyse your Blog for free with these steps: Go Plugins disable all uneeded Plugins like […]

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

Impressum Datenschutz-DSGVO-GDPR

www.linuxonlinehelp.eu - Nonprofit Linux PC & Server Support since 2004 Tags: Linux Online Help, Linuxonlinehelp, Linux Support, Linux Hilfe