Ondrej Valenta OndrejValenta

## enable_serial_console_rhel_in_proxmox.md

      
              1 file
            
          
              0 forks
            
          
                3 comments
              
            
              4 stars
            
          
                OndrejValenta
                / enable_serial_console_rhel_in_proxmox.md
            
            
              Created
              June 8, 2023 23:31
            
              
                Enable Serial Console for Rocky Linux 9 / CentOS in Proxmox
              
          
    Enable Serial Console for Rocky Linux / CentOS / RHEL in Proxmox


This guide is a combination of two sources


https://www.thegeekdiary.com/centos-rhel-7-how-to-configure-serial-getty-with-systemd/


https://pve.proxmox.com/wiki/Serial_Terminal

Done in Proxmox console


## Convert cell range to links in Excel.osts
This script converts all cells in selected range if they are of text value and the url is valid, check the isValid function if you need it updated.

You can add this script through Automate function.

```
function main(workbook: ExcelScript.Workbook) {
	// Get the currently selected range
	let selectedRange = workbook.getSelectedRange();

	// Check if a range is actually selected

## Install Zsh and Oh-my-zsh on CentOS 7.md

      
              1 file
            
          
              15 forks
            
          
                9 comments
              
            
              48 stars
            
          
                OndrejValenta
                / Install Zsh and Oh-my-zsh on CentOS 7.md
            
            
              Last active
              August 7, 2025 22:35
            
          
    Install Zsh and Oh-my-zsh on CentOS 7

Based on this article

ALL INSTALLATIONS ASSUME YES WHEN PROMPTED, that's what -y does
This script can be copy paste to ssh as is. No hands installation. :-)
yum install zsh -y


## create-svg-preview-grid.ps1
# Define the folder path where SVG files are located
$folderPath = ".\"

# Get a list of all SVG files in the folder
$svgFiles = Get-ChildItem -Path $folderPath -Filter *.svg

# Create an HTML header with a grid layout
$htmlContent = @"
<!DOCTYPE html>
<html lang="en">

## Postgres-simple-reordering-of-rows.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              1 star
            
          
                OndrejValenta
                / Postgres-simple-reordering-of-rows.md
            
            
              Created
              July 9, 2020 00:59
            
          
    Simple reordering of items in database table

The problem

Ability to reorder item based on users drag and drop of items in UI. Items can be drag and drop in as a single object or with
This is not the most efficient way how to do this but it's working just fine.
-- Drop functions and data table if they already exists
drop function save_todo_float(_user_id int, _what text, _todo_id int);
drop function move_todo_float(_user_id int, _ids int[], _target_id int, _position text);
drop table todos_float;


## Install Redis on Ubuntu 18.04.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              1 star
            
          
                OndrejValenta
                / Install Redis on Ubuntu 18.04.md
            
            
              Last active
              July 15, 2024 14:31
            
          
    Based on this article

sudo apt-get update
sudo apt-get upgrade

sudo apt-get install redis-server
sudo systemctl enable redis-server.service


## install_postgres_rockylinux.md

      
              1 file
            
          
              0 forks
            
          
                1 comment
              
            
              1 star
            
          
                OndrejValenta
                / install_postgres_rockylinux.md
            
            
              Last active
              April 6, 2024 23:47
            
              
                Install PostgreSQL 15 on RockyLinux 9
              
          
    Installation of PostgreSQL 15 on RockyLinux 9 with OS configuration for better performance


Based on various sources

https://www.tecmint.com/install-postgresql-rocky-linux/


Installation and initialization


## install_grafana-loki-prometheus_rockylinux9.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                OndrejValenta
                / install_grafana-loki-prometheus_rockylinux9.md
            
            
              Created
              March 4, 2024 03:09
            
              
                Install Grafana/Loki/Prometheus on RockyLinux 9
              
          
    Installation of Grafana on RHEL

wget -q -O gpg.key https://rpm.grafana.com/gpg.key
sudo rpm --import gpg.key
nano /etc/yum.repos.d/grafana.repo and paste
[grafana]


## install_minio_rockylinux.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                OndrejValenta
                / install_minio_rockylinux.md
            
            
              Last active
              March 4, 2024 02:54
            
              
                Install Minio.io on RockyLinux
              
          
    Install standards


Installs also firewalld !!


You can skip this step completely.

sudo dnf -y update
sudo yum install -y epel-release
sudo dnf install -y tar wget curl nano mc firewalld htop git

  
## rocky-linux_9-2_first-steps.sh
#!/bin/bash

# Update everything automatically
dnf update -y

# Install nano and other useful stuff because you are not a masochist
dnf install epel-release -y;

dnf makecache
	This script converts all cells in selected range if they are of text value and the url is valid, check the isValid function if you need it updated.

	You can add this script through Automate function.

	```
	function main(workbook: ExcelScript.Workbook) {
	// Get the currently selected range
	let selectedRange = workbook.getSelectedRange();

	// Check if a range is actually selected
	# Define the folder path where SVG files are located
	$folderPath = ".\"

	# Get a list of all SVG files in the folder
	$svgFiles = Get-ChildItem -Path $folderPath -Filter *.svg

	# Create an HTML header with a grid layout
	$htmlContent = @"
	<!DOCTYPE html>
	<html lang="en">
	#!/bin/bash

	# Update everything automatically
	dnf update -y

	# Install nano and other useful stuff because you are not a masochist
	dnf install epel-release -y;

	dnf makecache