How to Migrate a WordPress MySQL Database

I very often have to migrate MySQL Databases as I like to spend some time playing with Wordpress. So here is an easy and quick way to migrate your DB and avoid manual work when moving a blog from different providers/servers. Pre-Requisites You must have a pre-configured MySQL server, database and user already created in the destination(new) server You can either use command line or PHPMyAdmin if...

Including New Apps in the Search engine on Ubuntu

If you are experiencing issues when trying to search for your recently installed software on Ubuntu, try to create this file with all the info about your software. Version=x.y Name=ProgramName Comment=This is my comment Exec=/home/alex/Documents/exec.sh Icon=/home/alex/Pictures/icon.png Terminal=false Type=Application Categories=Utility;Application; It needs to be placed at this path:...

How to use Lets Encrypt (Debian / Ubuntu)

Let’s Encrypt is an SSL certificate authority managed by the Internet Security Research Group (ISRG). It utilizes the Automated Certificate Management Environment (ACME) to automatically deploy free SSL certificates that are trusted by nearly all major browsers. 1. Update/Upgrade your system sudo apt update && sudo apt upgrade   2. Download and Install Lets Encrypt sudo apt-get...

FOSDEM 2019

Last weekend I attended FOSDEM 2019 and I was amazed how big is this. Since 2001, FOSDEM is a free and non-commercial event organized by volunteers for software developers to meet, share ideas and collaborate. Every year, thousands of developers of free and open source software from all over the world gather at the event in Brussels. It's widely recognized as the best such conference in Europe....

Oracle DB – How to select user roles

You can use this SQL script giving the username as argument. Example: sqlplus myuser@myDBName @select_roles.sql user1 /* select_roles.sql Script */ select lpad(' ', 2*level) || granted_role "User and roles" from ( /* THE USERS */ select null grantee, username granted_role from dba_users where username like upper('%&1%') /* THE ROLES TO ROLES RELATIONS */ union select grantee, granted_role...

Install and configure chrony – CentOS7

What is Chrony ? Chrony provides another implementation of NTP. It is designed for systems that are often powered down or disconnected from the network. The main configuration file is /etc/chrony.conf and the parameters are similar to those in the /etc/ntp.conf file. Chronyd is a daemon that runs in user space and also is a command-line program that provides a command prompt and a number of...

Ubuntu with /var/lib/dpkg locked

Error: "Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)" As soon as you have your Ubuntu 16.04 machine up provisioned by either Ansible or Vagrant, it starts a process for unattended-updates that locks the dpkg repository and any script that needs to send instructions for apt app, will fail. This appears to be caused by a combination of an unattended-upgraded...