M. Fauzilkamil Zainuddin ApOgEE

## clustercontrol-podman-setup-20231209.md

      
              1 file
            
          
              0 forks
            
          
                4 comments
              
            
              2 stars
            
          
                linuxmalaysia
                / clustercontrol-podman-setup-20231209.md
            
            
              Last active
              May 12, 2024 00:58
            
              
                Clustercontrol v2 in Podman
              
          
    Podman Container Configuration for ClusterControl with Custom User and SSH

This document outlines how to configure a Podman container for ClusterControl with a custom user and SSH access.
1. Pulling the Image:
podman pull docker.io/severalnines/clustercontrol:latest


## PostgreSQL test if text can be cast to numeric
select (mytext ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$');

## parse_xlsx.php
<?php

/**
 * I had to parse an XLSX spreadsheet (which should damn well have been a CSV!)
 * but the usual tools were hitting the memory limit pretty quick. I found that
 * manually parsing the XML worked pretty well. Note that this, most likely,
 * won't work if cells contain anything more than text or a number (so formulas,
 * graphs, etc ..., I don't know what'd happen).
 */
	<?php

	/**
	* I had to parse an XLSX spreadsheet (which should damn well have been a CSV!)
	* but the usual tools were hitting the memory limit pretty quick. I found that
	* manually parsing the XML worked pretty well. Note that this, most likely,
	* won't work if cells contain anything more than text or a number (so formulas,
	* graphs, etc ..., I don't know what'd happen).
	*/