Category: Sad Servers

Scenario: “Ivujivik”: Parlez-vous Français?
Level: Medium
Description: Given the CSV file /home/admin/table_tableau11.csv, find the Electoral District Name/Nom de circonscription that has the largest number of Rejected Ballots/Bulletins rejetés and also has a population of less than 100,000.
The initial CSV file may be corrupted or invalid in a way that can be fixed without changing its data.
Installed in the VM are: Python3, Go, sqlite3, miller directly and PostgreSQL, MySQL in Docker images.
Save the solution in the /home/admin/mysolution , with the name as it is in the file
– YouTube https://www.youtube.com/@cceste
– Instagram https://www.instagram.com/ccesteok
– Facebook https://www.facebook.com/ccesteok
– Discord https://discord.gg/ZWQVg7cgdR

Level: Medium
Description: Using the file station_information.json , find the station_id where “has_kiosk” is false and “capacity” is greater than 30.
Save the station_id of the solution in the /home/admin/mysolution file

Admito que acá tuve suerte, ya había trabajado alguna que otra vez con jq

– YouTube https://www.youtube.com/@cceste
– Instagram https://www.instagram.com/ccesteok
– Facebook https://www.facebook.com/ccesteok
– Discord https://discord.gg/ZWQVg7cgdR

Level: Easy

Description: A web application relies on the PostgreSQL 13 database present on this server. However, the connection to the database is not working. Your task is to identify and resolve the issue causing this connection failure. The application connects to a database named app1 with the user app1user and the password app1user.

Level: Medium
Description: There is a /home/admin/kihei program. Make the changes necessary so it runs succesfully, without deleting the /home/admin/datafile file.
Test: Running /home/admin/kihei returns Done..

Había cositas escondidas es este escenario !!
Tuve que mirar algunas pistas. pero resolvimos correctamente al menos

– YouTube https://www.youtube.com/@cceste
– Instagram https://www.instagram.com/ccesteok
– Facebook https://www.facebook.com/ccesteok
– Discord https://discord.gg/ZWQVg7cgdR

Level: Medium
Description: There is a /home/admin/kihei program. Make the changes necessary so it runs succesfully, without deleting the /home/admin/datafile file.
Test: Running /home/admin/kihei returns Done..

Honestamente me quedé sin ideas y terminé haciendo trampa 🤣

– YouTube https://www.youtube.com/@cceste
– Instagram https://www.instagram.com/ccesteok
– Facebook https://www.facebook.com/ccesteok
– Discord https://discord.gg/ZWQVg7cgdR

Level: Medium
Description: There is a /home/admin/kihei program. Make the changes necessary so it runs succesfully, without deleting the /home/admin/datafile file.
Test: Running /home/admin/kihei returns Done..

Honestamente me quedé sin ideas y terminé haciendo trampa 🤣

– YouTube https://www.youtube.com/@cceste
– Instagram https://www.instagram.com/ccesteok
– Facebook https://www.facebook.com/ccesteok
– Discord https://discord.gg/ZWQVg7cgdR

Level: Medium
Type: Fix
Description: There’s an etcd server running on https://localhost:2379 , get the value for the key “foo”, ie etcdctl get foo or curl https://localhost:2379/v2/keys/foo

Venia muy bieeeeen ! No llegué a tiempo por desprolijo!

– YouTube https://www.youtube.com/@cceste
– Instagram https://www.instagram.com/ccesteok
– Facebook https://www.facebook.com/ccesteok
– Discord https://discord.gg/ZWQVg7cgdR

Level: Medium

Description: There is a Python WSGI web application file at /home/admin/wsgi.py , the purpose of which is to serve the string “Hello, world!”. This file is served by a Gunicorn server which is fronted by an nginx server (both servers managed by systemd).

So the flow of an HTTP request is: Web Client (curl) – Nginx – Gunicorn – wsgi.py . The objective is to be able to curl the localhost (on default port :80) and get back “Hello, world!”, using the current setup.

Yyyyy la verdad tuve que mirar las pistas, nunca me imaginé que el problema era la aplicación
Tampoco estaba TAN errado en el fix

– YouTube https://www.youtube.com/@cceste
– Instagram https://www.instagram.com/ccesteok
– Facebook https://www.facebook.com/ccesteok
– Discord https://discord.gg/ZWQVg7cgdR