Repo-list

This is a documentation I’ve made time ago searching some open source tools and platforms(& freeware), I hope It can be useful to you: Ticketing https://www.graylog.org/ Monitoring / Open source Discover and resolve issues faster. Keep end users happy with less downtime and better performance by proactively monitoring key indicators and exceptions across the entire stack. https://www.happyfox.com/ Ticketing / private Meet HappyFox, a practical help desk and customer support software solution....

2020-03-08

SQL some concepts & notes

SQL Structured Query Language, is a language designed to allow both technical and non-technical users query, manipulate, and transform data from a relational database. Some popular SQL databases: SQLite MySQL Postgres Oracle Microsoft SQL Server Relational database: Represents a collection of related ( two-dimensional) tables.Each of the tables are similar to an Excel spreadsheet, with a fixed number of named columns and any number of rows of data. DDL (Data Definition Language) refers to the CREATE, ALTER and DROP statements DDL allows to add / modify / delete the logical structures which contain the data or which allow users to access / maintain the data (databases, tables, keys, views
)....

2020-02-24

Docker Container "before start"

Part I Containers are environments that host individual applications using a framework like Docker. Docker Editions: Docker CE ( community edition ) free version Docker EE ( enterprise edition) Paid Versions: Stable, released every 4 months. Edge (beta) released every month. For testing EE, support for one year. Example how to create a container: $docker container run --publish 80:80 --detach --name webhost nginx detach: subcommand is to let run the container and keep use the command prompt name: create a container’s name....

2020-01-26

How to set you SSH key into Gitlab

How to set you SSH key into Gitlab [First you need to had installed Git onto your distro] Go to your terminal and issue the follow command to generate your key: $ssh-keygen Copy your public key from the route: /home/user/.ssh/id_rsa.pub Then go at your gitlab profile https://gitlab.com/profile/keys/ a paste and save. From the terminal test the conection by typing: $ssh -T git@gitlab.com and if everything was fine it has to promt –> Welcome to GitLab, @user_account!...

2019-12-26

How to create a docker-compose.service

Here are the steps I made to set a service into my Fedora server to start/stop my Docker-compose (Wikijs) Why I decided to use a docker-compose into a Linux VM machine? —> for make it more stable, faster,portable, isolated, etc. First I stared using Docker for Windows and it was a little bit unstable and not quite easy to handled, so when I switched to Docker compose into a Fedora VM and in that point it was a huge different(I do not recommend to use Docker in Windows); I use a Vmware hypervisor ( in the office we use it )....

2019-09-08

Backup your Wikijs DB

This is a little resume of how I’m doing a backup procedure of my wikijs database based in Docker-compose. Below are the systems used in my enviroment: Project: Wikijs 2.0 Beta Platform: Docker-Compose DB: Postgres (9.6.14) Server: Fedora Server 30.x86_64 Workstation: Windows 10 (provided by work) 😬 PSQL basic commands: Here are 4 basic commands I use to connect into my Postgre DB and check out DB list and quite....

2019-07-15

Create a .zip using 7z by cmd in Windows

After to install the 7z in our windows workstation/server then we need to create our evironment variables to call the function from the cmd [1]. Then the command below will guide you to zip a simple file: 7z a -r [myzip] [example.txt] [myzip] - the zip name file [example.txt] file used for the example To zip a folder 7z a [myzip] [folder] Docu based thx to the information seen from: [1] GlobalEnviroment

2019-06-11

Closing opened ports on Linux (Fedora 29)

Using the Nmap to list our opened port in our machine, how described the official website: Nmap “..is an utility for network discovery and security auditing..” Regarding CUPS from the official website: “is an open source printing system developed by Apple Inc. for macOS¼ and other UNIX¼-like operating systems. CUPS uses the Internet Printing Protocol (IPP) to support printing to local and network printers.” By default we have the cups service running in the system’s startup we could check out issue the following commands:...

2019-05-05

Output IPCONFIG report to HTML by PowerShell

$file = "C:\Users\jcr\a.html" $ipconfig=ipconfig /all |%{"$_<br/>"} $body=@" <html> <head> <title>Network Report</title> </head> <body> <h1>IPConfig /All</h1> <pre>$ipconfig</pre> </body> </html> "@ $body | Out-File $file . $file

2019-04-25

Setup Grafana in Raspbian (Raspberrypi)

The below post is a simple explanation I did time ago, if you want further info and better explanation about how to setup a monitoring system into your Raspberripy please go to here. Raspbian version:9.8 $ uname -r 4.14.98-v7+ $ uname -m armv7l Version installed on my RasPi: Grafana v6.0.2 (3f4c2e7) Download Grafana package for your correct Raspi ARM $sudo dpkg -i grafana_6.1.3_armhf.deb $systemctl start grafana-server $systemctl status grafana-server then you will see from the status propmt the address=0....

2019-04-09