Moodle – How to install Moodle on Ubuntu 18.04

This post will show you how to install Moodle step by step by below details: 

  • OS: Ubuntu 18.04
  • Web Server: Apache 2.4
  • PHP 7.2
  • Mysql 5.7
  • Moodle 3.6


Moodle – Mysql query initiate new DB for Moodle

How to create Data Base for Moodle Instance via CLI Mode

run: CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON moodle.* to 'youredbusername'@'localhost' identified by 'yourepassword'; 


Ubuntu – How to open new Ubuntu 18.04 server on Digital Ocean

Step 1 (registrations)

Create account on digital ocean

After registration click on create new droplet and choose Ubuntu 18.04


Moodle – Query to copy logstore_standard_log to logstore_xapi_log

Query to Import all current moodle logs to xapi logs

TRUNCATE mdl_logstore_xapi_log;
INSERT INTO mdl_logstore_xapi_log
 (id, eventname, component, action, target, objecttable, objectid, crud, edulevel, contextid, contextlevel, contextinstanceid, userid, courseid, relateduserid, anonymous, other, timecreated, origin, ip, realuserid) 
 select * 
 from mdl_logstore_standard_log;

Moodle – Filter Team Work tutorial

This tutorial will describe how to use Team Work filter plugin in Moodle environment. Please, follow the instructions: 

Download plugin with link:


Moodle -Query to change all users details

UPDATE mdl_user 
idnumber= CONCAT('1000',,'2000')
WHERE id>=7

Management – Helpful Extensions for Trello and Toggl

Small Trello Inconveniences 

Sitting down to work on my next Trello ticket I realized my Toggl account was still on my previous task. I had to stop what I was doing and switch to Toggl counter to stop and create a new counter for my current task. Having finished the test I wanted to make a list of a few fixes that had to be tested elsewhere – since there is no easy way to refer to Trello cards other than their url address I made a list of links for reference.