Splunk Basic Commands

Search for all indexes

 

Search for all sources

 

Search for all sourcetypes

 

Search for all servers + sources + sourcetypes

Control-M Basic Commands

Create/Edit User

 

Create Group

 

Join user to the group

 

New Rule for root usage

 

Grant sudo Access

 

Reference Links

Selang Reference Guide

New Office Setup

Here is the new office setup with a lot of changes since I moved to a new house.

Starting with the new desk that I got from Jarvis, it is much bigger than the old Ikea one, more stable, less noisy and able to stand up. Curtains are not in the best setup yet, I am working on this!

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 you have available in the source server
  • Don´t forget to backup your wordpress files/images

From PHPMyAdmin

1. Access your DB

2. Navigate to Export -> Select ¨Quick” and ¨Go¨

3. You will have a .sql file downloaded

From Command Line

1. Access your server where you are migrating from

2. Create WordPress database backup

 

3. Create WordPress files backup

 

4. Restore WordPress DB on the new server

 

5. Restore WordPress files on the new server

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.

It needs to be placed at this path:

/usr/share/applications/

Example:

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

 

2. Download and Install Lets Encrypt

 

3. Download a clone of Let’s Encrypt from the official GitHub repository. /opt is a common installation directory for third-party packages, so let’s install the clone to /opt/letsencrypt:

 

4. Navigate to the new /opt/letsencrypt directory:

 

5. Create the certificate

Run Let’s Encrypt with the --standalone parameter. For each additional domain name requiring a certificate, add -d example.com to the end of the command.

If you receive this error, stop your Apache server and try again.

Agree to the Terms of Service and specify if you would like to share your email address with EFF:

 

If all goes well, you should receive a result like this:

 

6. Configure your Virtual Host, it should be similar to this, one entry for port 80 and a duplicated block for port 443:

 

7. Check for the certificated domains:

 

8. All your certificated sites should be under this path, you also can check with this command:

 

9. Restart your Apache to apply your changes

 

10. Test your SSL website use:

 

For more information: Let’s Encrypt Homepage

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.

Attending to the FOSDEM 2019 conference, we could have a deeply immersion in many subjects from more than 728 speakers, 776 events, and 62 different tracks.

The event itself starts only on Saturday, but at day before and after, you have the opportunity to attend to additional workshops, like Pre and Post-FOSDEM events, plus lots of other conferences awareness around the world. So it’s a great opportunity to catch up with the developers and sysadmins community and see what’s is going on at moment. The experience to be there in person is unique!

Also, all the speeches are recorded (automated!) and if you missed any speech that you wanted to watch, you can watch the videos anytime you like. I had a friend speaking on Saturday, and also anyone who wishes to give a speech is free to submit.

 Picture: Janson Room

 

FOSDEM

https://fosdem.org/

Videos

https://video.fosdem.org/

Pre and Post-events

https://www.eventbrite.com/e/pre-fosdem-mysql-day-2019-tickets-53287378985#

https://jenkins.io/blog/2019/01/21/fosdem-2019/

Important to know

  • Always try to wear comfortable and light clothes/shoes as you are going to walk around a lot
  • Mind your belongs, lots of pick pockets around and they can get very aggressive sometimes, specially late night
  • Use your time to spend meeting new friends and networking, thanks to the technology, you’ll have time to check out the speeches you couldn’t attend
  • There are many food trucks with affordable price inside the University, You’ll spend some time at the queue but it’s worth waiting for