About #

An simple URL shortener RESTful web service API written in Go, using the net/http package for the server, the HttpRouter for the router and Bolt DB for the database.

The Stoplight service was used to design and document the REST API. See below for the API Documentation

The API service is deployed on Heroku, and you can access it on url-shortener-thanoskoutr.herokuapp.com.

Because the Heroku Free plan is no longer available from November 28, 2022, the above link does not work. I wish to deploy the API in a Heroku free alternative service in the future.

In this post, we will see how we can install Grafana in our Ubuntu Server. Grafana is an open-source data visualization and monitoring tool that can easily be integrated with other tools.

We will install Grafana in our server as a service and not in a container.

We have more than one way to install Grafana:

• By downloading the Linux binary
• By downloading and installing the .deb package
• By installing from the official repository

We will show the last method, because we don’t have to manually update the package ourselves.

In this post, we will see how we can install the latest version of InfluxDB (ver 2.0) in our Ubuntu Server. With the new version there’s only one thing to download and install and we can avoid installing the TICK Stack (Telegraf, InfluxDB, Chronograf, Kapacitor).

The new version is not a simple time-series database anymore, but also a platform for querying, visualization and data manipulation.

We have more than one way to install InfluxDB 2.0:

About #

A python bot, that uses Selenium, in order to automatically access the Router/Modem’s web-based setup page and get DSL Link info. It uses Plotly to create an interactive Plot as an HTML web page.

It also supports the export of the data to an InfluxDB Bucket for further monitoring and visualizing.

Currently gets the following info:

• CRC Errors
• FEC Errors
• Showtime_start

Support for the following Routers/Modems:

• ZTE Nova Routers (H267N, H288A, …)

The need behind this project, was to monitor my DSL Link information over time, to correlate with various internet outages or sudden internet speed issues.

About #

The purpose of this project is to create a Web Application in which a user can search movies to watch in different streaming platforms (Netflix, Hulu, Amazon Prime, Disney+).

The user can filter the results with different criteria and choose to search on any number of the streaming platforms in order to find the desired movies. Also, some statistics are provided about the number of movies that are available on each platform in the form of a pie chart.

In this post we will see, how we can change the default port (port 80) of Wordpress to something else (port 1280) in order to have port 80 available for other applications to use.

To make this change we will need to change 2 main things, the Apache configuration files and some options in the MySQL database.

We are assuming that Wordpress is installed in a LAMP stack on an Ubuntu or Debian server.

Wordpress Installation and Configuration Guide.

Prerequisites #

• Create a sudo user on your server
• Install a LAMP stack
• Secure your site with SSL (can be done after)

Create a MySQL Database and User for WordPress #

Log in to a MySQL administrative account (root):

sudo mysql -u root -p

Create wordpress database:

CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Create exclusive user for this database:

GRANT ALL ON wordpress.* TO 'wordpressuser'@'localhost' IDENTIFIED BY 'password';

Flush the privileges so that the current instance of MySQL knows about the recent changes:

MySQL #

Install MySQL #

sudo apt install mysql-server

Run security script #

Accept almost everything, and add secure root password:

sudo mysql_secure_installation

Change authentication method #

If you don’t change the authentication method from auth_socket to mysql_native_password then anyone with a sudo user password can log in as root.

To check the authentication method, enter MySQL:

sudo mysql

And type:

SELECT user,authentication_string,plugin,host FROM mysql.user;

To configure the root account to authenticate with a password, run the following ALTER USER command. Be sure to change password to a strong password of your choosing, and note that this command will change the root password you set in the security script: