Posts

I’ve been looking for a encryptation app open source, to encrypt my files into Cloud with a touch of off-online control, and I found this nice app called Cryptomator. I downloaded the extension .Appimage, so the following instruction I will explain is how to set the .appimage into the app menu in Gnome. Download the Cryptomator by the link above. Set the permission below: #chmod a+x cryptomator-1.4.15-x86_64.AppImage The try to execute the file by a shell terminal or just double click on it ( to confirm it was downloaded fined) ...

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. Reduce chaos and bring order to your support process with a robust support ticket system, self-service knowledge base and community forums. ...

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…). DDL is about “metadata”. DML (Data Manipulation Language) refers to the INSERT, UPDATE and DELETE statements DML allows to add / modify / delete data itself. DQL (Data Query Language) refers to the SELECT, SHOW and HELP statements (queries) SELECT is the main DQL instruction. It retrieves data you need. SHOW retrieves infos about the metadata. HELP… is for people who need help. DCL (Data Control Language) refers to the GRANT and REVOKE statements DCL is used to grant / revoke permissions on databases and their contents. DCL is simple, but MySQL’s permissions are rather complex. DCL is about security. DTL (Data Transaction Language) refers to the START TRANSACTION, SAVEPOINT, COMMIT and ROLLBACK [TO SAVEPOINT] statements DTL is used to manage transactions (operations which include more instructions none of which can be executed if one of them fails). Some SQL queries: ...

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. ...

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! ...

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 ). ...

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. $psql -h localhost -p 5416 -U <my-user> -d <my-database> ...

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 ...

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: ...

$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