Kiril

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

Kiril

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'; 

Kiril

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

Step 1 (registrations)

Create account on digital ocean https://www.digitalocean.com

After registration click on create new droplet and choose Ubuntu 18.04

Kiril

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;
Kiril

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: https://github.com/PeTeL-Weizmann/moodle-filter_teamwork

Kiril

Moodle -Query to change all users details

UPDATE mdl_user 
SET 
username=CONCAT('username',mdl_user.id),
phone1=CONCAT('11111',mdl_user.id),
phone2=CONCAT('11111',mdl_user.id),
firstname=CONCAT('Name',mdl_user.id),
lastname=CONCAT('Last',mdl_user.id),
email=CONCAT('email',mdl_user.id,'@test.com'), 
idnumber= CONCAT('1000',mdl_user.id,'2000')
WHERE id>=7
Kiril

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.